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

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 Hutchinson Cancer Center
17	UCSF/University of California at San Franscisco (formerly CPIC, originally 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.

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

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

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