Module: biospecimens

Module Contents

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.

AMT_UNIT

number (2,0)

Required:true

Unit of measure for the biospecimen dispatched

Error Description
If BLOCK_PROD_CID is not null, AMT_UNIT must be 1 or 2
Error Description
If BLOOD_PROD_CID is not null, AMT_UNIT must be 1,2,5 or 6
Error Description
If FRESH_PROD_CID is not null, AMT_UNIT must be 3,4
Error Description
If NUC_ACID_CID is not null, AMT_UNIT must be 4
This special value check will pass under the following conditions: AMT_UNIT in {1,2,3,4,5,6}

AMT_VALUE

number (11,4)

Required:true

Numerical value for unites in AMT_UNIT