Dimensional Warehouse Model Data Model

Entity

Entity Provider PHR Usage Analysis

Description

Analysis of electronic personal health record (PHR) usage by healthcare providers.

Attributes
Average Number Of PHR Updates Per Updating Provider
Average Number Of PHR Viewings Per Viewing Provider
Calendar Dk
Geographic Area Dk
Number Of Emergency Department PHR Views
Number Of Members In Panel
Number Of PHRs In Panel
Number Of PHRs Updated
Number Of PHRs Viewed
Number Of PHR Viewings
Number Of Provider PHR Updates
Number Of Providers Updating PHRs
Number Of Providers Viewing PHRs
Practitioner Dk
Provider Dk
Ratio Of PHRs In Panel
Ratio Of PHRs Updated To PHRs In Panel
Ratio Of PHRs Viewed To PHRs In Panel

Relationship
Provider PHR Usage Analysis_Calendar Dimension_FK
Provider PHR Usage Analysis_Geographic Area Dimension_FK
Provider PHR Usage Analysis_Practitioner Dimension_FK
Provider PHR Usage Analysis_Provider Dimension_FK

Primary Key
Provider PHR Usage Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Average Number Of PHR Updates Per Updating Provider

Description	The average number of healthcare provider personal health record (PHR) updates per updating provider, averaged over all updating providers that performed PHR Updates during the period of analysis. The providers who have not updated any PHR during the period are excluded. 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 Viewings Per Viewing Provider

Description	The average number of personal health record (PHR) viewings per viewing provider, averaged over all viewing providers that performed PHR Viewings during the period of analysis. The providers who have not viewed any PHR during the period are excluded. 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

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

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

Number Of Emergency Department PHR Views

Description	The count of member personal health record (PHR) viewings performed by the Emergency Center 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 In Panel

Description	The number of health plan organization members assigned to a primary care practitioner (PCP), as at the end of the analysis period.
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 In Panel

Description	Number of personal health records (PHRs) created by health plan organization members assigned to the primary care practitioner's panel, that are still not closed/deleted as at the end of the analysis period.
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 Updated

Description	The count of distinct member personal health records (PHRs) updated at least once by the healthcare provider over the period of analysis (irrespective of how many times).
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 Viewed

Description	The count of personal health records (PHRs) viewed at least once by the healthcare provider over the period of analysis (irrespective of how many times).
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

Description	The count of personal health record (PHR) viewings performed by the healthcare provider 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 Provider PHR Updates

Description	The count of member personal health record (PHR) updates performed by the healthcare provider 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 Providers Updating PHRs

Description	The count of distinct healthcare providers who updated at least one of their patient's personal health record (PHR) at least once 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 Providers Viewing PHRs

Description	The count of distinct healthcare providers who viewed at least one of their patient's personal health record (PHR) at least once 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

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

Ratio Of PHRs In Panel

Description	Ratio of number of personal health records (PHRs) maintained by members in the PCP panel, active as at end of period of analysis, to number of members in PCP panel. 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 PHRs Updated To PHRs In Panel

Description	The ratio of personal health records (PHRs) updated by the primary care practitioner during the analysis period to the PHRs that had been created by members assigned to the PCP's panel and are not closed as at the end of the analysis period. 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 PHRs Viewed To PHRs In Panel

Description	The ratio of personal health records (PHRs) viewed by the primary care practitioner during the analysis period to the PHRs that had been created by members assigned to the PCP's panel and are not closed as at the end of the analysis period. 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

Provider PHR Usage Analysis_Calendar Dimension_FK

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

Provider PHR Usage Analysis_Geographic Area Dimension_FK

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

Provider PHR Usage Analysis_Practitioner Dimension_FK

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

Provider PHR Usage Analysis_Provider Dimension_FK

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

Provider PHR Usage Analysis PK

Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk
Key Attribute	Practitioner Dk
Key Attribute	Provider Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model