Module: biospecimens

Module Contents

  1. fresh-prod
    1.CENTER_NO (*PK)
    2.FRESH_PROD_CID (*PK)
    3.FRESH_SPEC_CID
    4.IS_DISPATCHABLE
    5.IS_DEPLETED
    6.FRESH_PROD_TYPE
    7.COUNT_ORIG
    8.COUNT_REM
    9.COUNT_REM_DISP
    10.STORAGE_TEMP
    11.LOCATION

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

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

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

Error Description
If IS_DEPLETED = 1, IS_DISPATCHABLE must be 2


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


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


7 COUNT_ORIG number (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


8 COUNT_REM number (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


9 COUNT_REM_DISP number (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


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


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