Dimensional Warehouse Model Data Model

Entity

Entity Diagnosis Event Dimension

Description

A medical determination of disease or syndrome established by a practitioner. The focus is on the disease process and the physical, genetic, or environmental cause of that process. There are various types of diagnosis, for example, admitting, primary, etc. In some instances, there could be multiple diagnoses. There could also be additional attribution when the diagnosis code does not provide sufficient information for a billing system.

Attributes
Acceptance Reason Cd
Acceptance Reason Code Descr
Acceptance Reason Code Sk
Accepted Dt
Accepted Ind
Alternate Diagnosis Cd
AWM Load Info Sk
Confidential Ind
Current Ind
Derived Ind
Diagnosis Cd
Diagnosis Classification Cd
Diagnosis Classification Code Sk
Diagnosis Classification Descr
Diagnosis Descr
Diagnosis Event Dk
Diagnosis Event Sk
Diagnosis Identifier Num
Diagnosis Ts
Diagnosis Type Cd
Diagnosis Type Code Sk
Diagnosis Type Descr
DWM Load Info Sk
Effective From Dt
Effective To Dt
Exempt Ind
Patient Dk
Present On Admission Cd
Present On Admission Code Sk
Present On Admission Descr
Previous C Section Ind
Set Id Num
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Translated Diagnosis Cd
Translated Diagnosis Code Descr
Translated Diagnosis Code Set Cd
Translated Diagnosis Code Set Code Descr
Translated Diagnosis Code Set Code Sk
Translated Diagnosis Code Sk
Translation Dt
Translation Rule Applied Cd
Translation Rule Applied Code Descr
Translation Rule Applied Code Sk
Valid From Ts
Valid To Ts

Relationship
Diagnosis Event Dimension_Patient Dimension_FK

Primary Key
Diagnosis Event Dimension PK

Dependencies

Reverse Dependencies

Alternate Keys
Diagnosis Code AK

Attribute Details

Acceptance Reason Cd

Description	Indicates the reason for accepting this diagnosis.
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

Acceptance Reason Code Descr

Description	Indicates the reason for accepting this diagnosis.
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

Acceptance Reason Code Sk

Description	Indicates the reason for accepting this diagnosis.
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

Accepted Dt

Description	The date upon which the diagnosis was accepted or approved.
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

Accepted Ind

Description	Indicates whether or not the diagnosis has been accepted by the modeled organization.
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

Alternate Diagnosis Cd

Description	An alternative code that also uniquely identifies a diagnosis code within a domain.
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

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

Confidential Ind

Description	Indicates whether the diagnosis is confidential.
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

Derived Ind

Description	Indicates whether the diagnosis code was submitted or derived.
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

Diagnosis Cd

Description	Specifies the diagnosis and identifies the disease or patient condition. Diagnosis codes generally comply to the International Classification of Diseases code system. ICD-9 CM or ICD-10 codes would typically be used.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Diagnosis Classification Cd

Description	Indicates whether the patient information is for a diagnosis or a non-diagnosis code. For example: Consultation Diagnosis Medication Sign Symptom
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

Diagnosis Classification Code Sk

Description	Indicates whether the patient information is for a diagnosis or a non-diagnosis code. For example: Consultation Diagnosis Medication Sign Symptom
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

Diagnosis Classification Descr

Description	Indicates whether the patient information is for a diagnosis or a non-diagnosis code. For example: Consultation Diagnosis Medication Sign Symptom
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

Diagnosis Descr

Description	A textual description associated with the diagnosis code.
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

Diagnosis Event 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

Diagnosis Event 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 [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Diagnosis Identifier Num

Description	Identifies a single diagnosis for an encounter. It is unique across all segments and messages for an encounter.
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

Diagnosis Ts

Description	The date and time that the diagnosis was determined.
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

Diagnosis Type Cd

Description	Indicates the type of diagnosis. For example: Admitting 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

Diagnosis Type Code Sk

Description	Indicates the type of diagnosis. For example: Admitting 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

Diagnosis Type Descr

Description	Indicates the type of diagnosis. For example: Admitting 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

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

Exempt Ind

Description	Identifies code as being exempt from Hospital Acquired Condition processing.
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

Patient 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

Present On Admission Cd

Description	Indicates that a given diagnosis was made at the time of the patient's admission to a healthcare facility or that the diagnosis related to a condition already known upon admission.
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

Present On Admission Code Sk

Description	Indicates that a given diagnosis was made at the time of the patient's admission to a healthcare facility or that the diagnosis related to a condition already known upon admission.
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

Present On Admission Descr

Description	Indicates that a given diagnosis was made at the time of the patient's admission to a healthcare facility or that the diagnosis related to a condition already known upon admission.
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

Previous C Section Ind

Description	Indicates whether a patient has previously had a cesarean section.
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

Set Id Num

Description	This is an anchor entity that anchors one or more detail entities. Relationships in AWM are created between anchor entities using associative entities.
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

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

Translated Diagnosis Cd

Description	A code indicating the disease diagnosis based on a diagnosis code set. The translated code relates to a code allocated to the diagnosis other than the one supplied. Translated codes may be used to maintain consistency or to facilitate migration from one code set to another.
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

Translated Diagnosis Code Descr

Description	A code indicating the disease diagnosis based on a diagnosis code set. The translated code relates to a code allocated to the diagnosis other than the one supplied. Translated codes may be used to maintain consistency or to facilitate migration from one code set to another.
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

Translated Diagnosis Code Set Cd

Description	A code indicating the diagnostic code set, standard or source used for the translated diagnosis code. For example: ICD-10 ICD-9
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

Translated Diagnosis Code Set Code Descr

Description	A code indicating the diagnostic code set, standard or source used for the translated diagnosis code. For example: ICD-10 ICD-9
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

Translated Diagnosis Code Set Code Sk

Description	A code indicating the diagnostic code set, standard or source used for the translated diagnosis code. For example: ICD-10 ICD-9
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

Translated Diagnosis Code Sk

Description	A code indicating the disease diagnosis based on a diagnosis code set. The translated code relates to a code allocated to the diagnosis other than the one supplied. Translated codes may be used to maintain consistency or to facilitate migration from one code set to another.
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

Translation Dt

Description	The date upon which the translation was performed.
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

Translation Rule Applied Cd

Description	The business rule used to perform the translation.
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

Translation Rule Applied Code Descr

Description	The business rule used to perform the translation.
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

Translation Rule Applied Code Sk

Description	The business rule used to perform the translation.
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

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

Diagnosis Event Dimension_Patient Dimension_FK

Is Identifying Relationship	false
Child Table	Diagnosis Event 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	Patient 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

Diagnosis Event Dimension PK

Key Attribute

Diagnosis Event Dk

Alternate Key Details

Diagnosis Code AK

Key Attribute	Diagnosis Event Sk
Key Attribute	Valid From Ts
Key Attribute	Current Ind

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model