tblDIS - CDC-C and WHO Stage Diseases


holds type and date of CDC-C diseases and malignancies.

Core Fields

Note: 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)
character. see coding table for valid codings.
Code to identify event
yyyy-mm-dd
Start date of event (Date of disease diagnosis)
numeric. see coding table for valid codings.
Means/Certainty of diagnosis
character
Other location, only to be filled out if DIS_ID code alone is not sufficient
1 DIS_OTH might be part of the record's unique identification

Additional Fields

Please see tblCEP for specification on optional fields.
Field name
Format
Description
yyyy-mm-dd
End date of Event (If end date is available, disease outcome should be specified)
optional precision annotation for end of infection date DIS_ED
numeric. see coding table for valid codings.
Event site
numeric. see coding table for valid codings.
Disease outcome

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
tblDISWithinTableDW001Duplicate records for same DIS_ID and same DIS_D Yes
tblDISWithinTableDW002Miscoded DIS_WD as codes on table definition Yes
tblDISWithinTableDW003Miscoded DIS_ID - as in code list attached to table definition Yes
tblDISWithinTableDW004DIS_D missing Yes
tblDISWithinTableDW005DIS_ID missing Yes
tblDISWithinTableDW006Same event recorded twice - 2 records, same DIS_ID, DIS_D within 6 months Yes
tblDISWithinTableDW007DIS_ED present but before DIS_D Yes
tblDISCrossTableDC001Patient has no record in BAS Yes
tblDISCrossTableDC002AIDS-defining records, yet AIDS=0 in tblBAS Yes
tblDISCrossTableDC003First AIDS-defining DIS_D not equal to AIDS_D in tblBAS Yes