Specimen IdSpecimen RiskSpecimen Risk Description Txt
| Business Data Model Data Model |
| Description | A known or suspected hazard in either obtaining or handling a specimen. For example: Biological risk Corrosive Escape risk Explosive |
| Attributes | |
| Specimen Id |
|
| Specimen Risk |
|
| Specimen Risk Description Txt |
|
| Relationship | |
 Specimen Risk_Biospecimen_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Specimen Id
| Description | Identifies an instance of a specimen. A unique series of numbers and or letters assigned by the data provider that names one and only one specimen. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Specimen Risk
| Description | Indicates the nature of a known or suspected hazards associated with the collected specimen. For example: Infectious agent or blood from a hepatitis patient. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Specimen Risk Description Txt
| Description | A free-form text clarifying and augmenting definition of the known or suspected hazards as indicated by the specimen risk code. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Specimen Risk_Biospecimen_FK
| Is Identifying Relationship | false |
| Child Table | Specimen Risk |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Specimen |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |