Module: biospecimens

Module Contents

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

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.

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.

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

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

COUNT_ORIG

number (4,0)

Required:false

Original number of aliquots in the group corresponding to this record..

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).

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).

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

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

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
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}

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
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}

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
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}

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

FREEZE_COUNT

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

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}