Module: family-history

Module Contents

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

1 CENTER_NO number (2,0) Required:true
Unique identifier for a CFR center
Allowable Values
11 Cancer Care Ontario
12 USC Consortium
13 University of Melbourne
14 Cancer Research Center of Hawaii
15 Mayo Clinic
16 Fred Hutchinson, Seattle
17 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 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 dervived underlying cuase of death. In these cases this element should be marked '999999=unknown' and the derived value go into COD_UND1_ICD.

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

5 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

25 COD_SOURCE number (1,0) Required:false
Source of Cause of Death for all causes primary to 10 underlying. This should be from the single best source the site has for that individual. General rule of the thumb for priority should be NDI > SEER > Med Record > dept of health > death certificate. Though this might vary some at particular sites. NOTE: The source if th 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
6 Death certificate
7 Other medical record
8 Other family member
9 Unknown


26 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 esspcially 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