Module: family-history

Module Contents

family-membership
- 1.CENTER_NO
- 2.FAMILY_ID (PK*)
- 3.PERSON_ID (PK*)
- 4.PROBAND_FLG
- 5.PROBAND_TYPE
- 6.SPOUSE_CONTROL_ID
- 7.FUNDING_PHASE
- 8.PROB_WGT
- 9.P_FRACTION
- 10.P_POP_TYPE
- 11.RELATION_CODE
- 12.LINEAGE
- 13.CONTROL_FLG

CENTER_NO

number (2,0)

Required:true

Center Identification Number

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))

This special value check will pass under the following conditions: CENTER_NO in {11,12,13,14,15,16,17}

2	FAMILY_ID (PK*)	string (9)	Required:true
	Family identification number uniquely identifying a family. Consists of concatenated CENTER_NO (2 digits; digits 1-2) + local family number (7 digits; digits 3-9). The last portion of the number (7 digit part) should be right justified, zero filled. Ex: Family Id 12345 from Australia Colon Center should be: 130012345. *FAMILY_ID + PERSON_ID are the primary key for the table.

3	PERSON_ID (PK*)	string (12)	Required:true
	Number that uniquely identifies an individual. Consists of concatenation of CENTER_NO (2 digit; digits 1-2) + (10 digit local unique individual id; digits 3-12). The 10 digit individual number component should be right justified, zero filled. Ex: Individual Id 98765 from Australia Colon Center should be: 130000098765. *FAMILY_ID + PERSON_ID are the primary key for the table.

PROBAND_FLG

number (1,0)

Required:false

Flag indicated that individual is the proband. Note: multiple records within a family may be flagged as a proband for families sampled with population-based criteria.

Allowable Values
1	First identified or only proband
2	Second identified proband
3	Third identified proband
4	Forth identified proband
5	Fifth identified proband

This special value check will pass under the following conditions: PROBAND_FLG in {1,2,3,4,5}

PROBAND_TYPE

number (1,0)

Required:false

Type of proband.

Allowable Values
1	Affected proband (Affected with a CRC at enrollment)
2	Unaffected proband (Unaffected with CRC at enrollment)
3	Population-based control
4	Recruited as a population-based case, but it was later determined their qualifying tumor was not a malignant colorectal cancer

This special value check will pass under the following conditions: PROBAND_TYPE in {1,2,3,4}

6	SPOUSE_CONTROL_ID	string (12)	Required:false
	PERSON_ID of a non-blood relative that was specifically recruited as a control, who is the spouse of a population-based case proband or family member. The ID of this spouse control is to be populated for the proband or relative they are linked to. That is, the proband/family member record would have the variable SPOUSE_CONTROL_ID set to the PERSON_ID of their spouse specifically serving as a control. Note: A proband or a family member may have a spouse control but the spouse may not have the proband or family member as a spouse control.

FUNDING_PHASE

number (1,0)

Required:false

Funding phase (and source) for recruitment of proband.

Allowable Values
1	Phase I (NCI), initial funding (first 5 years of funding, includes Yr-5 interim funding)
2	Phase II (NCI), first renewal funding (second 5 years of funding)
3	Phase III (NCI), second renewal funding (third 5 years of funding)
4	Minority RO1 Funding (NCI)
5	Non-NIH Funding Source

This special value check will pass under the following conditions: FUNDING_PHASE in {1,2,3,4,5}

8	PROB_WGT	number (9,6)	Required:false
	Weight for population-based probands that does NOT take response/participation rates into account.

9	P_FRACTION	number (4,3)	Required:false
	The sampling fraction, based on ascertainment criteria such as family history, ethnicity, age of diagnosis etc. The probability of being sampled. It does not take response/participation rates into account. Applicable to population-based probands.

P_POP_TYPE

number (1,0)

Required:false

Type of recruitment for population-based probands.

Allowable Values
1	Incident: The CRC is the subjects first CRC diagnosis, and it was made during the CFR recruitment period
2	Previous Incident: The qualifying tumor is an incident or 'first CRC', but the diagnosis date is prior to the CFR recruitment period. In other words, the proband had one CRC diagnosis up to enrollment in the CFR, prior to the 'CFR recruitment period'.
3	Second primary (previously referred to as 'prevalent'). The qualifying tumor is not the first CRC. In other words, the participant had one or more CRC diagnoses prior to a CRC diagnosis during the CFR recruitment period. The new (or subsequent) CRC is flagged as the 'qualifying tumor'.
9	Unknown

This special value check will pass under the following conditions: P_POP_TYPE in {1,2,3,9}

RELATION_CODE

string (3)

Required:true

An internal code to describe the individuals relationship to the primary proband (proband_flag ; 1 First identified or only proband) in a family. Will serve as a foreign key to a new relationship meta-table that contains the code, degree of relationship, English description of the relationship and potentially other attributes.

Code1	Degree	Description	Common Name
0S0	0	Self	Proband
0S1	1	Child	Daughter/son
0S2	2	Grandchild	Granddaughter/son
0S3	3	Great grandchild	Great granddaughter/son
0T0	0	Twin sibling (identical)	Sister/brother
0F0	1	Full sibling	Sister/brother
0H0	2	Half sibling	Sister/brother
0U0	2	Unkn sibling (one parent is unknown)	Sister/brother
0T1	1	Twin siblings child	Niece/nephew
0T2	2	Twin siblings grandchild	Grandniece/nephew
0T3	3	Twin siblings great grandchild	Great grandniece/nephew
0F1	2	Full siblings child	Niece/nephew
0F2	3	Full siblings grandchild	Grandniece/nephew
0F3	4	Full siblings great grandchild	Great grandniece/nephew
0H1	3	Half siblings child	Niece/nephew
0H2	4	Half siblings grandchild	Grandniece/nephew
0H3	5	Half siblings great grandchild	Great grandniece/nephew
0U1	3	Unkn siblings child	Niece/nephew
0U2	4	Unkn siblings grandchild	Grandniece/nephew
0U3	5	Unkn siblings great grandchild	Great grandniece/nephew
1S0	1	Parent	Mother/father
2S0	2	Grandparent	Grandmother/father
3S0	3	Great grandparent	Great grandmother/father
4S0	4	Great-great grandparent	Great-great grandmother/father
1T0	1	Parents twin sibling	Aunt/uncle
1F0	2	Parents full sibling	Aunt/uncle
1H0	3	Parents half sibling	Aunt/uncle
1U0	3	Parents unkn sibling	Aunt/uncle
1T1	2	Parents twin siblings child	1st cousin
1T2	3	Parents twin siblings grandchild	1st cousin 1x rem
1T3	4	Parents twin siblings great grandchild	1st cousin 2x rem
1T4	5	Parents twin siblings great-great grandchild	1st cousin 3x rem
1F1	3	Parents full siblings child	1st cousin
1F2	4	Parents full siblings grandchild	1st cousin 1x rem
1F3	5	Parents full siblings great grandchild	1st cousin 2x rem
1F4	6	Parents full siblings great-great grandchild	1st cousin 3x rem
1H1	4	Parents half siblings child	1st cousin
1H2	5	Parents half siblings grandchild	1st cousin 1x rem
1H3	6	Parents half siblings great grandchild	1st cousin 2x rem
1H4	7	Parents half siblings great-great grandchild	1st cousin 3x rem
1U1	4	Parents unkn siblings child	1st cousin
1U2	5	Parents unkn siblings grandchild	1st cousin 1x rem
1U3	6	Parents unkn siblings great grandchild	1st cousin 2x rem
1U4	7	Parents unkn siblings great-great grandchild	1st cousin 3x rem
2T0	2	Grandparents twin sibling	Grandaunt/uncle
2F0	3	Grandparents full sibling	Grandaunt/uncle
2H0	4	Grandparents half sibling	Grandaunt/uncle
2U0	4	Grandparents unkn sibling	Grandaunt/uncle
2T1	3	Grandparents twin siblings child	1st cousin 1x rem
2T2	4	Grandparents twin siblings grandchild	2nd cousin
2T3	5	Grandparents twin siblings great grandchild	2nd cousin 1x rem
2T4	6	Grandparents twin siblings great-great grandchild	2nd cousin 2x rem
2T5	7	Grandparents twin siblings great-great-great grandchild	2nd cousin 3x rem
2F1	4	Grandparents full siblings child	1st cousin 1x rem
2F2	5	Grandparents full siblings grandchild	2nd cousin
2F3	6	Grandparents full siblings great grandchild	2nd cousin 1x rem
2F4	7	Grandparents full siblings great-great grandchild	2nd cousin 2x rem
2F5	8	Grandparents full siblings great-great-great grandchild	2nd cousin 3x rem
2H1	5	Grandparents half siblings child	1st cousin 1x rem
2H2	6	Grandparents half siblings grandchild	2nd cousin
2H3	7	Grandparents half siblings great grandchild	2nd cousin 1x rem
2H4	8	Grandparents half siblings great-great grandchild	2nd cousin 2x rem
2H5	9	Grandparents half siblings great-great-great grandchild	2nd cousin 3x rem
2U1	5	Grandparents unkn siblings child	1st cousin 1x rem
2U2	6	Grandparents unkn siblings grandchild	2nd cousin
2U3	7	Grandparents unkn siblings great grandchild	2nd cousin 1x rem
2U4	8	Grandparents unkn siblings great-great grandchild	2nd cousin 2x rem
2U5	9	Grandparents unkn siblings great-great-great grandchild	2nd cousin 3x rem
3T0	3	Great grandparents twin sibling	Great grandaunt/uncle
3F0	4	Great grandparents full sibling	Great grandaunt/uncle
3H0	5	Great grandparents half sibling	Great grandaunt/uncle
3U0	5	Great grandparents unkn sibling	Great grandaunt/uncle
3T1	4	Great grandparents twin siblings child	2nd cousin 2x rem
3T2	5	Great grandparents twin siblings grandchild	2nd cousin 1x rem
3T3	6	Great grandparents twin siblings great grandchild	3rd cousin
3T4	7	Great grandparents twin siblings great-great grandchild	3rd cousin 1x rem
3T5	8	Great grandparents twin siblings great-great-great grandchild	3rd cousin 2x rem
3T6	9	Great grandparents twin siblings great-great-great-great grandchild	3rd cousin 3x rem
3F1	5	Great grandparents full siblings child	2nd cousin 2x rem
3F2	6	Great grandparents full siblings grandchild	2nd cousin 1x rem
3F3	7	Great grandparents full siblings great grandchild	3rd cousin
3F4	8	Great grandparents full siblings great-great grandchild	3rd cousin 1x rem
3F5	9	Great grandparents full siblings great-great-great grandchild	3rd cousin 2x rem
3F6	10	Great grandparents full siblings great-great-great-great grandchild	3rd cousin 3x rem
3H1	6	Great grandparents half siblings child	2nd cousin 2x rem
3H2	7	Great grandparents half siblings grandchild	2nd cousin 1x rem
3H3	8	Great grandparents half siblings great grandchild	3rd cousin
3H4	9	Great grandparents half siblings great-great grandchild	3rd cousin 1x rem
3H5	10	Great grandparents half siblings great-great-great grandchild	3rd cousin 2x rem
3H6	11	Great grandparents half siblings great-great-great-great grandchild	3rd cousin 3x rem
3U1	6	Great grandparents unkn siblings child	2nd cousin 2x rem
3U2	7	Great grandparents unkn siblings grandchild	2nd cousin 1xrem
3U3	8	Great grandparents unkn siblings great grandchild	3rd cousin
3U4	9	Great grandparents unkn siblings great-great grandchild	3rd cousin 1x rem
3U5	10	Great grandparents unkn siblings great-great-great grandchild	3rd cousin 2x rem
3U6	11	Great grandparents unkn siblings great-great-great-great grandchild	3rd cousin 3x rem
BLO	-3	Blood relation - other	Blood relation - other
NBS	-1	Non-blood relation - proband spouse	Non-blood relation - proband spouse
NBO	-1	Non-blood relation - other	Non-blood relation - other
XXX	-9	Relationship is completely unknown	Unknown

This special value check will pass under the following conditions: RELATION_CODE in {0S0,0S1,0S2,0S3,0T0,0F0,0H0,0U0,0T1,0T2,0T3,0F1,0F2,0F3,0H1,0H2,0H3,0U1,0U2,0U3,1S0,2S0,3S0,4S0,1T0,1F0,1H0,1U0,1T1,1T2,1T3,1T4,1F1,1F2,1F3,1F4,1H1,1H2,1H3,1H4,1U1,1U2,1U3,1U4,2T0,2F0,2H0,2U0,2T1,2T2,2T3,2T4,2T5,2F1,2F2,2F3,2F4,2F5,2H1,2H2,2H3,2H4,2H5,2U1,2U2,2U3,2U4,2U5,3T0,3F0,3H0,3U0,3T1,3T2,3T3,3T4,3T5,3T6,3F1,3F2,3F3,3F4,3F5,3F6,3H1,3H2,3H3,3H4,3H5,3H6,3U1,3U2,3U3,3U4,3U5,3U6,BLO,NBS,NBO,XXX}

LINEAGE

number (1,0)

Required:false

An indication of which line down the pedigree a relative descends from. Maternal or Paternal or Both to be used in conjunction with the RELATION_CODE to denote lineage.

Allowable Values
1	PATERNAL
2	MATERNAL
3	BOTH
8	NON BLOOD
9	UNKNOWN

This special value check will pass under the following conditions: LINEAGE in {1,2,3,8,9}

CONTROL_FLG

number (1,0)

Required:false

A flag used to identify a subject specifically recruited as a control throughout all population-based families. Note: There were no controls recruited through the clinic-based families.

Allowable Values
1	Population-based Control Proband
2	Population-based Control Relative (Australia Only)
3	Spouse Control

This special value check will pass under the following conditions: CONTROL_FLG in {1,2,3}

Family-membership

Module: family-history

Module Contents

Main Menu