Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity OASIS - Sensory Status Observation Analysis

Description

Summary of clinical observations of the patients sensory status.

Attributes

Administered Calendar Dk

Average Survey Admin Duration

Average Survey Completion Time

Encounter Dk

Number Of Adolescent Respondents

Number Of Child Respondents

Number Of Formal Pain Assessment Severe Pain

Number Of Hearing Ability Moderately Impaired

Number Of Hearing Ability Normal

Number Of Hearing Ability Severley Impaired

Number Of Hearing Ability Unknown

Number Of Individuals Surveyed

Number Of Medicaid Respondents

Number Of Medicare Respondents

Number Of Oral Language Expression Clear

Number Of Oral Language Expression Minimal Difficulty

Number Of Oral Language Expression Moderate Difficulty

Number Of Oral Language Expression Nonresponsive

Number Of Oral Language Expression Severe Difficulty

Number Of Oral Language Expression Unintelligible

Number Of Pain Frequency Constantly

Number Of Pain Frequency Daily

Number Of Pain Frequency Less Than Daily

Number Of Pain Frequency None

Number Of Pain Frequency Non Interfering

Number Of Respondents

Number Of Surveys

Number Of Verbal Content Understanding Not Assessed

Number Of Verbal Content Understanding Rarely Understands

Number Of Verbal Content Understanding Sometimes Understands

Number Of Verbal Content Understanding Understands

Number Of Verbal Content Understanding Usually Understands

Number Of Vision Ability Normal

Number Of Vision Ability Partially Impaired

Number Of Vision Ability Severley Impaired

Patient Dk

Point Of Care Location Dk

Practitioner Dk

Provider Dk

Response Calendar Dk

Survey Admin Duration

Survey Completion Time

Survey Dk

Relationship

OASIS - Sensory Status Observation Analysis_Encounter Dimension_FK

OASIS - Sensory Status Observation Analysis_Point Of Care Location Dimension_FK

OASIS - Sensory Status Observation Analysis_Calendar Dimension_FK

OASIS - Sensory Status Observation Analysis_Calendar Dimension_FK1

OASIS - Sensory Status Observation Analysis_Patient Dimension_FK

OASIS - Sensory Status Observation Analysis_Practitioner Dimension_FK

OASIS - Sensory Status Observation Analysis_Provider Dimension_FK

OASIS - Sensory Status Observation Analysis_Survey Dimension_FK

Primary Key

OASIS - Sensory 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

---

 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 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 Formal Pain Assessment Severe Pain

Description	Identifies the number of patients with a clinically significant level of pain present, as determined by the assessment tool used.
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 Hearing Ability Moderately Impaired

Description	Number of patients whose ability to hear spoken language and other sounds (e.g., alarms) is Mildly to Moderately Impaired: difficulty hearing in some environments or speaker may need to increase volume or speak distinctly.
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 Hearing Ability Normal

Description	Number of patients whose ability to hear spoken language and other sounds (e.g., alarms) is adequate: hears normal conversation without difficulty.
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 Hearing Ability Severley Impaired

Description	Number of patients whose ability to hear spoken language and other sounds (e.g., alarms) is Severely Impaired: absence of useful hearing.
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 Hearing Ability Unknown

Description	Number of patients whose ability to hear spoken language and other sounds (e.g., alarms) isUnable to assess hearing.
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 Oral Language Expression Clear

Description	Number of patients with physical and cognitive ability to communicate with words in the patient’s primary language reported as: expresses complex ideas, feelings, and needs clearly, completely, and easily in all situations with no observable impairment. The item does not address communicating in sign language, in writing, or by any nonverbal means.
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 Oral Language Expression Minimal Difficulty

Description	Number of patients with physical and cognitive ability to communicate with words in the patient’s primary language reported as: Minimal difficulty in expressing ideas and needs (may take extra time; makes occasional errors in word choice, grammar or speech intelligibility; needs minimal prompting or assistance). The item does not address communicating in sign language, in writing, or by any nonverbal means.
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 Oral Language Expression Moderate Difficulty

Description	Number of patients with physical and cognitive ability to communicate with words in the patient’s primary language reported as: Expresses simple ideas or needs with moderate difficulty (needs prompting or assistance, errors in word choice, organization or speech intelligibility). Speaks in phrases or short sentences. The item does not address communicating in sign language, in writing, or by any nonverbal means.
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 Oral Language Expression Nonresponsive

Description	Number of patients with physical and cognitive ability to communicate with words in the patient’s primary language reported as: Patient nonresponsive or unable to speak. The item does not address communicating in sign language, in writing, or by any nonverbal means.
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 Oral Language Expression Severe Difficulty

Description	Number of patients with physical and cognitive ability to communicate with words in the patient’s primary language reported as: Has severe difficulty expressing basic ideas or needs and requires maximal assistance or guessing by listener. Speech limited to single words or short phrases. The item does not address communicating in sign language, in writing, or by any nonverbal means.
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 Oral Language Expression Unintelligible

Description	Number of patients with physical and cognitive ability to communicate with words in the patient’s primary language reported as: Unable to express basic needs even with maximal prompting or assistance but is not comatose or unresponsive (e.g., speech is nonsensical or unintelligible). The item does not address communicating in sign language, in writing, or by any nonverbal means.
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 Pain Frequency Constantly

Description	The number of patients with which pain interferes with patient’s activities, with treatments if prescribed 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 Pain Frequency Daily

Description	The number of patients with which pain interferes with patient’s activities, with treatments if prescribed 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 Pain Frequency Less Than Daily

Description	The number of patients with which pain interferes with patient’s activities, with treatments if prescribed 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 Pain Frequency None

Description	The number of patients with which pain interferes with patient’s activities, with treatments if prescribed reported as: Patient has no pain
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 Pain Frequency Non Interfering

Description	The number of patients with which pain interferes with patient’s activities, with treatments if prescribed reported as: Patient has pain that does not interfere with activity or movement
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 Of Verbal Content Understanding Not Assessed

Description	Identifies the number of patients whose functional ability to comprehend spoken words and instructions in the patient’s primary language is reported as: Unable to assess understanding. Both hearing and cognitive abilities may impact a patient's ability to understand verbal content.
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 Verbal Content Understanding Rarely Understands

Description	Identifies the number of patients whose functional ability to comprehend spoken words and instructions in the patient’s primary language is reported as: Rarely/Never Understands Both hearing and cognitive abilities may impact a patient's ability to understand verbal content.
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 Verbal Content Understanding Sometimes Understands

Description	Identifies the number of patients whose functional ability to comprehend spoken words and instructions in the patient’s primary language is reported as: Sometimes Understands: understands only basic conversations or simple, direct phrases. Frequently requires cues to understand. Both hearing and cognitive abilities may impact a patient's ability to understand verbal content.
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 Verbal Content Understanding Understands

Description	Identifies the number of patients whose functional ability to comprehend spoken words and instructions in the patient’s primary language is reported as: Understands: clear comprehension without cues or repetitions. Both hearing and cognitive abilities may impact a patient's ability to understand verbal content.
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 Verbal Content Understanding Usually Understands

Description	Identifies the number of patients whose functional ability to comprehend spoken words and instructions in the patient’s primary language is reported as: Usually Understands: understands most conversations, but misses some part/intent of message. Requires cues at times to understand. Both hearing and cognitive abilities may impact a patient's ability to understand verbal content.
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 Vision Ability Normal

Description	Identifies the number of patients whose ability to see and visually manage (function) safely within his/her environment, wearing corrective lenses if these are usually worn is reported as: Normal vision: sees adequately in most situations; can see medication labels, newsprint. ⃞ 1 - Partially impaired: cannot see medication labels or newsprint, but can see obstacles in path, and the surrounding layout; can count fingers at arm's length. ⃞ 2 - Severely impaired:.
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 Vision Ability Partially Impaired

Description	Identifies the number of patients whose ability to see and visually manage (function) safely within his/her environment, wearing corrective lenses if these are usually worn is reported as: Partially impaired: cannot see medication labels or newsprint, but can see obstacles in path, and the surrounding layout; can count fingers at arm's length.
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 Vision Ability Severley Impaired

Description	Identifies the number of patients whose ability to see and visually manage (function) safely within his/her environment, wearing corrective lenses if these are usually worn is reported as: Severely impaired:.
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 - Sensory Status Observation Analysis_Encounter Dimension_FK

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

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

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

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

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

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

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

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