Module: biospecimens

Module Contents

  1. dispatch-item
    1.CENTER_NO (*PK)
    2.DISPATCH_CID
    3.DISPATCH_ITEM_CID (*PK)
    4.BLOCK_PROD_CID
    5.BLOOD_PROD_CID
    6.FRESH_PROD_CID
    7.LCL_CID
    8.NUC_ACID_CID
    9.AMT_UNIT
    10.AMT_VALUE

1 CENTER_NO (*PK) number (2,0) Required:true
Center Identification Number. *CENTER_NO + DISPATCH_ITEM_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 string (40) Required:true
Center specific identifier used by centers for tracking a dispatch of biospecimens.

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

4 BLOCK_PROD_CID string (18) Required:false
Unique local identifier used at a center to uniquely identify a block.

5 BLOOD_PROD_CID string (12) Required:false
Identifier used internally by centers for a product from a blood draw.

6 FRESH_PROD_CID string (10) Required:false
Identifier used internally by centers for a product of a fresh tissue specimen.

7 LCL_CID string (11) Required:false
Identifier used internally by centers for a lymphocytic cell line transformation or expansion.

8 NUC_ACID_CID string (12) Required:false
Identifier used internally by centers for a nucleic acid sample from a single extraction.

9 AMT_UNIT number (2,0) Required:true
Unit of measure for the biospecimen dispatched
Allowable Values
1 count (slide, tube, plate)
2 sets (set of slides, tubes)
3 weight in milligrams, mg
4 weight in micrograms, ug
5 volume in milliliters, ml
6 volume in microliters, ul

Error Description
If BLOCK_PROD_CID is not null, AMT_UNIT must be 1 or 2
If BLOOD_PROD_CID is not null, AMT_UNIT must be 1,2,5 or 6
If FRESH_PROD_CID is not null, AMT_UNIT must be 3,4
If NUC_ACID_CID is not null, AMT_UNIT must be 4


10 AMT_VALUE number (11,4) Required:true
Numerical value for unites in AMT_UNIT
Allowable Values
0 to 9999999.9999 or -99 Range
   
-99 Unknown