Blood-prod

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

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


2BLOOD_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.

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


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

5IS_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

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


7COUNT_ORIGnumber (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

8COUNT_REMnumber (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

9COUNT_REM_DISPnumber (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

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

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

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

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

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

13AMT_REMnumber (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 -9Range
-9Unknown 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

14AMT_REM_DISPnumber (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 -9Range
-9Unknown 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

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

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

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

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