Version 1 (modified by trac, 7 years ago) (diff)

copy from version 1.50

tblDIS - Opportunistic infections

holds type and date of CDC-C diseases.

Core fields

Note: Fields marked bold form the unique identifier for a record of the table.

Field name




character (or numeric if possible)

Code to identify patient (Cohort Patient ID)


character. see coding table for valid codings.

Code to identify event



Date of event


numeric. see coding table for valid codings.

Means of diagnosis



Other location, only to be filled out if code alone is not sufficient

1 DIS_OTH might be part of the record's unique identification

Additional fields

Please see tblAE - Adverse Events for specification on optional fields.

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