Dimensional Warehouse Model Data Model

Entity

Entity PHR Transfer Analysis

Description

Analysis of electronic personal health record (PHR) transfers between Health Plan Organizations.

Attributes
Calendar Dk
Coverage Agreement Dimension Dk
Geographic Area Dk
Group Dk
Health Plan Product Dk
Number Of Group Member PHRs Transferred In
Number Of Group Member PHRs Transferred Out
Number Of Group Members Enrolled
Number Of Group Members Unenrolled
Number Of Groups Enrolled
Number Of Groups Transferring PHRs In
Number Of Groups Transferring PHRs Out
Number Of Groups Unenrolled
Number Of Individual Member PHRs Transferred In
Number Of Individual Member PHRs Transferred Out
Number Of Individual Members Enrolled
Number Of Individual Members Requesting PHR Transfer In
Number Of Individual Members Requesting PHR Transfer Out
Number Of Individual Members Unenrolled
Number Of Members Enrolled
Number Of Members Involved In Group Requests For PHR Transfer In
Number Of Members Involved In Group Requests For PHR Transfer Out
Number Of Members Unenrolled
Number Of PHRs Requested In
Number Of PHRs Requested Out
Number Of PHRs Transferred In
Number Of PHRs Transferred Out
Number Of Requests For Group PHR Transfer In
Number Of Requests For Group PHR Transfer Out
Plan Member Dk
Ratio Of Enrolled Groups Completing PHR Transfers In
Ratio Of Enrolled Groups Requesting PHRs In
Ratio Of Enrolled Individual Members Requesting PHR Transfer In
Ratio Of Enrolled Individual Members Who Completed PHR Transfer In
Ratio Of Unenrolled Groups Completing PHR Transfers Out
Ratio Of Unenrolled Groups Requesting PHRs Out
Ratio Of Unenrolled Individual Members Requesting PHR Transfer Out
Ratio Of Unenrolled Individual Members Who Completed PHR Transfer Out

Relationship
PHR Transfer Analysis_Calendar Dimension_FK
PHR Transfer Analysis_Geographic Area Dimension_FK
PHR Transfer Analysis_Plan Member Dimension_FK
PHR Transfer Analysis_Group Dimension_FK
PHR Transfer Analysis_Health Plan Product Dimension_FK
PHR Transfer Analysis_Coverage Agreement Dimension_FK

Primary Key
PHR Transfer 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

Coverage Agreement Dimension 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 Group Member PHRs Transferred In

Description	A count of members belonging to groups switching to the health plan from another health plan and transferring personal health records (PHRs). Number of personal health records owned by members belonging to groups that were successfully transferred from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) during the period of analysis, subsequent to their owners having been switched, on a group basis, from the other plan into the health plan organization during the same period of analysis.
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 Group Member PHRs Transferred Out

Description	A count of members belonging to groups switching from the health plan to another health plan and transferring personal health records (PHRs). Number of personal health records owned by members belonging to groups that were successfully transferred from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) during the period of analysis, subsequent to their owners having been switched, on a group basis, from the health plan organization to another health plan organization during the same period of analysis.
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 Group Members Enrolled

Description	Number of members belonging to groups who have been moved, on the basis of group switch, from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) during the period of analysis.
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 Group Members Unenrolled

Description	Number of members belonging to groups who have been moved, on the basis of group switch, from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) during the period of analysis.
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 Groups Enrolled

Description	Number of groups that were switched from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) during the period of analysis.
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 Groups Transferring PHRs In

Description	A count of groups switching to the health plan from another health plan and transferring personal health records (PHRs). Number of groups that were switched from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) during the period of analysis and successfully transferred their members' personal health records during the same period of analysis.
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 Groups Transferring PHRs Out

Description	A count of groups switching from the health plan to another health plan and transferring personal health records (PHRs). Number of groups that were switched from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) during the period of analysis and successfully transferred their members' personal health records during the same period of analysis.
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 Groups Unenrolled

Description	Number of groups that were switched from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) during the period of analysis.
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 Individual Member PHRs Transferred In

Description	A count of individual members switching to the health plan from another health plan and transferring personal health records (PHRs). Number of personal health records owned by members that were successfully transferred from another plan (sending) into the health plan organization (the modeled organization, receiving) during the period of analysis, subsequent to their owners having switched on an individual basis from the other plan into the health plan organization during the same period of analysis.
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 Individual Member PHRs Transferred Out

Description	A count of individual members switching from the health plan to another health plan and transferring personal health records (PHRs). Number of personal health records owned by members that were successfully transferred from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) during the period of analysis, subsequent to their owners having switched on an individual basis from the other plan into the health plan organization during the same period of analysis.
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 Individual Members Enrolled

Description	Number of members who moved, on an individual basis, from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) during the period of analysis.
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 Individual Members Requesting PHR Transfer In

Description	A count of individual members switching to the health plan from another health plan and requesting transfer of personal health records (PHRs). Number of members who switched from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) on an individual basis, during the period of analysis, and who requested the transfer of their personal health records during the same period of analysis.
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 Individual Members Requesting PHR Transfer Out

Description	A count of individual members switching from the health plan to another health plan and requesting transfer of personal health records (PHRs). Number of members who switched from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) on an individual basis, during the period of analysis, and who requested the transfer of their personal health records during the same period of analysis.
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 Individual Members Unenrolled

Description	Number of members who moved, on an individual basis, from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) during the period of analysis.
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 Members Enrolled

Description	Total number of health plan organization members who have moved from another plan (sending) into the health plan organization (the modeled organization, receiving) over the period of analysis, both on a group switch and on an individual move basis. Formula: [A+B] (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

Number Of Members Involved In Group Requests For PHR Transfer In

Description	A count of members belonging to groups switching to the health plan from another health plan and requesting transfer of personal health records (PHRs). Number of members belonging to one or more groups who were switched, on a group basis, from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) during the period of analysis, and for whom the transfer of their personal health records was requested during the period of analysis.
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 Members Involved In Group Requests For PHR Transfer Out

Description	A count of members belonging to groups switching from the health plan to another health plan and requesting transfer of personal health records (PHRs). Number of members belonging to one or more groups who were switched, on a group basis, from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) during the period of analysis, and for whom the transfer of their personal health records was requested during the period of analysis.
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 Members Unenrolled

Description	Total number of members who have moved from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) over the period of analysis, both on a group switch and on an individual move basis. Formula: [A+B] (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

Number Of PHRs Requested In

Description	A count of personal health records (PHRs) requested to be transferred to the health plan. The total number of personal health records whose transfer into the health plan organization from another sending plan was requested during the period of analysis, subsequent to PHRs' owners having moved into the receiving plan both on a group basis and on an individual basis. It is assumed that the number of PHRs requested in on a group basis is always identical to the number of group members whose PHR transferring into the health plan organization was requested. This is based on the assumption that the receiving health plan organization does not know in advance whether the group members to be enrolled do or don't actually have a PHR with the sending health plan organization. It is also assumed that individual members who requested a PHR transfer in on an individual basis always do have a PHR with the sending plan; otherwise they wouldn't have asked for a PHR transfer. Therefore this measure is calculated as a sum of member counts, rather than a sum of PHR counts. Formula: [A+B] (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

Number Of PHRs Requested Out

Description	A count of personal health records (PHRs) requested to be transferred from the health plan to another plan. The total number of personal health records whose transfer from the health plan organization to the other receiving plan was requested during the period of analysis, subsequent to PHRs' owners having moved out from the sending plan both on a group basis and on an individual basis. It is assumed that the number of PHRs requested out on a group basis is always identical to the number of group members whose PHR transferring from the sending health plan organization was requested. This is based on the assumption that the receiving health plan organization does not know in advance whether the group members to be enrolled do or don't actually have a PHR with the sending health plan organization. It is also assumed that individual members who requested a PHR transfer out on an individual basis always do have a PHR with the sending plan; otherwise they wouldn't have asked for a PHR transfer. Therefore this measure is calculated as a sum of member counts, rather than a sum of PHR counts. Formula: [A+B] (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

Number Of PHRs Transferred In

Description	A count of personal health records (PHRs) transferred to the health plan. Total number of personal health records that were successfully transferred from another plan (sending) into the health plan organization (the modeled organization, receiving) during the period of analysis, either subsequent to their owners having been switched, on a group basis, from the other plan into the health plan organization during the same period of analysis, or subsequent to individual member moves. Formula: [A+B] (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

Number Of PHRs Transferred Out

Description	A count of personal health records (PHRs) transferred from the health plan to another plan. Total number of personal health records that were successfully transferred from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) during the period of analysis, either subsequent to their owners having been switched, on a group basis, from the health plan organization to another plan during the same period of analysis, or subsequent to individual member moves. Formula: [A+B] (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

Number Of Requests For Group PHR Transfer In

Description	A count of groups switching to the health plan from another health plan and requesting transfer of personal health records (PHRs). Number of groups that were switched from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) during the period of analysis, and for whom the transfer of their members' personal health records was requested during the period of analysis.
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 Requests For Group PHR Transfer Out

Description	A count of groups switching from the health plan to another health plan and requesting transfer of personal health records (PHRs). Number of groups that were switched from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) during the period of analysis, and for whom the transfer of their members' personal health records was requested during the period of analysis.
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

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

Ratio Of Enrolled Groups Completing PHR Transfers In

Description	The number of groups that transferred personal health records (PHRs) to the health plan in relation to the number of enrolled groups. Ratio of - number of groups that had been switched from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) and for whose members the transfer of personal health records from the other plan into the receiving health plan organization was completed successfully during the period of analysis, to - total number of groups that had been switched from another health plan organization into the receiving health plan organization during the period of analysis. 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

Ratio Of Enrolled Groups Requesting PHRs In

Description	The number of groups requesting personal health records (PHRs) transfer to the health plan in relation to the number of enrolled groups. Ratio of - number of groups that had been switched from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) and for whose members the groups requested the transfer of personal health records from the other plan into the health plan organization during the period of analysis, to - total number of groups that had been switched from another health plan organization into the receiving health plan organization during the period of analysis. 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

Ratio Of Enrolled Individual Members Requesting PHR Transfer In

Description	The number of individual members requesting personal health record (PHR) transfer to the health plan in relation to the number of enrolled individual members. Ratio of - number of members who switched on an individual basis from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) during the period of analysis and who requested the transfer of personal health records from the other plan into the receiving health plan organization during the period of analysis, to - the total number of members who have switched on an individual basis from another health plan organization into the receiving health plan organization during the period of analysis. 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

Ratio Of Enrolled Individual Members Who Completed PHR Transfer In

Description	The number of individual members that transferred personal health records (PHRs) to the health plan in relation to the number of enrolled individual members. Ratio of - number of Health Plan Organization members who switched on an individual basis from another health plan organization (sending) into the health plan organization (the modeled organization, receiving) and for whom the transfer of personal health records from the other plan into the receiving health plan organization was completed successfully during the period of analysis, to - total number of members who switched on an individual basis from another health plan organization into the receiving health plan organization during the period of analysis. 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

Ratio Of Unenrolled Groups Completing PHR Transfers Out

Description	The number of groups that transferred personal health records (PHRs) from the health plan to another plan in relation to the number of unenrolled groups. Ratio of - number of groups that had been switched from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) and for whose members the transfer of personal health records from the health plan organization to the receiving other plan was completed successfully during the period of analysis, to - total number of groups that had been switched from the health plan organization to the receiving other plan during the period of analysis. 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

Ratio Of Unenrolled Groups Requesting PHRs Out

Description	The number of groups requesting personal health record (PHR) transfer from the health plan to another plan in relation to the number of unenrolled groups. Ratio of - number of groups that had been switched from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) and for whose members the groups requested the transfer of personal health records from the health plan organization to the other plan during the period of analysis, to - total number of groups that had been switched from the health plan organization to the receiving other plan during the period of analysis. 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

Ratio Of Unenrolled Individual Members Requesting PHR Transfer Out

Description	The number of individual members requesting personal health record (PHR) transfer from the health plan to another plan in relation to the number of unenrolled individual members. Ratio of - number of members who switched on an individual basis from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) during the period of analysis and who requested the transfer of personal health records from the health plan organization to the other receiving Health Plan Organization during the period of analysis, to - the total number of members who have switched on an individual basis from the health plan organization to the other receiving plan during the period of analysis. 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

Ratio Of Unenrolled Individual Members Who Completed PHR Transfer Out

Description	The number of individual members that transferred personal health records (PHRs) from the health plan to another plan in relation to the number of unenrolled individual members. Ratio of - number of Health Plan Organization members who switched on an individual basis from the health plan organization (the modeled organization, sending) to another health plan organization (receiving) and for whom the transfer of personal health records from the health plan organization to the other receiving plan was completed successfully during the period of analysis, to - total number of members who switched on an individual basis from the health plan organization to the other receiving plan during the period of analysis. 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

Relationship Details

PHR Transfer Analysis_Calendar Dimension_FK

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

PHR Transfer Analysis_Geographic Area Dimension_FK

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

PHR Transfer Analysis_Plan Member Dimension_FK

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

PHR Transfer Analysis_Group Dimension_FK

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

PHR Transfer Analysis_Health Plan Product Dimension_FK

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

PHR Transfer Analysis_Coverage Agreement Dimension_FK

Is Identifying Relationship	true
Child Table	PHR Transfer 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	Coverage Agreement 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

PHR Transfer Analysis PK

Key Attribute	Plan Member Dk
Key Attribute	Health Plan Product Dk
Key Attribute	Group Dk
Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk
Key Attribute	Coverage Agreement Dimension Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model