Module: family-history

Module Contents

cancer
- 1.CENTER_NO
- 2.PERSON_ID (*PK)
- 3.TUMOR_NO (*PK)
- 4.SITE
- 5.LATERAL
- 6.HISTO
- 7.BEHAV
- 8.AGEDX
- 9.DXDATE
- 10.DXEST
- 11.DXSRC
- 12.TISSUE
- 13.QUALIFY_TUMOR

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	PERSON_ID (*PK)	number (12,0)	Required:true
	Number that uniquely identifies an individual. *PERSON_ID + TUMOR_NO are the primary key for this table.

TUMOR_NO (*PK)

number (2,0)

Required:true

Computer generated sequential number, starting with “1”, assigned to each tumor for a given individual when entered into local system. No adjustment is made when a tumor is deleted from the system. Tumor numbers are never reused. Tumor_no is a machine-generated value that has no implied meaning such as sequence of diagnosis. The first tumor that is entered into the system is assigned 1, the second tumor entered into the system assigned 2, etc. For example, if a person has two tumors and tumor_no 2 is deleted, that number should never be reused for that individual. Should that person develop a second primary, that tumor should have tumor_no set to 3. *PERSON_ID + TUMOR_NO are the primary key for this table. This tumor is also mapped throughout the Registry to all block samples and molecular testing for that PERSON_ID.

SITE

string (4)

Required:true

Location where this tumor originated in as much detail as is known and for which a code is provided in ICD-O-3.

LATERAL

number (1,0)

Required:true

Laterality of tumor. Side of the body in which the tumor originated. Note: laterality of left and right is not applicable for all sites. Coding for this field is based on SEER, NAACCR and AcoS guidelines.

Allowable Values
0	Not a paired site
1	Right
2	Left
3	Unilateral, NOS
4	Bilateral
5	Midline
9	Paired site, no information

HISTO

number (5,0)

Required:true

First four digits of the ICD-O-3 morphology code which designates the histologic type of this tumor. Coding for this field is based on SEER, NAACCR and AcoS guidelines.

Allowable Values
8000 to 9990	Range
8000	No specific histologic type information
72860	Keratoacanthoma

BEHAV

number (1,0)

Required:false

ICD-O-3 5th digit behavior code. Coding for this field is based on SEER, NAACCR and AcoS guidelines.

Allowable Values
0	Benign
1	Uncertain whether benign or malignant; borderline; low malignant potential
2	Carcinoma in situ
3	Malignant (Invasive)

AGEDX

number (3,0)

Required:true

Age at diagnosis (De-Identified)

Allowable Values
996	Less than 20
997	90 or over
998	Less than 1 year
999	Unknown

DXDATE

string (8)

Required:true

Date of diagnosis.

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	1700 (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
If YYYY	9999 then MM and DD must
If MM	99 then DD must

DXEST

number (1,0)

Required:true

Accuracy of diagnosis date.

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

DXSRC

number (2,0)

Required:true

Source of diagnosis information (site, histology, behavior, laterality).

Allowable Values
1	Pathology review (means your center’s pathologist examined the tissue and may have also completed an internal review sheet;)
2	Pathology report (means the documents from the hospital’s medical records or pathologist. It often comes with the Biospecimens (block, tissue…). )
3	Other hospital record or clinic record
4	Death certificate
5	Self
6	Relative
7	SEER
8	Other cancer registry (e.g. state)
9	Unknown
10	NDI, NDI+, site-specific state death indices (health department)
11	Spouse
12	Other source, for example specialized genealogy

TISSUE

number (1,0)

Required:true

Status of tissue procurement.

Allowable Values
0	Not needed / not applicable
1	Permission granted by patient, pending request to hospital/clinic
2	Specimen requested from hospital/clinic, awaiting receipt
3	Specimen received
4	Refusal from patient
5	Lost or destroyed
6	Refusal from hospital/clinic
7	Unable to request tissue (tissue location overseas or location is unknown)
8	Pending permission from patient

QUALIFY_TUMOR

number (1,0)

Required:false

Flag indicating that the tumor qualifies a population sampled affected proband as eligible for inclusion in the study. The tumor must meet all site-specific eligibility criteria. Synchronous qualifying tumours should be sequentially ordered beginning with the largest in size.