Dimensional Warehouse Model Data Model

Entity

Entity OASIS - Neuro Status Observation Analysis

Description

Observation of a population of patients neuro status.

Attributes
Administered Calendar Dk
Average Survey Admin Duration
Average Survey Completion Time
Disruptive Behavior Frequency
Encounter Dk
Number Of Adolescent Respondents
Number Of Anxious State Constantly
Number Of Anxious State Daily
Number Of Anxious State Never
Number Of Anxious State Not Daily
Number Of Anxious State Not Responsive
Number Of Child Respondents
Number Of Cognitive Functioning Alert
Number Of Cognitive Functioning Needs Assistance
Number Of Cognitive Functioning Not Alert
Number Of Cognitive Functioning Requires Prompting
Number Of Cognitive Functioning Totally Dependent
Number Of Confusion State At Awakening
Number Of Confusion State Constantly
Number Of Confusion State Never
Number Of Confusion State New Situations
Number Of Confusion State Not Constantly
Number Of Confusion State Unresponsive
Number Of Depression Screen Responses More Than Half
Number Of Depression Screen Responses Nearly All
Number Of Depression Screen Responses None
Number Of Depression Screen Responses No Response
Number Of Depression Screen Responses Several Days
Number Of Depression Screens Little Interest More Than Half
Number Of Depression Screens Little Interest Nearly All
Number Of Depression Screens Little Interest No Response
Number Of Depression Screens Little Interest Several Days
Number Of Depression Screens Little Interest Zero
Number Of Individuals Surveyed
Number Of Medicaid Respondents
Number Of Medicare Respondents
Number Of Respondents
Number Of Standard Depression Screenings
Number Of Surveys
Number Of Symptom Disruptive Behaviors
Number Of Symptom Impaired Decision Making
Number Of Symptom Inappropriate Behavior
Number Of Symptom Memory Deficit
Number Of Symptom None Demonstrated
Number Of Symptom Physical Aggression
Number Of Symptom Verbal Disruption
Number Receiving Psychiatric Nursing Services
Patient Dk
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Response Calendar Dk
Survey Admin Duration
Survey Completion Time
Survey Dk

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

Primary Key
OASIS - Neuro Status 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

Disruptive Behavior Frequency

Description	Identifies the average frequency of any behaviors that are disruptive or dangerous to the patient or the caregivers.
Data Type	Standards - Data Domains.ddm/Data Domains/Ratio [FLOAT(5)]
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 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 Anxious State Constantly

Description	Identifies the number of patients who have felt anxious within the past 14 days reported as all of the time
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 Anxious State Daily

Description	Identifies the number of patients who have felt anxious within the past 14 days reported as daily, but not constantly.
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 Anxious State Never

Description	Identifies the number of patients who have felt anxious within the past 14 days reported as none of the time
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 Anxious State Not Daily

Description	Identifies the number of patients who have felt anxious within the past 14 days reported as less often than daily.
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 Anxious State Not Responsive

Description	Identifies the number of patients who have felt anxious within the past 14 days reported as patient nonresponsive.
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 Cognitive Functioning Alert

Description	Identifies the number of patients current (at the time of the assessment and in the preceding 24 hours) level of cognitive functioning as alert/oriented, able to focus and shift attention, comprehends and recalls task directions independently.
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 Cognitive Functioning Needs Assistance

Description	Identifies the number of patients current (at the time of the assessment and in the preceding 24 hours) level of cognitive functioning as requires assistance and some direction in specific situations (e.g., on all tasks involving shifting of attention), or consistently requires low stimulus environment due to distractibility.
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 Cognitive Functioning Not Alert

Description	Identifies the number of patients current (at the time of the assessment and in the preceding 24 hours) level of cognitive functioning as requires considerable assistance in routine situations. Is not alert and oriented or is unable to shift attention and recall directions more than half the time.
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 Cognitive Functioning Requires Prompting

Description	Identifies the number of patients current (at the time of the assessment and in the preceding 24 hours) level of cognitive functioning as requires prompting (cuing, repetition, reminders) only under stressful or unfamiliar conditions.
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 Cognitive Functioning Totally Dependent

Description	Identifies the number of patients current (at the time of the assessment and in the preceding 24 hours) level of cognitive functioning as totally dependent due to disturbances such as constant disorientation, coma, persistent vegetative state, or delirium.
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 Confusion State At Awakening

Description	Identifies number of patients who reported experiencing confusion on awakening or at night only.
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 Confusion State Constantly

Description	Identifies number of patients who reported experiencing confusion constantly.
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 Confusion State Never

Description	Identifies number of patients who never reported experiencing confusion.
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 Confusion State New Situations

Description	Identifies number of patients who reported experiencing confusion in new or complex situations only.
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 Confusion State Not Constantly

Description	Identifies number of patients who reported experiencing confusion during the day and evening, but not constantly.
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 Confusion State Unresponsive

Description	Identifies number of patients who are unresponsive.
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 Depression Screen Responses More Than Half

Description	Identifies the number of patient the home health agency screened for depression using PHQ-2© who reported feeling depressed 7 to 11 days out of the past 14. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Depression Screen Responses Nearly All

Description	Identifies the number of patient the home health agency screened for depression using PHQ-2© who reported feeling depressed12 to 14 days out of the past 14. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Depression Screen Responses None

Description	Identifies the number of patient the home health agency screened for depression using PHQ-2© who reported feeling depressed 0 days out of the past 14. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Depression Screen Responses No Response

Description	Identifies the number of patient the home health agency screened for depression using PHQ-2© who could no give a response. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Depression Screen Responses Several Days

Description	Identifies the number of patient the home health agency screened for depression using PHQ-2© who reported feeling depressed 2 to 6 days out of the past 14. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Depression Screens Little Interest More Than Half

Description	Indicates the number of patients screened with PHQ-2© who indictated they had little interest or pleasure in doing things 7 to 11 days in the last 14 days.. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Depression Screens Little Interest Nearly All

Description	Indicates the number of patients screened with PHQ-2© who indictated they had little interest or pleasure in doing things 13 or 14 days in the last 14 days.. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Depression Screens Little Interest No Response

Description	Indicates the number of patients screened with PHQ-2© who could not responsethat they had little interest or pleasure in doing things. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Depression Screens Little Interest Several Days

Description	Indicates the number of patients screened with PHQ-2© who indictated they had little interest or pleasure in doing things 2 to 6 days in the last 14 days.. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Depression Screens Little Interest Zero

Description	Indicates the number of patients screened with PHQ-2© who indictated they had little interest or pleasure in doing things 0 or 1 days in the last 14 days.. 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/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 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 Standard Depression Screenings

Description	Identifies the number of patients the home health agency screened 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/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 Of Symptom Disruptive Behaviors

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

Number Of Symptom Impaired Decision Making

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

Number Of Symptom Inappropriate Behavior

Description	Identifies the number of patients with specific behaviors associated with significant neurological, developmental, behavioral or psychiatric disorders. Delusional, hallucinatory, or paranoid behavior
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 Symptom Memory Deficit

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

Number Of Symptom None Demonstrated

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

Number Of Symptom Physical Aggression

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

Number Of Symptom Verbal Disruption

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

Number Receiving Psychiatric Nursing Services

Description	Identifies the number of patients 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

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 - Neuro Status Observation Analysis_Encounter Dimension_FK

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

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

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

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

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

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

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

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