Module: family-history
Module Contents
- family-membership
| 1 | CENTER_NO | number (2,0) | Required:true | ||||||||||||||||
| Center Identification Number | |||||||||||||||||||
| |||||||||||||||||||
| 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 indicating that individual is the proband. Note: multiple records within a family may be flagged as a proband for families sampled with population-based criteria. | |||||||||||||||
| |||||||||||||||
| 5 | PROBAND_TYPE | number (1,0) | Required:false | ||||||||||
| Type of proband. | |||||||||||||
| |||||||||||||
| 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. | |||
| 7 | FUNDING_PHASE | number (1,0) | Required:false | ||||||||||||
| Funding phase (and source) for recruitment of proband. | |||||||||||||||
| |||||||||||||||
| 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. | |||||||||||||
| |||||||||||||
| 11 | 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12 | 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. | |||||||||||||||
| |||||||||||||||
| 13 | 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. Also, CENTER_NO 12 generally enrolled CRC-unaffected family members as controls but did not specifically tag/identify them. | |||||||||||
| |||||||||||