Dimensional Warehouse Model Data Model

Entity

Entity Lab Test Dimension

Description

The details of a laboratory diagnostic test which can be ordered for a patient to assess their general health status.

Attributes
AWM Load Info Sk
Change Type Cd
Change Type Code Sk
Change Type Descr
Class Cd
Class Code Sk
Class Descr
Comments Txt
Component Cd
Component Code Sk
Component Descr
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Example Unit Txt
Full Common Name Txt
INPC Percentage Pct
Laboratory Result Map To Cd
Laboratory Result Map To Code Sk
Laboratory Result Map To Descr
Lab Test Cd
Lab Test Code Dk
Lab Test Code Sk
Lab Test Descr
Lab Test Dk
Method Type Cd
Method Type Code Sk
Method Type Descr
Property Cd
Property Code Sk
Property Descr
Scale Type Cd
Scale Type Code Sk
Scale Type Descr
Source Cd
Source Code Descr
Source Code Sk
Standard Lab Test Cd
Standard Lab Test Code Dk
Standard Lab Test Code Sk
Standard Lab Test Descr
Status Cd
Status Code Sk
Status Descr
Status Reason Cd
Status Reason Code Sk
Status Reason Descr
Status Txt
System Cd
System Code Sk
System Descr
Tenant Sk
Time Aspect Cd
Time Aspect Code Sk
Time Aspect Descr
Update Dt
Valid From Ts
Valid To Ts

Primary Key
Lab Test Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

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

Change Type Cd

Description	The type of change that was made. For example: Delete/Deprecate Add Change to Analyte/Component Change to name field Change to field other than name Undelete
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

Change Type Code Sk

Description	The type of change that was made. For example: Delete/Deprecate Add Change to Analyte/Component Change to name field Change to field other than name Undelete
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

Change Type Descr

Description	The type of change that was made. For example: Delete/Deprecate Add Change to Analyte/Component Change to name field Change to field other than name Undelete
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

Class Cd

Description	An arbitrary classification of the terms for grouping related observations together. The content of the laboratory test subclasses should be obvious from the subclass name.
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

Class Code Sk

Description	An arbitrary classification of the terms for grouping related observations together. The content of the laboratory test subclasses should be obvious from the subclass name.
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

Class Descr

Description	An arbitrary classification of the terms for grouping related observations together. The content of the laboratory test subclasses should be obvious from the subclass name.
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

Comments Txt

Description	Comments relating to the laboratory test result.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Component Cd

Description	First major axis-component or analyte (i.e. potassium, hemoglobin, hepatitis C antigen, etc).
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

Component Code Sk

Description	First major axis-component or analyte (i.e. potassium, hemoglobin, hepatitis C antigen, etc).
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

Component Descr

Description	First major axis-component or analyte (i.e. potassium, hemoglobin, hepatitis C antigen, etc).
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

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

Example Unit Txt

Description	Text which shows representative, but not necessarily recommended units in which data could be submitted for this term.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Full Common Name Txt

Description	Text which describes the fully specified laboratory result code name.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

INPC Percentage Pct

Description	Percent of overall 13 month result volume within the INPC (circa 2006). A record with a value 0 indicates that this code is one of the common test results that comprise 99% of the total INPC result volume.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Laboratory Result Map To Cd

Description	The new term that should be used when an existing term has been replaced by an updated term.
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

Laboratory Result Map To Code Sk

Description	The new term that should be used when an existing term has been replaced by an updated term.
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

Laboratory Result Map To Descr

Description	The new term that should be used when an existing term has been replaced by an updated term.
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

Lab Test Cd

Description	A code that a tenant uses to identify a lab test.
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

Lab Test Code 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Lab Test Code Sk

Description	The surrogate key for a lab test.
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

Lab Test Descr

Description	A description that a tenant uses to identify a lab test.
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

Lab Test 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

Method Type Cd

Description	Sixth major axis - method of measurement.
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

Method Type Code Sk

Description	Sixth major axis - method of measurement.
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

Method Type Descr

Description	Sixth major axis - method of measurement.
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

Property Cd

Description	Second major axis-property observed (i.e. mass vs.substance).
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

Property Code Sk

Description	Second major axis-property observed (i.e. mass vs.substance).
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

Property Descr

Description	Second major axis-property observed (i.e. mass vs.substance).
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

Scale Type Cd

Description	Fifth major axis - scale of measurement (i.e. qualitative vs.quantitative).
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

Scale Type Code Sk

Description	Fifth major axis - scale of measurement (i.e. qualitative vs.quantitative).
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

Scale Type Descr

Description	Fifth major axis - scale of measurement (i.e. qualitative vs.quantitative).
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

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

Standard Lab Test Cd

Description	A tenant code for a standard lab test.
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

Standard Lab Test Code 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Standard Lab Test Code Sk

Description	The generated unique key for standard lab test code.
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

Standard Lab Test Descr

Description	A description for a tenant standard lab test code.
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

Status Cd

Description	Describes the status of a laboratory test concept. For example: Active - Concept is active Trial- Concept is experimental in nature. Use with caution as the concept and associated attributes may change Discouraged - Concept is not recommended for current use. New mappings to this concept are discouraged; although existing mappings may continue to be valid in context. Wherever possible, the superseding concept is indicated in the Laboratory Result Map To field and should be used instead. Deprecated - Concept is deprecated. Concept should not be used, but it is retained for historical purposes. Wherever possible, the superseding concept is indicated in the Laboratory Result Map To field and should be used both for new mappings and updating existing implementations.
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

Status Code Sk

Description	Describes the status of a laboratory test concept. For example: ACTIVE - Concept is active TRIAL - Concept is experimental in nature. Use with caution as the concept and associated attributes may change DISCOURAGED - Concept is not recommended for current use. New mappings to this concept are discouraged; although existing mappings may continue to be valid in context. Wherever possible, the superseding concept is indicated in the Laboratory Result Map To field and should be used instead. DEPRECATED - Concept is deprecated. Concept should not be used, but it is retained for historical purposes. Wherever possible, the superseding concept is indicated in the Laboratory Result Map To field and should be used both for new mappings and updating existing implementations.
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

Status Descr

Description	Describes the status of a laboratory test concept. For example: Active - Concept is active Trial- Concept is experimental in nature. Use with caution as the concept and associated attributes may change Discouraged - Concept is not recommended for current use. New mappings to this concept are discouraged; although existing mappings may continue to be valid in context. Wherever possible, the superseding concept is indicated in the Laboratory Result Map To field and should be used instead. Deprecated - Concept is deprecated. Concept should not be used, but it is retained for historical purposes. Wherever possible, the superseding concept is indicated in the Laboratory Result Map To field and should be used both for new mappings and updating existing implementations.
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

Status Reason Cd

Description	Indicates the reason for the laboratory test concept status. For example: Ambiguous Duplicate Erroneous
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

Status Reason Code Sk

Description	Indicates the reason for the laboratory test concept status. For example: AMBIGUOUS DUPLICATE ERRONEOUS
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

Status Reason Descr

Description	Indicates the reason for the laboratory test concept status. For example: Ambiguous Duplicate Erroneous
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

Status Txt

Description	Explanation of concept status in narrative text. This field will be Null for ACTIVE concepts, and optionally populated for terms in other status.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

System Cd

Description	Fourth major axis - type of specimen or system (i.e. serum vs.urine).
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

System Code Sk

Description	Fourth major axis - type of specimen or system (i.e. serum vs.urine).
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

System Descr

Description	Fourth major axis - type of specimen or system (i.e. serum vs.urine).
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

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

Time Aspect Cd

Description	Third major axis - timing of the measurement frequency of the laboratory test (i.e. point in time vs.24 hours).
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

Time Aspect Code Sk

Description	Third major axis - timing of the measurement frequency of the laboratory test (i.e. point in time vs.24 hours).
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

Time Aspect Descr

Description	Third major axis - timing of the measurement frequency of the laboratory test (i.e. point in time vs.24 hours).
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

Update Dt

Description	The date the laboratory test details are edited/updated.
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

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

Lab Test Dimension PK

Key Attribute

Lab Test Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model