Module: biospecimens
Module Contents
- fresh-prod
1.CENTER_NO (*PK)
2.FRESH_PROD_CID (*PK)
3.FRESH_SPEC_CID
4.IS_DISPATCHABLE
5.IS_DEPLETED
6.FRESH_PROD_TYPE
7.COUNT_ORIG
8.COUNT_REM
9.COUNT_REM_DISP
10.STORAGE_TEMP
11.LOCATION
1 | CENTER_NO (*PK) | number (2,0) | Required:true | ||||||||||||||||
Center Identification Number. *CENTER_NO + FRESH_PROD_CID are the primary key for the table. | |||||||||||||||||||
|
2 | FRESH_PROD_CID (*PK) | string (12) | Required:true |
Identifier used internally by centers for a product of a fresh tissue specimen or group of fresh tissue specimens. *CENTER_NO + FRESH_PROD_CID are the primary key for the table. |
3 | FRESH_SPEC_CID | string (9) | Required:true |
Unique local identifier used at a center to uniquely identify a fresh tissue specimen. |
4 | IS_DISPATCHABLE | number (1,0) | Required:true | ||||||||
Indicates whether the center is willing to dispatch the material to external investigators. | |||||||||||
|
5 | IS_DEPLETED | number (1,0) | Required:true | ||||||
Indicates whether the material has been depleted through testing, processing, and dispatching. | |||||||||
|
6 | FRESH_PROD_TYPE | number (1,0) | Required:true | ||||||||
Type of fresh frozen tissues product | |||||||||||
|
7 | COUNT_ORIG | number (4,0) | Required:true | ||
Original number of tubes in the group corresponding to this record. | |||||
|
8 | COUNT_REM | number (4,0) | Required:true | ||
Current number of tubes in the group corresponding to this record remaining at the time of transmission (includes material held in reserve). | |||||
|
9 | COUNT_REM_DISP | number (4,0) | Required:true | ||
Current number of tubes in the group corresponding to this record remaining at the time of transmission that is available for dispatch (excludes material held in reserve). | |||||
|
10 | STORAGE_TEMP | number (1,0) | Required:false | ||||||||
Storage temperature for fresh frozen specimen | |||||||||||
|
11 | LOCATION | number (1,0) | Required:false | ||||||||||||
Storage site for a specimen. | |||||||||||||||
|