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_OTH<sup>1</sup> | 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 |
|---|---|---|
| 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
| Table | Crosstable | Error Code | Description | Study specific | Is 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 | |
| tblDIS | WithinTable | DW001 | Duplicate records for same DIS_ID and same DIS_D | Yes | |
| tblDIS | WithinTable | DW002 | Miscoded DIS_WD as codes on table definition | Yes | |
| tblDIS | WithinTable | DW003 | Miscoded DIS_ID - as in code list attached to table definition | Yes | |
| tblDIS | WithinTable | DW004 | DIS_D missing | Yes | |
| tblDIS | WithinTable | DW005 | DIS_ID missing | Yes | |
| tblDIS | WithinTable | DW006 | Same event recorded twice - 2 records, same DIS_ID, DIS_D within 6 months | Yes | |
| tblDIS | WithinTable | DW007 | DIS_ED present but before DIS_D | Yes | |
| tblDIS | CrossTable | DC001 | Patient has no record in BAS | Yes | |
| tblDIS | CrossTable | DC002 | AIDS-defining records, yet AIDS=0 in tblBAS | Yes | |
| tblDIS | CrossTable | DC003 | First AIDS-defining DIS_D not equal to AIDS_D in tblBAS | Yes |