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	University of Southern California Consortium (USCC)
13	University of Melbourne
14	University of Hawaii Cancer Center
15	Mayo Clinic
16	Fred Hutch, Seattle
17	University of California at San Francisco (UCSF) (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. *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
34	Community Recruitment PhIV
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)
Error Description
If CENTER_NO = 13 then CTR_SUB must be in(13,14,15,16,17,18,23,24,31,32,33)
Error Description
If CENTER_NO = 15 then CTR_SUB must be in (32,55,56,57,58,65,67,68,75,78)
This special value check will pass under the following conditions: CTR_SUB in {01,02,03,04,05,06,07,13,14,15,16,17,18,23,24,31,32,33,32,34,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)

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.

Allowable Values
YYYY	Minimum year – system date year, 8888, 9999
MM	01 – 12, 88, 99
DD	01 – 31, 88, 99
If YYYY	9999 then MM and DD must
If MM	99 then DD must

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

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:
YYYY	1997 (Minimum year) – system date year, 8888, 9999
MM	01 – 12, 88, 99
DD	01 – 31, 88, 99

Allowable Values
YYYY	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

Allowable Values
1	Yes
2	No
9	Unknown