Module: biospecimens

Module Contents

  1. block-prod

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


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

3BLOCK_SPEC_CIDstring (17)Required:true
Unique local identifier used at a center to uniquely identify a block tissue specimen.

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

5IS_DEPLETEDnumber (1,0)Required:true
Indicates whether the material has been depleted through testing, processing, and dispatching.
Allowable Values
1Yes
2No


6BLOCK_PROD_TYPEnumber (1,0)Required:true
Type of block product
Allowable Values
1Single H and E slide
2Set of H and E slides with the same basic properties
3Single uncoated (i.e. uncharged) slide
4Set of uncoated (i.e. uncharged) slides with the same basic properties
5Single coated (i.e. charged) slide
6Set of coated (i.e. charged) slides with the same basic properties
7Single section tube
8Set of section tubes


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

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

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

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

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

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

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

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