| Dimensional Warehouse Model Data Model |
| Description | A clinical observation of a patients discharge state and the preparations made for them before discharge. |
| Primary Key | |
 OASIS Discharge Analysis Snapshot PK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Death Dt
| Description | Identifies the actual date of death (at home), depending on the reason for assessment. |
| 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 |
Depression Intervention
| Description | Identifies if specific interventions focused on specific problems 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. 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/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Diabetic Foot Care Plan
| Description | Identifies if specific interventions focused on specific problems 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/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Discharge Disposition
| Description | Identifies where the patient resides after discharge from the home health agency. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Discharge Dt
| Description | Identifies the actual date of discharge depending on the reason for assessment. |
| 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 |
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 |
Falls Prevention Intervention
| Description | Identifies if specific interventions focused on specific problems 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/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Inpatient Admission Facility Type
| Description | Identifies the type of inpatient facility to which the patient was admitted. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Last Home Visit Dt
| Description | Identifies the last or most recent home visit by any agency provider that is included on the Plan of Care. |
| 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 |
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 |
Medicaid Ind
| Description | Indicator if respondent is classified as Medicaid recipient. |
| 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 |
Medicare Ind
| Description | Indicator if respondent is classified as Medicare recipient. |
| 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 |
Pain Prevention Intervention
| Description | Identifies if specific interventions focused on specific problems 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/Text Medium [VARCHAR(255)] |
| 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 |
Pressure Ulcer Prevention Intervention
| Description | Identifies if specific interventions focused on specific problems 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/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pressure Ulcer Treatment Plan
| Description | Identifies if specific interventions focused on specific problems 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/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 |
Survey Date 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 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 |
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 |
Transfer Dt
| Description | Identifies the actual date of transfer depending on the reason for assessment. |
| 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 |
| Relationship Details |
OASIS Discharge Analysis Snapshot_Provider Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Discharge Analysis Snapshot |
| 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 Analysis Snapshot_Patient Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Discharge Analysis Snapshot |
| 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 Analysis Snapshot_Encounter Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Discharge Analysis Snapshot |
| 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 Analysis Snapshot_Practitioner Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Discharge Analysis Snapshot |
| 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 Analysis Snapshot_Survey Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Discharge Analysis Snapshot |
| 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 |
OASIS Discharge Analysis Snapshot_Point Of Care Location Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Discharge Analysis Snapshot |
| 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 Analysis Snapshot_Calendar Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Discharge Analysis Snapshot |
| Child Multiplicity | ZERO_TO_ONE |
| 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 |
| Primary Key Details |
OASIS Discharge Analysis Snapshot PK
| Key Attribute | Provider Dk |
| Key Attribute | Patient Dk |
| Key Attribute | Encounter Dk |
| Key Attribute | Practitioner Dk |
| Key Attribute | Survey Dk |
| Key Attribute | Point Of Care Location Dk |
| Key Attribute | Survey Date Dk |
| Dimensional Warehouse Model Data Model |