Dimensional Warehouse Model Data Model

Entity

Entity OASIS - Discharge Observation Activities Analysis

Description

The Discharge Observation Activities Analysis fact contains aggregations of survey responses from the OASIS Discharge Observations survey, which tracks in what condition patients are discharged from medical facilities. Number of respondents and statistics on the survey submission are also tracked.

The BST is a template with dimensions and measures as examples of how this subject can be approached. From one BST a number of topics can be extracted with appropriate sub-designs.

Attributes
Administered Calendar Dk
Average Survey Admin Duration
Average Survey Completion Time
Encounter Dk
Number Of Adolescent Respondents
Number Of Child Respondents
Number Of Depression Interventions
Number Of Diabetic Foot Care Plans
Number Of Falls Prevention Interventions
Number Of Individuals Surveyed
Number Of Medicaid Respondents
Number Of Medicare Respondents
Number of Pain Prevention Interventions
Number Of Pressure Ulcer Treatment Plans
Number Of Respondents
Number Of Surveys
Number Pressure Ulcer Prevention Interventions
Patient Dk
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Response Calendar Dk
Survey Admin Duration
Survey Completion Time
Survey Dk

Relationship
OASIS - Discharge Observation Activities Analysis_Encounter Dimension_FK
OASIS - Discharge Observation Activities Analysis_Point Of Care Location Dimension_FK
OASIS - Discharge Observation Activities Analysis_Calendar Dimension_FK
OASIS - Discharge Observation Activities Analysis_Calendar Dimension_FK1
OASIS - Discharge Observation Activities Analysis_Patient Dimension_FK
OASIS - Discharge Observation Activities Analysis_Practitioner Dimension_FK
OASIS - Discharge Observation Activities Analysis_Provider Dimension_FK
OASIS - Discharge Observation Activities Analysis_Survey Dimension_FK

Primary Key
OASIS - Discharge Observation Activities Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Administered Calendar 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	false

Average Survey Admin Duration

Description	Average time survey was administered. From start to end time of survey being active. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
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

Average Survey Completion Time

Description	Average time for a respondent to complete the survey. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
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

Encounter 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	false

Number Of Adolescent Respondents

Description	Count of respondents who are adolescents.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Child Respondents

Description	Count of respondents who are children.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Depression Interventions

Description	Identifies the number specific interventions focused on Depression that were both on the physician-ordered home health plan of care AND implemented as part of care provided during the home health care episode (at the time of the previous OASIS assessment or since that time). The physician-ordered plan of care means that the patient condition was discussed and there was agreement as to the plan of care between the home health agency staff and the patient’s physician. This item is used to calculate process measures to capture the use of best practices. The problem-specific interventions referenced in the item may or may not directly correlate to stated requirements in the Conditions of Participation. The formal assessment that is referred to in the last column for rows b – e refers to the assessment defined in OASIS items for M1240, M1300, M1730, and M1910. Depression intervention(s) such as medication, referral for other treatment, or a monitoring plan for current treatment
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Diabetic Foot Care Plans

Description	Identifies number of times specific interventions that focused on Diabetic Foot problems that were both included on the physician-ordered home health plan of care AND implemented as part of care provided during the home health care episode (at the time of the previous OASIS assessment or since that time). The physician-ordered plan of care means that the patient condition was discussed and there was agreement as to the plan of care between the home health agency staff and the patient’s physician. This item is used to calculate process measures to capture the use of best practices. The problem-specific interventions referenced in the item may or may not directly correlate to stated requirements in the Conditions of Participation. The formal assessment that is referred to in the last column for rows b – e refers to the assessment defined in OASIS items for M1240, M1300, M1730, and M1910. Diabetic foot care including monitoring for the presence of skin lesions on the lower extremities and patient/caregiver education on proper foot care
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Falls Prevention Interventions

Description	Identifies if specific interventions focused on Fall Preventions that were both included on the physician-ordered home health plan of care AND implemented as part of care provided during the home health care episode (at the time of the previous OASIS assessment or since that time). The physician-ordered plan of care means that the patient condition was discussed and there was agreement as to the plan of care between the home health agency staff and the patient’s physician. This item is used to calculate process measures to capture the use of best practices. The problem-specific interventions referenced in the item may or may not directly correlate to stated requirements in the Conditions of Participation. The formal assessment that is referred to in the last column for rows b – e refers to the assessment defined in OASIS items for M1240, M1300, M1730, and M1910. Falls prevention interventions
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Individuals Surveyed

Description	Count of individuals surveyed.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Medicaid Respondents

Description	Count of respondents classified as Medicaid recipients.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Medicare Respondents

Description	Count of respondents classified as Medicare recipients.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number of Pain Prevention Interventions

Description	Identifies the number of specific interventions focused on Pain Prevention that were both included on the physician-ordered home health plan of care AND implemented as part of care provided during the home health care episode (at the time of the previous OASIS assessment or since that time). The physician-ordered plan of care means that the patient condition was discussed and there was agreement as to the plan of care between the home health agency staff and the patient’s physician. This item is used to calculate process measures to capture the use of best practices. The problem-specific interventions referenced in the item may or may not directly correlate to stated requirements in the Conditions of Participation. The formal assessment that is referred to in the last column for rows b – e refers to the assessment defined in OASIS items for M1240, M1300, M1730, and M1910. Intervention(s) to monitor and mitigate pain
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Pressure Ulcer Treatment Plans

Description	Identifies the number of specific interventions focused on Pressure Ulcer Tratments that were both included on the physician-ordered home health plan of care AND implemented as part of care provided during the home health care episode (at the time of the previous OASIS assessment or since that time). The physician-ordered plan of care means that the patient condition was discussed and there was agreement as to the plan of care between the home health agency staff and the patient’s physician. This item is used to calculate process measures to capture the use of best practices. The problem-specific interventions referenced in the item may or may not directly correlate to stated requirements in the Conditions of Participation. The formal assessment that is referred to in the last column for rows b – e refers to the assessment defined in OASIS items for M1240, M1300, M1730, and M1910. Pressure ulcer treatment based on principles of moist wound healing
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Respondents

Description	Count of individuals responding to the survey.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Surveys

Description	Count of surveys.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Pressure Ulcer Prevention Interventions

Description	Identifies the number of specific interventions focused on Pressure Ulcer Prevention that were both included on the physician-ordered home health plan of care AND implemented as part of care provided during the home health care episode (at the time of the previous OASIS assessment or since that time). The physician-ordered plan of care means that the patient condition was discussed and there was agreement as to the plan of care between the home health agency staff and the patient’s physician. This item is used to calculate process measures to capture the use of best practices. The problem-specific interventions referenced in the item may or may not directly correlate to stated requirements in the Conditions of Participation. The formal assessment that is referred to in the last column for rows b – e refers to the assessment defined in OASIS items for M1240, M1300, M1730, and M1910. Intervention(s) to prevent pressure ulcers
Data Type	Standards - Data Domains.ddm/Data Domains/Count [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	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Point Of Care Location 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	false

Practitioner 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	false

Provider 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	false

Response Calendar 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	false

Survey Admin Duration

Description	Total time (in minutes) survey was administered. From start to end time of survey being active.
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

Survey Completion Time

Description	Total time for a respondent to complete the survey.
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

Survey 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	false

Relationship Details

OASIS - Discharge Observation Activities Analysis_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Discharge Observation Activities Analysis
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	Encounter Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Discharge Observation Activities Analysis_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Discharge Observation Activities Analysis
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	Point Of Care Location Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Discharge Observation Activities Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Discharge Observation Activities Analysis
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	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Discharge Observation Activities Analysis_Calendar Dimension_FK1

Is Identifying Relationship	true
Child Table	OASIS - Discharge Observation Activities Analysis
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	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Discharge Observation Activities Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Discharge Observation Activities Analysis
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

OASIS - Discharge Observation Activities Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Discharge Observation Activities Analysis
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	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Discharge Observation Activities Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Discharge Observation Activities Analysis
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	Provider Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Discharge Observation Activities Analysis_Survey Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Discharge Observation Activities Analysis
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	Survey 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

OASIS - Discharge Observation Activities Analysis PK

Key Attribute	Provider Dk
Key Attribute	Patient Dk
Key Attribute	Encounter Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Practitioner Dk
Key Attribute	Administered Calendar Dk
Key Attribute	Response Calendar Dk
Key Attribute	Survey Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model