Module: biospecimens

Module Contents

CENTER_NO (*PK)

number (2,0)

Required:true

Center Identification Number. *CENTER_NO + ORAL_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.

3	ORAL_SPEC_CID (*PK)	string (40)	Required:true
	Identifier used internally by centers for a oral sample. *CENTER_NO + ORAL_SPEC_CID are the primary key for the table.

DATE_RECEIVED

string (8)

Required:true

Date specimen was received into the laboratory of a center. 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

Error Description
must be a valid date of format with minimum year of 1980
Error Description
DATE_RECEIVED must be greater or equal to DATE_TAKEN
This check will pass under the following conditions: DATE_RECEIVED is valid date{Minimum year:1980}

DATE_TAKEN

string (8)

Required:false

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

IS_DEPLETED

number (1,0)

Required:true

Indicates whether the material has been depleted through testing, processing, and dispatching.

ORAL_TYPE

number (1,0)

Required:true

Type of oral specimen.