RYAN_WHITE_RSR_DATA
Description:
This table contains the basic information from Ryan White abstractions.

Primary Key
Column Name Ordinal Position
REGISTRY_DATA_ID 1

Column Information
Name Type Discontinued?
1 REGISTRY_DATA_ID NUMERIC No
The unique identifier (.1 item) for the registry data record.
2 CUR_STAGE_C_NAME VARCHAR No
The current state of the registry record
May contain organization-specific values: Yes
Category Entries:
New
Associated
Populated
In Progress
Edited
Validated
Needs Review
Ready for Export
Exported
Restored
Signed
Ready to Sign
Ready to Submit
Submitted
Accepted
Rejected
Done
Submit
Historical
Modified
Inactivated
Void
Saved to EQRS
Dialysis Intra-Facility Transfer
End COSD Pathway
Investigating
Closed
Abstracting
Completed
Ready for Nurse Review
Ready for Physician Review
Waiting for Signoff
Care Planning Complete
Will Not Be Exported
Accepted with Warnings
Unopened
Canceled
A0410 Correction Requested
Wrong FAC_ID
Test Record
Corrected/Inactivated/Deleted
Abandoned
Admission Complete
Doc Complete
Filed
3 RYN_WHT_REPORT_YEAR INTEGER No
The Ryan White reporting year.
4 RYN_WHT_REG_CODE_C_NAME VARCHAR No
The unique provider registration code that is automatically generated when the provider is entered into the RSR Web system provider directory.
May contain organization-specific values: Yes
No Entries Defined
5 RYN_WHT_UNIQUE_CLIENT_ID VARCHAR No
The encrypted, unique client identifier generated by the HAB Unique Client Identifier (UCI) generation utilities.
6 RYN_WHT_ENROLL_STATUS_C_NAME VARCHAR No
The patient's enrollment status in the Ryan White program at the end of the reporting period.
May contain organization-specific values: No
Category Entries:
Active, continuing in program
Referred to another program or services, or self-sufficient
Removed from treatment due to violation of rules
Incarcerated
Relocated
Deceased
7 RYN_WHT_BIRTH_YEAR INTEGER No
The patient's year of birth.
8 RYN_WHT_ETHNICITY_C_NAME VARCHAR No
The patient's ethnicity
May contain organization-specific values: No
Category Entries:
Hispanic/Latino
Non-Hispanic/Latino
9 RYN_WHT_SEX_AT_BIRTH_C_NAME VARCHAR No
The biological sex assigned to the patient at birth.
May contain organization-specific values: No
Category Entries:
Male
Female
10 RYN_WHT_CURRENT_GENDER_C_NAME VARCHAR No
The patient's current gender.
May contain organization-specific values: No
Category Entries:
Male
Female
Transgender
Unknown
Transgender Male to Female
Transgender Female to Male
Transgender Other
11 RYN_WHT_FPL_PERCENT NUMERIC No
The annual household income of the patient being reported to the Ryan White program.
12 RYN_WHT_HOUSING_STATUS_C_NAME VARCHAR No
Patient's housing status at the end of the reporting period.
May contain organization-specific values: No
Category Entries:
Stable/permanent
Temporary
Unstable
13 RYN_WHT_HIVAIDSSTATUS_C_NAME VARCHAR No
Patient's HIV/AIDS status at the end of the reporting period.
May contain organization-specific values: No
Category Entries:
HIV negative
HIV positive, not AIDS
HIV positive, AIDS status unknown
CDC defined AIDS
HIV indeterminate (infants only)
14 RYN_WHT_HIV_DX_YEAR INTEGER No
The year of the patient's HIV diagnosis.
15 RYN_WHT_RISK_SCR_PROV_YN VARCHAR No
Did the patient receive risk reduction screening/counseling during this reporting period?
May contain organization-specific values: No
Category Entries:
No
Yes
16 RYN_WHT_FIRST_AMB_DATE DATETIME No
Date of patient's first ambulatory care date at this provider agency. This value must be on or before the last date of the reporting period.
17 RYN_WHT_PRESC_PCP_PRLX_C_NAME VARCHAR No
Was the patient prescribed PCP Prophylaxis anytime during this reporting period.
May contain organization-specific values: No
Category Entries:
No
Yes
Not medically indicated
No, client refused
18 RYN_WHT_PRESC_ART_C_NAME VARCHAR No
Was the patient prescribed Antiretroviral Therapy(ART) anytime during this reporting period.
May contain organization-specific values: No
Category Entries:
Yes
No, not ready (as determined by clinician)
No, client refused
No, intolerance, side-effect, toxicity
No, ART payment assistance unavailable
No, other reason
No
19 RYN_WHT_SCR_TB_C_NAME VARCHAR No
Has the patient been screened for TB since his/her HIV diagnosis.
May contain organization-specific values: No
Category Entries:
No
Yes
Not medically indicated
Unknown
20 RYN_WHT_SCR_SYPHILIS_C_NAME VARCHAR No
Was the patient screened for syphilis during this reporting period? Exclude if under the age of 18 and not sexually active.
May contain organization-specific values: No
Category Entries:
No
Yes
Not medically indicated
21 RYN_WHT_SCR_HEP_B_C_NAME VARCHAR No
Has the patient been screened for Hepatitis B since his/her HIV diagnosis?
The category values for this column were already listed for column: RYN_WHT_SCR_TB_C_NAME
22 RYN_WHT_VACC_HEP_B_C_NAME VARCHAR No
Has the patient completed the vaccine series for Hepatitis B?
The category values for this column were already listed for column: RYN_WHT_SCR_SYPHILIS_C_NAME
23 RYN_WHT_SCR_HEP_C_C_NAME VARCHAR No
Has the patient been screened for Hepatitis C since his/her HIV diagnosis?
The category values for this column were already listed for column: RYN_WHT_SCR_TB_C_NAME
24 RYN_WHT_SCR_SBST_ABUSE_C_NAME VARCHAR No
Was the patient screened for substance abuse during the reporting period?
The category values for this column were already listed for column: RYN_WHT_SCR_SYPHILIS_C_NAME
25 RYN_WHT_MENTAL_SCR_C_NAME VARCHAR No
Was the patient screened for mental health during the reporting period?
The category values for this column were already listed for column: RYN_WHT_SCR_SYPHILIS_C_NAME
26 RYN_WHT_RECV_PAP_SMEAR_C_NAME VARCHAR No
Did the patient receive a cervical pap smear during the reporting period.
May contain organization-specific values: No
Category Entries:
No
Yes
Not medically indicated
Not applicable
27 RYN_WHT_PREGNANT_C_NAME VARCHAR No
Was the patient pregnant during the reporting period.
May contain organization-specific values: No
Category Entries:
No
Yes
Not applicable
28 RYN_WHT_HIV_POS_DATE DATETIME No
Date of patient's last confidential confirmatory HIV test with a positive result within the reporting period.
29 RYN_WHT_OAMC_LINK_DATE DATETIME No
Date of patient's first Outpatient Ambulatory Medical Care (OAMC) visit after positive HIV test.
30 RYN_WHT_PROVIDER_ID NUMERIC No
The unique provider organization identifier assigned through the Ryan White HIV/AIDS Program Data Report (RDR) or RSR Web application.
31 RYN_WHT_VITAL_STATUS_C_NAME VARCHAR No
Holds the vital status of a Ryan White patient.
May contain organization-specific values: No
Category Entries:
Deceased
Unknown
Alive
32 RYN_WHT_HOUSING_DATE DATETIME No
Holds date of collection of housing status for Ryan White reporting.
33 RW_NEW_CLIENT_YN VARCHAR No
Holds whether the patient is new to this provider.
The category values for this column were already listed for column: RYN_WHT_RISK_SCR_PROV_YN
34 RW_SERV_PREV_YEAR_YN VARCHAR No
Holds whether the patient received services in the previous year.
The category values for this column were already listed for column: RYN_WHT_RISK_SCR_PROV_YN
35 RYN_WHT_CW_ENROLL_STAT_C_NAME VARCHAR No
Ryan White client enrollment status
May contain organization-specific values: No
Category Entries:
Active
Referred or Discharged
Removed
Incarcerated
Relocated
36 RYN_WHT_ENROLL_DATE DATETIME No
Ryan White enrollment date
37 RYN_WHT_CASE_CLOSED_DATE DATETIME No
The date the Ryan White case was closed.
38 RYN_WHT_AIDS_DATE DATETIME No
The date on which the patient was first diagnosed with AIDS
39 RYN_WHT_AIDS_DATE_EST_YN VARCHAR No
Is the date of first AIDS diagnosis an estimate?
May contain organization-specific values: No
Category Entries:
No
Yes
40 RYN_WHT_ART_RX_DATE DATETIME No
The date ART medication was first prescribed to the patient.
41 RYN_WHT_ADAP_APP_DATE DATETIME No
Date of the ADAP application for the patient.
42 RYN_WHT_HIV_DATE DATETIME No
The date on which the patient was first diagnosed with HIV
43 RYN_WHT_HIV_DATE_EST_YN VARCHAR No
Is the date of first HIV diagnosis an estimate?
The category values for this column were already listed for column: RYN_WHT_AIDS_DATE_EST_YN
44 RYN_WHT_HOUSEHOLD_INCOME NUMERIC No
The patient's household income for Ryan White reporting
45 RYN_WHT_HOUSEHOLD_SIZE INTEGER No
The number of people in the patient's household for Ryan White reporting
46 RYN_WHT_POVERTY_LEVEL_DATE DATETIME No
The date of the poverty level assessment for Ryan White reporting
47 RYN_WHT_INDIVIDUAL_INCOME NUMERIC No
The patient's individual income for Ryan White reporting
48 RYN_WHT_PRE_ART_REASON_C_NAME VARCHAR No
The reason ART medication was not prescribed to the patient.
May contain organization-specific values: No
Category Entries:
Treatment not medically indicated per guidelines
Client not ready (as determined by clinician)
Client refused therapy
Other extenuating circumstances (e.g. inadequate insurance, ability to pay)
49 RYN_WHT_SUBSTANCE_ABUSE_C_NAME VARCHAR No
Stores the value for the Ryan White Substance Abuse annual review screening.
May contain organization-specific values: No
Category Entries:
Yes
No
Not medically indicated
50 RYN_WHT_SUBSTANCE_ABUSE_DT DATETIME No
The date on whice the Ryan White substance abuse annual review screening took place.
51 RYN_WHT_MENTAL_HEALTH_C_NAME VARCHAR No
The result of the Ryan White annual review mental health screening.
The category values for this column were already listed for column: RYN_WHT_SUBSTANCE_ABUSE_C_NAME
52 RYN_WHT_MENTAL_HEALTH_DT DATETIME No
The date on which the Ryan White annual review mental health screening took place.
53 RYN_WHT_HIV_RISK_COUNS_YN VARCHAR No
The result of the Ryan White annual review risk reduction counseling screening.
The category values for this column were already listed for column: RYN_WHT_AIDS_DATE_EST_YN
54 RYN_WHT_HIV_RRC_DATE DATETIME No
The date on which the Ryan White annual review HIV risk reduction counseling took place.
55 RYN_WHT_HIV_RRC_CNS_BY_C_NAME VARCHAR No
Enter who did the couseling for the Ryan White annual review HIV risk reduction counseling screening.
May contain organization-specific values: No
Category Entries:
Primary care clinician
Case mgr/social worker
Other trained counselor
Unknown
56 RYN_WHT_HIV_PRIM_CARE_C_NAME VARCHAR No
The result of the Ryan White annual review HIV primary care screening.
May contain organization-specific values: No
Category Entries:
Publicly-funded clinic or health dept.
Emergency Room
Hospital outpatient center
No primary source of care
Other
Private practice
Unknown
57 RYN_WHT_HIV_PC_DATE DATETIME No
The date on which the Ryan White annual review HIV primary care screening took place.