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
    13.EN_NEO_CELL_PC

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


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

13EN_NEO_CELL_PCnumber (3,0)Required:false
Proportion (defined as percent) of tumor within tumor bed (area on PET slide that contains tumor cells) that contains the highest density of tumor cells compared to non-neoplastic elements.
Allowable Values
1 to 100 or 999Range
999Unknown

Error Description
If BLOCK_PROD_TYPE not in {1,2}, EN_NEO_CELL_PC must be null