Module: family-history

Module Contents

  1. family
    1.CENTER_NO
    2.FAMILY_ID (PK*)
    3.CTR_SUB
    4.FSRC
    5.FRSTDATE
    6.FRSTEST
    7.BASELINE_CUTOFF
    8.ASHKENAZI

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 Philadelphia Breast Center should be: 010012345 or 10012345 Ex: Family Id 12345 from Australia Colon Center should be: 130012345. *This field is a Primary Key for the table.

3 CTR_SUB string (2) Required:false
Center subsite location (determined by institution).
Allowable Values
01 Dartmouth
02 USC
03 Uni of Colorado
04 Uni of Arizona
05 Cleveland Clinic
06 UNC
07 Uni of Minnesota
13 Cases 18-44
14 Cases 45-49
15 Cases 18-44 2003+
16 Cases 45-49 2003+
17 Cases 18-44 preNIH Ph II
18 Cases 45-49 preNIH Ph II
23 Controls 18-44
24 Controls 45-49
31 Clinic Ph I
32 Clinic Ph II
33 Clinic Ph III
32 Clinic Cases with Frozen Tissue
55 Ph I Clinic-Based (Mayo Clinic)
56 Ph I Clinic-Based (Nth Central Ca Tx Center)
57 Ph I Pop-Based (Minnesota Ca Surveillance System)
58 Ph I Other Clinic-Based
65 Ph II Clinic-Based (Mayo Clinic)
67 Ph II Pop-Based (Minnesota Ca Surveillance System)
68 Ph II Other Clinic-Based
75 Ph III Clinic-Based (Mayo Clinic)
78 Ph III Other Clinic-Based

Error Description
If CENTER_NO = 12 then CTR_SUB must be in (01,02,03,04,05,06,07)
If CENTER_NO = 13 then CTR_SUB must be in(13,14,15,16,17,18,23,24,31,32,33)
If CENTER_NO = 15 then CTR_SUB must be in (32,55,56,57,58,65,67,68,75,78)


4 FSRC number (1,0) Required:true
Source of family/proband.
Allowable Values
1 Population-based (cancer registry)
2 Clinic (non-population based)


5 FRSTDATE string (8) Required:true
Date proband first identified. E.g. date of diagnosis of incident case in cancer registry or date of first visit to clinic or date first identified to study.

6 FRSTEST number (1,0) Required:false
Accuracy of date identified/recruited.
Allowable Values
1 Exact
2 Within 1 year
3 Within 1+ to 5 years
4 Within 5+ to 10 years
5 10 or more years
9 Unknown


7 BASELINE_CUTOFF string (8) Required:false
Date when the complete initial family history interview/information was received.
Date Value Check
The date must follow to the following format:

Format YYYYMMDD. Must consist of valid date.
Components of date should be right justified and zero filled.
MM = 01 - 12, 88, 99
DD = 01 - 31, 88, 99
YYYY = Minimum year - system date year, 8888, 9999
Use 88, 8888 for not currently known, in progress to obtain information.
Use 99, 9999 for not known.
If century is known, but year is unknown then give an estimate of year or code YYYY = 9999.
If MM = 99 then DD must = 99.
If century is known, but year is unknown then give an estimate of year or code YYYY = 9999.
If YYYY = 9999 then MM and DD must = 99.

The following special parameters are used:
Format YYYYMMDD  
YYYY 1997 (Minimum year) - system date year, 8888, 9999
MM 01 - 12, 88, 99
DD 01 - 31, 88, 99


8 ASHKENAZI number (1,0) Required:true
Flag to indicate whether proband is of Ashkenazi Jewish descent
Allowable Values
1 Yes
2 No
9 Unknown