Dimensional Warehouse Model Data Model

Entity

Entity Device Alert Array

Description

A message sent by a point of care device that is used to communicate an alarm condition, for example, low battery, low IV level, and so on.

Attributes
Alert Severity Cd
Alert Severity Code Sk
AWM Load Info Sk
Current Ind
Device Alert Sk
DWM Load Info Sk
Effective From Dt
Effective To Dt
Finding Comparative Operator Symbol Nm
Finding End Ts
Finding Identifier Cd
Finding Identifier Code Sk
Finding Language Cd
Finding Language Code Sk
Finding Observation Method Cd
Finding Observation Method Code Sk
Finding Occurred Ts
Finding Producing System Cd
Finding Producing System Code Sk
Finding Producing System Nm
Finding Reference Range Effective Ts
Finding Reference Range Txt
Finding Reported Ts
Finding Result Status Cd
Finding Result Status Code Sk
Finding Result Status Ts
Finding Sub Identifier Num
Finding Unit Cd
Finding Unit Code Sk
Finding Value Qty
Finding Value Txt
Finding Value Type Cd
Finding Value Type Code Sk
Finding Value UOM Cd
Finding Value UOM Code Sk
Point Of Care Device Dk
Priority Seq
Source Cd
Source Code Sk
Tenant Sk
Type Cd
Type Code Sk
Valid From Ts
Valid To Ts

Relationship
Device Alert Array_Point Of Care Device Dimension_FK

Primary Key
Device Alert Array PK

Dependencies

Reverse Dependencies

Attribute Details

Alert Severity Cd

Description	Code identifying the severity of the alert. For Example: Normal Warning Serious Critical
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

Alert Severity Code Sk

Description	Code identifying the severity of the alert. For Example: Normal Warning Serious Critical
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

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

Device Alert 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

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

Finding Comparative Operator Symbol Nm

Description	Identifies the name of the finding comparative operator symbol for the clinical finding. For example: Greater than is Equals is = Less that is
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Finding End Ts

Description	The date and time that a timed observation or test was completed. For example: Glucose Tolerance test is a series of blood glucose tests. Samples of blood are taken before the test begins and every 30 to 60 minutes after the person has drank a glucose drink. The last blood sample is considered the finding end timestamp.
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

Finding Identifier Cd

Description	A unique identifier for the finding that has been generated by the application system for the submitting organization. It is an external identifier and has not been created internally.
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

Finding Identifier Code Sk

Description	A unique identifier for the finding that has been generated by the application system for the submitting organization. It is an external identifier and has not been created internally.
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

Finding Language Cd

Description	Indicates the language used to describe the finding.
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

Finding Language Code Sk

Description	Indicates the language used to describe the finding.
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

Finding Observation Method Cd

Description	An acronym or abbreviation name for the technique or procedure used to obtain the Clinical Finding. This is normally used to indicate that a different method than the standard method was used for the clinical finding.
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

Finding Observation Method Code Sk

Description	An acronym or abbreviation name for the technique or procedure used to obtain the Clinical Finding. This is normally used to indicate that a different method than the standard method was used for the clinical finding.
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

Finding Occurred Ts

Description	The date and time when the clinical finding was observed or performed.
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

Finding Producing System Cd

Description	Identifies the system responsible for producing the clinical finding. This may name an internal hospital system or an outside laboratory. In the United States the Medicare number for the producing system is the suggested identifier.
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

Finding Producing System Code Sk

Description	Identifies the system responsible for producing the clinical finding. This may name an internal hospital system or an outside laboratory. In the United States the Medicare number for the producing system is the suggested identifier.
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

Finding Producing System Nm

Description	Identifies the system responsible for producing the clinical finding. This may name an internal hospital system or an outside laboratory. In the United States the Medicare number for the producing system is the suggested identifier.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Finding Reference Range Effective Ts

Description	The date upon which a reference range for a finding using a point care device is to be observed from.
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

Finding Reference Range Txt

Description	Reference ranges are a set of values used to interpret clinical findings. The values would include the upper and lower limits for a specific clinical finding. For example: Potassium has a reference range of 3.5 - 5.2 mmols/L which means a potassium level above 5.2 mmols/l would be considered high. If the finding quantifies a toxic substance, the upper limit identifies the toxic limit. If the finding measures a drug, then the range represents the lower and upper therapeutic bounds.
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

Finding Reported Ts

Description	The date and time the clinical findings were officially recorded.
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

Finding Result Status Cd

Description	Indicates the current condition of the clinical finding result. For example: Interim Final
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

Finding Result Status Code Sk

Description	Indicates the current condition of the clinical finding result. For example: Interim Final
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

Finding Result Status Ts

Description	The date and time the clinical finding result status was recorded.
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

Finding Sub Identifier Num

Description	A unique identifier for the Finding that has been generated to distinguish between the multiple findings for one clinical order detail. It is a number generated externally by a laboratory application system.
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

Finding Unit Cd

Description	Identifies the Point of Care Location responsible for the clinical finding. For Example: Hematology Radiology Microbiology
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

Finding Unit Code Sk

Description	Identifies the Point of Care Location responsible for the clinical finding. For Example: Hematology Radiology Microbiology
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

Finding Value Qty

Description	The numeric version of the Finding Value Text.
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

Finding Value Txt

Description	A description of the clinical finding result. The field may contain the exact scientific result or it may contain the normal/abnormal state of the test, i.e. quantitative or qualitative results. The field may contain a single or multi-part answer.
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

Finding Value Type Cd

Description	Indicates the type of data that is contained within the clinical finding value. For example: Numerical Textual Images Recorded Signals
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

Finding Value Type Code Sk

Description	Indicates the type of data that is contained within the clinical finding value. For example: Numerical Textual Images Recorded Signals
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

Finding Value UOM Cd

Description	The unit of measure in which the finding value quantity is expressed. For Example: mmol= millimole kg = kilogram mcg = microgram iu= international units
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

Finding Value UOM Code Sk

Description	The unit of measure in which the finding value quantity is expressed. For Example: mmol= millimole kg = kilogram mcg = microgram iu= international units
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

Point Of Care Device 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	false

Priority Seq

Description	Indicates the relative order or importance of this row in the set of alerts.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Cd

Description	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/Tenant Common Code [VARCHAR(80)]
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

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

Type Cd

Description	Code identifying the actual type of the entity as per the type hierarchy defined in the business data model.
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

Type Code Sk

Description	Code identifying the actual type of the entity as per the type hierarchy defined in the business data model.
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

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

Device Alert Array_Point Of Care Device Dimension_FK

Is Identifying Relationship	true
Child Table	Device Alert Array
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	Point Of Care Device Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Device Alert Array PK

Key Attribute	Point Of Care Device Dk
Key Attribute	Valid From Ts
Key Attribute	Type Code Sk
Key Attribute	Priority Seq

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model