ReagentReagent Amount QtySpecimen IdSpecimen Reagent Amount Unit Of Measure
| Business Data Model Data Model |
| Description | A substance used in chemical reactions to detect, analyze, or produce other substances. The specimen reagent is recorded to track the chemicals used on the patient specimen sample. For example: Phenolphthalin Hydrogen peroxide |
| Attributes | |
| Reagent |
|
| Reagent Amount Qty |
|
| Specimen Id |
|
| Specimen Reagent Amount Unit Of Measure |
|
| Relationship | |
 Specimen Reagent_Specimen_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Reagent
| Description | Indicates the substance used as a reagent for the specimen. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Reagent Amount Qty
| Description | The quantity of a chemical or other substance used as a reagent in analyzing the specimen. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
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 | false |
| Is Derived | false |
| Is Surrogate Key | false |
Specimen Reagent Amount Unit Of Measure
| Description | Indicates the units of measure in which the reagent amount is expressed. For example: ml for milliliters mg for milligrams |
| 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 |
| Relationship Details |
Specimen Reagent_Specimen_FK
| Is Identifying Relationship | true |
| Child Table | Specimen Reagent |
| 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 | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |