Module: biospecimens
Module Contents
- fresh-prod
| 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. | |||||||||||||||
| |||||||||||||||