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
Needs Review - Updated
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
Manually Submitted
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
Ready for Prospective Reporting
Prospective Reporting Complete
Ready for Final Export
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
Unknown
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_CMS_MU_NAME | VARCHAR | No |
The name of the CMS Meaningful Use record.
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
Inactive/Case Closed
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.