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
PATIENT	character (or numeric if possible)	Code to identify patient (Cohort Patient ID)
DROP_Y	numeric: 0 = No 1 = Yes	Has the patient dropped out?
DROP_D	yyyy-mm-dd	If patient has dropped out, date of last visit
DROP_D_A	character: see coding of date precision	optional precision annotation for date of last visit
DROP_RS	numeric. see coding table for valid codings.	Reason for drop
DEATH_Y	numeric: 0 = No 1 = Yes	Has the patient died?
DEATH_D	yyyy-mm-dd	Date of Death
DEATH_D_A	character: see coding of date precision	optional precision annotation for date of death
SUD_DEATH_Y	numeric: 0 = No 1 = Yes 9 = Unknown	Sudden Death?
EXP_DEATH_Y	numeric: 0 = No 1 = Yes 9 = Unknown	Expected Death?
AUTOP_Y	numeric: 0 = No 1 = Yes 9 = Unknown	Was an autopsy Performed?
DEATH_R1	character. see coding table for valid codings.	Cause of death
DEATH_RC1	character with codes: I = Immediate cause U = Underlying cause/condition C = Contributing cause N = Not available	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: I = Immediate cause U = Underlying cause/condition C = Contributing cause N = Not available	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: I = Immediate cause U = Underlying cause/condition C = Contributing cause N = Not available	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.)
MOTHERDEATH_Y	numeric: 0 = No 1 = Yes 9 = Unknown	Hast the patient's biological mother died?
MOTHERDEATH_D	yyyy-mm-dd	Date of death of the patient's biological mother
MOTHERDEATH_D_A	character: see coding of date precision	optional precision annotation for date of death of patient's mother
FATHERDEATH_Y	numeric: 0 = No 1 = Yes 9 = Unknown	Hast the patient's biological father died?
FATHERDEATH_D	yyyy-mm-dd	Date of death of the patient's biological father
FATHERDEATH_D_A	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
ICD10_1	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
ICD9_1?	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
DEATH_OT	character	Reason for death – other - description
L_ALIVE_D	yyyy-mm-dd	Last date known to be alive
L_ALIVE_D_A	character: see coding of date precision	optional precision annotation for last date of Information / lknown to be alive

¹: 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