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


TableCrosstableError CodeDescriptionStudy specificHICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFU Yes
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFU Yes
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBAS Yes
AllTablesCrossTableATC004any date in database in the future Yes
AllTablesCrossTableATC005patients submitted previously who have been missed out Yes
AllTablesCrossTableATC006Any fields not coded as coding lists on table definition Yes
tblMEDWithinTableMW001Duplicate records Yes
tblMEDWithinTableMW002MED_ONG=0 and MED_ED nullEPPICCNo
tblMEDWithinTableMW003MED_ONG=1 and MED_ED non-nullEPPICCNo
tblMEDWithinTableMW004Missing MED_ID Yes
tblMEDWithinTableMW005Missing MED_SD Yes
tblMEDWithinTableMW006Misisng MED_ED Yes
tblMEDWithinTableMW007Overlapping periods of same drug Yes
tblMEDWithinTableMW008MED_ED < MED_SD Yes
tblMEDWithinTableMW009MED_RS not null, but end date NULL Yes
tblMEDCrossTableMC001Patient has no records in tblBAS Yes