Dimensional Warehouse Model Data Model

Entity

Entity Specimen Dimension

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
AWM Load Info Sk
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Filler Order Num
Placer Order Num
Source Cd
Source Code Descr
Source Code Sk
Specimen Action Cd
Specimen Action Code Sk
Specimen Action Descr
Specimen Appropriateness Cd
Specimen Appropriateness Code Sk
Specimen Appropriateness Descr
Specimen Availability Cd
Specimen Availability Code Sk
Specimen Availability Descr
Specimen Bk
Specimen Collection Method Cd
Specimen Collection Method Code Sk
Specimen Collection Method Descr
Specimen Collection Site Cd
Specimen Collection Site Code Sk
Specimen Collection Site Descr
Specimen Description Txt
Specimen Dk
Specimen Id Num
Specimen Quality Cd
Specimen Quality Code Sk
Specimen Quality Descr
Specimen Sk
Specimen Source Site Code Sk
Specimen Type Code Sk
Specimen Type Modifier Cd
Specimen Type Modifier Code Sk
Specimen Type Modifier Descr
Standard Specimen Source Group Cd
Standard Specimen Source Group Code Sk
Standard Specimen Source Group Descr
Standard Specimen Source Site Cd
Standard Specimen Source Site Code Descr
Standard Specimen Source Site Code Sk
Standard Specimen Type Cd
Standard Specimen Type Code Descr
Standard Specimen Type Code Sk
Tenant Sk
Transport Logistics Collected Sample Nm
Valid From Ts
Valid To Ts

Primary Key
Specimen Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Accession Num

Description	Identifies the product/test that initiated the specimen collection.
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

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
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

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

DWM 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

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 order 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

Placer Order Num

Description	The placer application's order number.
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

Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Descr

Description	The description that corresponds to the Source Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
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 Cd

Description	Code specifying the type of action to be taken regarding this Specimen.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Action Code Sk

Description	A surrogate key for a code specifying the type of action to be taken regarding this 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 Action Descr

Description	The description corresponding to the Specimen Action 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

Specimen Appropriateness Cd

Description	An abbreviation or acronym that describes the collected specimen for its particular planned use. Examples are: preferred, inappropriate and appropriate.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Appropriateness Code Sk

Description	An abbreviation or acronym that describes the collected specimen for its particular planned use. Examples are: preferred, inappropriate and 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 Appropriateness Descr

Description	The description corresponding to the Specimen Appropriateness 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

Specimen Availability Cd

Description	A yes or no value that describes whether or not the collected specimen is ready for use in laboratory or observation analysis.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Availability Code Sk

Description	A yes or no value that describes 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 Availability Descr

Description	A yes or no value that describes whether or not the collected specimen is ready for use in laboratory or observation analysis.
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

Specimen Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Specimen Collection Method Cd

Description	An acronym or abbreviation used to name the procedure or process by which the specimen was collected.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Collection Method Code Sk

Description	An acronym or abbreviation used to name the procedure or process by which the specimen was 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 Method Descr

Description	The description corresponding to the Specimen Collection Method 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

Specimen Collection Site Cd

Description	An acronym or abbreviation used to name the origin, normally a body part, from which the specimen material was collected. Specimen collection site and specimen source site can be different, but normally work in tandem to describe the specimen collection details. As an 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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Collection Site Code Sk

Description	An acronym or abbreviation used to name the origin, normally a body part, from which the specimen material was collected. Specimen collection site and specimen source site can be different, but normally work in tandem to describe the specimen collection details. As an 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 Site Descr

Description	The description corresponding to the Specimen Collection Site 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

Specimen Description Txt

Description	Describes words and phrases to provide additional information describing 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 Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
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	true

Specimen Id Num

Description	A unique series of numbers and or letters assigned by the data provider that names one and only specimen. The operation system's identifier for the specimen (i.e. accession number or specimen id).
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 Cd

Description	An acronym or abbreviation that describes 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. Examples are: excellent, good, fair and poor.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Quality Code Sk

Description	An acronym or abbreviation that describes 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. Examples are: excellent, good, fair and 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 Quality Descr

Description	The description corresponding to the Specimen Quality 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

Specimen Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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

Specimen Source Site Code Sk

Description	An acronym or abbreviation used to name the origin, normally a body part, from which the specimen material was obtained. A nationally recognized coding system should be used to specify the list of possible enumerated values. As an 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	true
Is Derived	false
Is Surrogate Key	false

Specimen Type Modifier Cd

Description	An abbreviation or acronym that points to modifying or qualifying descriptions about the collected specimen and its associated specimen type code. This is useful when the specimen type code is too limiting in its description or does not provide the precision to absolutely describe the specimen. If code only contains 'venous blood' then 'capillary' can be added as a modifier to augment the description of the specimen type.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Type Modifier Code Sk

Description	An abbreviation or acronym that points to modifying or qualifying descriptions about the collected specimen and its associated specimen type code. This is useful when the specimen type code is too limiting in its description or does not provide the precision to absolutely describe the specimen. If code only contains 'venous blood' then 'capillary' can be added as a modifier to augment the description of the specimen type.
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 Modifier Descr

Description	The description corresponding to the Specimen Type Modifier 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

Standard Specimen Source Group Cd

Description	An identifier naming either a Tenant Common code or a common code which represents the name for a group of specimens. If the specimen is kidney, the Specimen Group is urinary tract.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Standard Specimen Source Group Code Sk

Description	An identifier naming either a Tenant Common code or a common code which represents the name for a group of specimens. 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

Standard Specimen Source Group Descr

Description	The description corresponding to the Specimen Source Group 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

Standard Specimen Source Site Cd

Description	An acronym or abbreviation used to name the origin, normally a body part, from which the specimen material was obtained. A nationally recognized coding system should be used to specify the list of possible enumerated values. As an example, the specimen source site would be liver, if the procedure were a liver biopsy.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Standard Specimen Source Site Code Descr

Description	The description corresponding to the Specimen Source Site 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

Standard Specimen Source Site Code Sk

Description	An acronym or abbreviation used to name the origin, normally a body part, from which the specimen material was obtained. A nationally recognized coding system should be used to specify the list of possible enumerated values. As an 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

Standard Specimen Type Cd

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

Standard Specimen Type Code Descr

Description	The description that corresponds to the Specimen Type 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

Standard 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 Nm

Description	The name of the transport logistics for the collected sample.
Data Type	Standards - Data Domains.ddm/Data Domains/Data Object Name Medium [VARCHAR(80)]
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	false
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

Primary Key Details

Specimen Dimension PK

Key Attribute

Specimen Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model