Dimensional Warehouse Model Data Model

Entity

Entity OASIS - Medication Observation Analysis

Description

Counts of clinical observations of patient medications.

Attributes
Administered Calendar Dk
Average Survey Admin Duration
Average Survey Completion Time
Encounter Dk
Number Able To Take Injectable Medication
Number Able To Take Injectable Medication With Reminder
Number Able To Take Oral Medication
Number Able To Take Oral Medication After Reminder
Number Able To Take Prepared Injectable Medication
Number Able To Take Prepared Oral Medication
Number Not Able To Take Oral Medication
Number Not On Oral Medication
Number Not Taking Injectable Medication
Number Of Adolescent Respondents
Number Of Child Respondents
Number Of Drug Education Interventions
Number Of Drug Regimen Review Issues Found
Number Of High Risk Drug Educations
Number Of Individuals Surveyed
Number Of Medicaid Respondents
Number Of Medicare Respondents
Number Of Medication Interventions
Number Of Medication Issue Follow Ups
Number Of Respondents
Number Of Surveys
Number Previously Able To Take Injectable Medication
Number Previously Able To Take Injectable Medication With Reminder
Number Previously Able To Take Oral Medication
Number Previously Able To Take Oral Medication After Reminder
Number Previously Able To Take Prepared Injectable Medication
Number Previously Able To Take Prepared Oral Medication
Number Previously Not Able To Take Oral Medication
Number Previously Not On Oral Medication
Number Previously Not Taking Injectable Medication
Number Previously Unable To Take Injectable Medication
Number Unable To Take Injectable Medication
Patient Dk
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Response Calendar Dk
Survey Admin Duration
Survey Completion Time
Survey Dk

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

Primary Key
OASIS - Medication Observation 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 Able To Take Injectable Medication

Description	The number of patients able to independently take the correct medication(s) and proper dosage(s) at the correct 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Able To Take Injectable Medication With Reminder

Description	The number of patients able to take medication(s) at the correct times if given reminders by another person based on the frequency of the injection. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Able To Take Oral Medication

Description	Number of patients in the respondent population able to take oral medicaitons independently. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Able To Take Oral Medication After Reminder

Description	Number of patients in the respondent population able to take medication(s) at the correct times if given reminders by another person at the appropriate times 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Able To Take Prepared Injectable Medication

Description	The number of patients able to take injectable medication(s) at the correct times if: (a) individual syringes are prepared in advance by another person; OR (b) another person develops a drug diary or chart 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Able To Take Prepared Oral Medication

Description	Number of patients in the respondent population able to take oral medication(s) at the correct times if: (a) individual dosages are prepared in advance by another person; OR (b) another person develops a drug diary or chart.. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Not Able To Take Oral Medication

Description	Number of patients in the respondent population unable to take medication unless administered by another person. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Not On Oral Medication

Description	Number of patients in the respondent population not on oral medications 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Not Taking Injectable Medication

Description	The number of patients to whom no injectable medications are prescribed.. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
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 Drug Education Interventions

Description	Identifies number of times 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.
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 Drug Regimen Review Issues Found

Description	Number of Clinically significant problems found in a respondent population. Identified in OASIS Drug Regimen Review Code 0 - Not assessed/reviewed 1 - No problems found during review 2 - Problems found during review NA - Patient is not taking any medications
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 High Risk Drug Educations

Description	Identifies number of times 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.
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 Medication Interventions

Description	Identifies number of 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.
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 Medication Issue Follow Ups

Description	Identifies number of potential clinically significant problems identified through a medication review were addressed with the physician within one calendar day following identification of medication issue(s).
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 Previously Able To Take Injectable Medication

Description	The number of patients able to independently take the correct medication(s) and proper dosage(s) at the correct 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Previously Able To Take Injectable Medication With Reminder

Description	The number of patients able to take medication(s) at the correct times if given reminders by another person based on the frequency of the injection. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Previously Able To Take Oral Medication

Description	Number of patients in the respondent population able to take oral medicaitons independently. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Previously Able To Take Oral Medication After Reminder

Description	Number of patients in the respondent population able to take medication(s) at the correct times if given reminders by another person at the appropriate times 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Previously Able To Take Prepared Injectable Medication

Description	The number of patients able to take injectable medication(s) at the correct times if: (a) individual syringes are prepared in advance by another person; OR (b) another person develops a drug diary or chart 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Previously Able To Take Prepared Oral Medication

Description	Number of patients in the respondent population able to take oral medication(s) at the correct times if: (a) individual dosages are prepared in advance by another person; OR (b) another person develops a drug diary or chart.. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Previously Not Able To Take Oral Medication

Description	Number of patients in the respondent population unable to take medication unless administered by another person. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Previously Not On Oral Medication

Description	Number of patients in the respondent population not on oral medications 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Previously Not Taking Injectable Medication

Description	The number of patients to whom no injectable medications are prescribed.. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Previously Unable To Take Injectable Medication

Description	The number of patients nable to take injectable medication unless administered by another person. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Unable To Take Injectable Medication

Description	The number of patients nable to take injectable medication unless administered by another person. 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/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 - Medication Observation Analysis_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Medication Observation 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 - Medication Observation Analysis_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Medication Observation 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 - Medication Observation Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Medication Observation 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 - Medication Observation Analysis_Calendar Dimension_FK1

Is Identifying Relationship	true
Child Table	OASIS - Medication Observation 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 - Medication Observation Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Medication Observation 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 - Medication Observation Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Medication Observation 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 - Medication Observation Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Medication Observation 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 - Medication Observation Analysis_Survey Dimension_FK

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