Blood-prod

Module: biospecimens

Module Contents

  1. blood-prod


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
11Sinai Health Systems (formerly Cancer Care Ontario)
12Cedars-Sinai & Cleveland Clinic (formerly USC Consortium)
13University of Melbourne
14University of Hawaii Cancer Center
15Mayo Clinic
16Fred Hutch, Seattle
17UCSF: University of California at San Franscisco (formerly CPIC, originally Northern California (NCCC))

This special value check will pass under the following conditions:

CENTER_NO (*PK) in {11,12,13,14,15,16,17}

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

This special value check will pass under the following conditions:

BLOOD_PROD_TYPE in {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17}

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

This special value check will pass under the following conditions:

IS_DISPATCHABLE in {1,2}

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

This special value check will pass under the following conditions:

IS_DEPLETED in {1,2}

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

Error Description
If BLOOD_PROD_TYPE is not 11, COUNT_ORIG must not be null
Error Description
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).
Allowable Values

Error Description
BLOOD_PROD_TYPE is not 11, must not be null
Error Description
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).
Allowable Values

Error Description
If BLOOD_PROD_TYPE is not 11, then COUNT_REM_DISP must not be null
Error Description
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

This special value check will pass under the following conditions:

LOCATION in {1,2,3,4,9}

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

range check will pass under the following conditions:

{AMT_ORIG>=0 and AMT_ORIG<=0 }

This special value check will pass under the following conditions:

AMT_ORIG in {-9}

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
Error Description
AMT_REM must be less than or equal to AMT_ORIG

range check will pass under the following conditions:

{AMT_REM>=0 and AMT_REM<=0 }

This special value check will pass under the following conditions:

AMT_REM in {-9}

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
Error Description
AMT_REM_DISP must be less than or equal to AMT_ORIG

range check will pass under the following conditions:

{AMT_REM_DISP>=0 and AMT_REM_DISP<=0 }

This special value check will pass under the following conditions:

AMT_REM_DISP in {-9}

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

This special value check will pass under the following conditions:

VC_TUBE_TYPE in {1,2,3,4,5,9}

16FREEZE_COUNTnumber (1,0)Required:false
Number of times sample tube has been frozen. The default value is '1', indicating the sample had been frozen only once, following the blood processing. If the sample is subsequently thawed and refrozen, the value would be 2, etc.
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

range check will pass under the following conditions:

{FREEZE_COUNT>=1 and FREEZE_COUNT<=1 }

This special value check will pass under the following conditions:

FREEZE_COUNT in {-9}