Dimensional Warehouse Model Data Model

Entity

Entity Provider Revenue Cycle Analysis

Description

The analysis of the overall performance of providers and physicians in terms of managing their billings and receiving payments. A range of measure and dimensions track the timing of providing healthcare services and subsequently billing for such services and being paid for them. These insights can be used to identify where delays are occurring and to remedy such delays by introducing new practices or improving supporting services.

Attributes
Average Practitioner Claims Paid Amount
Average Practitioner Claims Submitted Amount
Average Service To Billing Duration
Average Service To Claim Duration
Average Service To Final Adjudication Duration
Average Service To Payment Duration
Calendar Dk
Claims Paid Amount
Claims Paid Within 120 Days Amount
Claims Paid Within 30 Days Amount
Claims Paid Within 60 Days Amount
Claims Paid Within 90 Days Amount
Claims Submitted Amount
Claims Unpaid After 120 Days Amount
Diagnosis Related Group Dk
Healthcare Insurer Dk
Number Of Claims
Number Of Claims Adjusted
Number Of Claims Paid Within 120 Days
Number Of Claims Paid Within 30 Days
Number Of Claims Paid Within 60 Days
Number Of Claims Paid Within 90 Days
Number Of Claims Passed First Time
Number Of Claims Repriced
Number Of Claims Unpaid After 120 Days
Number Of Practitioners
Percentage Claims Adjusted
Percentage Claims Paid Within 120 Days
Percentage Claims Paid Within 30 Days
Percentage Claims Paid Within 60 Days
Percentage Claims Paid Within 90 Days
Percentage Claims Passed First Time
Percentage Claims Repriced
Percentage Claims Unpaid After 120 Days
Percentage Claims Value Paid
Percentage Claims Value Paid Within 120 Days
Percentage Claims Value Paid Within 30 Days
Percentage Claims Value Paid Within 60 Days
Percentage Claims Value Paid Within 90 Days
Percentage Claims Value Unpaid After 120 Days
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Service Dk
Service To Billing Duration
Service To Claim Duration
Service To Final Adjudication Duration
Service To Payment Duration

Relationship
Provider Revenue Cycle Analysis_Provider Dimension_FK
Provider Revenue Cycle Analysis_Practitioner Dimension_FK
Provider Revenue Cycle Analysis_Point Of Care Location Dimension_FK
Provider Revenue Cycle Analysis_Healthcare Insurer Dimension_FK
Provider Revenue Cycle Analysis_Calendar Dimension_FK
Provider Revenue Cycle Analysis_Diagnosis Related Group Dimension_FK
Provider Revenue Cycle Analysis_Service Dimension_FK

Primary Key
Provider Revenue Cycle Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Average Practitioner Claims Paid Amount

Description	The average monetary value of claims settled by practitioners being the overall value of claim payments included in the analysis divided by the number of practitioners involved. This provides a comparative value for assessing the performance of individual practitioners in generating cash flow. 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 Practitioner Claims Submitted Amount

Description	The average monetary value claimed by practitioners being the overall value of claims included in the analysis divided by the number of practitioners involved. This provides a comparative value for assessing the performance of individual practitioners in generating billable revenue. 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 Service To Billing Duration

Description	The average time lag expressed in days between the completion of a billable service and the coding and billing of that service. The average is based on the number of claims included in the analysis. 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 Service To Claim Duration

Description	The average time lag expressed in days between the completion of a billable service and the issuing of a claim for that service. The average is based on the number of claims included in the analysis. 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 Service To Final Adjudication Duration

Description	The average time lag expressed in days between the completion of a billable service and the final adjudication of a claim for that service by a health insurer. The average is based on the number of claims included in the analysis. 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 Service To Payment Duration

Description	The average time lag expressed in days between the completion of a billable service and the settlement of a claim for that service. The average is based on the number of claims included in the analysis. 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

Claims Paid Amount

Description	The monetary amount of all payments made in settlement of claims by payers.
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

Claims Paid Within 120 Days Amount

Description	The monetary amount of all claim payments made within 120 days of the date of claim issue. Note that depending on the analytical requirements of the organization this measure may relate to all claims settled within 90 days or only to those settled between 91 days and 120 days.
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

Claims Paid Within 30 Days Amount

Description	The monetary amount of all claim payments made within 30 days of the date of claim issue.
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

Claims Paid Within 60 Days Amount

Description	The monetary amount of all claim payments made within 60 days of the date of claim issue. Note that depending on the analytical requirements of the organization this measure may relate to all claims settled within 60 days or only to those settled between 31 days and 60 days.
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

Claims Paid Within 90 Days Amount

Description	The monetary amount of all claim payments made within 90 days of the date of claim issue. Note that depending on the analytical requirements of the organization this measure may relate to all claims settled within 90 days or only to those settled between 61 days and 90 days.
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

Claims Submitted Amount

Description	The monetary amount claimed from payers in respect of healthcare services.
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

Claims Unpaid After 120 Days Amount

Description	The monetary amount of all claims that remain outstanding 120 days after the date of claim issue. Note that this period of 120 days or some other period may be considered by the provider organization to be the limit after which claims are effectively unrecoverable and may have to be written off or reclassified as bad debts.
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

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

Healthcare Insurer 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 Claims

Description	A count of claims submitted by health care providers.
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 Claims Adjusted

Description	A count of the claims that were adjusted after issue and before being cleared for payment by healthcare insurers. Adjustments to claims after issue typically reduce the value of the claim and therefore impact the profitability of the provider. Adjustments also introduce additional administrative effort, costs and delays.
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 Claims Paid Within 120 Days

Description	A count of claims that are settled within 120 days of issue. Note that depending on the analytical requirements of the organization this measure may relate to all claims settled within 120 days or only to those settled between 91 days and 120 days.
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 Claims Paid Within 30 Days

Description	A count of claims that are settled within 30 days of issue.
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 Claims Paid Within 60 Days

Description	A count of claims that are settled within 60 days of issue. Note that depending on the analytical requirements of the organization this measure may relate to all claims settled within 60 days or only to those settled between 31 days and 60 days.
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 Claims Paid Within 90 Days

Description	A count of claims that are settled within 90 days of issue. Note that depending on the analytical requirements of the organization this measure may relate to all claims settled within 90 days or only to those settled between 61 days and 90 days.
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 Claims Passed First Time

Description	A count of the claims that were cleared for payment by healthcare insurers without any queries, clarifications, repricing or other manual interventions. Claims passed without intervention suggest that good practices are in place in the coding and billing of services. This wil speed the payment process and reduce the overall administrative cost, thereby delivering improved cash flow and profitability.
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 Claims Repriced

Description	A count of the claims that were repriced after issue and before being cleared for payment by healthcare insurers. Adjustments to claims after issue typically reduce the value of the claim and therefore impact the profitability of the provider. Adjustments also introduce additional administrative effort, costs and delays.
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 Claims Unpaid After 120 Days

Description	A count of claims that remain outstanding 120 days after issue. Note that this period of 120 days or some other period may be considered by the provider organization to be the limit after which claims are effectively unrecoverable and may have to be written off or reclassified as bad debts.
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

Percentage Claims Adjusted

Description	A count of the claims that were adjusted after issue and before being cleared for payment by healthcare insurers expressed as a percentage of the overall number of claims. 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 Claims Paid Within 120 Days

Description	A count of the claims that were settled by healthcare insurers within 120 days of their date of issue expressed as a percentage of the number of claims involved. 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 Claims Paid Within 30 Days

Description	A count of the claims that were settled by healthcare insurers within 30 days of their date of issue expressed as a percentage of the number of claims involved. 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 Claims Paid Within 60 Days

Description	A count of the claims that were settled by healthcare insurers within 60 days of their date of issue expressed as a percentage of the number of claims involved. 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 Claims Paid Within 90 Days

Description	A count of the claims that were settled by healthcare insurers within 90 days of their date of issue expressed as a percentage of the number of claims involved. 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 Claims Passed First Time

Description	A count of the claims that were cleared for payment by healthcare insurers without manual interventions expressed as a percentage of the number of claims involved. 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 Claims Repriced

Description	A count of the claims that were repriced after issue and before being cleared for payment by healthcare insurers expressed as a percentage of the overall number of claims. 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 Claims Unpaid After 120 Days

Description	A count of the claims that remain outstanding 120 days after their date of issue expressed as a percentage of the number of claims involved. 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 Claims Value Paid

Description	The monetary amount of all payments made in settlement of claims expressed as a percentage of the monetary value of claims submitted. This measure indicates how accurate the pricing and billing of services is in respect of coverage agreements. If the analysis is restricted to include the submitted and paid values only of claims that have actually been paid, the result will not be distorted by payment lag times. 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 Claims Value Paid Within 120 Days

Description	The monetary value of claim settlements made within 120 days of the date of claim issue expressed as a percentage of the monetary value of claims issued. Formula: [(A/B)*100] (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

Percentage Claims Value Paid Within 30 Days

Description	The monetary value of claim settlements made within 30 days of the date of claim issue expressed as a percentage of the monetary value of claims issued. Formula: [(A/B)*100] (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

Percentage Claims Value Paid Within 60 Days

Description	The monetary value of claim settlements made within 60 days of the date of claim issue expressed as a percentage of the monetary value of claims issued. Formula: [(A/B)*100] (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

Percentage Claims Value Paid Within 90 Days

Description	The monetary value of claim settlements made within 90 days of the date of claim issue expressed as a percentage of the monetary value of claims issued. Formula: [(A/B)*100] (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

Percentage Claims Value Unpaid After 120 Days

Description	The monetary value of claims that remain outstanding 120 days after the date of claim issue expressed as a percentage of the monetary value of claims issued. Formula: [(A/B)*100] (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

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

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

Service 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

Service To Billing Duration

Description	The time lag expressed in days between the completion of a billable service and the coding and billing of that service. Long delays in the preparation of service bills negatively impact on the healthcare organization's cash flow and profitability. Delays can be the result of poor administrative practice at a systemic level or at the level of individual practitioners.
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

Service To Claim Duration

Description	The time lag expressed in days between the completion of a billable service and the issuing of a claim for that service. Long delays in the issuing of claims negatively impact on the healthcare organization's cash flow and profitability.
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

Service To Final Adjudication Duration

Description	The time lag expressed in days between the completion of a billable service and the final adjudication of a claim for that service by a health insurer. This period covers all of the time taken to prepare, code and issue claims as well as the time taken to follow up on any queries or repricing.
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

Service To Payment Duration

Description	The time lag expressed in days between the completion of a billable service and the settlement of a claim for that service.
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

Relationship Details

Provider Revenue Cycle Analysis_Provider Dimension_FK

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

Provider Revenue Cycle Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Provider Revenue Cycle 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 Revenue Cycle Analysis_Point Of Care Location Dimension_FK

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

Provider Revenue Cycle Analysis_Healthcare Insurer Dimension_FK

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

Provider Revenue Cycle Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Provider Revenue Cycle 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 Revenue Cycle Analysis_Diagnosis Related Group Dimension_FK

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

Provider Revenue Cycle Analysis_Service Dimension_FK

Is Identifying Relationship	true
Child Table	Provider Revenue Cycle 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	Service 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 Revenue Cycle Analysis PK

Key Attribute	Provider Dk
Key Attribute	Practitioner Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Healthcare Insurer Dk
Key Attribute	Calendar Dk
Key Attribute	Diagnosis Related Group Dk
Key Attribute	Service Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model