Dimensional Warehouse Model Data Model

Entity

Entity OASIS Daily Living Activities Snapshot

Description

A clinical observation of the patients daily living and assisted living activities.

Attributes
Ambulation Ability Cd
Bathing Ability Cd
Dress Lower Body Ability Cd
Dress Upper Body Ability Cd
Encounter Dk
Fall Risk Assessment Cd
Grooming Ability Cd
Load Info Sk
Medicaid Ind
Medicare Ind
Patient Dk
Plan And Prepare Light Meals Ability Cd
Point Of Care Location Dk
Practitioner Dk
Prior Ambulation Ability Cd
Prior Household Tasks Ability Cd
Prior Self Care Ability Cd
Prior Transfer Ability Cd
Provider Dk
Self Feeding Ability Cd
Survey Date Dk
Survey Dk
Telephone Usage Ability Cd
Tenant Sk
Toilet Hygiene Ability Cd
Toilet Transferring Ability Cd
Transferring Ability Cd

Relationship
OASIS Daily Living Activities Snapshot_Provider Dimension_FK
OASIS Daily Living Activities Snapshot_Patient Dimension_FK
OASIS Daily Living Activities Snapshot_Encounter Dimension_FK
OASIS Daily Living Activities Snapshot_Practitioner Dimension_FK
OASIS Daily Living Activities Snapshot_Survey Dimension_FK
OASIS Daily Living Activities Snapshot_Point Of Care Location Dimension_FK
OASIS Daily Living Activities Snapshot_Calendar Dimension_FK

Primary Key
OASIS Daily Living Activities Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Ambulation Ability Cd

Description	Identifies the patient’s ability and the type of assistance required to safely ambulate or propel self in a wheelchair over a variety of surfaces. 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 ambulate/locomote, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a holistic perspective in assessing ability to perform ADLs. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited range of motion, impaired balance) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision or pain) - environmental barriers (e.g., stairs, narrow doorways, location of bathroom or laundry)
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

Bathing Ability Cd

Description	Identifies the patient’s ability to bathe entire body and the assistance that may be required to safely bathe, including transferring in/out of the tub/shower. 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 bathe, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a holistic perspective in assessing ability to perform ADLs. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited range of motion, impaired balance) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision or pain) - environmental barriers (e.g., stairs, narrow doorways, location of bathroom or laundry)
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

Dress Lower Body Ability Cd

Description	Identifies the patient’s ability to dress lower body, including the ability to obtain, put on and remove lower body clothing. Assess ability to put on whatever clothing is routinely worn. 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 dress the lower body, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a holistic perspective in assessing ability to perform ADLs. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited range of motion, impaired balance) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision or pain) - environmental barriers (e.g., stairs, narrow doorways, location of bathroom or laundry)
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

Dress Upper Body Ability Cd

Description	dentifies the patient’s ability to dress upper body, including the ability to obtain, put on and remove upper body clothing. Assess ability to put on whatever clothing is routinely worn. This specifically includes the ability to manage zippers, buttons, and snaps if these are routinely worn. 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 dress the upper body, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a holistic perspective in assessing ability to perform ADLs. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited range of motion, impaired balance) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision or pain) - environmental barriers (e.g., stairs, narrow doorways, location of bathroom or laundry)
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

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

Fall Risk Assessment Cd

Description	Identifies whether the home health agency has assessed the patient and home environment for characteristics that place the patient at risk for falls. Patients under the age of 65 will be excluded from the denominator of the publicly reported measure. The multi-factor falls risk assessment must include at least one standardized tool that 1) has been scientifically tested in a population with characteristics similar to that of the patient being assessed (for example, community-dwelling elders, noninstitutionalized adults with disabilities, etc.) and shown to be effective in identifying people at risk for falls; and 2) includes a standard response scale. The standardized tool must be both appropriate for the patient based on their cognitive and physical status and appropriately administered as indicated in the instructions. 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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Grooming Ability Cd

Description	Identifies the patient’s ability to tend to personal hygiene needs, excluding bathing, shampooing hair, and toileting hygiene. 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 perform grooming, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a holistic perspective in assessing ability to perform ADLs. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited range of motion, impaired balance) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision or pain) - environmental barriers (e.g., accessing grooming aids, mirror and sink).
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

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

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

Plan And Prepare Light Meals Ability Cd

Description	Identifies the patient’s physical, cognitive, and mental ability to plan and prepare meals, even if the patient does not routinely perform this task. 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 perform light meal planning and preparation, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a holistic perspective in assessing ability to perform IADLs. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited range of motion, impaired balance) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision, pain) - environmental barriers (e.g., stairs, narrow doorways)
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

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 Ambulation Ability Cd

Description	Identifies the patient’s functional ability 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. Prior Functioning Activities of Daily Living/Instrumental Activities of Daily Living: Indicate the patient’s usual ability with everyday activities prior to this current illness, exacerbation, or injury. Check only one box in each row. Ambulation
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

Prior Household Tasks Ability Cd

Description	Identifies the patient’s functional ability 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. Prior Functioning Activities of Daily Living/Instrumental Activities of Daily Living: Indicate the patient’s usual ability with everyday activities prior to this current illness, exacerbation, or injury. Check only one box in each row. Household tasks (e.g., light meal preparation, laundry, shopping )
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

Prior Self Care Ability Cd

Description	Identifies the patient’s functional ability 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. Prior Functioning Activities of Daily Living/Instrumental Activities of Daily Living: Indicate the patient’s usual ability with everyday activities prior to this current illness, exacerbation, or injury. Check only one box in each row. Self-Care (e.g., grooming, dressing, and bathing)
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

Prior Transfer Ability Cd

Description	Identifies the patient’s functional ability 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. Prior Functioning Activities of Daily Living/Instrumental Activities of Daily Living: Indicate the patient’s usual ability with everyday activities prior to this current illness, exacerbation, or injury. Check only one box in each row. Transfer
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

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

Self Feeding Ability Cd

Description	Identifies the patient’s ability to feed him/herself, including the process of eating, chewing, and swallowing food. 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 self-feed, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a holistic perspective in assessing ability to perform ADLs. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited range of motion, impaired balance) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision or hearing, pain) - environmental barriers (e.g., stairs, narrow doorways, location of bathroom or laundry)
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

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

Telephone Usage Ability Cd

Description	Identifies the ability of the patient to answer the phone, dial number, and effectively use the telephone to communicate. 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 use the telephone, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a holistic perspective in assessing ability to perform IADLs. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited range of motion, impaired balance) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision or hearing, pain) - environmental barriers (e.g., stairs, narrow doorways)
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

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

Toilet Hygiene Ability Cd

Description	Identifies the patient’s ability to manage personal hygiene and clothing when toileting. 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 perform toileting hygiene, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a holistic perspective in assessing ability to perform ADLs. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited range of motion, impaired balance) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision or pain) - environmental barriers (e.g., stairs, narrow doorways, location of bathroom or laundry)
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

Toilet Transferring Ability Cd

Description	Identifies the patient’s ability to safely get to and from and transfer on and off the toilet or bedside commode. 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 perform toilet transferring, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a holistic perspective in assessing ability to perform ADLs. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited range of motion, impaired balance) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision or pain) - environmental barriers (e.g., stairs, narrow doorways, location of bathroom)
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

Transferring Ability Cd

Description	Identifies the patient’s ability to safely transfer from bed to chair (and chair to bed), or position self in bed if bedfast. 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 transfer, given the current physical and mental/emotional/cognitive status, activities permitted, and environment. The patient must be viewed from a holistic perspective in assessing ability to perform ADLs. Ability can be temporarily or permanently limited by: - physical impairments (e.g., limited range of motion, impaired balance) - emotional/cognitive/behavioral impairments (e.g., memory deficits, impaired judgment, fear) - sensory impairments, (e.g., impaired vision or pain) - environmental barriers (e.g., stairs, narrow doorways, location of bathroom or laundry)
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

Relationship Details

OASIS Daily Living Activities Snapshot_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Daily Living Activities 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 Daily Living Activities Snapshot_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Daily Living Activities 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 Daily Living Activities Snapshot_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Daily Living Activities 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 Daily Living Activities Snapshot_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Daily Living Activities 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 Daily Living Activities Snapshot_Survey Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Daily Living Activities 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 Daily Living Activities Snapshot_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Daily Living Activities 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 Daily Living Activities Snapshot_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Daily Living Activities 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 Daily Living Activities 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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model