Dimensional Warehouse Model Data Model

Entity

Entity Member Satisfaction Analysis

Description

The analysis of the satisfaction of members, with regard to their membership experience with the health plan organization as determined through member surveys, during the period of analysis.

Attributes
Calendar Dk
Condition Dk
Geographic Area Dk
Group Dk
Health Plan Product Dk
Number Of Members Satisfied With Access To Information On Costs
Number Of Members Satisfied With Access To Necessary Care
Number Of Members Satisfied With Claims Processing
Number Of Members Satisfied With Coordination Of Care
Number Of Members Satisfied With Customer Service
Number Of Members Satisfied With Decision Making Process
Number Of Members Satisfied With General Access To Care
Number Of Members Satisfied With Healthcare Provider Communication
Number Of Members Satisfied With Health Plan Generally
Number Of Members Satisfied With Health Promotion And Education
Number Of Members Satisfied With Overall Healthcare
Number Of Members Satisfied With PCP
Number Of Members Satisfied With Specialist
Number Of Surveyed Members Responding
Percentage Of Members Satisfied With Membership Experience
Plan Member Dk
Practitioner Dk
Provider Dk
Survey Dk
Survey Question Dk

Relationship
Member Satisfaction Analysis_Calendar Dimension_FK
Member Satisfaction Analysis_Geographic Area Dimension_FK
Member Satisfaction Analysis_Plan Member Dimension_FK
Member Satisfaction Analysis_Condition Dimension_FK
Member Satisfaction Analysis_Group Dimension_FK
Member Satisfaction Analysis_Practitioner Dimension_FK
Member Satisfaction Analysis_Provider Dimension_FK
Member Satisfaction Analysis_Survey Dimension_FK
Member Satisfaction Analysis_Survey Question Dimension_FK
Member Satisfaction Analysis_Health Plan Product Dimension_FK

Primary Key
Member Satisfaction Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

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

Condition 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

Geographic Area 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

Group 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

Health Plan Product 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 Members Satisfied With Access To Information On Costs

Description	The number of members satisfied that there is clear, accurate and easily accessible information on healthcare costs, under plan membership, during the surveyed period.
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

Number Of Members Satisfied With Access To Necessary Care

Description	The number of members satisfied with their personal level of access to necessary care during the surveyed period.
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

Number Of Members Satisfied With Claims Processing

Description	The number of members satisfied with the processing of their personal claims during the surveyed period.
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

Number Of Members Satisfied With Coordination Of Care

Description	The number of members satisfied with how their personal care is being coordinated during the surveyed period.
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

Number Of Members Satisfied With Customer Service

Description	The number of members satisfied with their personal customer service experience with the health plan, during the surveyed period.
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

Number Of Members Satisfied With Decision Making Process

Description	The number of members who are satisfied that there views are being fully represented and considered during the healthcare decision making process over the surveyed period.
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

Number Of Members Satisfied With General Access To Care

Description	The number of members satisfied with the speed with which they can access personal care during the surveyed period.
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

Number Of Members Satisfied With Healthcare Provider Communication

Description	The number of members satisfied with their personal experience of doctors communication during the surveyed period.
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

Number Of Members Satisfied With Health Plan Generally

Description	The number of members satisfied with the health plan in general, from their own personal experience during the surveyed period.
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

Number Of Members Satisfied With Health Promotion And Education

Description	The number of members satisfied with the level of health education and promotion that they received through the health plan during the surveyed period.
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

Number Of Members Satisfied With Overall Healthcare

Description	The number of members satisfied with their own personal healthcare delivery, while enrolled with the health plan, during the surveyed period.
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

Number Of Members Satisfied With PCP

Description	The number of members satisfied with their primary care practitioner (PCP) during the surveyed period.
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

Number Of Members Satisfied With Specialist

Description	The number of members satisfied with the specialist healthcare provider they have seen the most during the surveyed period.
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

Number Of Surveyed Members Responding

Description	The number of members responding, where a response was successfully recorded, during the surveyed period.
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

Percentage Of Members Satisfied With Membership Experience

Description	The percentage of members who are satisfied with selected aspects of their health plan membership, during the period of analysis. This measurement may be supported by health survey results. Formula: [((A or B or C or D or E or F or G or H or I or J or K or L or M)/N)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Plan Member 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

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

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

Relationship Details

Member Satisfaction Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Member Satisfaction 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

Member Satisfaction Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Member Satisfaction 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	Geographic Area Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Member Satisfaction Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	Member Satisfaction 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	Plan Member Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Member Satisfaction Analysis_Condition Dimension_FK

Is Identifying Relationship	true
Child Table	Member Satisfaction 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	Condition Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Member Satisfaction Analysis_Group Dimension_FK

Is Identifying Relationship	true
Child Table	Member Satisfaction 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	Group Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Member Satisfaction Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Member Satisfaction 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

Member Satisfaction Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Member Satisfaction 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

Member Satisfaction Analysis_Survey Dimension_FK

Is Identifying Relationship	true
Child Table	Member Satisfaction 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

Member Satisfaction Analysis_Survey Question Dimension_FK

Is Identifying Relationship	true
Child Table	Member Satisfaction 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

Member Satisfaction Analysis_Health Plan Product Dimension_FK

Is Identifying Relationship	true
Child Table	Member Satisfaction 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	Health Plan Product 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

Member Satisfaction Analysis PK

Key Attribute	Plan Member Dk
Key Attribute	Condition Dk
Key Attribute	Practitioner Dk
Key Attribute	Provider Dk
Key Attribute	Survey Dk
Key Attribute	Survey Question Dk
Key Attribute	Health Plan Product Dk
Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk
Key Attribute	Group Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model