Module: biospecimens

Module Contents

  1. fresh-prod

1CENTER_NO (*PK)number (2,0)Required:true
Center Identification Number. *CENTER_NO + FRESH_PROD_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)


2FRESH_PROD_CID (*PK)string (12)Required:true
Identifier used internally by centers for a product of a fresh tissue specimen or group of fresh tissue specimens. *CENTER_NO + FRESH_PROD_CID are the primary key for the table.

3FRESH_SPEC_CIDstring (9)Required:true
Unique local identifier used at a center to uniquely identify a fresh tissue specimen.

4IS_DISPATCHABLEnumber (1,0)Required:true
Indicates whether the center is willing to dispatch the material to external investigators.
Allowable Values
1Yes
2No

Error Description
If IS_DEPLETED = 1, IS_DISPATCHABLE must be 2

5IS_DEPLETEDnumber (1,0)Required:true
Indicates whether the material has been depleted through testing, processing, and dispatching.
Allowable Values
1Yes
2No


6FRESH_PROD_TYPEnumber (1,0)Required:true
Type of fresh frozen tissues product
Allowable Values
1Fresh frozen
2Fresh frozen
3Embedded in OCT, then frozen


7COUNT_ORIGnumber (4,0)Required:true
Original number of tubes in the group corresponding to this record.

Error Description
COUNT_ORIG must be greater or equal to COUNT_REM

8COUNT_REMnumber (4,0)Required:true
Current number of tubes in the group corresponding to this record remaining at the time of transmission (includes material held in reserve).

Error Description
COUNT_REM must be less than or equal to COUNT_ORIG

9COUNT_REM_DISPnumber (4,0)Required:true
Current number of tubes in the group corresponding to this record remaining at the time of transmission that is available for dispatch (excludes material held in reserve).

Error Description
COUNT_REM_DISP must be less than or equal to COUNT_REM

10STORAGE_TEMPnumber (1,0)Required:false
Storage temperature for fresh frozen specimen
Allowable Values
1-20 °C
2-80 °C
3Liquid nitrogen (smaller than -140°C)


11LOCATIONnumber (1,0)Required:false
Storage site for a specimen.
Allowable Values
1Center
2CORIELL
3SAIC
4Multiple Sites
9Unknown/lost