tblMED - Other medication

holds type, start and stop dates for other medication/treatments.

Core Fields

Note: Fields marked bold form the unique identifier for a record of the table.

Field name Format Description
PATIENT character (or numeric if possible) Code to identify patient (Cohort Patient ID)
MED_ID character. see coding table for valid codings. Code representing the treatment
MED_SD yyyy-mm-dd Date of Initiation of Treatment
MED_SD_A character: see coding of date precision Precision annotation variable for date of initiation of drug
MED_ED yyyy-mm-dd Date of stopping treatment
MED_ED_A character: see coding of date precision Precision annotation variable for date of stopping drug
MED_RS character. see coding table for valid codings (identical to stopping reasons for ART) reason for stopping treatment

Additional Fields

Field name Format Description
MED_RS2 character. see coding table for valid codings (identical to stopping reasons for ART) Additional reason for stopping treatment
MED_RS3 character. see coding table for valid codings (identical to stopping reasons for ART) Additional reason for stopping treatment
MED_RS4 character. see coding table for valid codings (identical to stopping reasons for ART) Additional reason for stopping treatment
MED_DO numeric Dosage (mg or mL) per intake unless MED_FR=-1 (optional)
MED_FR

numeric:

  • -1 = Frequency not known. MED_DO contains dosage per day
  • 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... = code gives number of daily doses
Frequency
DOT_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown / Not performed
Directly observed Treatment (optional)
MEDSTART_RS

numeric:

  • 1 = Treatment (incl. for presumptive dx)
  • 2 = Prophylaxis (Primary or secondary)
  • 9 = Unknown
Reason for starting medication (optional)

QA Checks

Table Crosstable Error Code Description Study specific Is HICDEP
AllTables CrossTable ATC001 any date in database after DEATH_D in tblLTFU Yes
AllTables CrossTable ATC002 any date in database after DROP_D in tblLTFU Yes
AllTables CrossTable ATC003 any date in database before BIRTH_D in tblBAS Yes
AllTables CrossTable ATC004 any date in database in the future Yes
AllTables CrossTable ATC005 patients submitted previously who have been missed out Yes
AllTables CrossTable ATC006 Any fields not coded as coding lists on table definition Yes
tblMED WithinTable MW001 Duplicate records Yes
tblMED WithinTable MW002 MED_ONG=0 and MED_ED null EPPICC No
tblMED WithinTable MW003 MED_ONG=1 and MED_ED non-null EPPICC No
tblMED WithinTable MW004 Missing MED_ID Yes
tblMED WithinTable MW005 Missing MED_SD Yes
tblMED WithinTable MW006 Misisng MED_ED Yes
tblMED WithinTable MW007 Overlapping periods of same drug Yes
tblMED WithinTable MW008 MED_ED < MED_SD Yes
tblMED WithinTable MW009 MED_RS not null, but end date NULL Yes
tblMED CrossTable MC001 Patient has no records in tblBAS Yes