Atomic Warehouse Model Data Model

Entity

Entity Specimen Container

Description

An association between a specimen and a container in which it stored or carried.

Attributes
Barrier Delta
Bottom Delta
Cap Type Code Sk
Carrier Id
Container Barrier Delta Unit Of Measure Code Sk
Container Bottom Delta Unit Of Measure Code Sk
Container Condition Code Sk
Container Diameter
Container Diameter Unit Of Measure Code Sk
Container Height
Container Height Unit Of Measure Code Sk
Container Location Id
Container Type Code Sk
Container Volume
Container Volume Unit Of Measure Code Sk
Effective From Dt
Effective To Dt
Induced Contaminants Code Sk
Load Info Sk
Position in Carrier Id
Position in Tray Id
Separator Type Code Sk
Source Code Sk
Specimen Sk
Tenant Sk
Tray Id
Tray Type Code Sk
Valid From Ts
Valid To Ts

Relationship
Specimen Container _Specimen_FK

Primary Key
Specimen Container PK

Dependencies

Reverse Dependencies

Attribute Details

Barrier Delta

Description	A number or decimal value describing the distance from the Point of Reference to the separator material (barrier) within the specimen container.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Bottom Delta

Description	A number or decimal value describing the distance from the Point of Reference to the outside bottom of the specimen container.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Cap Type Code Sk

Description	Indicates the type of cap that is to be used with this specimen container for decapping, piercing or other mechanisms.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Carrier Id

Description	Identifies the carrier where container is located.
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

Container Barrier Delta Unit Of Measure Code Sk

Description	Indicates the unit of measure in which the specimen container barrier delta is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Container Bottom Delta Unit Of Measure Code Sk

Description	Indicates the unit of measure in which the specimen container bottom delta is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Container Condition Code Sk

Description	Indicates the physical state of the container. The chain of custody for specimen must also describe if the container has been compromised in any way. For example: Seal broken Cracked Leaking
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Container Diameter

Description	A number or decimal value describing the outside diameter of the container.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Container Diameter Unit Of Measure Code Sk

Description	Indicates the unit of measure in which the specimen container outer diameter is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Container Height

Description	A number or decimal value describing the height of the specimen container.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Container Height Unit Of Measure Code Sk

Description	Indicates the unit of measure in which the specimen container height is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Container Location Id

Description	Identifies the physical location of the specimen container.
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

Container Type Code Sk

Description	Indicates the category of receptacle used to hold or carry material such as a specimen to a laboratory for analysis.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Container Volume

Description	A number or decimal value describing the volume of the container.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Container Volume Unit Of Measure Code Sk

Description	Indicates the unit of measure in which the specimen container volume is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Induced Contaminants Code Sk

Description	Indicates the specimen contaminant that is associated with the specimen in the container.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Position in Carrier Id

Description	Identifies the position of the specimen container in the carrier.
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

Position in Tray Id

Description	Identifies the position of the specimen carrier in the tray.
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

Separator Type Code Sk

Description	Indicates the type of the separator that is being used in the container. For example: Gel separator
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Specimen Sk

Description	This element is the anchor surrogate key for the Specimen data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Tray Id

Description	Uniquely identifies the tray holding the specimen carrier.
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

Tray Type Code Sk

Description	Indicates the type of tray holding the specimen carrier.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Specimen Container _Specimen_FK

Is Identifying Relationship	true
Child Table	Specimen Container
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

Primary Key Details

Specimen Container PK

Key Attribute	Specimen Sk
Key Attribute	Container Type Code Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model