Module: biospecimens

Module Contents

CENTER_NO (*PK)

number (2,0)

Required:true

Center Identification Number. *CENTER_NO + FRESH_SPEC_CID are the primary key for the table.

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	string (12)	Required:true
	Number that uniquely identifies an individual.

TUMOR_NO

number (2,0)

Required:false

Sequential number, starting with “1”, assigned to each tumor for a given individual when entered into the local system.

Allowable Values
1 to 99 or -9, -15	Range
1, 2, 3, …	Number of tumor on cancer table
-9	NA/Out of scope: Tissue is not cancer or contiguous adenoma
-15	Information Unknown

Error Description
If NORMAL_ONLY = 1, TUMOR_NO must be null
range check will pass under the following conditions: {TUMOR_NO>=1 and TUMOR_NO<=1 } This special value check will pass under the following conditions: TUMOR_NO in {1, 2, 3, … ,-9,-15}

POLYP_NO

number (1,0)

Required:false

Sequential number over range of 1 to 3 to distinguish a polyp removed on a particular date.

Allowable Values
1 to 3 or -9, -1	Range
-9	NA/Out of scope. Tissue is not a polyp
-1	Polyp has IHC/MSI result but center is currently unable to locate polyp pathology information. Center review to obtain this information is currently underway

Error Description
If NORMAL_ONLY is 1, POLYP_NO must be null
range check will pass under the following conditions: {POLYP_NO>=1 and POLYP_NO<=1 } This special value check will pass under the following conditions: POLYP_NO in {-9,-1}

5	FRESH_SPEC_CID (*PK)	string (9)	Required:true
	Unique local identifier used at a center to uniquely identify a fresh tissue specimen. *CENTER_NO + FRESH_SPEC_CID are the primary key for the table.

DATE_TAKEN

string (8)

Required:true

Date specimen was taken from patient. Format: YYYYMMDD.

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:
1980	Minimum year

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

7	COLLECTION_CID	string (10)	Required:true
	Identifier used internally by centers to denote a unique surgical event

NORMAL_ONLY

number (1,0)

Required:true

Indicates that the specimen/product contains only normal tissue.

9	FRESH_SOURCE	string (21)	Required:false
	Source or origin in as much detail as is known. For tumors, ICD-O-3 site code should be used.

PATH_REPORT_RECEIVED

number (1,0)

Required:false

Indicates whether a pathology report has been received for subject specimen.