Dimensional Warehouse Model Data Model

Entity

Entity Patient Problem Dimension

Description

The health issues that are reported by a patient observed by a practitioner or determined via empirical evidence such as a lab test result or radiology exam.

For example:
Dizziness
Reduced mobility
Loss of appetite

Attributes
Actual Problem Resolution Ts
Anticipated Problem Resolution Ts
AWM Load Info Sk
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Patient Problem Bk
Patient Problem Dk
Patient Problem Num
Patient Problem Sk
Problem Awareness Family Cd
Problem Awareness Family Code Sk
Problem Awareness Family Descr
Problem Certainty Cd
Problem Certainty Code Sk
Problem Certainty Descr
Problem Classification Cd
Problem Classification Code Sk
Problem Classification Descr
Problem Code Dk
Problem Code Txt
Problem Confirmation Status Cd
Problem Confirmation Status Code Sk
Problem Confirmation Status Descr
Problem Individual Awareness Cd
Problem Individual Awareness Code Sk
Problem Individual Awareness Descr
Problem Life Cycle Status Cd
Problem Life Cycle Status Code Sk
Problem Life Cycle Status Descr
Problem Onset Txt
Problem Persistence Cd
Problem Persistence Code Sk
Problem Persistence Descr
Problem Prognosis Cd
Problem Prognosis Code Sk
Problem Prognosis Descr
Problem Sensitivity Cd
Problem Sensitivity Code Sk
Problem Sensitivity Descr
Prognosis Awareness Individual Cd
Prognosis Awareness Individual Code Sk
Prognosis Awareness Individual Descr
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Patient Problem Dimension_Problem Code Dimension_FK

Primary Key
Patient Problem Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Actual Problem Resolution Ts

Description	The date and time upon which the problem was actually resolved.
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

Anticipated Problem Resolution Ts

Description	The estimated date and time for resolving the stated problem.
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

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

Patient Problem 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 Large [VARCHAR(500)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Problem 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

Patient Problem Num

Description	Identifies a record of a patient problem within the source system environment.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Patient Problem 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

Problem Awareness Family Cd

Description	Identifies the individual's family or significant other's comprehension of the actual problem/prognosis. For example: Full Marginal Partial
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

Problem Awareness Family Code Sk

Description	Identifies the individual's family or significant other's comprehension of the actual problem/prognosis. For example: Full Marginal Partial
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

Problem Awareness Family Descr

Description	Identifies the individual's family or significant other's comprehension of the actual problem/prognosis. For example: Full Marginal Partial
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

Problem Certainty Cd

Description	Identifies the qualitative representation of the certainty of a problem. For example: HI - high LO - low ME - medium
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

Problem Certainty Code Sk

Description	Identifies the qualitative representation of the certainty of a problem. For example: HI - high LO - low ME - medium
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

Problem Certainty Descr

Description	Identifies the qualitative representation of the certainty of a problem. For example: HI - high LO - low ME - medium
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

Problem Classification Cd

Description	Identifies the type of problem.This can be used to categorize problems so that they may be managed and viewed independently within different applications. For example: Admission Final Post-operative Pre-operative Outpatient Discharge
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

Problem Classification Code Sk

Description	Identifies the type of problem.This can be used to categorize problems so that they may be managed and viewed independently within different applications. For example: Admission Final Post-operative Pre-operative Outpatient Discharge
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

Problem Classification Descr

Description	Identifies the type of problem.This can be used to categorize problems so that they may be managed and viewed independently within different applications. For example: Admission Final Post-operative Pre-operative Outpatient Discharge
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

Problem 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

Problem Code Txt

Description	Identifies a problem or disorder faced by a person. For example: Diabetes High Blood Pressure
Data Type	Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Problem Confirmation Status Cd

Description	Identifies the verification status of a problem. For example: Confirmed Differential Provisional Rule-out
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

Problem Confirmation Status Code Sk

Description	Identifies the verification status of a problem. For example: Confirmed Differential Provisional Rule-out
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

Problem Confirmation Status Descr

Description	Identifies the verification status of a problem. For example: Confirmed Differential Provisional Rule-out
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

Problem Individual Awareness Cd

Description	Identifies the individual's comprehension of the problem. For example: Full Marginal Partial
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

Problem Individual Awareness Code Sk

Description	Identifies the individual's comprehension of the problem. For example: Full Marginal Partial
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

Problem Individual Awareness Descr

Description	Identifies the individual's comprehension of the problem. For example: Full Marginal Partial
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

Problem Life Cycle Status Cd

Description	Identifies the current status of the problem. For example: Active Active-improving Active-stable Active-worsening Inactive Resolved
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

Problem Life Cycle Status Code Sk

Description	Identifies the current status of the problem. For example: Active Active-improving Active-stable Active-worsening Inactive Resolved
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

Problem Life Cycle Status Descr

Description	Identifies the current status of the problem. For example: Active Active-improving Active-stable Active-worsening Inactive Resolved
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

Problem Onset Txt

Description	A place to describe and annotate more details about the patient's problem when the problem began.
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

Problem Persistence Cd

Description	Identifies the perseverance of an individual's problem. For example: Acute Chronic
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

Problem Persistence Code Sk

Description	Identifies the perseverance of an individual's problem. For example: Acute Chronic
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

Problem Persistence Descr

Description	Identifies the perseverance of an individual's problem. For example: Acute Chronic
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

Problem Prognosis Cd

Description	Identifies the prognosis for the individual's problem. For example: Good 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

Problem Prognosis Code Sk

Description	Identifies the prognosis for the individual's problem. For example: Good 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

Problem Prognosis Descr

Description	Identifies the prognosis for the individual's problem. For example: Good Poor
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

Problem Sensitivity Cd

Description	Identifies the level of security and/or sensitivity surrounding the problem. For example: Highly sensitive Not sensitive Sensitive
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

Problem Sensitivity Code Sk

Description	Identifies the level of security and/or sensitivity surrounding the problem. For example: Highly sensitive Not sensitive Sensitive
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

Problem Sensitivity Descr

Description	Identifies the level of security and/or sensitivity surrounding the problem. For example: Highly sensitive Not sensitive Sensitive
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

Prognosis Awareness Individual Cd

Description	Identifies the individual's comprehension of the prognosis for the problem. For example: Full Marginal Partial
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

Prognosis Awareness Individual Code Sk

Description	Identifies the individual's comprehension of the prognosis for the problem. For example: Full Marginal Partial
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

Prognosis Awareness Individual Descr

Description	Identifies the individual's comprehension of the prognosis for the problem. For example: Full Marginal Partial
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

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

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

Relationship Details

Patient Problem Dimension_Problem Code Dimension_FK

Is Identifying Relationship	false
Child Table	Patient Problem Dimension
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	Problem Code 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

Patient Problem Dimension PK

Key Attribute

Patient Problem Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model