Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Patient Experience Survey Analysis

Description

Patient Experience Survey Analysis contains aggregations of survey responses. Typically the surveys are quality based to poll perceptions and experiences of patients with provider or payer services.

Attributes

Administered Calendar Dk

Average Satisfaction Level With Accommodations

Average Satisfaction Level With Admission Process

Average Satisfaction Level With Discharge Process

Average Satisfaction Level With Nursing Staff

Encounter Dk

Number Of Adolescent Respondents

Number Of Child Respondents

Number Of Individuals Surveyed

Number Of Medicaid Respondents

Number Of Medicare Respondents

Number Of Respondents

Number Of Respondents Satisfied With Access To Costs

Number Of Respondents Satisfied With Access To Necessary Care

Number Of Respondents Satisfied With Coordination Of Care

Number Of Respondents Satisfied With Customer Service

Number Of Respondents Satisfied With General Access To Care

Number Of Respondents Satisfied With Overall Healthcare

Number Of Respondents Satisfied With PCP

Number Of Respondents Satisfied With Specialist

Number Of Surveys

Patient Dk

Percentage Of Respondents Satisfied With Overall Healthcare

Percentage Of Survey Respondents

Point Of Care Location Dk

Practitioner Dk

Provider Dk

Response Calendar Dk

Satisfaction Level With Accommodations

Satisfaction Level With Admission Process

Satisfaction Level With Discharge Process

Satisfaction Level With Nursing Staff

Survey Administration Dk

Survey Answer Dk

Survey Question Dk

Survey Section Dk

Survey Template Dk

Relationship

Survey Analysis_Encounter Dimension_FK

Survey Analysis_Point Of Care Location Dimension_FK

Survey Analysis_Calendar Dimension_FK

Survey Analysis_Calendar Dimension_FK1

Survey Analysis_Survey Administration Dimension_FK

Survey Analysis_Survey Template Dimension_FK

Survey Analysis_Survey Section Dimension_FK

Survey Analysis_Patient Dimension_FK

Survey Analysis_Practitioner Dimension_FK

Survey Analysis_Provider Dimension_FK

Survey Analysis_Survey Question Dimension_FK

Survey Analysis_Survey Answer Dimension_FK

Primary Key

Survey 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 Satisfaction Level With Accommodations

Description	The calculated average level of satisfaction with accommodations based on the aggregate level of satisfaction expressed by respondents divided by the number of respondents. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Average Satisfaction Level With Admission Process

Description	The calculated average level of satisfaction with the admission process based on the aggregate level of satisfaction expressed by respondents divided by the number of respondents. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Average Satisfaction Level With Discharge Process

Description	The calculated average level of satisfaction with the discharge process based on the aggregate level of satisfaction expressed by respondents divided by the number of respondents. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Average Satisfaction Level With Nursing Staff

Description	The calculated average level of satisfaction with nursing staff based on the aggregate level of satisfaction expressed by respondents divided by the number of respondents. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
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	A 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	A 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	A count of people who were asked to complete 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 Medicaid Respondents

Description	A count of survey 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	A count of survey 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	A 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 Respondents Satisfied With Access To Costs

Description	A count of survey respondents who indicated that they were satisfied with their access to information on costs.
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 Satisfied With Access To Necessary Care

Description	A count of survey respondents who indicated that they were satisfied with their access to necessary care.
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 Satisfied With Coordination Of Care

Description	A count of survey respondents who indicated that they were satisfied with their experience of coordination of care.
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 Satisfied With Customer Service

Description	A count of survey respondents who indicated that they were satisfied with their experience of customer service.
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 Satisfied With General Access To Care

Description	A count of survey respondents who indicated that they were satisfied with their general access to care.
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 Satisfied With Overall Healthcare

Description	A count of survey respondents with a satisfaction rating on overall healthcare services.
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 Satisfied With PCP

Description	A count of survey respondents who indicated that they were satisfied with their primary care provider.
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 Satisfied With Specialist

Description	A count of survey respondents who indicated that they were satisfied with their specialist practitioner.
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	A 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

---

 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

---

 Percentage Of Respondents Satisfied With Overall Healthcare

Description	The number of respondents who indicated that they were satisfied with their overall healthcare experience expressed as a percentage of the number of people who responded to the survey. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
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

---

 Percentage Of Survey Respondents

Description	The number of people who responded to a survey expressed as a percentage of the number who were requested to respond. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
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

---

 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

---

 Satisfaction Level With Accommodations

Description	The aggregate level of satisfaction expressed by respondents with respect to provider accommodations (rooms).
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

---

 Satisfaction Level With Admission Process

Description	The aggregate level of satisfaction expressed by respondents with respect to the overall admissions process.
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

---

 Satisfaction Level With Discharge Process

Description	The aggregate level of satisfaction expressed by respondents with respect to the overall discharge process.
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

---

 Satisfaction Level With Nursing Staff

Description	The aggregate level of satisfaction expressed by respondents with respect to nursing staff.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Survey Administration 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 Answer 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 Question 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 Section 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 Template 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

 Survey Analysis_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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

---

 Survey Analysis_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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

---

 Survey Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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

---

 Survey Analysis_Calendar Dimension_FK1

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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

---

 Survey Analysis_Survey Administration Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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 Administration Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Survey Analysis_Survey Template Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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 Template Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Survey Analysis_Survey Section Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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 Section Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Survey Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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

---

 Survey Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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

---

 Survey Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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

---

 Survey Analysis_Survey Question Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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 Question Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Survey Analysis_Survey Answer Dimension_FK

Is Identifying Relationship	true
Child Table	Patient Experience Survey 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 Answer 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

 Survey 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 Administration Dk
Key Attribute	Survey Template Dk
Key Attribute	Survey Section Dk
Key Attribute	Survey Question Dk
Key Attribute	Survey Answer Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model