Dimensional Warehouse Model Data Model

Entity

Entity OASIS Neuro Status Snapshot

Description

A clinical observation of the patients integumentary or skin system status.

Attributes
Cognitive Functioning
Depression Depressed
Depression Interest
Depression Screening Ind
Disruptive Behavior Frequency
Encounter Dk
Load Info Sk
Medicaid Ind
Medicare Ind
Patient Dk
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Receiving Psychiatric Nursing Services Ind
State Of Anxiety
State Of Confusion
Survey Date Dk
Survey Dk
Symptom Disruptive Behavior Ind
Symptom Impaired Decision Making Ind
Symptom Inappropriate Behavior Ind
Symptom Memory Deficit Ind
Symptom None Demonstrated Ind
Symptom Physical Aggression Ind
Symptom Verbal Disruption Ind
Tenant Sk

Relationship
OASIS Neuro Status Snapshot_Provider Dimension_FK
OASIS Neuro Status Snapshot_Patient Dimension_FK
OASIS Neuro Status Snapshot_Encounter Dimension_FK
OASIS Neuro Status Snapshot_Practitioner Dimension_FK
OASIS Neuro Status Snapshot_Survey Dimension_FK
OASIS Neuro Status Snapshot_Point Of Care Location Dimension_FK
OASIS Neuro Status Snapshot_Calendar Dimension_FK

Primary Key
OASIS Neuro Status Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Cognitive Functioning

Description	Identifies the patient’s current (at the time of the assessment and in the preceding 24 hours) level of cognitive functioning, including alertness, orientation, comprehension, concentration, and immediate memory for simple commands.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Depression Depressed

Description	Identifies if the home health agency screened the patient for depression using a standardized depression screening tool. CMS does not mandate that clinicians conduct depression screening for all patients, nor is there a mandate for the use of the PHQ-2© or any other particular standardized tool. 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. Feeling down, depressed, or hopeless?
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Depression Interest

Description	Identifies if the home health agency screened the patient for depression using a standardized depression screening tool. CMS does not mandate that clinicians conduct depression screening for all patients, nor is there a mandate for the use of the PHQ-2© or any other particular standardized tool. 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. Little interest or pleasure in doing things
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Depression Screening Ind

Description	Identifies if the home health agency screened the patient for depression using a standardized depression screening tool. CMS does not mandate that clinicians conduct depression screening for all patients, nor is there a mandate for the use of the PHQ-2© or any other particular standardized tool. This item is used to calculate process measures to capture the agency’s use of best practices following the completion of the comprehensive assessment. The best practices stated in the item are not necessarily required in the Conditions of Participation.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Disruptive Behavior Frequency

Description	Identifies frequency of any behaviors that are disruptive or dangerous to the patient or the caregivers.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Encounter Dk

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

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

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

Receiving Psychiatric Nursing Services Ind

Description	Identifies whether the patient is receiving psychiatric nursing services at home as provided by a qualified psychiatric nurse. “Psychiatric nursing services” address mental/emotional needs; a “qualified psychiatric nurse” is so qualified through educational preparation, certification, or experience.
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

State Of Anxiety

Description	Identifies the frequency with which the patient has felt anxious within the past 14 days.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

State Of Confusion

Description	Identifies the time of day or situations when the patient experienced confusion, if at all.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Symptom Disruptive Behavior Ind

Description	Identifies specific behaviors associated with significant neurological, developmental, behavioral or psychiatric disorders. Disruptive, infantile, or socially inappropriate behavior (excludes verbal actions)
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

Symptom Impaired Decision Making Ind

Description	Identifies specific behaviors associated with significant neurological, developmental, behavioral or psychiatric disorders. Impaired decision-making: failure to perform usual ADLs or IADLs, inability to appropriately stop activities, jeopardizes safety through actions
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

Symptom Inappropriate Behavior Ind

Description	Identifies specific behaviors associated with significant neurological, developmental, behavioral or psychiatric disorders. Delusional, hallucinatory, or paranoid behavior
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

Symptom Memory Deficit Ind

Description	Identifies specific behaviors associated with significant neurological, developmental, behavioral or psychiatric disorders. Memory deficit: failure to recognize familiar persons/places, inability to recall events of past 24 hours, significant memory loss so that supervision is required
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

Symptom None Demonstrated Ind

Description	Identifies specific behaviors associated with significant neurological, developmental, behavioral or psychiatric disorders. No Cognitive, behavioral, or psychiatric symptoms demonstrated at least once a week.
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

Symptom Physical Aggression Ind

Description	Identifies specific behaviors associated with significant neurological, developmental, behavioral or psychiatric disorders. Physical aggression: aggressive or combative to self and others (e.g., hits self, throws objects, punches, dangerous maneuvers with wheelchair or other objects)
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

Symptom Verbal Disruption Ind

Description	Identifies specific behaviors associated with significant neurological, developmental, behavioral or psychiatric disorders. Verbal disruption: yelling, threatening, excessive profanity, sexual references, etc.
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

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Relationship Details

OASIS Neuro Status Snapshot_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Neuro Status 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 Neuro Status Snapshot_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Neuro Status 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 Neuro Status Snapshot_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Neuro Status 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 Neuro Status Snapshot_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Neuro Status 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 Neuro Status Snapshot_Survey Dimension_FK

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

Is Identifying Relationship	true
Child Table	OASIS Neuro Status 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 Neuro Status Snapshot_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS Neuro Status 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 Neuro Status 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