Atomic Warehouse Model Data Model

Entity

Entity Specimen Detail

Description

A limited quantity of biological material that is typically removed from a person for use in medical laboratory tests in order to study the presence or absence of microorganisms. Other sources of specimens include environmental samples of soil, water or air.

For example:
Blood
Tissue
Urine
Sputum

Attributes
Accession Num
Effective From Dt
Effective To Dt
Filler Order Num
Grouped Specimen Cnt
Load Info Sk
Parent Specimen ID Num
Placer Order Num
Priority Seq
Source Code Sk
Specimen Action Code Sk
Specimen Appropriateness Code Sk
Specimen Availability Code Sk
Specimen Collection End Ts
Specimen Collection Method Code Sk
Specimen Collection Qty
Specimen Collection Quantity UOM Code Sk
Specimen Collection Site Code Sk
Specimen Collection Ts
Specimen Container Cnt
Specimen Current Qty
Specimen Current Quantity UOM Code Sk
Specimen Description Txt
Specimen Expiration Ts
Specimen Id Num
Specimen Quality Code Sk
Specimen Received Ts
Specimen Sk
Specimen Source Group Code Sk
Specimen Source Site Code Sk
Specimen Type Code Sk
Tenant Sk
Transport Logistics Collected Sample Code Sk
Valid From Ts
Valid To Ts

Relationship
Specimen Detail_Specimen_FK

Primary Key
Specimen Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Accession Num

Description	The identifying number associated with the filling application.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
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

Filler Order Num

Description	The identifying number associated with the filling application.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Grouped Specimen Cnt

Description	The total number of individual specimens of a particular specimen type. All specimens in this group of specimens will have identical attributes.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [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

Parent Specimen ID Num

Description	A unique series of numbers and or letters assigned by the data provider that names the specimen that this specimen was taken from.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Placer Order Num

Description	The placer application's order number for the service/material being ordered.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Priority Seq

Description	A number that identifies the relative order of importance of the pharmacy order give indication.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [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 Action Code Sk

Description	Indicates the type of action taken for a specimen.
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

Specimen Appropriateness Code Sk

Description	Indicates the suitability of a collected specimen for its particular planned use. For example: Preferred Inappropriate Appropriate
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

Specimen Availability Code Sk

Description	Indicates whether or not the collected specimen is ready for use in laboratory or observation analysis.
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

Specimen Collection End Ts

Description	The date and time time that the specimen collection ended.
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

Specimen Collection Method Code Sk

Description	Indicates the procedure or process by which a specimen is collected.
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

Specimen Collection Qty

Description	A number either integer or decimal that describes the volume or mass of the collected specimen. This amount can only be specified after the specimen has been collected.
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 Collection Quantity UOM Code Sk

Description	Indicates the units in which the amount of the collected specimen is expressed. These units of measure should come from a recognized standard. For example: ml for milliliters mg for milligrams
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

Specimen Collection Site Code Sk

Description	Indicates the origin, normally a body part, from which a specimen is collected. Specimen collection site and specimen source site can be different, but normally work in tandem to describe the specimen collection details. For example: The specimen source site would be liver, if the procedure were a liver biopsy. If the liver biopsy uses a percutaneous needle, then the specimen collection site is the eye of the needle.
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

Specimen Collection Ts

Description	The date and time that the specimen was acquired from the source, normally the patient.
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

Specimen Container Cnt

Description	The number of containers required to hold the collected sample. For example: A blood sample taken in a single procedure may be split across multiple syringes.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Current Qty

Description	A number, either decimal or integer, that describes the volume or amount of collected specimen available for use in further testing.
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 Current Quantity UOM Code Sk

Description	Indicates the units in which the amount of the collected specimen is expressed. These units of measure should come from a recognized standard. For example: ml for milliliters mg for milligrams
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

Specimen Description Txt

Description	A free form textual description providing additional information about the collected specimen.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Expiration Ts

Description	The date and time when the collected specimen can no longer be used for its intended purpose. The specimen rejected reason would contain 'expired' when this time has been reached.
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

Specimen Id Num

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/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Quality Code Sk

Description	Indicates the degree, grade or condition of excellence for the collected specimen at the time of receipt. The condition is judged by a person at the filling system. These values can be user-defined. For example: Excellent Good Fair Poor
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

Specimen Received Ts

Description	The date and time that the specimen was received at the diagnostic service for examination.
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

Specimen Sk

Description	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

Specimen Source Group Code Sk

Description	Indicates a common code which represents the name for a group of specimens. For example: If the specimen is kidney, the Specimen Group is urinary tract.
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

Specimen Source Site Code Sk

Description	Indicates the origin, normally a body part, from which the specimen material was obtained. For example: The specimen source site would be liver, if the procedure were a liver biopsy.
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

Specimen Type Code Sk

Description	An acronym or abbreviation used to describe the precise nature of the patient source material that will be used either to support a laboratory result or a patient observation. The specimen described is a physical substance and it can be either a complex organism or a specific cellular mass. It is preferred that a nationally recognized coding standard be used to codify this attribute.
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

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

Transport Logistics Collected Sample Code Sk

Description	A textual description of the transport logistics for the collected sample.
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 Detail_Specimen_FK

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

Key Attribute	Specimen Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model