Entity Unfavorable Event Fact

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

Attributes
Accident Cause CdAccident Cause Cd
Accident Cause Code SkAccident Cause Code Sk
Accident Event DescrAccident Event Descr
Accident Event NmAccident Event Nm
Accident Occurrence DtAccident Occurrence Dt
Adverse Drug Event Cause CdAdverse Drug Event Cause Cd
Adverse Drug Event Cause Code SkAdverse Drug Event Cause Code Sk
AWM Load Info SkAWM Load Info Sk
Catastrophe IndCatastrophe Ind
Current IndCurrent Ind
Disturbance Event DescrDisturbance Event Descr
Disturbance Event NmDisturbance Event Nm
Disturbance Event Occurrence DtDisturbance Event Occurrence Dt
Disturbance Type CdDisturbance Type Cd
Disturbance Type Code SkDisturbance Type Code Sk
Duration Unit CdDuration Unit Cd
Duration Unit Code SkDuration Unit Code Sk
DWM Load Info SkDWM Load Info Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Exposure DurationExposure Duration
Health Risk Exposure Type CdHealth Risk Exposure Type Cd
Health Risk Exposure Type Code SkHealth Risk Exposure Type Code Sk
Medical Error Reason CdMedical Error Reason Cd
Medical Error Reason Code SkMedical Error Reason Code Sk
Medical Error Severity CdMedical Error Severity Cd
Medical Error Severity Code SkMedical Error Severity Code Sk
Medical Error Type CdMedical Error Type Cd
Medical Error Type Code SkMedical Error Type Code Sk
Medication DkMedication Dk
Medication Error Index Rating CdMedication Error Index Rating Cd
Medication Error Index Rating Code SkMedication Error Index Rating Code Sk
Medication SkMedication Sk
Occurrence DtOccurrence Dt
Patient DkPatient Dk
Patient Safety Incident DescrPatient Safety Incident Descr
Patient Safety Incident NmPatient Safety Incident Nm
Patient Safety Incident Occurrence DtPatient Safety Incident Occurrence Dt
Patient Safety Incident Type CdPatient Safety Incident Type Cd
Patient Safety Incident Type Code SkPatient Safety Incident Type Code Sk
Patient SkPatient Sk
Person DkPerson Dk
Person SkPerson Sk
Pharmacy Order Dispense DkPharmacy Order Dispense Dk
Pharmacy Order Dispense SkPharmacy Order Dispense Sk
Point Of Care Location DkPoint Of Care Location Dk
Point Of Care Location SkPoint Of Care Location Sk
Provider DkProvider Dk
Provider SkProvider Sk
Rain FallRain Fall
Richter ScaleRichter Scale
Source CdSource Cd
Source Code SkSource Code Sk
Tenant SkTenant Sk
Type CdType Cd
Type Code SkType Code Sk
Type of Accident Location CdType of Accident Location Cd
Type of Accident Location Code SkType of Accident Location Code Sk
Unfavorable Event CntUnfavorable Event Cnt
Unfavorable Event DescrUnfavorable Event Descr
Unfavorable Event Dimension DkUnfavorable Event Dimension Dk
Unfavorable Event Dimension SkUnfavorable Event Dimension Sk
Unfavorable Event Fact BkUnfavorable Event Fact Bk
Unfavorable Event Fact DkUnfavorable Event Fact Dk
Unfavorable Event Fact SkUnfavorable Event Fact Sk
Unfavorable Event NmUnfavorable Event Nm
Valid From TsValid From Ts
Valid To TsValid To Ts
Wind SpeedWind Speed

Relationship
Unfavorable Event Fact_Point Of Care Location Dimension_FKUnfavorable Event Fact_Point Of Care Location Dimension_FK
Unfavorable Event Fact_Patient Dimension_FKUnfavorable Event Fact_Patient Dimension_FK
Unfavorable Event Fact_Person Dimension_FKUnfavorable Event Fact_Person Dimension_FK
Unfavorable Event Fact_Medication Dimension_FKUnfavorable Event Fact_Medication Dimension_FK
Unfavorable Event Fact_Pharmacy Order Dispense Dimension_FKUnfavorable Event Fact_Pharmacy Order Dispense Dimension_FK
Unfavorable Event Fact_Provider Dimension_FKUnfavorable Event Fact_Provider Dimension_FK
Unfavorable Event Fact_Unfavorable Event Dimension_FKUnfavorable Event Fact_Unfavorable Event Dimension_FK

Primary Key
Unfavorable Event Fact PKUnfavorable Event Fact PK

Dependencies
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Reverse Dependencies
 

Attribute Details

 Accident Cause Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accident Cause Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accident Event Descr
DescriptionThe textual representation of information about an occurrence of Accident event.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accident Event Nm
DescriptionThe word or phrase identifying an occurrence of Accident event.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accident Occurrence Dt
DescriptionThe date at which the Accident event is considered as having occurred.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Adverse Drug Event Cause Cd
DescriptionIndicates the reason for the occurrence of the adverse drug event.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Adverse Drug Event Cause Code Sk
DescriptionIndicates the reason for the occurrence of the adverse drug event.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 AWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Catastrophe Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Current Ind
DescriptionSet to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Disturbance Event Descr
DescriptionThe textual representation of information about an occurrence of Disturbance event.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Disturbance Event Nm
DescriptionThe word or phrase identifying an occurrence of Disturbance event.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Disturbance Event Occurrence Dt
DescriptionThe date at which the Disturbance event is considered as having occurred.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Disturbance Type Cd
DescriptionIndicates the type of disturbance events according to their inherent nature.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Disturbance Type Code Sk
DescriptionIndicates the type of disturbance events according to their inherent nature.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Duration Unit Cd
DescriptionIndicates the unit of measure for the exposure duration.

For example
minutes
hours
days
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Duration Unit Code Sk
DescriptionIndicates the unit of measure for the exposure duration.

For example
minutes
hours
days
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 DWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Exposure Duration
DescriptionThe length of time the person was exposed to the health risk.
Data TypeStandards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Health Risk Exposure Type Cd
DescriptionIndicates the type of health risk exposure according to the nature of the substance or environmental factor involved.

Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Health Risk Exposure Type Code Sk
DescriptionIndicates the type of health risk exposure according to the nature of the substance or environmental factor involved.

Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medical Error Reason Cd
DescriptionIndicates the primary reason why the medical error event occurred.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medical Error Reason Code Sk
DescriptionIndicates the primary reason why the medical error event occurred.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medical Error Severity Cd
DescriptionDescribes the level of seriousness of medical error and the degree of harm caused to the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medical Error Severity Code Sk
DescriptionDescribes the level of seriousness of medical error and the degree of harm caused to the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medical Error Type Cd
DescriptionIndicates the type of medical error events according to their inherent nature.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medical Error Type Code Sk
DescriptionIndicates the type of medical error events according to their inherent nature.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medication Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Medication Error Index Rating Cd
DescriptionCategorization 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medication Error Index Rating Code Sk
DescriptionCategorization 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medication Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Occurrence Dt
DescriptionThe date upon which the unfavorable event has occurred.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Safety Incident Descr
DescriptionThe textual representation of information about an occurrence of Patient Safety Incident.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Safety Incident Nm
DescriptionThe word or phrase identifying an occurrence of Patient Safety Incident.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Safety Incident Occurrence Dt
DescriptionThe date at which the Patient Safety Incident is considered as having occurred.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Safety Incident Type Cd
DescriptionIndicates the type of patient safety incidents according to their inherent nature.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Safety Incident Type Code Sk
DescriptionIndicates the type of patient safety incidents according to their inherent nature.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Person Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Person Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Pharmacy Order Dispense Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Pharmacy Order Dispense Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Point Of Care Location Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Point Of Care Location Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Rain Fall
DescriptionIndicates the magnitude of rainfall.

For example:
5cm of rain fell in South Wales during the storm on the night of 5 November 1996.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Richter Scale
DescriptionIndicates the value on the Richter scale.

For example:
The earthquake in San Francisco in 1906 measured 8.3 on the Richter scale.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Cd
DescriptionThe code that corresponds to the Source Code Sk.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type Cd
DescriptionCode identifying the actual type of the entity as per the type hierarchy defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type Code Sk
DescriptionCode identifying the actual type of the entity as per the type hierarchy defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type of Accident Location Cd
DescriptionIndicates the type of location where accident occurred.

For example:
Farm
Outdoors
Public street
Residence
Work
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Type of Accident Location Code Sk
DescriptionIndicates the type of location where accident occurred.

For example:
Farm
Outdoors
Public street
Residence
Work
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Unfavorable Event Cnt
DescriptionUsed to count fact rows. Always set to 1.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Default Value1
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Unfavorable Event Descr
DescriptionThe textual representation of information about an occurrence of unfavorable event.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Unfavorable Event Dimension Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Unfavorable Event Dimension Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Unfavorable Event Fact Bk
DescriptionConcatenated values of a set of business attributes that uniquely identify the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Unfavorable Event Fact Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keytrue



 Unfavorable Event Fact Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Unfavorable Event Nm
DescriptionThe word or phrase identifying an occurrence of unfavorable event.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes 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 TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Wind Speed
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Unfavorable Event Fact_Point Of Care Location Dimension_FK
Is Identifying Relationshipfalse
Child TableUnfavorable Event Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePoint Of Care Location Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Unfavorable Event Fact_Patient Dimension_FK
Is Identifying Relationshipfalse
Child TableUnfavorable Event Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Unfavorable Event Fact_Person Dimension_FK
Is Identifying Relationshipfalse
Child TableUnfavorable Event Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePerson Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Unfavorable Event Fact_Medication Dimension_FK
Is Identifying Relationshipfalse
Child TableUnfavorable Event Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableMedication Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Unfavorable Event Fact_Pharmacy Order Dispense Dimension_FK
Is Identifying Relationshipfalse
Child TableUnfavorable Event Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePharmacy Order Dispense Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Unfavorable Event Fact_Provider Dimension_FK
Is Identifying Relationshipfalse
Child TableUnfavorable Event Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProvider Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Unfavorable Event Fact_Unfavorable Event Dimension_FK
Is Identifying Relationshipfalse
Child TableUnfavorable Event Fact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableUnfavorable Event Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Unfavorable Event Fact PK
Key AttributeUnfavorable Event Fact Dk