Dimensional Warehouse Model Data Model

Entity

Entity OASIS - Daily Living Activities Analysis

Description

The Daily Living fact contains aggregations of survey responses from the OASIS C Daily Living survey, which tracks how well patients can care for themselves day to day. Number of respondents and statistics on the survey submission are also tracked.

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

Attributes
Administered Calendar Dk
Average Survey Admin Duration
Average Survey Completion Time
Encounter Dk
Fall Risk Assessed Count
Number Needing Assistance To Bathe
Number Of Adolescent Respondents
Number Of Ambulatory Patients
Number Of Child Respondents
Number Of Individuals Surveyed
Number Of Medicaid Respondents
Number Of Medicare Respondents
Number Of Prior Able To Bed Transfer
Number Of Prior Able To Do Household Tasks
Number Of Prior Ambulatory Patient
Number Of Respondents
Number Of Surveys
Number Unable To Bathe
Number Unable To Bed Transfer
Number Unable To Dress Lower Body
Number Unable To Dress Upper Body
Number Unable To Groom
Number Unable To Manage Toilet Hygiene
Number Unable To Plan And Prepare Light Meals
Number Unable To Self Feed
Number Unable To Transfer To Toilet
Number Unable To Use Telephone
Number With Prior Inability To Self Care
Patient Dk
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Response Calendar Dk
Survey Admin Duration
Survey Completion Time
Survey Dk

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

Primary Key
OASIS - Daily Living Activities Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Administered Calendar Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Average Survey Admin Duration

Description	Average time survey was administered. From start to end time of survey being active. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Survey Completion Time

Description	Average time for a respondent to complete the survey. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Encounter Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Fall Risk Assessed Count

Description	Identifies then number of patients given the Fall Risk Assessment (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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Needing Assistance To Bathe

Description	Identifies the number of patients who need assistance to bathe or transfer 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/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 Ambulatory Patients

Description	Identifies the number of patients able 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/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 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 Prior Able To Bed Transfer

Description	Identifies the number of patients functionally able to safely transfer from bed to chair (and chair to bed), or position self in bed if bedfast 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Prior Able To Do Household Tasks

Description	Identifies the number of patients functional able to perform household tasks 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Prior Ambulatory Patient

Description	Identifies the number of patients functionally able to ambulate on thier own 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/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 Unable To Bathe

Description	Identifies the number of patients unable to bathe entire body. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Unable To Bed Transfer

Description	Identifies the number of patients able 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Unable To Dress Lower Body

Description	Identifies the number of patients unable 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Unable To Dress Upper Body

Description	Identifies the number of patients unable 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Unable To Groom

Description	Identifies the number of patient’s unable to tend to personal hygiene needs, excluding bathing, shampooing hair, and toileting hygiene. The intent of the item is to count 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Unable To Manage Toilet Hygiene

Description	Identifies the number of patients unable 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Unable To Plan And Prepare Light Meals

Description	Identifies the number of patients ability to plan and prepare meals due to physical, cognitive, and mental issues, 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Unable To Self Feed

Description	Identifies the number of patients unable 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Unable To Transfer To Toilet

Description	Identifies the number of patients unable 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Unable To Use Telephone

Description	Identifies the number of patients unable 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number With Prior Inability To Self Care

Description	Identifies the number of patients functionally unable to care for themselves 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/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 - Daily Living Activities Analysis_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Daily Living Activities Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Encounter Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Daily Living Activities Analysis_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Daily Living Activities Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Point Of Care Location Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Daily Living Activities Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Daily Living Activities Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Daily Living Activities Analysis_Calendar Dimension_FK1

Is Identifying Relationship	true
Child Table	OASIS - Daily Living Activities Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Daily Living Activities Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Daily Living Activities Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Daily Living Activities Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Daily Living Activities Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Daily Living Activities Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Daily Living Activities Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Provider Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

OASIS - Daily Living Activities Analysis_Survey Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Daily Living Activities Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Survey Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

OASIS - Daily Living Activities Analysis PK

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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model