Module: biospecimens

Module Contents

  1. dispatch-item

1CENTER_NO (*PK)number (2,0)Required:true
Center Identification Number. *CENTER_NO + DISPATCH_ITEM_CID are the primary key for the table.
Allowable Values
11Cancer Care Ontario
12USC Consortium
13University of Melbourne
14Cancer Research Center of Hawaii
15Mayo Clinic
16Fred Hutchinson, Seattle
17Northern California (NCCC)


2DISPATCH_CIDstring (40)Required:true
Center specific identifier used by centers for tracking a dispatch of biospecimens.

3DISPATCH_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.

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

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

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

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

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

9AMT_UNITnumber (2,0)Required:true
Unit of measure for the biospecimen dispatched
Allowable Values
1count (slide, tube, plate)
2sets (set of slides, tubes)
3weight in miligrams, mg
4weight in micrograms, ug
5volume in mililiters, ml
6volume 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

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