Dimensional Warehouse Model Data Model

Entity

Entity Parent Satisfaction Analysis

Description

The analysis of the satisfaction of parents, with regard to their child's membership experience with the Health Plan Organization.

Attributes
Calendar Dk
Condition Dk
Geographic Area Dk
Group Dk
Health Plan Product Dk
Number Of Parents Satisfied With Access To Information
Number Of Parents Satisfied With Access To Necessary Care
Number Of Parents Satisfied With Access To Prescription Medicines
Number Of Parents Satisfied With Access To Specialized Services
Number Of Parents Satisfied With Childs PCP
Number Of Parents Satisfied With Childs Specialist
Number Of Parents Satisfied With Claims Processing
Number Of Parents Satisfied With Coordination Of Care
Number Of Parents Satisfied With Customer Service
Number Of Parents Satisfied With Decision Making Process
Number Of Parents Satisfied With General Access To Care
Number Of Parents Satisfied With Health Plan Generally
Number Of Parents Satisfied With Overall Healthcare
Number Of Parents Satisfied With Provider Communication
Number Of Parents Satisfied With Provider Office Staff
Number Of Surveyed Parents Responding
Percentage Of Parents Satisfied With Childs Chronic Care
Percentage Of Parents Satisfied With Childs Membership Experience
Plan Member Dk
Practitioner Dk
Provider Dk
Survey Dk
Survey Question Dk

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

Primary Key
Parent 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 Parents Satisfied With Access To Information

Description	The number of parents satisfied with the access to necessary information about their child's healthcare during the survey period. This measurement may be particularly relevant to parents of children with chronic medical conditions.
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 Parents Satisfied With Access To Necessary Care

Description	The number of parents that are satisfied with the level of access to necessary care for their child, through the health plan networks during the survey 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 Parents Satisfied With Access To Prescription Medicines

Description	The number of parents that are satisfied with the level of access to prescription medicines for their child during the survey period. This measurement may be particularly relevant to parents of children with chronic medical conditions.
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 Parents Satisfied With Access To Specialized Services

Description	The number of parents satisfied with the level of access to specialized services for their child during the survey period. This measurement may be particularly relevant to parents of children with chronic medical conditions.
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 Parents Satisfied With Childs PCP

Description	The number of parents that are satisfied with their children's primary care practitioner (PCP) over the survey 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 Parents Satisfied With Childs Specialist

Description	The number of parents satisfied with their child's specialist healthcare provider over the survey 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 Parents Satisfied With Claims Processing

Description	The number of parents satisfied with the processing of their child's claims during the survey 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 Parents Satisfied With Coordination Of Care

Description	The number of parents satisfied with the coordination of their children's care, by the health plans healthcare providers during the survey period. This measurement may be particularly relevant to parents of children with chronic medical conditions.
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 Parents Satisfied With Customer Service

Description	The number of parents satisfied with the health plan customer service experienced through their child's membership, during the survey 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 Parents Satisfied With Decision Making Process

Description	The number of parents satisfied that there views are being fully represented and considered in the healthcare decisions relating to the children's care during the survey period. This measurement may be particularly relevant to parents of children with chronic medical conditions.
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 Parents Satisfied With General Access To Care

Description	The number of parents satisfied with the speed, with which their child can access care, through the health plans networks during the survey 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 Parents Satisfied With Health Plan Generally

Description	The number of parents satisfied with the health plan in general, from their child's membership experience over the survey 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 Parents Satisfied With Overall Healthcare

Description	The number of parents satisfied with their child's overall healthcare delivery, while enrolled with the health plan, during the survey 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 Parents Satisfied With Provider Communication

Description	The number of parents who indicated they usually or always felt their child's doctors or other healthcare providers communicated well with them during the survey 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 Parents Satisfied With Provider Office Staff

Description	The number of parents who indicated they usually or always experienced courtesy, respect, and helpfulness from the healthcare provider office staff managing the care of their child during the survey 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 Parents Responding

Description	The number of parents, whose child is a member of the health plan, that responded to questions relating to their children's membership experience, during the survey 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 Parents Satisfied With Childs Chronic Care

Description	The percentage of parents , whose child is a member of the health plan, who are satisfied with the treatment, management, and support of their child's chronic medical conditions. For children, the term 'chronic medical condition' refers to a wide range of physical, developmental, behavioral, and emotional health problems where the need for care is ongoing, and the services are of a type or at a level exceeding that which children normally require. Formula: [((A or B or C or D or E or F)/G)*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

Percentage Of Parents Satisfied With Childs Membership Experience

Description	The percentage of parents who are satisfied with selected aspects, of their child's health plan membership experience, during survey period. Formula: [((A or B or C or D or E or F or G or H or I or J)/K)*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

Parent Satisfaction Analysis_Calendar Dimension_FK

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

Parent Satisfaction Analysis_Geographic Area Dimension_FK

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

Parent Satisfaction Analysis_Plan Member Dimension_FK

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

Parent Satisfaction Analysis_Condition Dimension_FK

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

Parent Satisfaction Analysis_Group Dimension_FK

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

Parent Satisfaction Analysis_Practitioner Dimension_FK

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

Parent Satisfaction Analysis_Provider Dimension_FK

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

Parent Satisfaction Analysis_Survey Dimension_FK

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

Parent Satisfaction Analysis_Survey Question Dimension_FK

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

Parent Satisfaction Analysis_Health Plan Product Dimension_FK

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

Parent 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	Group Dk
Key Attribute	Geographic Area Dk
Key Attribute	Calendar Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model