Module: biospecimens

Module Contents

  1. block-prod
    1.CENTER_NO (PK*)
    2.BLOCK_PROD_CID (PK*)
    3.BLOCK_SPEC_CID
    4.IS_DISPATCHABLE
    5.IS_DEPLETED
    6.BLOCK_PROD_TYPE
    7.COUNT_ORIG
    8.COUNT_REM
    9.COUNT_REM_DISP
    10.LOCATION
    11.THICKNESS
    12.DIGITAL_IMAGE

1 CENTER_NO (PK*) number (2,0) Required:true
Center Identification Number.*CENTER_NO + BLOCK_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 BLOCK_PROD_CID (PK*) string (17) Required:true
Unique local identifier used at a center to uniquely identify a block. *CENTER_NO + BLOCK_PROD_CID are the primary key for the table.

3 BLOCK_SPEC_CID string (17) Required:true
Unique local identifier used at a center to uniquely identify a block 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 BLOCK_PROD_TYPE number (1,0) Required:true
Type of block product
Allowable Values
1 Single H and E slide
2 Set of H and E slides with the same basic properties
3 Single uncoated (i.e. uncharged) slide
4 Set of uncoated (i.e. uncharged) slides with the same basic properties
5 Single coated (i.e. charged) slide
6 Set of coated (i.e. charged) slides with the same basic properties
7 Single section tube
8 Set of section tubes


7 COUNT_ORIG number (4,0) Required:true
Original number of slides or section 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 slides or section tubes in the group corresponding to this record.

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 slides or section 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 LOCATION number (1,0) Required:true
Storage site for a specimen.
Allowable Values
1 Center
4 Multiple Sites
9 Unknown/lost

Error Description
If BLOCK_PROD_TYPE in (1,3,5,7), LOCATION must not equal 4


11 THICKNESS number (6,2) Required:false
Thickness of section or sections in microns.

12 DIGITAL_IMAGE number (1,0) Required:false
Flag indicating a digital image of the H & E slide is available
Allowable Values
1 Yes

Error Description
If BLOCK_PROD_TYPE not in (1,2), DIGITAL_IMAGE must be null