Blood-spec

Module: biospecimens

Module Contents

  1. blood-spec


1CENTER_NO (*PK)number (2,0)Required:true
Center Identification Number. *CENTER_NO + BLOOD_SPEC_CID are the primary key for the table.
Allowable Values
11Sinai Health Systems (formerly Cancer Care Ontario)
12University of Southern California Consortium (USCC)
13University of Melbourne
14University of Hawaii Cancer Center
15Mayo Clinic
16Fred Hutch, Seattle
17University of California at San Francisco (UCSF) (formerly CPIC, originally Northern California (NCCC))


2PERSON_IDstring (12)Required:true
Number that uniquely identifies an individual.

3BLOOD_SPEC_CID (*PK)string (15)Required:true
Unique local identifier used at a center to uniquely identify a blood tissue specimen. *CENTER_NO + BLOOD_SPEC_CID are the primary key for the table.

4DATE_RECEIVEDstring (8)Required:true
Date specimen was received into the laboratory of a CRC-CFR 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:
1980Minimum 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


5DATE_TAKENstring (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:
1980Minimum 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