Dimensional Warehouse Model Data Model

Entity

Entity Diagnosis Related Group Dimension

Description

A code that is used to determine specific reimbursement fees based on the personal medical condition of a patient.

Attributes
Arithmetic Average Length Of Stay
AWM Load Info Sk
Coding System Version Dk
Current Ind
Diagnosis Related Group Dk
Diagnosis Related Group Sk
DRG Cd
DRG Code Descr
DRG Qualifier Cd
DRG Qualifier Code Descr
DRG Qualifier Code Sk
DRG Type Cd
DRG Type Code Descr
DRG Type Code Sk
DWM Load Info Sk
Effective From Dt
Effective To Dt
Geometric Average Length Of Stay
Illness Severity Class Cd
Illness Severity Class Code Descr
Illness Severity Class Code Sk
Major Diagnostic Category Cd
Major Diagnostic Category Code Descr
Major Diagnostic Category Code Sk
Mortality Risk Class Cd
Mortality Risk Class Code Descr
Mortality Risk Class Code Sk
Relative Weighting Factor
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Diagnosis Related Group Dimension_Coding System Version Dimension_FK

Primary Key
Diagnosis Related Group Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Arithmetic Average Length Of Stay

Description	A key statistical component in calculating the total amount paid to hospital per DRG and weighting factor.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
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

Coding System Version 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

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

Diagnosis Related Group 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 Related Group 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

DRG Cd

Description	The number or code used to identify the Diagnosis Related Group.
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

DRG Code Descr

Description	A free-text statement used to explain the meaning of the Diagnosis Related Group.
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

DRG Qualifier Cd

Description	Indicates the type of diagnosis related group (DRG) code.
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

DRG Qualifier Code Descr

Description	Indicates the type of diagnosis related group (DRG) 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

DRG Qualifier Code Sk

Description	Indicates the type of diagnosis related group (DRG) code.
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

DRG Type Cd

Description	The type of the Diagnosis Related Group. For example: Medical Surgical
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

DRG Type Code Descr

Description	The type of the Diagnosis Related Group. For example: Medical Surgical
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

DRG Type Code Sk

Description	The type of the Diagnosis Related Group. For example: Medical Surgical
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

Geometric Average Length Of Stay

Description	A key statistical component in calculating the total amount paid to hospital per DRG and weighting factor that uses a more complex formula to minimize the impact of outliers in the length of stay data set for all patients in a particular DRG.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Illness Severity Class Cd

Description	The level of illness severity for the Diagnosis Related Group. Specifies a subclass of a DRG. For example: 1 - Minor 2 - Moderate 3 - Major 4 - Extreme
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

Illness Severity Class Code Descr

Description	The level of illness severity for the Diagnosis Related Group. Specifies a subclass of a DRG. For example: 1 - Minor 2 - Moderate 3 - Major 4 - Extreme
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

Illness Severity Class Code Sk

Description	The level of illness severity for the Diagnosis Related Group. Specifies a subclass of a DRG. For example: 1 - Minor 2 - Moderate 3 - Major 4 - Extreme
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

Major Diagnostic Category Cd

Description	Identifies the Major Diagnostic Category (MDC) to which the Diagnosis Related Group is assigned.
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

Major Diagnostic Category Code Descr

Description	Identifies the Major Diagnostic Category (MDC) to which the Diagnosis Related Group is assigned.
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

Major Diagnostic Category Code Sk

Description	Identifies the Major Diagnostic Category (MDC) to which the Diagnosis Related Group is assigned.
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

Mortality Risk Class Cd

Description	The level of Mortality Risk for the Diagnosis Related Group. Specifies a subclass of a DRG. For example: 1 - Minor 2 - Moderate 3 - Major 4 - Extreme
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

Mortality Risk Class Code Descr

Description	The level of Mortality Risk for the Diagnosis Related Group. Specifies a subclass of a DRG. For example: 1 - Minor 2 - Moderate 3 - Major 4 - Extreme
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

Mortality Risk Class Code Sk

Description	The level of Mortality Risk for the Diagnosis Related Group. Specifies a subclass of a DRG. For example: 1 - Minor 2 - Moderate 3 - Major 4 - Extreme
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

Relative Weighting Factor

Description	Reflects the relative resource consumption associated with treating a patient whose diagnosis is classified as a specific DRG.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
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

Is Identifying Relationship	false
Child Table	Diagnosis Related Group 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	Coding System Version 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 Related Group Dimension PK

Key Attribute

Diagnosis Related Group Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model