Dimensional Warehouse Model Data Model

Entity

Entity Physician Productivity Analysis

Description

The analysis of the overall performance of the physicians in terms of care provided to patients and the time taken to provide such care. A wide variety of dimensions allow the healthcare organization to easily correlate many different factors to better understand the impact of factors such as case complexity and patient condition on performance measures. These insights can then be used to develop appropriate training or to suggest changes in facilities and supporting services.

Attributes
Actual Charge Amount
Aggregate Procedure Complexity Score
Average Actual Charge Amount Per Practitioner
Average Number Of Procedure RVUs Per Practitioner
Average Number Of Procedures Per Practitioner
Average Procedure Complexity Score
Average RVU Equivalent Charge Amount Per Practitioner
Calendar Dk
Diagnosis Related Group Dk
Encounter Dk
Number Of Clerical Hours
Number Of Other Professional Hours
Number Of Performed Procedure RVUs
Number Of Practitioners
Number Of Procedure Hours
Number Of Procedures Performed
Number Of Procedures With Comorbidities
Number Of Scheduled Duty Hours
Number Of Unaccounted Hours
Patient Dk
Percentage Clerical Time
Percentage Of Procedures With Comorbidities
Percentage Other Professional Time
Percentage Procedure Time
Percentage Unaccounted Time
Point Of Care Location Dk
Practitioner Dk
Procedure Code Dk
RVU Equivalent Charge Amount

Relationship
Physician Productivity Analysis_Point Of Care Location Dimension_FK
Physician Productivity Analysis_Diagnosis Related Group Dimension_FK
Physician Productivity Analysis_Procedure Code Dimension_FK
Physician Productivity Analysis_Encounter Dimension_FK
Physician Productivity Analysis_Practitioner Dimension_FK
Physician Productivity Analysis_Patient Dimension_FK
Physician Productivity Analysis_Calendar Dimension_FK

Primary Key
Physician Productivity Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Actual Charge Amount

Description	The monetary amount that is actually charged for the procedures performed. This can include the amount charged to the patient directly and any amounts charged to other payers such as health insurers.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Aggregate Procedure Complexity Score

Description	The total case complexity scores for all cases included in the analysis. This gives an approximation of the caseload adjusted by a weighting factor where the same type of procedure maybe more or less difficult depending on factors such as the patient's age, weight and general health.
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Actual Charge Amount Per Practitioner

Description	The average monetary value charged by practitioners for procedures included in the analysis being the actual charge amount divided by the number of practitioners. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Number Of Procedure RVUs Per Practitioner

Description	The calculated average number of performed procedure relative value units (RVU) performed by practitioners being the overall number of RVUs divided by the number of practitioners involved. This measure can be used as a basis for comparing the relative productivity of individual healthcare practitioners. The use of the relative value unit equivalents for procedures largely eliminates the problem of comparing the performance of practitioners involved in different specialties. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Number Of Procedures Per Practitioner

Description	The calculated average number of procedures performed by practitioners being the overall number of procedures divided by the number of practitioners involved. This measure can be used as a basis for comparing the relative productivity of individual healthcare practitioners. It is important, however, to ensure that the nature of the procedures included in such analysis is comparable. Comparing the number od major surgeries performed by a heart surgeon against an average procedure count based on large volume data such as lab tests performed has little analytical value. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Procedure Complexity Score

Description	The calculated average case complexity scores for all cases included in the analysis being the aggregate procedure complexity score divided by the number of procedures performed. This allows for more meaningful comparison of case loads across physicians or facilities allowing for thier relative complexity and for the trending over time of the nature of cases being encountered. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average RVU Equivalent Charge Amount Per Practitioner

Description	The average monetary value that would be charged for procedures performed based on the Relative Value Unit charging scheme being the RVU equivalent charge amount divided by the number of practitioners. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
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

Diagnosis Related 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

Encounter 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 Clerical Hours

Description	A count of the hours spent by healthcare practitioners in general clerical and administrative activities. These might include assisting with billing and coding queries as well as any in house time recording.
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 Other Professional Hours

Description	A count of the hours spent by healthcare practitioners in other professional activities. These might include teaching or mentoring other healthcare practitioners, attending further professional training and development, consulting on patient cases and attending case meetings. It would typically exclude basic clerical activities.
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 Performed Procedure RVUs

Description	A count of the number relative value units (RVU) equivalent to the healthcare procedures performed. RVUs allow procedures of different scale and complexity to be compared by attributing a number of "relative units" to each type of procedure. Therefore a procedure such as a major surgery will have much greater number of relative value units than a simple procedure such as the administration of an annual flu immunization.
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 Practitioners

Description	A count of the healthcare practitioners included in the 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 Procedure Hours

Description	The duration expressed in hours of time spent by practitioners in the performance of procedures. This measures the time a practitioner is actively engaged in the performance of healthcare tasks.
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 Procedures Performed

Description	A count of the number of healthcare procedures performed.
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 Procedures With Comorbidities

Description	A count of the number of procedures performed where the patient had one or more chronic conditions other than the condition being addressed by the procedure.
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 Scheduled Duty Hours

Description	A count of the number of hours that practitioners have been rostered or scheduled for duty in a healthcare environment such as a hospital or consulting office.
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 Unaccounted Hours

Description	A count of the number of hours that practitioners have been rostered or scheduled for duty but cannot attribute to any specific activity. This might be considered idle time. Formula: [A-(B+C+D)] (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

Patient 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

Percentage Clerical Time

Description	The amount of time practitioners spend on general clerical or administrative tasks expressed as a percentage of the amount of time they have been rostered or scheduled for duty. A high percentage here may indicate that practitioners are working in a poorly organized manner or environment that is negatively impacting their primary function. Formula: [(A/B)*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 Procedures With Comorbidities

Description	The number of procedures performed where the patient had one or more chronic conditions other than the condition being addressed by the procedure expressed as a percentage og the number pf procedures performed. Formula: [(A/B)*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 Other Professional Time

Description	The amount of time practitioners are engaged in professional activities other than healthcare procedures expressed as a percentage of the amount of time they have been rostered or scheduled for duty. A high percentage here may indicate that practitioners have a high scheduled or unscheduled workload outside of their primary function. Formula: [(A/B)*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 Procedure Time

Description	The amount of time practitioners spend performing healthcare procedures expressed as a percentage of the amount of time they have been rostered or scheduled for duty. A high percentage here indicates that practitioners are able to efficiently allocate their time to their primary function. Formula: [(A/B)*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 Unaccounted Time

Description	The amount of time practitioners are unable to account for expressed as a percentage of the amount of time they have been rostered or scheduled for duty. A high percentage here may indicate poor work practices, poor administrative systems or possibly an occasional low demand for the practitioners' services. Formula: [(A/B)*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

Point Of Care Location 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

Procedure Code 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

RVU Equivalent Charge Amount

Description	The monetary amount that would be charged for procedures performed based on the Relative Value Unit charging scheme. This value will give a more comparable revenue value for estimating relative productivity as it eliminates distortions caused by special pricing arrangements.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Physician Productivity Analysis_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	Physician Productivity 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	Point Of Care Location Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Physician Productivity Analysis_Diagnosis Related Group Dimension_FK

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

Physician Productivity Analysis_Procedure Code Dimension_FK

Is Identifying Relationship	true
Child Table	Physician Productivity 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	Procedure Code Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Physician Productivity Analysis_Encounter Dimension_FK

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

Physician Productivity Analysis_Practitioner Dimension_FK

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

Physician Productivity Analysis_Patient Dimension_FK

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

Physician Productivity Analysis_Calendar Dimension_FK

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

Primary Key Details

Physician Productivity Analysis PK

Key Attribute	Practitioner Dk
Key Attribute	Patient Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Encounter Dk
Key Attribute	Procedure Code Dk
Key Attribute	Calendar Dk
Key Attribute	Diagnosis Related Group Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model