| Dimensional Warehouse Model Data Model |
| Description | A clinical observation of a patients emergent care. |
| Primary Key | |
 OASIS Medication Snapshot PK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Drug Education Intervention
| Description | Identifies if clinicians instructed the patient/caregiver about how to manage medications effectively and safely. Drug education interventions for M2015 should address all medications the patient is taking – prescribed and over-the-counter – by any route. Effective, safe management of medications includes knowledge of effectiveness, potential side effects and drug reactions, and when to contact the appropriate care provider. This item is used to calculate process measures to capture the agency’s use of best practices following the completion of the comprehensive assessment. The best practices stated in the item are not necessarily required in the Conditions of Participation. |
| 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 |
Drug Regimen Review
| Description | Identifies if a review of the patient’s medications indicated the presence of potential clinically significant problems. This item captures information for calculation of a process measure to identify best practices related to medications. |
| 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 |
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 |
High Risk Drug Education
| Description | Identifies if clinicians instructed the patient and/or caregiver about all high-risk medications the patient takes. High-risk medications are those identified by quality organizations (Institute for Safe Medication Practices, JCAHO, etc.) as having considerable potential for causing significant patient harm when they are used erroneously. This item is targeted to high-risk medications as it may be unrealistic to expect that patient education on all medications occur on admission and failure to provide patient education on high-risk medications such as hypoglycemics and anticoagulants (and others) at SOC/ROC could have severe negative impacts on patient safety and health. This item is used to calculate process measures to capture the agency’s use of best practices following the completion of the comprehensive assessment. The best practices stated in the item are not necessarily required in the Conditions of Participation. |
| 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 |
Injectable Medication Management
| Description | This item is intended to assess the patient’s ability to take all injectable medications reliably and safely at all times. The intent of the item is to identify the patient’s ABILITY, not necessarily actual performance. "Willingness" and "compliance" are not the focus of these items. These items address the patient's ability to safely manage injectable medications, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a wholistic perspective in assessing ability to perform medication management. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited manual dexterity) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision, pain) - environmental barriers (e.g., access to kitchen or medication storage area, stairs, narrow doorways) |
| 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 |
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 |
Medication Follow Up Ind
| Description | Identifies if potential clinically significant problems identified through a medication review were addressed with the physician within one calendar day following identification of medication issue(s). This item is used to calculate process measures to capture the agency’s use of best practices following the completion of the comprehensive assessment. The best practices stated in the item are not necessarily required in the Conditions of Participation. |
| 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 |
Medication Intervention
| Description | Identifies if potential clinically significant problems such as adverse effects or drug reactions identified at the time of the most recent OASIS assessment or after that time were addressed with the physician. This item is used to calculate process measures to capture the agency’s use of best practices following the completion of the comprehensive assessment. The best practices stated in the item are not necessarily required in the Conditions of Participation. |
| 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 |
Oral Medication Management
| Description | This item is intended to identify the patient’s ability to take all oral (p.o.) medications reliably and safely at all times. The intent of the item is to identify the patient’s ABILITY, not necessarily actual performance. "Willingness" and "compliance" are not the focus of these items. These items address the patient's ability to safely take oral medications, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a wholistic perspective in assessing ability to perform medication management. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited manual dexterity) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision, pain) - environmental barriers (e.g., access to kitchen or medication storage area, stairs, narrow doorways) |
| 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 |
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 |
Prior Injectable Medication Management
| Description | This item is intended to assess the patient’s ability to take all injectable medications reliably and safely at all times. The intent of the item is to identify the patient’s ABILITY, not necessarily actual performance. "Willingness" and "compliance" are not the focus of these items. These items address the patient's ability to safely manage injectable medications, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a wholistic perspective in assessing ability to perform medication management. |
| 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 |
Prior Oral Medication Management
| Description | Identifies the patient’s ability to manage all prescribed oral and injectable medications prior to the onset of the current illness, exacerbation of a chronic condition, or injury (whichever is most recent) that initiated this episode of care. The intent of the item is to identify the patient’s prior ABILITY, not necessarily actual performance. "Willingness" and "compliance" are not the focus of these items. This item is used for risk adjustment and can be helpful for setting realistic goals for the 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 |
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 |
| Relationship Details |
OASIS Medication Snapshot_Provider Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Medication 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 Medication Snapshot_Patient Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Medication 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 Medication Snapshot_Encounter Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Medication 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 Medication Snapshot_Practitioner Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Medication 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 Medication Snapshot_Survey Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Medication 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 Medication Snapshot_Point Of Care Location Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Medication 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 Medication Snapshot_Calendar Dimension_FK
| Is Identifying Relationship | true |
| Child Table | OASIS Medication 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 Medication 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 |