Dimensional Warehouse Model Data Model

Entity

Entity Goal Dimension

Description

An objective that is to be achieved as a consequence of healthcare interventions applied to a patient.

For example:
Mobilize patient
Reduce pain
Restart dietary intake

Attributes
AWM Load Info Sk
Current Goal Review Status Cd
Current Goal Review Status Code Sk
Current Goal Review Status Descr
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Episode of Care Num
Goal Bk
Goal Cd
Goal Classification Cd
Goal Classification Code Sk
Goal Classification Descr
Goal Code Sk
Goal Descr
Goal Dk
Goal Evaluation Cd
Goal Evaluation Code Sk
Goal Evaluation Descr
Goal Instance Num
Goal Life Cycle Status Cd
Goal Life Cycle Status Code Sk
Goal Life Cycle Status Descr
Goal List Priority Num
Goal Management Discipline Cd
Goal Management Discipline Code Sk
Goal Management Discipline Descr
Goal Review Interval Num
Goal Sk
Goal Target Type Cd
Goal Target Type Code Sk
Goal Target Type Descr
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Primary Key
Goal Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

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 Goal Review Status Cd

Label	Current Goal Review Status Cd
Description	Indicates the current point in the continuum of a goal review cycle. For example: Due Initiated Reviewed Overdue Verified
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

Current Goal Review Status Code Sk

Description	Indicates the current point in the continuum of a goal review cycle. For example: Due Initiated Reviewed Overdue Verified
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

Current Goal Review Status Descr

Label	Current Goal Review Status Cd
Description	Indicates the current point in the continuum of a goal review cycle. For example: Due Initiated Reviewed Overdue Verified
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

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

Episode of Care Num

Label	Episode of Care Num
Description	Identifies the episode of care to which this goal applies.
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

Goal 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	true
Is Derived	false
Is Surrogate Key	false

Goal Cd

Label	Goal Cd
Description	Indicates the code listed in institution's master list of goals.
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

Goal Classification Cd

Label	Goal Classification Cd
Description	Indicates the type of goal. This can be used to categorize goals 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

Goal Classification Code Sk

Description	Indicates the type of goal. This can be used to categorize goals 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

Goal Classification Descr

Label	Goal Classification Cd
Description	Indicates the type of goal. This can be used to categorize goals 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

Goal Code Sk

Description	Indicates the code listed in institution's master list of goals.
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

Goal Descr

Label	Goal Cd
Description	Indicates the code listed in institution's master list of goals.
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

Goal 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

Goal Evaluation Cd

Label	Goal Evaluation Cd
Description	Indicates the progress towards achievement of the goal. For example: Achieved Ahead of schedule Delayed Failed to achieve
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

Goal Evaluation Code Sk

Label	Goal Evaluation Cd
Description	Indicates the progress towards achievement of the goal. For example: Achieved Ahead of schedule Delayed Failed to achieve
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

Goal Evaluation Descr

Label	Goal Evaluation Cd
Description	Indicates the progress towards achievement of the goal. For example: Achieved Ahead of schedule Delayed Failed to achieve
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

Goal Instance Num

Label	Goal Instance Num
Description	Identifies the instance of the goal assigned by an initiating system.
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

Goal Life Cycle Status Cd

Label	Goal Life Cycle Status Cd
Description	Indicates the status of the goal. For example: Active Canceled Inactive Suspended
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

Goal Life Cycle Status Code Sk

Label	Goal Life Cycle Status Cd
Description	Indicates the status of the goal. For example: Active Canceled Inactive Suspended
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

Goal Life Cycle Status Descr

Label	Goal Life Cycle Status Cd
Description	Indicates the status of the goal. For example: Active Canceled Inactive Suspended
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

Goal List Priority Num

Label	Goal List Priority
Description	Indicates the importance of the goal on the goal's list maintained for an individual.
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

Goal Management Discipline Cd

Label	Goal Management Discipline Cd
Description	Indicates the of caregiver with responsibility for managing this specific goal. For example: Care team Nursing Medicine Respiratory therapy Occupational therapy Dietary
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

Goal Management Discipline Code Sk

Label	Goal Management Discipline Cd
Description	Indicates the of caregiver with responsibility for managing this specific goal. For example: Care team Nursing Medicine Respiratory therapy Occupational therapy Dietary
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

Goal Management Discipline Descr

Label	Goal Management Discipline Cd
Description	Indicates the of caregiver with responsibility for managing this specific goal. For example: Care team Nursing Medicine Respiratory therapy Occupational therapy Dietary
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

Goal Review Interval Num

Label	Goal Review Interval
Description	Indicates the interval used to calculate the next goal review date.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Goal 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

Goal Target Type Cd

Label	Goal Target Type Cd
Description	Indicates the type of individual/group for whom the goal has been established. For example: Family group Family member 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

Goal Target Type Code Sk

Label	Goal Target Type Cd
Description	Indicates the type of individual/group for whom the goal has been established. For example: Family group Family member 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

Goal Target Type Descr

Label	Goal Target Type Cd
Description	Indicates the type of individual/group for whom the goal has been established. For example: Family group Family member 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

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

Primary Key Details

Goal Dimension PK

Key Attribute

Goal Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model