Dimensional Warehouse Model Data Model

Entity

Entity Unfavorable Event Dimension

Description

An occurrence that causes or has the potential to cause destruction, injury, deterioration or other damage to persons or objects.

Attributes
Accident Cause Cd
Accident Cause Code Descr
Accident Cause Code Sk
Accident Event Descr
Accident Event Nm
Accident Occurrence Dt
Adverse Drug Event Cause Cd
Adverse Drug Event Cause Code Descr
Adverse Drug Event Cause Code Sk
AWM Load Info Sk
Catastrophe Ind
Current Ind
Disturbance Event Descr
Disturbance Event Nm
Disturbance Event Occurrence Dt
Disturbance Type Cd
Disturbance Type Code Descr
Disturbance Type Code Sk
Duration Unit Cd
Duration Unit Code Descr
Duration Unit Code Sk
DWM Load Info Sk
Effective From Dt
Effective To Dt
Exposure Duration
Health Risk Exposure Type Cd
Health Risk Exposure Type Code Descr
Health Risk Exposure Type Code Sk
Medical Error Reason Cd
Medical Error Reason Code Descr
Medical Error Reason Code Sk
Medical Error Severity Cd
Medical Error Severity Code Descr
Medical Error Severity Code Sk
Medical Error Type Cd
Medical Error Type Code Descr
Medical Error Type Code Sk
Medication Error Index Rating Cd
Medication Error Index Rating Code Descr
Medication Error Index Rating Code Sk
Occurrence Dt
Patient Safety Incident Descr
Patient Safety Incident Nm
Patient Safety Incident Occurrence Dt
Patient Safety Incident Type Cd
Patient Safety Incident Type Code Descr
Patient Safety Incident Type Code Sk
Rain Fall
Richter Scale
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Type Cd
Type Code Descr
Type Code Sk
Type of Accident Location Cd
Type of Accident Location Code Descr
Type of Accident Location Code Sk
Unfavorable Event Descr
Unfavorable Event Dimension Bk
Unfavorable Event Dimension Dk
Unfavorable Event Dimension Sk
Unfavorable Event Nm
Valid From Ts
Valid To Ts
Wind Speed

Primary Key
Unfavorable Event Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Accident Cause Cd

Description	Indicates the unexpected and unforeseen cause of an accident. The 'means' that caused the mishap must be accidental in order to claim benefits under a policy. Therefore, also referred to as 'accidental means'.
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

Accident Cause Code Descr

Description	Indicates the unexpected and unforeseen cause of an accident. The 'means' that caused the mishap must be accidental in order to claim benefits under a policy. Therefore, also referred to as 'accidental means'.
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

Accident Cause Code Sk

Description	Indicates the unexpected and unforeseen cause of an accident. The 'means' that caused the mishap must be accidental in order to claim benefits under a policy. Therefore, also referred to as 'accidental means'.
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

Accident Event Descr

Description	The textual representation of information about an occurrence of Accident event.
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

Accident Event Nm

Description	The word or phrase identifying an occurrence of Accident event.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Accident Occurrence Dt

Description	The date at which the Accident event is considered as having occurred.
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

Adverse Drug Event Cause Cd

Description	Indicates the reason for the occurrence of the adverse drug event.
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

Adverse Drug Event Cause Code Descr

Description	Indicates the reason for the occurrence of the adverse drug event.
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

Adverse Drug Event Cause Code Sk

Description	Indicates the reason for the occurrence of the adverse drug event.
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

Catastrophe Ind

Description	Indicates whether or not an unfavorable event has been designated as a natural phenomenon catastrophe by a government or authorities. For example: The United States Federal Emergency Management Authority (FEMA) designated the Red River Valley Flood of 1997 as a catastrophe.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
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

Disturbance Event Descr

Description	The textual representation of information about an occurrence of Disturbance event.
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

Disturbance Event Nm

Description	The word or phrase identifying an occurrence of Disturbance event.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Disturbance Event Occurrence Dt

Description	The date at which the Disturbance event is considered as having occurred.
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

Disturbance Type Cd

Description	Indicates the type of disturbance events according to their inherent nature.
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

Disturbance Type Code Descr

Description	Indicates the type of disturbance events according to their inherent nature.
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

Disturbance Type Code Sk

Description	Indicates the type of disturbance events according to their inherent nature.
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

Duration Unit Cd

Description	Indicates the unit of measure for the exposure duration. For example minutes hours days
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

Duration Unit Code Descr

Description	Indicates the unit of measure for the exposure duration. For example minutes hours days
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

Duration Unit Code Sk

Description	Indicates the unit of measure for the exposure duration. For example minutes hours days
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

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

Exposure Duration

Description	The length of time the person was exposed to the health risk.
Data Type	Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Health Risk Exposure Type Cd

Description	Indicates the type of health risk exposure according to the nature of the substance or environmental factor involved.
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

Health Risk Exposure Type Code Descr

Description	Indicates the type of health risk exposure according to the nature of the substance or environmental factor involved.
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

Health Risk Exposure Type Code Sk

Description	Indicates the type of health risk exposure according to the nature of the substance or environmental factor involved.
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

Medical Error Reason Cd

Description	Indicates the primary reason why the medical error event occurred.
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

Medical Error Reason Code Descr

Description	Indicates the primary reason why the medical error event occurred.
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

Medical Error Reason Code Sk

Description	Indicates the primary reason why the medical error event occurred.
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

Medical Error Severity Cd

Description	Describes the level of seriousness of medical error and the degree of harm caused to the patient.
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

Medical Error Severity Code Descr

Description	Describes the level of seriousness of medical error and the degree of harm caused to the patient.
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

Medical Error Severity Code Sk

Description	Describes the level of seriousness of medical error and the degree of harm caused to the patient.
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

Medical Error Type Cd

Description	Indicates the type of medical error events according to their inherent nature.
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

Medical Error Type Code Descr

Description	Indicates the type of medical error events according to their inherent nature.
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

Medical Error Type Code Sk

Description	Indicates the type of medical error events according to their inherent nature.
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

Medication Error Index Rating Cd

Description	Categorization of the severity of a medication error event, defined in the US by the National Coordinating Council for Medication Error Reporting and Prevention (NCC MERP).
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

Medication Error Index Rating Code Descr

Description	Categorization of the severity of a medication error event, defined in the US by the National Coordinating Council for Medication Error Reporting and Prevention (NCC MERP).
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

Medication Error Index Rating Code Sk

Description	Categorization of the severity of a medication error event, defined in the US by the National Coordinating Council for Medication Error Reporting and Prevention (NCC MERP).
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

Occurrence Dt

Description	The date upon which the unfavorable event has occurred.
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

Patient Safety Incident Descr

Description	The textual representation of information about an occurrence of Patient Safety Incident.
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

Patient Safety Incident Nm

Description	The word or phrase identifying an occurrence of Patient Safety Incident.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Safety Incident Occurrence Dt

Description	The date at which the Patient Safety Incident is considered as having occurred.
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

Patient Safety Incident Type Cd

Description	Indicates the type of patient safety incidents according to their inherent nature.
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

Patient Safety Incident Type Code Descr

Description	Indicates the type of patient safety incidents according to their inherent nature.
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

Patient Safety Incident Type Code Sk

Description	Indicates the type of patient safety incidents according to their inherent nature.
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

Rain Fall

Description	Indicates the magnitude of rainfall. For example: 5cm of rain fell in South Wales during the storm on the night of 5 November 1996.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Richter Scale

Description	Indicates the value on the Richter scale. For example: The earthquake in San Francisco in 1906 measured 8.3 on the Richter scale.
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

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

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	The code that corresponds to the Type 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

Type Code Descr

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

Type Code Sk

Description	The code identifying the actual type of the entity as per the type hierarchy defined in the analysis data model.
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 of Accident Location Cd

Description	Indicates the type of location where accident occurred. For example: Farm Outdoors Public street Residence Work
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

Type of Accident Location Code Descr

Description	Indicates the type of location where accident occurred. For example: Farm Outdoors Public street Residence Work
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

Type of Accident Location Code Sk

Description	Indicates the type of location where accident occurred. For example: Farm Outdoors Public street Residence Work
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

Unfavorable Event Descr

Description	The textual representation of information about an occurrence of unfavorable event.
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

Unfavorable Event Dimension 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

Unfavorable Event Dimension 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

Unfavorable Event Dimension 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

Unfavorable Event Nm

Description	The word or phrase identifying an occurrence of unfavorable event.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
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

Wind Speed

Description	Indicates the wind speed at the time of the natural phenomenon. For example: The highest wind speed was recorded on Mount Washington New Hampshire USA on the 12 April 1934 and measured 231 miles per hour (371 Km/h).
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Primary Key Details

Unfavorable Event Dimension PK

Key Attribute

Unfavorable Event Dimension Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model