tblMED - Other medication
holds type, start and stop dates for other medication/treatments.
|
Core FieldsNote: Fields marked bold form the unique identifier for a record of the table.
|
Field name Format Description character (or numeric if possible) Code to identify patient (Cohort Patient ID)
|
Code representing the treatment
|
yyyy-mm-dd Date of Initiation of Treatment
|
Precision annotation variable for date of initiation of drug
|
yyyy-mm-dd Date of stopping treatment
|
Precision annotation variable for date of stopping drug
|
reason for stopping treatment
|
Additional FieldsField name Format Description Additional reason for stopping treatment
|
Additional reason for stopping treatment
|
Additional reason for stopping treatment
|
numeric Dosage (mg or mL) per intake unless MED_FR=-1 (optional)
|
|
Directly observed Treatment (optional)
|
Reason for starting medication (optional)
|
QA Checks
Table | Crosstable | Error Code | Description | Study specific | 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 |