tblMED
Other medications
Table status
Status Unknown

Variables

Field Name Format Description
PATIENTCharacter or Numeric
*Required
Code to identify patient (Cohort Patient ID)
MED_IDCharacter
See Code List
*Required
ATC Code for drug
See ATC code list
MED_SDYYYY-MM-DD
*Required
Date of initiation of drug
MED_SD_ACharacter
< = Before this date
D = Exact to the date
M = Exact to the month
Y = Exact to the year
> = After the date
U = Unknown
Date approximation for MED_SD
MED_EDYYYY-MM-DD
Date of stopping drug
MED_ED_ACharacter
< = Before this date
D = Exact to the date
M = Exact to the month
Y = Exact to the year
> = After the date
U = Unknown
Date approximation for MED_ED
MED_RSCharacter
See Code List
Reason for stopping drug
MED_RS2Character
See Code List
Additional reason for stopping drug
MED_RS3Character
See Code List
Additional reason for stopping drug
Use same list of codes as MED_RS
MED_RS4Character
See Code List
Additional reason for stopping drug
MEDSTART_RSCharacter
1 = Treatment (incl. for presumptive dx)
2 = Prophylaxis (primary or secondary)
9 = Unknown
Reason for starting medication (optional)
MED_DONumeric
Dosage (mg or mL) per intake unless MED_FR=-1 (frequency unknown), in which case it means dosage per day
(optional)
MED_FRNumeric
-1 = Frequency not known
0.33 = 1 dose every third day
0.5 = 1 dose every second day
1 = 1 daily dose/qd
2 = 2 daily doses/bid
3 = 3 daily doses/tid
4 = 4 daily doses
5 = 5 daily doses
6 = 6 daily doses
7 = 7 daily doses
8 = 8 daily doses
9 = 9 daily doses
10 = 10 daily doses
Frequency (optional)
DOT_YNumeric
0 = No
1 = Yes
9 = Unknown
Directly observed treatment
(optional)