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
PATIENT
character (or numeric if possible)
Code to identify patient (Cohort Patient ID)
DIS_ID
character. see coding table for valid codings.
Code to identify event
DIS_D
yyyy-mm-dd
Start date of event (Date of disease diagnosis)
DIS_WD
numeric. see coding table for valid codings.
Means/Certainty of diagnosis
DIS_OTH1
character
Other location, only to be filled out if DIS_ID code alone is not sufficient
DIS_SPEC
Character. See coding table below for valid coding.
Specifies the event identified by DIS_ID. Only applicable for DIS_IDs: ADM, MCP, MCX, and CVM
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
DIS_ED
yyyy-mm-dd
End date of Event (If end date is available, disease outcome should be specified)
DIS_ED_A
character: see coding of date precision
optional precision annotation for end of infection date DIS_ED
DIS_SITE
numeric. see coding table for valid codings.
Event site
DIS_OUTCOME
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