Family-membership

Module: family-history

Module Contents

  1. 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.LINEAGE
    12.RELATION_CODE

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


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.

4 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


5 PROBAND_TYPE number (1,0) Required:false
Type of proband.
Allowable Values
1 Affected proband (Affected with a CRC)
2 Unaffected proband (Do not have colorectal cancer)
3 Population-based control
4 Recruited as population-based control , later developed colorectal cancer and ascertained as an affected proband


6 SPOUSE_CONTROL_ID string (12) Required:false
Person _id of corresponding individuals that are linked together as proband/individual and spouse control. For example, the proband/individual record would have the spouse_control_id set to the person_id of their spouse. A proband or a family member may have a spouse control but the spouse may not have the proband as a spouse control. Note: this field should only be used in the situation that spouses are recruited specifically for serving as a control.

7 FUNDING_PHASE number (1,0) Required:false
Funding phase/source for recruitment of proband/family.
Allowable Values
1 Phase 1, initial funding (first 5 years of funding, colon centers 4 years of funding)
2 Phase 2, renewal funding
3 Ashkenazi supplement (only applicable for Breast centers)
4 Interim one year funding
5 Non-NIH Funding Source
6 Non-participation for Phase 1, Participating in Phase 2
7 Minority RO1 Funding
8 Phase III, second renewal funding (third 5 years of funding)


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.

10 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


11 LINEAGE number (1,0) Required:false
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


12 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.
Code1DegreeDescriptionCommon 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