Module: family-history

Module Contents

  1. cause-of-death
    1.CENTER_NO
    2.PERSON_ID (*PK)
    3.CRC_COD
    4.COD_IMM_ICD
    5.COD_IMM_TXT
    6.COD_UND1_ICD
    7.COD_UND1_TXT
    8.COD_UND2_ICD
    9.COD_UND2_TXT
    10.COD_UND3_ICD
    11.COD_UND3_TXT
    12.COD_UND4_ICD
    13.COD_UND4_TXT
    14.COD_UND5_ICD
    15.COD_UND5_TXT
    16.COD_UND6_ICD
    17.COD_UND6_TXT
    18.COD_UND7_ICD
    19.COD_UND7_TXT
    20.COD_UND8_ICD
    21.COD_UND8_TXT
    22.COD_UND9_ICD
    23.COD_UND9_TXT
    24.COD_UND10_ICD
    25.COD_UND10_TXT
    26.COD_SOURCE
    27.COD_ICD_VERSION

1 CENTER_NO number (2,0) Required:true
Unique identifier for a CFR center
Allowable Values
11 Sinai Health Systems (formerly Cancer Care Ontario)
12 Cedars-Sinai & Cleveland Clinic (formerly USC Consortium)
13 University of Melbourne
14 University of Hawaii Cancer Center
15 Mayo Clinic
16 Fred Hutch, Seattle
17 UCSF: University of California at San Franscisco (formerly CPIC, originally Northern California (NCCC))


2 PERSON_ID (*PK) number (12,0) Required:true
Identifier for person that is globally unique within the BC-CFR central database. *This field is the primary key for the table.

3 CRC_COD number (1,0) Required:true
Flag indicating the immediate or underlying cause of death was due to colorectal cancer.
ICD-O: C18[0-9]*, C199, C209, C218, C260
ICD-9: 153.[0-9]*, 154.[0-3]*
Text: includes colon, colorectal, bowel, large intestine
Allowable Values
1 Cause of death involved CRC


4 COD_IMM_ICD string (6) Required:true
First, primary or immediate cause of death in ICD. NOTE: Some sources, like SEER, do not give a primary/immediate Cause of Death but only a derived underlying cause of death. In these cases this element should be marked '999999=unknown' and the derived value go into COD_UND1_ICD.

5 COD_IMM_TXT string (250) Required:false
First, primary or immediate cause of death in text if ICD not available

6 COD_UND1_ICD string (6) Required:false
First underlying cause of death in ICD. Note for some sources, like SEER, this maybe a derived COD.

7 COD_UND1_TXT string (250) Required:false
First underlying cause of death in text if no ICD

8 COD_UND2_ICD string (6) Required:false
2nd underlying cause of death in ICD

9 COD_UND2_TXT string (250) Required:false
2nd underlying cause of death in text if no ICD

10 COD_UND3_ICD string (6) Required:false
3rd underlying cause of death in ICD

11 COD_UND3_TXT string (250) Required:false
3rd underlying cause of death in text if no ICD

12 COD_UND4_ICD string (6) Required:false
4th underlying cause of death in ICD

13 COD_UND4_TXT string (250) Required:false
4th underlying cause of death in text if no ICD

14 COD_UND5_ICD string (6) Required:false
5th underlying cause of death in ICD

15 COD_UND5_TXT string (250) Required:false
5th underlying cause of death in text if no ICD

16 COD_UND6_ICD string (6) Required:false
6th underlying cause of death in ICD

17 COD_UND6_TXT string (250) Required:false
6th underlying cause of death in text if no ICD

18 COD_UND7_ICD string (6) Required:false
7th underlying cause of death in ICD

19 COD_UND7_TXT string (250) Required:false
7th underlying cause of death in text if no ICD

20 COD_UND8_ICD string (6) Required:false
8th underlying cause of death in ICD

21 COD_UND8_TXT string (250) Required:false
8th underlying cause of death in text if no ICD

22 COD_UND9_ICD string (6) Required:false
9th underlying cause of death in ICD

23 COD_UND9_TXT string (250) Required:false
9th underlying cause of death in text if no ICD

24 COD_UND10_ICD string (6) Required:false
10th underlying cause of death in ICD

25 COD_UND10_TXT string (250) Required:false
10th underlying cause of death in text if no ICD

26 COD_SOURCE number (1,0) Required:false
Source of Cause of Death for all primary and underlying causes. This should be from the single best source the site has for that individual. General rule of thumb for selecting COD_SOURCE when more than 1 is applicable should be NDI > SEER/Other Cancer Registry > Medical Record > Linkage to other databases > Death Certificate > Family member/spouse/contact. Though this might vary by site. NOTE: The source of the ICD code is derived as follows. For COD_SOURCE options 1,2,3,4,5 & 9 the source of the ICD code is the same as COD_SOURCE. For COD options 6,7,8 the ICD code source is "Assigned by Site".
Allowable Values
1 SEER
2 Cancer registry
3 NDI US
4 NDI AUS
5 Linkage_Other database, e.g. Dept of Health
6 Death certificate
7 Medical record
8 Other family member, spouse, friend (contact)
9 Unknown


27 COD_ICD_VERSION number (2,0) Required:false
Version of ICD for all cause of deaths from COD source. NOTE: this value is sometimes determined by the ICD version in use at time of death which is usually accurate but not perfect especially if the death occurred in early January when a code change might have been in progress.
Allowable Values
2 ICD-2
3 ICD-3
4 ICD-4
5 ICD-5
6 ICD-6
7 ICD-7
8 ICD-8
9 ICD-9
10 ICD-10
88 Not Applicable
99 unknown