Module: family-history
Module Contents
- 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 | |||||||||||||||||||
|
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 |
|||||||
|
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". | |||||||||||||||||||||||
|
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. | |||||||||||||||||||||||||||
|