Dimensional Warehouse Model Data Model

Entity

Entity Member Personal Health Record Usage Analysis

Description

Analysis of electronic personal health record (PHR) usage by members of health plans.

Attributes
Average Number Of Other PHR Updates Per Other Updating Member
Average Number Of Other PHR Views Per Other Viewing Member
Average Number Of PHR Updates Per PHR Owner
Average Number Of PHR Updates Per Updating Member
Average Number Of PHR Viewings Per PHR Owner
Average Number Of PHR Views Per Viewing Member
Calendar Dk
Condition Dk
Geographic Area Dk
Group Dk
Median Time Between PHR Updates
Median Time Between PHR Updates By Others
Median Time Between PHR Updates By Owners
Median Time Between PHR Viewings By Owners
Median Time Between PHR Views
Median Time Between PHR Views By Others
Number Of Member PHR Updates
Number Of Members Authorized To Update Others PHRs
Number Of Members Authorized To View Others PHRs
Number Of Members Updating Others PHRs
Number Of Members Updating Own PHRs
Number Of Members Updating PHRs
Number Of Members Viewing Others PHRs
Number Of Members Viewing Own PHRs
Number Of Members Viewing PHRs
Number Of Members Who Authorized Others To Update Their PHRs
Number Of Members Who Authorized Others To View Their PHRs
Number Of PHR Updates By Others
Number Of PHR Updates By Owners
Number Of PHR Viewings By Others
Number Of PHR Viewings By Owners
Number Of PHR Views
Plan Member Dk

Relationship
Member Personal Health Record Usage Analysis_Calendar Dimension_FK
Member Personal Health Record Usage Analysis_Geographic Area Dimension_FK
Member Personal Health Record Usage Analysis_Group Dimension_FK
Member Personal Health Record Usage Analysis_Plan Member Dimension_FK
Member Personal Health Record Usage Analysis_Condition Dimension_FK

Primary Key
Member Personal Health Record Usage Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Average Number Of Other PHR Updates Per Other Updating Member

Description	The average number of updates of personal health record (PHR) other than their own, per updating member during the period of analysis. Only members who did update PHRs other than their own at least once during the period of analysis are taken into consideration in the calculation of this average. 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 Number Of Other PHR Views Per Other Viewing Member

Description	The average number of viewings of personal health record (PHR) other than their own, per viewing member during the period of analysis. Only members who did view PHRs other than their own at least once during the period of analysis are taken into consideration in the calculation of this average. 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

Average Number Of PHR Updates Per PHR Owner

Description	The average number of updates of own personal health record (PHR) per updating member during the period of analysis. Only members who did update their own PHR at least once during the period of analysis are taken into consideration in the calculation of this average. 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 Number Of PHR Updates Per Updating Member

Description	The average number of personal health record (PHR) updates per updating member during the period of analysis. Only members who updated their own PHR or someone else's PHR (may have done both), at least once during the period of analysis are taken into consideration in the calculation of this average. 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

Average Number Of PHR Viewings Per PHR Owner

Description	The average number of viewings of own personal health record (PHR) per viewing member during the period of analysis. Only members who did view their own PHR at least once during the period of analysis are taken into consideration in the calculation of this average. 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

Average Number Of PHR Views Per Viewing Member

Description	The average number of personal health record (PHR) viewings per viewing member during the period of analysis. Only members who viewed their own PHR or someone else's PHR (may have done both) at least once during the period of analysis are taken into consideration in the calculation of this average. 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

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

Median Time Between PHR Updates

Description	The median of the length of time between personal health record (PHR) updates by health plan members, over the period of analysis. For the calculation of this median it is irrelevant whose PHR(s) the member updated in succession: her/his own or someone else's.
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

Median Time Between PHR Updates By Others

Description	The median of the length of time between updates of personal health record (PHR) belonging to others performed by health plan members 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

Median Time Between PHR Updates By Owners

Description	The median of the length of time between updates of their own personal health record (PHR) by health plan members, over 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

Median Time Between PHR Viewings By Owners

Description	The median of the length of time between viewings of their own personal health record (PHR) by health plan members, over 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

Median Time Between PHR Views

Description	The median of the length of time between personal health record (PHR) viewings by health plan members, over the period of analysis. For the calculation of this median it is irrelevant whose PHR(s) the member viewed in succession: her/his own or someone else's.
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

Median Time Between PHR Views By Others

Description	The median of the length of time between viewings of personal health record (PHR) belonging to others performed by health plan members 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 Member PHR Updates

Description	Number of personal health record (PHR) updates performed by health plan members during the period of analysis. Includes both own and non-own PHR updates. 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 Authorized To Update Others PHRs

Description	Number of health plan members who are currently authorized to update other members' personal health records (PHRs), under HIPAA privacy rules, as at the end of the analysis period. The authorization to update may have been granted directly by the member owning the PHR or by a competent authority, as per HIPAA legal requirements.
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 Authorized To View Others PHRs

Description	Number of health plan members who are currently authorized to view other members' personal health records (PHRs), under HIPAA privacy rules, as at the end of the analysis period. The authorization to view may have been granted directly by the member owning the PHR or by a competent authority, as per HIPAA legal requirements.
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 Updating Others PHRs

Description	The number of health plan members who updated personal health records (PHRs) belonging to members other than themselves during the period of analysis. This excludes members who only updated their own PHR during the period; it does include members who updated both their own and someone else's PHR during the 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 Updating Own PHRs

Description	The number of health plan members who updated their own personal health record (PHR) during the 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 Members Updating PHRs

Description	The number of health plan members who updated either their own or someone else's personal health record (PHR), or both, 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 Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Members Viewing Others PHRs

Description	The number of health plan members who viewed personal health records (PHRs) belonging to members other than themselves during the period of analysis. This excludes members who only viewed their own PHR during the period; it does include members who viewed both their own and someone else's PHR during the 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 Viewing Own PHRs

Description	The number of health plan members who viewed their own personal health (PHR) record during the 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 Members Viewing PHRs

Description	The number of health plan members who viewed either their own or someone else's personal health record (PHR), or both, 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 Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Members Who Authorized Others To Update Their PHRs

Description	Number of health plan members who have had authorized one or more other members to update their own personal health record (PHR), under HIPAA privacy rules, as at the end of the analysis period. The authorization to update may have been granted directly by the member owning the PHR or by a competent authority, as per HIPAA legal requirements.
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 Who Authorized Others To View Their PHRs

Description	Number of health plan members who have had authorized one or more other members to view their own personal health record (PHR), under HIPAA privacy rules, as at the end of the analysis period. The authorization to view may have been granted directly by the member owning the PHR or by a competent authority, as per HIPAA legal requirements.
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 PHR Updates By Others

Description	Total number of updates of personal health record (PHR) belonging to others performed by health plan members during the period of analysis. Excludes updates of one's own PHR. Includes all updates of PHRs belonging to members other than the updating member, authorized under HIPAA Privacy rules, e.g. : - updates of PHRs belonging to member's dependents under 18 years of age - updates of the PHR belonging to the member's spouse, from whom the updating member has received permission - updating of PHRs belonging to members to whose PHRs the updating member has been granted access permission based on e.g. medical power of attorney, guardianship or other legal status to make medical decisions for that member
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 PHR Updates By Owners

Description	Number of updates of their own personal health record (PHR) performed by health plan members 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 PHR Viewings By Others

Description	Total number of viewings of personal health records (PHRs) belonging to others performed by health plan members during the period of analysis. Excludes views of one's own PHR. Includes all viewings of PHRs belonging to members other than the viewing member, authorized under HIPAA Privacy rules, e.g. : - viewings of PHRs belonging to member's dependents under 18 years of age - viewings of the PHR belonging to the member's spouse, from whom the viewing member has received permission - viewing of PHRs belonging to members to whose PHRs the viewing member has been granted access permission based on e.g. medical power of attorney, guardianship or other legal status to make medical decisions for that member
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 PHR Viewings By Owners

Description	Number of viewings of their own personal health record (PHR) performed by health plan members 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 PHR Views

Description	Number of personal health record (PHR) viewings performed by health plan members during the period of analysis. Includes both own and non-own PHR viewings. 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

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

Relationship Details

Member Personal Health Record Usage Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Member Personal Health Record Usage 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 Personal Health Record Usage Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Member Personal Health Record Usage 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 Personal Health Record Usage Analysis_Group Dimension_FK

Is Identifying Relationship	true
Child Table	Member Personal Health Record Usage 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 Personal Health Record Usage Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	Member Personal Health Record Usage 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 Personal Health Record Usage Analysis_Condition Dimension_FK

Is Identifying Relationship	true
Child Table	Member Personal Health Record Usage 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

Primary Key Details

Member Personal Health Record Usage Analysis PK

Key Attribute	Plan Member Dk
Key Attribute	Condition Dk
Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk
Key Attribute	Group Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model