Module: biospecimens

Module Contents

  1. dispatch
    1.CENTER_NO (*PK)
    2.DISPATCH_CID (*PK)
    3.DISPATCH_DATE

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


2 DISPATCH_CID (*PK) string (30) Required:true
Center specific identifier used by centers for tracking a dispatch of biospecimens. *CENTER_NO + DISPATCH_CID are the primary key for the table.

3 DISPATCH_DATE string (8) Required:true
Date specimen was sent.
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