RYAN_WHITE_MED_DATA
Description:
Ryan White CAREWare Medication Import Table.

Primary Key
Column Name Ordinal Position
REGISTRY_DATA_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 REGISTRY_DATA_ID NUMERIC No
The unique identifier (.1 item) for the registry data record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 RW_MED_ORDER_ID NUMERIC No
Stores the Medication Order Id for the Medication Import Table
4 RW_MED_UNITS NUMERIC No
Ryan White Medication Units
5 RW_MED_STRENGTH INTEGER No
Ryan White Medication Strength
6 RW_MED_FREQUENCY_C_NAME VARCHAR No
Ryan White Medication Frequency
May contain organization-specific values: Yes
Category Entries:
Every Day
Twice a Day
Three Times a Day
Four Times a Day
As Necessary
Once a Week
Biweekly
Three Times in a Week
Every Other Week
Every Other Day
Every Hour
Every Bedtime
Every Morning
Every 6 Hours
Every 12 Hours
7 RW_MED_START_DATE DATETIME No
Ryan White Medication Start Date
8 RW_MED_END_DATE DATETIME No
Ryan White Medication End Date
9 RW_MED_INDICATION_C_NAME VARCHAR No
Ryan White Medication Indication
May contain organization-specific values: Yes
Category Entries:
ART
OI Prophylaxis
OI Treatment
Other
10 RW_MED_PRPHYLAXIS_C_NAME VARCHAR No
Ryan White Medication Prophylaxis
May contain organization-specific values: Yes
Category Entries:
Pneumocytis carinii pneumonia
M. avium complex
M. tuberculosis
Candida
Cytomegalovirus
Toxoplasma gondii
Varicella zoster virus
Other
11 RW_MED_DIS_REASON_C_NAME VARCHAR No
Ryan White Medication discontinue reason. Not the same concept as an Epic discontiunue reason
May contain organization-specific values: Yes
Category Entries:
Virologic Failure
Toxicity
Intolerance
Lost to followup
Dose Change
Other
Therapy completed
Improved immune function
Unknown
Stock out/supply disruption
Managed treatment interruption
Non-adherent
Immunological Failure
Pregnant
Risk of Pregnancy
Newly diagnosed TB
Availability of New Drug
Illness or hospitalization
Patient lacks sufficient financial resource
Patient Decision
12 RW_MED_COMMENT VARCHAR No
Ryan White Medication Comment
13 RW_MED_INSTRUCTIONS VARCHAR No
Ryan White Medication Instructions
14 RW_MED_MEDICATION_ID NUMERIC No
Stores the Medication ID (ERX) of the Order in (I RDI 30150)