wiki:Hicdep_1.110/TableMed

Version 1 (modified by admin, 11 months ago) (diff)

Copy from Hicdep 1.100

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 HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
tblMEDWithinTableMW001Duplicate recordsYES
tblMEDWithinTableMW002MED_ONG=0 and MED_ED null EPPICC NO
tblMEDWithinTableMW003MED_ONG=1 and MED_ED non-null EPPICC NO
tblMEDWithinTableMW004Missing MED_IDYES
tblMEDWithinTableMW005Missing MED_SDYES
tblMEDWithinTableMW006Misisng MED_EDYES
tblMEDWithinTableMW007Overlapping periods of same drugYES
tblMEDWithinTableMW008MED_ED < MED_SDYES
tblMEDWithinTableMW009MED_RS not null, but end date NULLYES
tblMEDCrossTableMC001Patient has no records in tblBASYES