Module: family-history

Module Contents

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

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.

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)

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.

FRSTEST

number (1,0)

Required:false

Accuracy of date identified/recruited.

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

ASHKENAZI

number (1,0)

Required:true

Flag to indicate whether proband is of Ashkenazi Jewish descent