Module: biospecimens

Module Contents

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

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	University of Southern California Consortium (USCC)
13	University of Melbourne
14	University of Hawaii Cancer Center
15	Mayo Clinic
16	Fred Hutch, Seattle
17	University of California at San Francisco (UCSF) (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.

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 material has been depleted through testing, processing, and dispatching.

Allowable Values
1	Yes
2	No

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

COUNT_ORIG

number (4,0)

Required:true

Original number of slides or section tubes in the group corresponding to this record.

COUNT_REM

number (4,0)

Required:true

Current number of slides or section tubes in the group corresponding to this record.

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

LOCATION

number (1,0)

Required:true

Storage site for a specimen.

Allowable Values
1	Center
4	Multiple Sites
9	Unknown/lost

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

DIGITAL_IMAGE

number (1,0)

Required:false

Flag indicating a digital image of the H & E slide is available. This need only be populated where BLOCK_PROD_TYPE = 1 or 2 (H & E slide).

Allowable Values
1	Yes

EN_NEO_CELL_PC

number (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. This need only be populated where BLOCK_PROD_TYPE = 1 or 2 (H & E slide).

Allowable Values
1 to 100 or 999	Range
999	Unknown

Error Description
If BLOCK_PROD_TYPE not in (1,2), EN_NEO_CELL_PC must be null
range check will pass under the following conditions: {EN_NEO_CELL_PC>=1 and EN_NEO_CELL_PC<=1 } This special value check will pass under the following conditions: EN_NEO_CELL_PC in {999}