Module: biospecimens

Module Contents

  1. blood-prod
    1.CENTER_NO (*PK)
    2.BLOOD_PROD_CID (*PK)
    3.BLOOD_PROD_TYPE
    4.BLOOD_SPEC_CID
    5.IS_DISPATCHABLE
    6.IS_DEPLETED
    7.COUNT_ORIG
    8.COUNT_REM
    9.COUNT_REM_DISP
    10.LOCATION
    11.DATE_TIME_PROCESSED
    12.AMT_ORIG
    13.AMT_REM
    14.AMT_REM_DISP
    15.VC_TUBE_TYPE
    16.FREEZE_COUNT

1 CENTER_NO (*PK) number (2,0) Required:true
Center Identification Number. *CENTER_NO + BLOOD_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 BLOOD_PROD_CID (*PK) string (16) Required:true
Identifier used internally by centers for a product from a blood draw. This identifier will correspond to a single aliquot if the center individually tracks such materials. Alternatively, the identifier will correspond to a group of related aliquots (e.g. all plasma vials from the same draw) in the case where the center does not track each material independently. *CENTER_NO + BLOOD_PROD_CID are the primary key for the table.

3 BLOOD_PROD_TYPE number (2,0) Required:true
Type of blood product
Allowable Values
1 Single aliquot of whole blood
2 Set of aliquots of whole blood with the same basic properties
3 Single aliquot of whole blood in DMSO
4 Set of aliquots of whole blood in DMSO with the same basic properties
5 Single aliquot of white blood cells. Refers specifically to lymphocytes isolated using a Ficoll-Histopaque gradient centrifugation, resuspended in freeze medium and cryopreserved
6 Set of white blood cells. Refers specifically to lymphocytes isolated using a Ficoll-Histopaque gradient centrifugation, resuspended in freeze medium and cryopreserved
7 Single aliquot of buffy coat
8 Set of aliquots of buffy coat with the same basic properties
9 Single aliquot of plasma
10 Set of aliquots of plasma with the same basic properties
11 Total spotted blood volume (i.e. on Guthrie cards)
12 Single lymphocyte pellet
13 Set of lymphocyte pellets with the same properties
14 Single white blood cell pellet
15 Set of white blood cell pellets with the same properties
16 Single granulocyte pellet
17 Set of granulocyte pellets with the same basic properties


4 BLOOD_SPEC_CID string (15) Required:true
Unique local identifier used at a center to uniquely identify a blood tissue specimen.

5 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


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


7 COUNT_ORIG number (4,0) Required:false
Original number of aliquots in the group corresponding to this record..

Error Description
If BLOOD_PROD_TYPE is not 11, COUNT_ORIG must not be null
If BLOOD_PROD_TYPE is in (1,3,5,7,9,12,13,16), COUNT_ORIG must be 1


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

Error Description
BLOOD_PROD_TYPE is not 11, must not be null
must be less than or equal to COUNT_ORIG


9 COUNT_REM_DISP number (4,0) Required:false
Current number of aliquots in the group corresponding to this record remaining at the time of transmission that are available for dispatch (excludes material held in reserve).

Error Description
If BLOOD_PROD_TYPE is not 11, then COUNT_REM_DISP must not be null
COUNT_REM_DISP must be less than or equal to COUNT_REM


10 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

Error Description
If BLOOD_PROD_TYPE is in (1,3,5,7,12,14,16), then LOCATION does not equal 4


11 DATE_TIME_PROCESSED number (12,0) Required:false
Records the date and time sample was processed

12 AMT_ORIG number (6,2) Required:false
Original amount of material in milliliters.
Allowable Values
0 to 9999.99 or -9 Range
   
-9 Unknown quantity

Error Description
If BLOOD_PROD_TYPE = 11, then AMT_ORIG must not be null


13 AMT_REM number (6,2) Required:false
Amount of material remaining at time of reporting in milliliters (includes material held in reserve).
Allowable Values
0 to 9999.99 or -9 Range
   
-9 Unknown quantity

Error Description
If BLOOD_PROD_TYPE = 11, then AMT_REM must not be null
AMT_REM must be less than or equal to AMT_ORIG


14 AMT_REM_DISP number (6,2) Required:false
Amount of material remaining at time of reporting in milliliters that is available for dispatch (excludes material held in reserve).
Allowable Values
0 to 9999.99 or -9 Range
   
-9 Unknown quantity

Error Description
If BLOOD_PROD_TYPE = 11, then AMT_REM_DISP must not be null
AMT_REM_DISP must be less than or equal to AMT_ORIG


15 VC_TUBE_TYPE number (1,0) Required:false
Vacuum tube type used.
Allowable Values
1 EDTA
2 ACD
3 Heparin
4 SST
5 Plain tube (no additives)
9 Unknown

Error Description
If BLOOD_PROD_TYPE does not equal 11, then VC_TUBE_TYPE must not be null


16 FREEZE_COUNT number (1,0) Required:false
Number of times sample tube has been frozen” – the default value is “1”.
Allowable Values
1 to 9 or -9 Range
   
-9 Unknown

Error Description
If BLOOD_PROD_TYPE is not equal 11, then FREEZE_COUNT must not be null