wiki:Hicdep_1.80/TableLtfu

Version 1 (modified by admin, 3 years ago) (diff)

Copy from Hicdep 1.70

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:

  • 1 = Yes
  • 0 = No

Has the patient DROPPED OUT?

DROP_D

yyyy-mm-dd

IF YES, Date of Last Visit

DROP_RS

numeric. see coding table for valid codings.

IF YES, Reason for DROP

DEATH_Y

numeric:

  • 1 = Yes
  • 0 = No

Has the patient died?

DEATH_D

yyyy-mm-dd

Date of Death

SUD_DEATH_Y

numeric:

  • 1 = Yes
  • 0 = No
  • 9 = Unknown

Sudden Death?

EXP_DEATH_Y

numeric:

  • 1 = Yes
  • 0 = No
  • 9 = Unknown

Expected Death?

AUTOP_Y

numeric:

  • 1 = Yes
  • 0 = No
  • 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.)

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

yyyy-mm-dd

Last date known 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?
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
tblLTFUWithinTableLFW001DROP_Y and DEATH_Y both non-nullYES
tblLTFUWithinTableLFW002DEATH_Y and DROP_RS both non-null YES
tblLTFUWithinTableLFW003Any of DEATH_Rx or DEATH_RCx non-null but DEATH_Y=0YES
tblLTFUWithinTableLFW004R2/RC2 non-null but R1/RC1 nullYES
tblLTFUWithinTableLFW005R3/RC3 non-null but R2/RC2 nullYES
tblLTFUWithinTableLFW006Duplicate patientsYES
tblLTFUWithinTableLFW007Missing DROP_YYES
tblLTFUWithinTableLFW008Missing DROP_D if DROP_Y=1YES
tblLTFUWithinTableLFW009Missing DROP_RS if DROP_Y=1YES
tblLTFUWithinTableLFW010Missing DEATH_YYES
tblLTFUWithinTableLFW011Missing DEATH_D if DEATH_Y=1YES
tblLTFUWithinTableLFW012DEATH_D non null but DEATH_Y=0YES
tblLTFUCrossTableLFC001Patient not found in tblBASYES
tblLTFUCrossTableLFC002patient in tblBAS hasn't got a record in tblLTFUYES
tblLTFUCrossTableLFC003tblBAS has AIDS=0 but DEATHRx =8.1 YES