tblLTFU - Death and drop-out
holds data in death and drop-out
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) | |
numeric:
| Has the patient dropped out? | |
yyyy-mm-dd | If patient has dropped out, date of last visit | |
character: see coding of date precision | optional precision annotation for date of last visit | |
numeric. see coding table for valid codings. | Reason for drop | |
numeric:
| Has the patient died? | |
yyyy-mm-dd | Date of Death | |
character: see coding of date precision | optional precision annotation for date of death | |
numeric:
| Sudden Death? | |
numeric:
| Expected Death? | |
numeric:
| Was an autopsy Performed? | |
character. see coding table for valid codings. | Cause of death | |
character with codes:
| Coding of causal relation of the code given in DEATH_R1 to the death | |
DEATH_R2 | character. see coding table for valid codings. | Cause of death |
DEATH_RC2 | character with codes:
| Coding of causal relation of the code given in DEATH_R2 to the death |
DEATH_R3 | character. see coding table for valid codings. | Cause of death |
DEATH_RC3 | character with codes:
| Coding of causal relation of the code given in DEATH_R3 to the death |
DEATH_SOURCE | character | Source of information for coding of death (e.g. CoDe within own cohort, CoDe from D:A:D, CoDe from ART-CC, etc.) |
numeric:
| Hast the patient's biological mother died? | |
yyyy-mm-dd | Date of death of the patient's biological mother | |
character: see coding of date precision | optional precision annotation for date of death of patient's mother | |
numeric:
| Hast the patient's biological father died? | |
yyyy-mm-dd | Date of death of the patient's biological father | |
character: see coding of date precision | optional precision annotation for date of death of patient's father |
List of DEATH_R# and DEATH_RC# should be continued for as many reasons that are recorded.
The DEATH_RC# fields should enable cohorts to transfer data in accordance with the Coding of Death project (CoDe). You are welcome to contact the CoDe group for electronic sample forms for detailed collection of data used for the CoDe review process.
CoDe defines 1 immediate, 2 contributing and 1 underlying cause of death.
Additional fields
Field name | Format | Description |
---|---|---|
character | Cause of death as ICD-10 if available | |
ICD10_2 | character | Cause of death as ICD-10 if available |
ICD10_31 | character | Cause of death as ICD-10 if available |
character | Cause of death as ICD-9 if available | |
ICD9_2 | character | Cause of death as ICD-9 if available |
ICD9_31 | character | Cause of death as ICD-9 if available |
character | Reason for death – other - description | |
yyyy-mm-dd | Last date known to be alive | |
character: see coding of date precision | optional precision annotation for last date of Information / lknown to be alive |
1: List of ICD10_# and ICD9_#inplace of or together with DEATH_R# and together DEATH_RC# and should be continued for as many reasons that are recorded.
CoDe defines 1 immediate, 2 contributing and 1 underlying cause of death.
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 | |
tblLTFU | WithinTable | LFW001 | DROP_Y and DEATH_Y both non-null | YES | |
tblLTFU | WithinTable | LFW002 | DEATH_Y and DROP_RS both non-null | YES | |
tblLTFU | WithinTable | LFW003 | Any of DEATH_Rx or DEATH_RCx non-null but DEATH_Y=0 | YES | |
tblLTFU | WithinTable | LFW004 | R2/RC2 non-null but R1/RC1 null | YES | |
tblLTFU | WithinTable | LFW005 | R3/RC3 non-null but R2/RC2 null | YES | |
tblLTFU | WithinTable | LFW006 | Duplicate patients | YES | |
tblLTFU | WithinTable | LFW007 | Missing DROP_Y | YES | |
tblLTFU | WithinTable | LFW008 | Missing DROP_D if DROP_Y=1 | YES | |
tblLTFU | WithinTable | LFW009 | Missing DROP_RS if DROP_Y=1 | YES | |
tblLTFU | WithinTable | LFW010 | Missing DEATH_Y | YES | |
tblLTFU | WithinTable | LFW011 | Missing DEATH_D if DEATH_Y=1 | YES | |
tblLTFU | WithinTable | LFW012 | DEATH_D non null but DEATH_Y=0 | YES | |
tblLTFU | CrossTable | LFC001 | Patient not found in tblBAS | YES | |
tblLTFU | CrossTable | LFC002 | patient in tblBAS hasn't got a record in tblLTFU | YES | |
tblLTFU | CrossTable | LFC003 | tblBAS has AIDS=0 but DEATHRx =8.1 | YES |