Purpose

Define the custom report fields and filter parameters listed in the supplied Custom Report Columns workbook, organized by report type.

Who should use this

CAREWare administrators, data managers, report writers, quality staff, and support users who create, validate, or troubleshoot custom reports.

Use this guide when

Selecting report fields, defining report filters and subfilters, interpreting report output, or checking the database record represented by a field.

Source Basis

CAREWare Creating Custom Reports and Custom Report Run Report

Main warning

The report type determines the available fields and filters. Similar field names can produce different results when the critical date, key date, provider-sharing settings, funding source, code system, or subfilter criteria differ.

Reports > Custom Reports Menu > Manage/Run Custom Reports > select a report > Field Selection or Report Filter

Important
A field can display a value, while a filter limits which clients or records are included. Subfilter fields supply additional parameters—such as a service category, code, date span, provider, threshold, or sequence rule—to the parent filter.

Tip
Demographics reports normally produce one row per client. Most other report types produce one row per record, so one client may appear on several rows. Confirm the row basis before interpreting totals or client counts.

Displays

A value read from the primary record or resolved from a linked reference record.

Indicates

A Yes/No-style condition calculated from a stored flag or the existence of qualifying records.

Returns

A derived, selected, first, last, current, highest, lowest, or as-of result.

Counts / totals

An aggregate of qualifying database records or numeric values; the description states when the result is client-level or record-level.

Internal identifier

A database key intended for reconciliation, joins, or troubleshooting rather than a user-facing label.

ADAP Enrollment History

One row represents an ADAP enrollment or disenrollment event. Statuses and disenrollment reasons are resolved from linked reference records.

ADAP Enrollment History Date

Case Notes

One row represents a client case note, with the employee and provider relationships used to identify the author and domain.

Case Note Date

Child

One row represents a relationship link and displays attributes from the client identified as the child or dependent side of that link.

Relations behavior; Service Date

Counseling and Testing

One row represents a counseling and testing encounter, including counseling, HIV testing, notification, and provider values.

HIV Test Date

Custom Forms

One row represents a saved custom form record and may include values from a service linked to that form.

Form Date or Master Date if enabled

Custom Subform

One row represents a custom subform entry. Dynamic field values follow the custom control definition, data type, and active value list.

Custom Subform Date

Demographics

One row represents one client. Direct client values are combined with calculated results drawn from related clinical, service, enrollment, eligibility, insurance, referral, and custom records.

No single intrinsic critical date; date-span, key-date, and annual-review settings control many calculated fields

Diagnosis

One row represents a diagnosis record. Diagnosis labels, assessments, statuses, and code descriptions may be resolved from linked reference and coding records.

Diagnosis Date

Drug Service

One row represents an ADAP drug service or dispensed-drug transaction and may join formulary, NDC, generic drug, funding, payment, and dispenser details.

Drug Service Date

Eligibility

One row represents an eligibility determination, linked to the client, provider domain, funding source, and eligibility status.

Eligibility Date

Immunization

One row represents an immunization record, with vaccine definitions and code mappings used to resolve names, CVX values, and related attributes.

Vaccine Date

Insurance Assessment

One row represents an insurance assessment. Coverage flags, primary coverage, codes, and descriptive values are read from the assessment and linked insurance reference records.

Insurance Assessment Date

Lab

One row represents a lab test record. Test definitions, assays, result values, code mappings, data source, status, and provider may be joined to the test record.

Lab Date

Medication

One row represents a client medication record, linked to medication definitions, frequency, indication, prophylaxis, coding, form, and provider values.

Medication Start Date and Stop Date

Parent

One row represents a relationship link and displays attributes from the client identified as the parent or index side of that link.

Relations behavior; Service Date

Poverty Level Assessment

One row represents a poverty level assessment containing household income, household size, individual income, and the calculated federal poverty level.

Poverty Level Assessment Date

Pregnancy History

One row represents a pregnancy history record, including conception, prenatal care, antiretroviral use, outcome, delivery, newborn status, and provider values.

Conception Date, generally the estimated conception date

Referrals

One row represents a referral. Provider, service category, definition, class, type, status, code, user, and received-service relationships may supply display values.

Referral Date

Relations

One row represents a relationship link between an index client and a dependent client, with the relationship type and related-client attributes resolved through linked records.

Service Date

ROI Agreement

One row represents a release-of-information agreement, including its active period, provider domain, and sharing type.

ROI Start Date and ROI End Date

Screening

One row represents a screening test record. Screening definitions, actions, results, scores, status, code mappings, data source, and provider may be joined to the test record.

Screening Date

Screening Lab

One row represents a screening-lab test record. Test definitions, qualitative or titer results, treatment, STI action, code mappings, source, and provider may supply report values.

Screening Lab Date

Service

One row represents a service record, linked to subservice, service category, contract, sponsor, funding, provider, code, tag, billing, and user records.

Service Date

Service Receipts

One row represents a receipt linked to a service record, so receipt values can be reported with the service, contract, funding, provider, billing, and subservice details.

Receipt Date

Subfilter Fields

These entries are configuration parameters used by report filters that require a subfilter. They select codes, date spans, comparison values, providers, services, or sequence rules rather than defining a report row.

The report type critical date  and subfilter date span or key-date settings control evaluation

Vital Signs

One row represents a vital-sign encounter containing date, height, weight, pulse, blood pressure, temperature, provider, and calculated BMI values.

Vitals Date

ADAP Enrollment History Date

Displays the date of the client’s ADAP enrollment or disenrollment event. This is the critical date used to place ADAP enrollment-history rows within Date From and Date Through.

ADAP Enrollment History Status

Displays the enrollment status assigned to the ADAP history event, resolved from the ADAP enrollment-status reference values.

ADAP History Disenroll Reason

Displays the standard ADAP disenrollment reason linked to a disenrollment event, using the configured disenrollment-reason reference value.

ADAP Other Disenroll Reason

Displays the locally maintained other disenrollment reason linked to the ADAP enrollment-history event.

Case Note Author

Displays the employee associated with the case note, using the employee link stored on the case-note record.

Case Note Comment

Displays the short comment recorded separately from the full case-note narrative.

Case Note Date

Displays the date and time assigned to the case note. This is the critical date used to include case-note rows within the report date span.

Case Note Date Created

Displays the database timestamp recorded when the case-note record was created, which can differ from the case-note date used for reporting.

Case Notes

Displays the full narrative text entered for the client case note.

Case Notes Author First Name

Displays the first name of the employee linked as the case-note author.

Case Notes Author Last Name

Displays the last name of the employee linked as the case-note author.

Relation AIDS diagnosis date

Displays the AIDS diagnosis date for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation date case closed

Displays the date the related client’s case or enrollment was closed for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation date of birth

Displays the date of birth for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation date of death

Displays the date of death for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation enroll date

Displays the provider enrollment date for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation enroll status

Displays the provider enrollment status for the client on the child or dependent side of the relationship, resolved from the applicable client or provider-enrollment reference value.

Relation eURN

Displays the encrypted or extended unique record number for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation first name

Displays the first name for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation gender

Displays the gender for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation HIV diag date

Displays the HIV diagnosis date for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation last name

Displays the last name for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation middle name

Displays the middle name for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation type

Displays the relationship type that links the index client and dependent client, resolved from the relationship reference values.

Relation URN

Displays the unique record number for the client on the child or dependent side of the relationship by joining the relationship link to that client’s record.

Relation vital status

Displays the vital status for the client on the child or dependent side of the relationship, resolved from the applicable client or provider-enrollment reference value.

C&T Provider

Displays the provider domain associated with the counseling and testing encounter.

Comment

Displays the additional comment entered on the counseling and testing record.

HIV Result

Displays the HIV test result recorded for the encounter, resolved from the HIV test-result reference values.

HIV test date

Displays the date of the HIV test. This is the critical date used to include counseling and testing rows within the report date span.

HIV Tested

Indicates whether the client was recorded as HIV tested for the encounter, using the configured Yes/No/Unknown/Not Applicable value set.

Notified of HIV test result

Indicates whether the client was notified of the HIV test result for the encounter.

Partner notification offered

Indicates whether partner-notification services were offered during the encounter.

Post-test counsel date

Displays the date post-test counseling occurred for the encounter.

Post-test counseled

Indicates whether post-test counseling was provided, using the configured Yes/No/Unknown/Not Applicable value set.

Pre test counsel date

Displays the date pre-test counseling occurred for the encounter.

Pre-test counsel

Indicates whether pre-test counseling was provided, using the configured Yes/No/Unknown/Not Applicable value set.

Reason not counseled 

Displays the reason recorded when post-test counseling was not provided.

Created By

Displays the user or employee associated with creating the custom form record.

Form Date

Displays the date assigned to the custom form record.

Form Employee

Displays the employee linked to the custom form record.

Form Label

Displays the label configured for the custom form.

Form Name

Displays the configured name of the custom form design.

Form PK

Displays the internal unique identifier for the saved custom form record; use it for technical reconciliation or joins.

Form Provider

Displays the provider domain associated with the custom form record.

Form User

Displays the user associated with the saved custom form record.

Last Updated By

Displays the user associated with the most recent update to the custom form record.

Service Date Created

Displays the database timestamp recorded when the linked service record was created.

Service Primary Key

Displays the internal unique identifier for the service linked to the custom form record.

Service User

Displays the user name stored with the service linked to the custom form record.

Srv Cat PK

Displays the internal key for the service category linked to the form’s service record.

Srv Category

Displays the service category linked to the form’s service record.

Srv Contract

Displays the contract linked to the form’s service record.

Srv Date

Displays the date of the service linked to the custom form record.

Srv Funding

Displays the funding source linked to the form’s service record.

Srv Long Name

Displays the long name of the linked service or subservice.

Srv Price

Displays the unit price recorded for the linked service.

Srv Qty

Displays the quantity or units recorded for the linked service.

Srv RW Funded

Indicates whether the linked service is Ryan White funded.

Srv Short Name

Displays the short name of the linked service or subservice.

Srv Total

Displays the stored total amount for the linked service.

Srv Total Recd

Displays the total amount received from sources associated with the linked service.

Subservice Tags

Displays the tags assigned to the subservice linked to the form’s service record.

Tag

Displays the selected tag associated with the custom form or linked service configuration.

Adherence to Cotrimoxazole (Test New Subform)

Displays the value entered for the custom field “Adherence to Cotrimoxazole” on the “Test New Subform” custom subform. The value’s data type, validation, and allowed choices follow the custom control definition.

Beneficiary Comment (HOPWA Beneficiaries)

Displays the value entered for the custom field “Beneficiary Comment” on the “HOPWA Beneficiaries” custom subform. The value’s data type, validation, and allowed choices follow the custom control definition.

Beneficiary Date of Birth (HOPWA Beneficiaries)

Displays the value entered for the custom field “Beneficiary Date of Birth” on the “HOPWA Beneficiaries” custom subform. The value’s data type, validation, and allowed choices follow the custom control definition.

Beneficiary Ethnicity Hispanic (HOPWA Beneficiaries)

Displays the value entered for the custom field “Beneficiary Ethnicity Hispanic” on the “HOPWA Beneficiaries” custom subform. The value’s data type, validation, and allowed choices follow the custom control definition.

Beneficiary Gender (HOPWA Beneficiaries)

Displays the value entered for the custom field “Beneficiary Gender” on the “HOPWA Beneficiaries” custom subform. The value’s data type, validation, and allowed choices follow the custom control definition.

Beneficiary HIV Status Positive (HOPWA Beneficiaries)

Displays the value entered for the custom field “Beneficiary HIV Status Positive” on the “HOPWA Beneficiaries” custom subform. The value’s data type, validation, and allowed choices follow the custom control definition.

Beneficiary Name (HOPWA Beneficiaries)

Displays the value entered for the custom field “Beneficiary Name” on the “HOPWA Beneficiaries” custom subform. The value’s data type, validation, and allowed choices follow the custom control definition.

Beneficiary Race (HOPWA Beneficiaries)

Displays the value entered for the custom field “Beneficiary Race” on the “HOPWA Beneficiaries” custom subform. The value’s data type, validation, and allowed choices follow the custom control definition.

Cognitive function assessed? (Test New Subform)

Displays the value entered for the custom field “Cognitive function assessed?” on the “Test New Subform” custom subform. The value’s data type, validation, and allowed choices follow the custom control definition.

HOPWA Beneficiary Age Category

Returns the HOPWA beneficiary age category derived from the beneficiary date of birth and the reporting reference date.

New Subform Drop Down List (New Subform Tab)

Displays the value entered for the custom field “New Subform Drop Down List” on the “New Subform Tab” custom subform. The value’s data type, validation, and allowed choices follow the custom control definition.

 Hepatitis C Screening

Returns the client-level “Hepatitis C Screening” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

 HIV risk counseling

Returns the client-level hiv risk counseling, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

 RW-funded visits by service category (RDR)

Returns the number of qualifying service or appointment records represented by “Ryan White-funded visits by service category (RDR)”, after applying service-category, subservice, funding, and interval criteria.

2nd To Last Lab Date

Returns the second most recent qualifying lab date through the report Date Through, after applying the selected test and subfilter criteria.

2nd to Last Lab Value

Returns the second most recent qualifying lab value through the report Date Through, after applying the selected test and subfilter criteria.

2nd To Last Qualitative Test Date

Returns the second most recent qualifying qualitative test date through the report Date Through, after applying the selected test and subfilter criteria.

2nd To Last Qualitative Value

Returns the second most recent qualifying qualitative value through the report Date Through, after applying the selected test and subfilter criteria.

ADAP Application Date

Returns the adap application date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

ADAP Disenroll Reason

Returns the client-level adap disenroll reason, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

ADAP Enrolled In Period

Returns the client-level “ADAP Enrolled In Period” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

ADAP enrollment status

Returns the client-level adap enrollment status, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

ADAP Enrollment Status By Date

Returns the latest applicable adap enrollment status on or before the configured key date or report Date Through.

ADAP First Enrollment Date

Returns the adap first enrollment date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

ADAP First Enrollment Date Not Disenrolled

Returns the adap first enrollment date not disenrolled from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

ADAP First Enrollment Status

Returns the client-level adap first enrollment status, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

ADAP Formatted NDC

Returns the client-level “ADAP Formatted NDC” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

ADAP Is Last Disenrolled By Reason Before Date

Returns the adap is last disenrolled by reason before date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

ADAP Last Enrl Date Not Disenrolled

Returns the adap last enrollment date not disenrolled from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

ADAP Last Enrollment Date

Returns the adap last enrollment date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

ADAP Last Enrollment Status

Returns the client-level adap last enrollment status, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

ADAP Legacy Date Closed

Returns the adap legacy date closed from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

ADAP Premium Months

Returns the client-level “ADAP Premium Months” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Address

Displays the street address recorded on the client record.

Adh. Prob. Addressed?

Indicates whether the client satisfies the “Adh. Prob. Addressed” condition based on qualifying client or related records.

Adh. Prob. Identified?

Indicates whether the client satisfies the “Adh. Prob. Identified” condition based on qualifying client or related records.

Adh. Quan. Assessed?

Indicates whether the client satisfies the “Adh. quantitative Assessed” condition based on qualifying client or related records.

Adherence Assessment

Returns the client-level “Adherence Assessment” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Adherence Rate

Calculates the percentage or rate represented by “Adherence Rate” from the qualifying numerator and denominator values defined by the field and its date criteria.

ADR Client In Period

Returns the client-level “ADR Client In Period” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

ADR Gender

Returns the client-level “ADR Gender” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

ADR Has Med With No Days

Returns the client-level “ADR Has medication With No Days” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

ADR Hispanic

Returns the client-level “ADR Hispanic” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

ADR Poverty Level

Returns the client-level “ADR Poverty Level” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

ADR Pregnant in Period

Returns the client-level “ADR pregnancynant in Period” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

Age

Returns the client’s age calculated from date of birth and the report’s reference date.

Age at Begin Date

Returns the client’s age on the report Date From value.

Age At Date

Returns the client’s age on the configured key date.

Age at Enrollment

Returns the client’s age on the applicable provider enrollment date.

Age In Months

Returns the client’s age in completed months on the report’s reference date.

AgeGroup

Returns the age category determined by the field’s configured number-format ranges.

AIDS Clients on HAART

Returns the client-level “AIDS Clients on HAART” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

AIDS diagnosis date estimated

Indicates whether the AIDS diagnosis date on the client record is marked as estimated.

All Disbursements Have Pickups

Returns the client-level “All Disbursements Have Pickups” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Allergies

Displays the medication-allergy text recorded on the client record.

Alt Phone 1 Type

Displays the type assigned to the client’s first alternate phone number.

Alt Phone 2 Type

Displays the type assigned to the client’s second alternate phone number.

Alt. Phone 1

Displays the client’s first alternate phone number.

Alt. Phone 2

Displays the client’s second alternate phone number.

American Indian or Alaska Native

Indicates whether American Indian or Alaska Native is selected for the client’s race.

Annual Mental Health Screening

Returns the client-level “Annual Mental Health Screening” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Annual Review Year

Returns the client-level “Annual Review Year” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Annual Substance Abuse Screening

Returns the client-level “Annual Substance Abuse Screening” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Another Hispanic, Latino/a Or Spanish origin

Returns the client-level “Another Hispanic, Latino/a Or Spanish origin” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Anxiety Screen?

Indicates whether the client satisfies the “Anxiety Screen” condition based on qualifying client or related records.

Appetite Assessment?

Indicates whether the client satisfies the “Appetite Assessment” condition based on qualifying client or related records.

ART date stopped by date

Returns the art date stopped by date from the client record or the qualifying related record selected by the field’s date and subfilter criteria. As of the configured key date or report date through.

ART first prescribed date

Returns the art first prescribed date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

ART medications during pregnancy

Returns the client-level art medications during pregnancy, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

ART taken during pregnancy (RDR)

Returns the client-level “ART taken during pregnancy (RDR)” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

ART taken in pregnancy by date

Returns the art taken in pregnancy by date from the client record or the qualifying related record selected by the field’s date and subfilter criteria. As of the configured key date or report date through.

Asian Indian

Indicates whether Asian Indian is selected for the client’s Asian subgroup.

Association Plan

Returns the client-level “Association Plan” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Begin Date

Displays the Date From parameter used to run the custom report.

Billing Dgn Date

Returns the billing diagnosis date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Billing Provider N5

Returns the client-level billing provider n5, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

Billing Provider NPI

Returns the client-level billing provider npi, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

Birth Year

Returns the calendar year from the client’s date of birth.

Black or Afr American

Indicates whether Black or African American is selected for the client’s race.

Category Visits In Span By Funding

Returns the number of qualifying service or appointment records represented by “Category Visits In Span By Funding” within the configured Date From and Date Through span, after applying service-category, subservice, funding, and interval criteria.

CD4 Count from first ART in Span

Returns the number of qualifying records or items represented by “CD4 Count from first ART in Span” within the configured Date From and Date Through span. The count is record-based unless the field explicitly defines unduplicated clients.

CD4<200 with PCP proph CQM 2025 Edited

Returns the client-level “CD4<200 with PCP proph CQM 2025 Edited” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

CD4<200 with PCP prophylaxis

Returns the client-level cd4<200 with pcp prophylaxis selected or calculated from qualifying vital-sign, lab, or screening records.

Cervical Cancer Screening

Returns the client-level “Cervical Cancer Screening” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Cervical Cancer Screening Copy _6cf6

Returns the client-level “Cervical Cancer Screening Copy _6cf6” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Change in Screening Score for period

Calculates the difference represented by “Change in Screening Score for period” between the selected earlier and later qualifying values.

Chinese

Indicates whether Chinese is selected for the client’s Asian subgroup.

Chlamydia Screening

Returns the client-level “Chlamydia Screening” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

City

Displays the client’s city of residence.

Client Date Created

Displays the database timestamp recorded when the client record was created.

Client ID

Displays the provider or application client identifier configured for the client.

Client is Pregnant

Returns the client-level “Client is pregnancynant” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Client On ART

Returns the client-level “Client On ART” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Client On ART After Span

Returns the client-level “Client On ART After Span” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Client On ART During Span

Returns the client-level “Client On ART During Span” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Client pregnant at enrollment

Returns the client-level “Client pregnant at enrollment” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Client User

Displays the user identifier associated with the client record or client portal account.

Client's Bar Code

Displays the barcode value associated with the client record.

Clients with visit in last 4 months

Returns the client-level “Clients with visit in last 4 months” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Clinical data shared by client

Indicates whether client-level clinical data sharing is enabled for the client.

Cog. Func. Assessed?

Indicates whether the client satisfies the “Cog. Func. Assessed” condition based on qualifying client or related records.

Completed Hep A vaccine series

Indicates whether the client satisfies the “Completed Hep A vaccine series” condition based on qualifying client or related records.

Completed Hep B vaccine series

Indicates whether the client satisfies the “Completed Hep B vaccine series” condition based on qualifying client or related records.

Counseled about HIV risks

Indicates whether the client satisfies the “Counseled about HIV risks” condition based on qualifying client or related records.

Counseled about HIV risks by

Indicates whether the client satisfies the “Counseled about HIV risks by” condition based on qualifying client or related records.

County of residence

Displays the county linked to the client’s address.

Cuban

Indicates whether Cuban is selected for the client’s Hispanic subgroup.

Current Antiretrovirals

Returns the active or most recent antiretrovirals as of the report’s reference date, using related medication or regimen records.

Current ARV Abbreviation

Returns the active or most recent arv abbreviation as of the report’s reference date, using related medication or regimen records.

Current ARV Hrt Classes

Returns the active or most recent arv art classes as of the report’s reference date, using related medication or regimen records.

Current Regimen

Returns the active or most recent regimen as of the report’s reference date, using related medication or regimen records.

Current Regimen Line

Returns the active or most recent regimen line as of the report’s reference date, using related medication or regimen records.

Current Regimen Months

Returns the active or most recent regimen months as of the report’s reference date, using related medication or regimen records.

Current Regimen Start Date

Returns the active or most recent regimen start date as of the report’s reference date, using related medication or regimen records.

Date ARV med first started in date span

Returns the date arv med first started in date span from the client record or the qualifying related record selected by the field’s date and subfilter criteria. Within the configured date from and date through span.

Date client closed out services

Returns the date client closed out services from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date determined ready for antiretrovirals

Returns the date determined ready for antiretrovirals from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date Diff

Calculates the number of days between the two dates selected by the field and its subfilter settings.

Date First HIVQUAL Referral Made

Returns the date first hivqual referral made from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date First HIVQUAL Referral Received

Returns the date first hivqual referral received from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date First HIVQUAL Referral Received after PAP smear abnormal result

Returns the date first hivqual referral received after pap smear abnormal result from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date First Referral Made

Returns the date first referral made from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date First Referral Received

Returns the date first referral received from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date last antiretroviral stopped

Returns the date last antiretroviral stopped from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date Last Referral Made

Returns the date last referral made from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date Last Referral Received

Returns the date last referral received from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date Of  Last Insurance Assessment In Span

Returns the most recent qualifying insurance assessment in span within the configured Date From and Date Through span.

Date of ADAP enrollment

Returns the date of adap enrollment from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date of AIDS diagnosis

Displays the AIDS diagnosis date recorded on the client record.

Date of birth

Displays the client’s date of birth.

Date Of Death

Displays the date of death recorded on the client record.

Date of first ADAP service

Returns the earliest qualifying adap service from the client’s available history through the report Date Through.

Date of first ARV medication ever

Returns the earliest qualifying arv medication ever from the client’s available history through the report Date Through.

Date of First HIVQUAL service

Returns the earliest qualifying hivqual service from the client’s available history through the report Date Through.

Date Of First Insurance Assessment In Span

Returns the earliest qualifying insurance assessment in span within the configured Date From and Date Through span.

Date Of First Poverty Level In Span

Returns the earliest qualifying poverty level in span within the configured Date From and Date Through span.

Date of first service

Returns the earliest qualifying service from the client’s available history through the report Date Through.

Date of first service category in date span

Returns the earliest qualifying service category in date span within the configured Date From and Date Through span.

Date of First Subservice

Returns the earliest qualifying subservice from the client’s available history through the report Date Through.

Date of first vaccination

Returns the earliest qualifying vaccination from the client’s available history through the report Date Through.

Date of HIV diagnosis

Displays the HIV diagnosis date recorded on the client record.

Date of last ADAP service

Returns the most recent qualifying adap service from the client’s available history through the report Date Through.

Date of Last ARV Med Change

Returns the most recent qualifying arv medication change from the client’s available history through the report Date Through.

Date of Last ARV Med Stop

Returns the most recent qualifying arv medication stop from the client’s available history through the report Date Through.

Date of Last HIVQUAL service

Returns the most recent qualifying hivqual service from the client’s available history through the report Date Through.

Date Of Last Poverty Level In Span

Returns the most recent qualifying poverty level in span within the configured Date From and Date Through span.

Date of last service

Returns the most recent qualifying service from the client’s available history through the report Date Through.

Date of Last Srv Cat In Span

Returns the most recent qualifying service cat in span within the configured Date From and Date Through span.

Date Of Last STI Test In Span

Returns the most recent qualifying sti test in span within the configured Date From and Date Through span.

Date of Last Subservice

Returns the most recent qualifying subservice from the client’s available history through the report Date Through.

Date of latest Diagnosis

Returns the date of latest diagnosisnosis from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date of latest diagnosis by ICD9 code

Returns the date of latest diagnosis by icd9 code from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date of latest Diagnosis ICD10

Returns the date of latest diagnosisnosis icd10 from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date of latest ICD9 in a range

Returns the date of latest icd9 in a range from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date of the next PAP smear after abnormal result

Returns the date of the next pap smear after abnormal result from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date prenatal care began

Returns the date prenatal care began from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date transferred in

Returns the date transferred in from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Date transferred out

Returns the date transferred out from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Days between appointments

Returns the number of qualifying service or appointment records represented by “Days between appointments”, after applying service-category, subservice, funding, and interval criteria.

Days Enrolled

Returns the client-level “Days Enrolled” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Depress Screen?

Indicates whether the client satisfies the “Depress Screen” condition based on qualifying client or related records.

Diastolic Change

Calculates the difference represented by “Diastolic Change” between the selected earlier and later qualifying values.

Domestic Violence?

Indicates whether the client satisfies the “Domestic Violence” condition based on qualifying client or related records.

Eligible For RSR

Indicates whether the client satisfies the “Eligible For RSR” condition based on qualifying client or related records.

Encrypted UCI

Displays the client’s encrypted unique client identifier.

Encrypted URN

Displays the client’s encrypted unique record number used by the applicable reporting function.

End date of report

Displays the Date Through parameter used to run the custom report.

Enrollment date

Returns the enrollment date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

Enrollment status

Returns the client-level enrollment status, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

Enrollment status - RSR

Returns the client-level “Enrollment status - RSR” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

Enrollment status (old)

Returns the client-level enrollment status (old), using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

Enrollment status across providers

Returns the client-level enrollment status across providers, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

Enrollment status by date

Returns the latest applicable enrollment status on or before the configured key date or report Date Through.

Enrollment Status-ADAP

Returns the client-level enrollment status-adap, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

Enrollment status-RDR

Returns the client-level “Enrollment status-RDR” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

ER Visits In Period

Returns the number of qualifying service or appointment records represented by “ER Visits In Period” within the configured Date From and Date Through span, after applying service-category, subservice, funding, and interval criteria.

Filipino

Indicates whether Filipino is selected for the client’s Asian subgroup.

First ARV Abbreviation

Returns the earliest qualifying arv abbreviation from the client’s available history through the report Date Through.

First ARV Haart Classes

Returns the earliest qualifying arv haart classes from the client’s available history through the report Date Through.

First ARV Regimen

Returns the earliest qualifying arv regimen from the client’s available history through the report Date Through.

First Conception Date

Returns the earliest qualifying conception date from the client’s available history through the report Date Through.

First Counseled about HIV risks in Span

Returns the earliest qualifying counseled about hiv risks in span within the configured Date From and Date Through span.

First date of qualitative test

Returns the earliest qualifying date of qualitative test from the client’s available history through the report Date Through.

First date specific service received

Returns the earliest qualifying date specific service received from the client’s available history through the report Date Through.

First Eligibility Date Field Value

Returns the earliest qualifying eligibility date field value from the client’s available history through the report Date Through.

First Eligibility Date Field Value By Funding

Returns the earliest qualifying eligibility date field value by funding from the client’s available history through the report Date Through.

First Eligibility Field Value

Returns the earliest qualifying eligibility field value, evaluated through the report Date Through and the field’s subfilter criteria.

First Eligibility Field Value By Funding

Returns the earliest qualifying eligibility field value for the selected funding source, evaluated through the report Date Through and the field’s subfilter criteria.

First ever service date

Returns the earliest qualifying service date from the client’s available history through the report Date Through.

First HH Income In Span

Returns the earliest qualifying hh income in span within the configured Date From and Date Through span.

First HH Size In Span

Returns the earliest qualifying hh size in span within the configured Date From and Date Through span.

First Housing Arr In Span

Returns the earliest qualifying housing arr in span within the configured Date From and Date Through span.

First Ins Codes In Span

Returns the earliest qualifying ins codes in span within the configured Date From and Date Through span.

First Name

Displays the client’s first name.

First Poverty Level In Span

Returns the earliest qualifying poverty level in span within the configured Date From and Date Through span.

First Primary Ins Code In Span

Returns the earliest qualifying primary ins code in span within the configured Date From and Date Through span.

First Primary Insurance In Span

Returns the earliest qualifying primary insurance in span within the configured Date From and Date Through span.

First Prm. Medical Care In Span

Returns the earliest qualifying primary medical care in span within the configured Date From and Date Through span.

First Qualitative Lab Date

Returns the earliest qualifying qualitative lab date from the client’s available history through the report Date Through.

First Qualitative Lab Value

Returns the earliest qualifying qualitative lab value from the client’s available history through the report Date Through.

First Quantitative Lab Date

Returns the earliest qualifying quantitative lab date from the client’s available history through the report Date Through.

First Quantitative Lab Value

Returns the earliest qualifying quantitative lab value from the client’s available history through the report Date Through.

First RSR Housing Arr In Span

Returns the earliest qualifying rsr housing arr in span within the configured Date From and Date Through span.

First Screening Score In Period

Returns the earliest qualifying screening score in period within the configured Date From and Date Through span.

First Secondary Ins Codes In Span

Returns the earliest qualifying secondary ins codes in span within the configured Date From and Date Through span.

First Subform Field Value

Returns the earliest qualifying custom subform field value through the report Date Through, based on the selected form, field, and subfilter criteria.

Fixed user value

Returns the constant value entered in the field-selection configuration for every included report row.

Formatted Field

Returns another selected value after applying the custom report’s configured display format.

Full LIS

Returns the client-level “Full LIS” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Functional Status At ART

Returns the client-level functional status at art, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

Funding source international version

Returns the client-level funding source international version, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

Gap in HIV Medical Visits: EHE

Returns the number of qualifying service or appointment records represented by “Gap in HIV Medical Visits: EHE”, after applying service-category, subservice, funding, and interval criteria.

Gender

Displays the client’s gender value resolved from the gender reference values.

Gonorrhea Screening

Returns the client-level “Gonorrhea Screening” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Guamanian Or Chamorro

Indicates whether Guamanian or Chamorro is selected for the client’s Pacific Islander subgroup.

Haart Classes As of Date

Returns the latest applicable haart classes on or before the configured key date or report Date Through.

HAB: Gap in HIV medical visits

Returns the number of qualifying service or appointment records represented by “HAB: Gap in HIV medical visits”, after applying service-category, subservice, funding, and interval criteria.

HAB: HIV medical visit frequency

Returns the client-level “HAB: HIV medical visit frequency” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HAB: HIV viral load suppression

Returns the client-level “HAB: HIV viral load suppression” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HAB: Prescription of antiretroviral therapy

Returns the client-level “HAB: Prescription of antiretroviral therapy” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

Had HOPWA Subsidy In Span

Indicates whether the client satisfies the “HOPWA Subsidy In Span” condition based on qualifying client or related records. Within the configured date from and date through span.

Had HOPWA Subsidy Prior Year

Indicates whether the client satisfies the “HOPWA Subsidy Prior Year” condition based on qualifying client or related records. During the prior reporting year.

Had Vaccination

Indicates whether the client satisfies the “Vaccination” condition based on qualifying client or related records.

Has ADAP Funded Drug Services

Indicates whether the client satisfies the “ADAP Funded Drug Services” condition based on qualifying client or related records.

Has Any Drug Service

Indicates whether the client satisfies the “Any Drug Service” condition based on qualifying client or related records.

Has Any Service

Indicates whether the client satisfies the “Any Service” condition based on qualifying client or related records.

Has clinical encounter

Indicates whether the client satisfies the “clinical encounter” condition based on qualifying client or related records.

Has Contract Item

Indicates whether the client satisfies the “Contract Item” condition based on qualifying client or related records.

Has Contract Item By Name

Indicates whether the client satisfies the “Contract Item By Name” condition based on qualifying client or related records.

Has Current ROI

Indicates whether the client satisfies the “Current ROI” condition based on qualifying client or related records.

Has Diagnosis Code

Indicates whether the client satisfies the “diagnosisnosis Code” condition based on qualifying client or related records.

Has Drug Class Change

Indicates whether the client satisfies the “Drug Class Change” condition based on qualifying client or related records.

Has Drug Disbursements In Period

Indicates whether the client satisfies the “Drug Disbursements In Period” condition based on qualifying client or related records. Within the configured date from and date through span.

Has Form

Indicates whether the client satisfies the “Form” condition based on qualifying client or related records.

Has HAART Class

Indicates whether the client satisfies the “HAART Class” condition based on qualifying client or related records.

Has HIV Risk Factor

Indicates whether the client satisfies the “HIV Risk Factor” condition based on qualifying client or related records.

Has HOPWA Service In Span

Indicates whether the client satisfies the “HOPWA Service In Span” condition based on qualifying client or related records. Within the configured date from and date through span.

Has Immunization Code

Indicates whether the client satisfies the “Immunization Code” condition based on qualifying client or related records.

Has Immunization In Period

Indicates whether the client satisfies the “Immunization In Period” condition based on qualifying client or related records. Within the configured date from and date through span.

Has Lab Code

Indicates whether the client satisfies the “Lab Code” condition based on qualifying client or related records.

Has Medication

Indicates whether the client satisfies the “Medication” condition based on qualifying client or related records.

Has Medication Code

Indicates whether the client satisfies the “Medication Code” condition based on qualifying client or related records.

Has medication in period

Indicates whether the client satisfies the “medication in period” condition based on qualifying client or related records. Within the configured date from and date through span.

Has Non HOPWA Only Service In Span

Indicates whether the client satisfies the “Non HOPWA Only Service In Span” condition based on qualifying client or related records. Within the configured date from and date through span.

Has OI Prophylaxis

Indicates whether the client satisfies the “OI Prophylaxis” condition based on qualifying client or related records.

Has OI prophylaxis in period

Indicates whether the client satisfies the “OI prophylaxis in period” condition based on qualifying client or related records. Within the configured date from and date through span.

Has OI Treatment

Indicates whether the client satisfies the “OI Treatment” condition based on qualifying client or related records.

Has PCP Proph if indicated

Indicates whether the client satisfies the “PCP Proph if indicated” condition based on qualifying client or related records.

Has Pos HBsAb Since AIDS Diag

Indicates whether the client satisfies the “Pos HBsAb Since AIDS diagnosis” condition based on qualifying client or related records.

Has Preceding Immunizations

Indicates whether the client satisfies the “Preceding Immunizations” condition based on qualifying client or related records.

Has Preceding Services

Indicates whether the client satisfies the “Preceding Services” condition based on qualifying client or related records.

Has primary health care service

Indicates whether the client satisfies the “primary health care service” condition based on qualifying client or related records.

Has Provider

Indicates whether the client satisfies the “Provider” condition based on qualifying client or related records.

Has Qualitative Test Result

Indicates whether the client satisfies the “Qualitative Test Result” condition based on qualifying client or related records.

Has Qualitative Test Treatment

Indicates whether the client satisfies the “Qualitative Test Treatment” condition based on qualifying client or related records.

Has Quantitative Lab Value Maintaining Threshold

Indicates whether the client satisfies the “Quantitative Lab Value Maintaining Threshold” condition based on qualifying client or related records.

Has Referral

Indicates whether the client satisfies the “Referral” condition based on qualifying client or related records.

Has Referral Code

Indicates whether the client satisfies the “Referral Code” condition based on qualifying client or related records.

Has referral of specific type

Indicates whether the client satisfies the “referral of specific type” condition based on qualifying client or related records.

Has referral type with status

Indicates whether the client satisfies the “referral type with status” condition based on qualifying client or related records.

Has RSR Defined Funded Service

Indicates whether the client satisfies the “RSR Defined Funded Service” condition based on qualifying client or related records.

Has RSR Service For Funded Provider

Indicates whether the client satisfies the “RSR Service For Funded Provider” condition based on qualifying client or related records.

Has RW Funded Service

Indicates whether the client satisfies the “Ryan White funded Service” condition based on qualifying client or related records.

Has RW Funded Service In Span

Indicates whether the client satisfies the “Ryan White funded Service In Span” condition based on qualifying client or related records. Within the configured date from and date through span.

Has RWHAP or EHE Service

Indicates whether the client satisfies the “RWHAP or EHE Service” condition based on qualifying client or related records.

Has Screening Code

Indicates whether the client satisfies the “Screening Code” condition based on qualifying client or related records.

Has Screening Lab Code

Indicates whether the client satisfies the “Screening Lab Code” condition based on qualifying client or related records.

Has Sec. 3 HOPWA Srv In Span

Indicates whether the client satisfies the “Sec. 3 HOPWA service In Span” condition based on qualifying client or related records. Within the configured date from and date through span.

Has Service Code

Indicates whether the client satisfies the “Service Code” condition based on qualifying client or related records.

Has Specific STI Test In Period

Indicates whether the client satisfies the “Specific STI Test In Period” condition based on qualifying client or related records. Within the configured date from and date through span.

Has STI Test In Period

Indicates whether the client satisfies the “STI Test In Period” condition based on qualifying client or related records. Within the configured date from and date through span.

Has Subform Field

Indicates whether the client satisfies the “Subform Field” condition based on qualifying client or related records.

Has Subsequent Immunizations

Indicates whether the client satisfies the “Subsequent Immunizations” condition based on qualifying client or related records.

Has Subsequent Services

Indicates whether the client satisfies the “Subsequent Services” condition based on qualifying client or related records.

Height At ART

Returns the client-level height at art selected or calculated from qualifying vital-sign, lab, or screening records.

Height At ART (cm)

Returns the client-level height at art (cm) selected or calculated from qualifying vital-sign, lab, or screening records.

Hemophiliac HIV risk factor

Indicates whether hemophilia-related blood exposure is selected as an HIV risk factor for the client.

Hepatitis B Screening

Returns the client-level “Hepatitis B Screening” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Hepatitis B Vaccination

Returns the client-level “Hepatitis B Vaccination” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Heterosexual HIV risk factor

Indicates whether heterosexual contact is selected as an HIV risk factor for the client.

High BMI

Returns the client-level high bmi selected or calculated from qualifying vital-sign, lab, or screening records.

High Diastolic

Returns the client-level high diastolic selected or calculated from qualifying vital-sign, lab, or screening records.

High Height

Returns the client-level high height selected or calculated from qualifying vital-sign, lab, or screening records.

High Pulse

Returns the client-level high pulse selected or calculated from qualifying vital-sign, lab, or screening records.

High Risk Insurance

Returns the client-level high risk insurance, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

High Risk Pool?

Indicates whether the client satisfies the “High Risk Pool” condition based on qualifying client or related records.

High Systolic

Returns the client-level high systolic selected or calculated from qualifying vital-sign, lab, or screening records.

High Temperature

Returns the client-level high temperature selected or calculated from qualifying vital-sign, lab, or screening records.

High Weight

Returns the client-level high weight selected or calculated from qualifying vital-sign, lab, or screening records.

Highest Quantitative Lab Date

Returns the highest qualifying quantitative lab date through the report Date Through, using the field’s test and subfilter criteria.

Highest Quantitative Lab Value

Returns the highest qualifying quantitative lab value through the report Date Through, using the field’s test and subfilter criteria.

Highest Screening Score In Period

Returns the highest qualifying screening score in period within the configured Date From and Date Through span, using the field’s test and subfilter criteria.

HIP 1st Service

Returns the client-level hip 1st service, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

HIP Date Closed

Returns the hip date closed from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

HIP Enrl Date

Returns the hip enrollment date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

HIP Enrl Status

Returns the client-level hip enrollment status, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

HIP Last Service

Returns the client-level hip last service, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

Hispanic

Indicates whether the client is recorded as Hispanic, Latino/a, or Spanish origin.

Hispanic ethnicity

Displays the client’s Hispanic ethnicity value using the configured Yes/No/Unknown reference values.

HIV Date Estimated

Indicates whether the HIV diagnosis date on the client record is marked as estimated.

HIV Link Date

Returns the hiv link date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

HIV Pos Test Date

Returns the hiv pos test date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

HIV Positive

Returns the client-level “HIV Positive” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

HIV Posttest counsled (RDR)

Returns the client-level “HIV Posttest counsled (RDR)” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HIV pretest counseling (RDR)

Returns the client-level “HIV pretest counseling (RDR)” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HIV Risk Factor

Displays the client’s HIV risk-factor category derived from the selected risk-factor flags.

HIV Status

Displays the HIV status recorded for the client.

HIV Status By Date

Returns the latest applicable hiv status on or before the configured key date or report Date Through.

HIV Status of Newborn

Returns the client-level hiv status of newborn, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

HIV tested (RDR)

Returns the client-level “HIV tested (RDR)” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HIVQUAL Export?

Indicates whether the client satisfies the “HIVQUAL Export” condition based on qualifying client or related records.

HOPWA Age Category

Returns the client-level “HOPWA Age Category” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HOPWA Chronic Homelessness

Returns the client-level “HOPWA Chronic Homelessness” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HOPWA Enroll Date

Returns the hopwa enroll date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

HOPWA Exit Date

Returns the hopwa exit date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

HOPWA NonSTRMU Housing By Sbs

Returns the client-level “HOPWA NonSTRMU Housing By subservice” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HOPWA Pre-Enrollment Housing Situation

Returns the client-level “HOPWA Pre-Enrollment Housing Situation” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HOPWA STRMU Exit Outcome

Returns the client-level “HOPWA STRMU Exit Outcome” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HOPWA STRMU Housing By Sbs

Returns the client-level “HOPWA STRMU Housing By subservice” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HOPWA TBRA Exit Outcome

Returns the client-level “HOPWA TBRA Exit Outcome” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HOPWA Trans Facility Outcome

Returns the client-level “HOPWA Trans Facility Outcome” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

HOPWA Veteran Status

Returns the client-level “HOPWA Veteran Status” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

Hospital Admissions In Period

Returns the client-level “hospitalital Admissions In Period” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Household Income

Returns the client-level “Household Income” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Household Size

Returns the client-level “Household Size” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

Housing Arr - RSR CLD

Returns the client-level “Housing Arr - RSR CLD” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

Housing status

Returns the client-level housing status, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

Housing status (RSR)

Returns the client-level “Housing status (RSR)” result using the applicable CAREWare program-reporting logic and the qualifying demographic, clinical, enrollment, insurance, or service records.

Housing Status Date

Returns the housing status date from the client record or the qualifying related record selected by the field’s date and subfilter criteria.

HRSA visits by Service Category (RDR)

Returns the number of qualifying service or appointment records represented by “HRSA visits by Service Category (RDR)”, after applying service-category, subservice, funding, and interval criteria.

IDU

Indicates whether injection drug use is selected as an HIV risk factor for the client.

IGRA Result

Returns the client-level igra result, using the client record or the most applicable related record selected by the field’s date and subfilter criteria.

Imm Or Proc Count After Imm Or Proc

Returns the number of qualifying records or items represented by “Imm Or Proc Count After Imm Or Proc”. The count is record-based unless the field explicitly defines unduplicated clients.

Imm Or Proc Count Before Imm Or Proc

Returns the number of qualifying records or items represented by “Imm Or Proc Count Before Imm Or Proc”. The count is record-based unless the field explicitly defines unduplicated clients.

Immunization And Procedure Count

Returns the number of qualifying records or items represented by “Immunization And Procedure Count”. The count is record-based unless the field explicitly defines unduplicated clients.

Immunization Count

Returns the number of qualifying records or items represented by “Immunization Count”. The count is record-based unless the field explicitly defines unduplicated clients.

Indian Health Service

Indicates whether Indian Health Service coverage is selected in the applicable insurance assessment.

Influenza vaccination

Returns the client-level “Influenza vaccination” value from the client record or qualifying related records, according to the field’s date, code, provider, funding, and subfilter settings.

International version

Indicates whether the result or configuration applies to CAREWare’s international-version data elements.

Is ART funded by US Govt: International version

Indicates whether the client satisfies the “ART funded by US Govt: International version” condition based on qualifying client or related records.

Is client race Asian?

Indicates whether the client has any Asian race or Asian subgroup selection.

Is date of birth estimated?

Indicates whether the client’s date of birth is marked as estimated.

Is Part D Client

Indicates whether the client satisfies the “Part D Client” condition based on qualifying client or related records.

Is RW Eligible In Span

Indicates whether the client satisfies the “RW Eligible In Span” condition based on qualifying client or related records. Within the configured date from and date through span.

Japanese

Indicates whether Japanese is selected for the client’s Asian subgroup.

Korean

Indicates whether Korean is selected for the client’s Asian subgroup.

Lab interval count

Returns the number of qualifying records or items represented by “Lab interval count”. The count is record-based unless the field explicitly defines unduplicated clients.

Last Billing Insurer

Returns the most recent qualifying billing insurer from the client’s available history through the report Date Through.

Last Billing Notes

Returns the most recent qualifying billing notes from the client’s available history through the report Date Through.

Last Billing PrimaryID

Returns the most recent qualifying billing primaryid from the client’s available history through the report Date Through.

Last Billing SecondaryID

Returns the most recent qualifying billing secondaryid from the client’s available history through the report Date Through.

Last Blood Pressure

Returns the most recent qualifying blood pressure from the client’s available history through the report Date Through.

Last BMI

Returns the most recent qualifying bmi from the client’s available history through the report Date Through.

Last Case Note

Returns the most recent qualifying case note from the client’s available history through the report Date Through.

Last Case Note Date

Returns the most recent qualifying case note date from the client’s available history through the report Date Through.

Last Counseled about HIV risks in Span

Returns the most recent qualifying counseled about hiv risks in span within the configured Date From and Date Through span.

Last Date PCP Preventive Med Started

Returns the most recent qualifying date pcp preventive medication started from the client’s available history through the report Date Through.

Last Diastolic

Returns the most recent qualifying diastolic from the client’s available history through the report Date Through.

Last Eligibility Field Value

Returns the most recent qualifying eligibility field value, evaluated through the report Date Through and the field’s subfilter criteria.

Last Eligibility Field Value By Funding

Returns the most recent qualifying eligibility field value for the selected funding source, evaluated through the report Date Through and the field’s subfilter criteria.

Last Height

Returns the most recent qualifying height from the client’s available history through the report Date Through.

Last HH Income In Span

Returns the most recent qualifying hh income in span within the configured Date From and Date Through span.

Last HH Size In Span

Returns the most recent qualifying hh size in span within the configured Date From and Date Through span.

Last HOPWA Subsidy Date

Returns the most recent qualifying hopwa subsidy date from the client’s available history through the report Date Through.

Last Housing Arr In Span

Returns the most recent qualifying housing arr in span within the configured Date From and Date Through span.

Last ICD10 Diagnosis Date

Returns the most recent qualifying icd10 diagnosisnosis date from the client’s available history through the report Date Through.

Last Ins Codes In Span

Returns the most recent qualifying ins codes in span within the configured Date From and Date Through span.

Last Name

Displays the client’s last name.

Last OI Prophylaxis Medication

Returns the most recent qualifying oi prophylaxis medication from the client’s available history through the report Date Through.

Last Poverty Level In Span

Returns the most recent qualifying poverty level in span within the configured Date From and Date Through span.

Last Preg Outcome In Span

Returns the most recent qualifying pregnancy outcome in span within the configured Date From and Date Through span.

Last Primary Ins Code In Span

Returns the most recent qualifying primary ins code in span within the configured Date From and Date Through span.

Last Primary Insurance In Span

Returns the most recent qualifying primary insurance in span within the configured Date From and Date Through span.

Last Prm. Medical Care In Span

Returns the most recent qualifying primary medical care in span within the configured Date From and Date Through span.

Last Pulse

Returns the most recent qualifying pulse from the client’s available history through the report Date Through.

Last Qualitative Action

Returns the most recent qualifying qualitative action from the client’s available history through the report Date Through.

Last Qualitative Date With Values

Returns the most recent qualifying qualitative date with values from the client’s available history through the report Date Through.

Last Qualitative Lab Date

Returns the most recent qualifying qualitative lab date from the client’s available history through the report Date Through.

Last Qualitative Lab Value

Returns the most recent qualifying qualitative lab value from the client’s available history through the report Date Through.

Last Qualitative Result With Values

Returns the most recent qualifying qualitative result with values from the client’s available history through the report Date Through.

Last Qualitative Treatment

Returns the most recent qualifying qualitative treatment from the client’s available history through the report Date Through.

Last Quantitative Date With Values

Returns the most recent qualifying quantitative date with values from the client’s available history through the report Date Through.

Last Quantitative Lab Date

Returns the most recent qualifying quantitative lab date from the client’s available history through the report Date Through.

Last Quantitative Lab Operator

Returns the most recent qualifying quantitative lab operator from the client’s available history through the report Date Through.

Last Quantitative Lab Value

Returns the most recent qualifying quantitative lab value from the client’s available history through the report Date Through.

Last Quantitative Result With Values

Returns the most recent qualifying quantitative result with values from the client’s available history through the report Date Through.

Last ROI End Date

Returns the most recent qualifying roi end date from the client’s available history through the report Date Through.

Last ROI Start Date

Returns the most recent qualifying roi start date from the client’s available history through the report Date Through.

Last RSR Housing Arr In Span

Returns the most recent qualifying rsr housing arr in span within the configured Date From and Date Through span.

Last Screening OID

Returns the most recent qualifying screening oid from the client’s available history through the report Date Through.

Last Screening Score In Period

Returns the most recent qualifying screening score in period within the configured Date From and Date Through span.

Last Secondary Ins Codes In Span

Returns the most recent qualifying secondary ins codes in span within the configured Date From and Date Through span.