Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Referral Analysis

Description

Referral Analysis tracks inbound and outbound, as well as intra-system, referrals by reason code. It also calculates revenue leakage due to outbound referrals correlated to that reason code.

Attributes

Average Revenue Leakage Amount

Healthcare Insurer Dk

Number Of Acceptable Outbound Referrals

Number Of Inbound Referrals

Number Of Intra System Referrals

Number Of Outbound Referrals

Number Of Unacceptable Outbound Referrals

Origination Calendar Dk

Patient Dk

Percentage Acceptable Outbound Referrals

Percentage Unacceptable Outbound Referrals

Performed Calendar Dk

Performing Encounter Dk

Performing Organization Specialty Dk

Performing Practitioner Dk

Performing Practitioner Specialty Dk

Performing Provider Dk

Procedure Cost Amount

Referral Reason Dk

Referred Procedure Code Dk

Referring Encounter Dk

Referring Organization Specialty Dk

Referring Practitioner Dk

Referring Practitioner Specialty Dk

Referring Provider Dk

Relative Value Unit Amount

Revenue Leakage Amount

Relationship

Referral Analysis_Referring Provider Dimension_FK

Referral Analysis_Healthcare Insurer Dimension_FK

Referral Analysis_Procedure Code Dimension_FK

Referral Analysis_Origination Calendar Dimension_FK

Referral Analysis_Referral Reason Dimension_FK

Referral Analysis_Performing Practitioner Dimension_FK

Referral Analysis_Referring Organization Specialty Dimension_FK

Referral Analysis_Performed Calendar Dimension_FK

Referral Analysis_Referring Encounter Dimension_FK

Referral Analysis_Performing Organization Specialty Dimension_FK

Referral Analysis_Referring Practitioner Specialty Dimension_FK

Referral Analysis_Performing Encounter Dimension_FK

Referral Analysis_Patient Dimension_FK

Referral Analysis_Performing Provider Dimension_FK

Referral Analysis_Performing Practitioner Specialty Dimension_FK

Referral Analysis_Referring Practitioner Dimension_FK

Primary Key

Referral Analysis PK

Dependencies

Reverse Dependencies

Attribute Details

 Average Revenue Leakage Amount

Description	The average loss, per referral, of income to the healthcare organization due to patients being referred to a non-affiliated provider. 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

---

 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 Acceptable Outbound Referrals

Description	Outbound referrals that are deemed acceptable because of the nature of or reason for the referral. An acceptable referral reason might be where the healthcare specialty required is only available in the facility to which the patient is being referred.
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 Inbound Referrals

Description	A count of all patient referrals where the referring practitioner is outside the healthcare organization and the performing practitioner is affiliated with the healthcare organization.
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 Intra System Referrals

Description	A count of all patient referrals where the referring practitioner and the performing practitioner are both affiliated with the healthcare organization.
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 Outbound Referrals

Description	A counts of all patient referrals where the referring practitioner is within the healthcare organization and the performing practitioner is not affiliated with the healthcare organization.
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 Unacceptable Outbound Referrals

Description	Outbound referrals that are not deemed acceptable because of the nature of or reason for the referral. An unacceptable referral reason might be where the patient had to be referred because a bed is not available or a practitioner with the required specialty is absent, suspended or otherwise unavailable.
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

---

 Origination 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

---

 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 Acceptable Outbound Referrals

Description	The number of outbound referrals that are deemed acceptable expressed as a percentage of the total number of outbound referrals. 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 Unacceptable Outbound Referrals

Description	The number of outbound referrals that are deemed unacceptable expressed as a percentage of the total number of outbound referrals. 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

---

 Performed 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

---

 Performing 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

---

 Performing Organization Specialty 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

---

 Performing 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

---

 Performing Practitioner Specialty 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

---

 Performing 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

---

 Procedure Cost Amount

Description	The monetary value of the referred procedure based on either the standard price or the contracted price with the healthcare insurer.
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

---

 Referral Reason 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

---

 Referred 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

---

 Referring 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

---

 Referring Organization Specialty 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

---

 Referring 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

---

 Referring Practitioner Specialty 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

---

 Referring 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

---

 Relative Value Unit Amount

Description	The fee for each service based on its relative value units (RVUs), which rank on a common scale the resources used to provide each service. These resources include the physician’s work, the expenses of the physician’s practice, and professional liability insurance. To determine the Medicare fee, a service’s RVUs are multiplied by a dollar conversion factor
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

---

 Revenue Leakage Amount

Description	The monetary value of the procedure that is lost due to it being referred to a non-affiliated provider. The value is either the standard price or the contract price with the healthcare insurer.
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

 Referral Analysis_Referring Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	referring
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

---

 Referral Analysis_Healthcare Insurer Dimension_FK

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

---

 Referral Analysis_Procedure Code Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	referred for
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

---

 Referral Analysis_Origination Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	origination
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

---

 Referral Analysis_Referral Reason Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	primary
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	Referral Reason Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Referral Analysis_Performing Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	performing
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

---

 Referral Analysis_Referring Organization Specialty Dimension_FK

Is Identifying Relationship	false
Child Table	Referral Analysis
Child Role Name	referring
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	Organization Specialty Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Referral Analysis_Performed Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	performed
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

---

 Referral Analysis_Referring Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	referring
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

---

 Referral Analysis_Performing Organization Specialty Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	performing
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	Organization Specialty Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Referral Analysis_Referring Practitioner Specialty Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	referring
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 Specialty Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Referral Analysis_Performing Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	performing
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

---

 Referral Analysis_Patient Dimension_FK

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

---

 Referral Analysis_Performing Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	performing
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

---

 Referral Analysis_Performing Practitioner Specialty Dimension_FK

Is Identifying Relationship	true
Child Table	Referral Analysis
Child Role Name	performing
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 Specialty Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Referral Analysis_Referring Practitioner Dimension_FK

Is Identifying Relationship	false
Child Table	Referral Analysis
Child Role Name	referring
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

Primary Key Details

 Referral Analysis PK

Key Attribute	Patient Dk
Key Attribute	Referring Provider Dk
Key Attribute	Referring Encounter Dk
Key Attribute	Referring Practitioner Dk
Key Attribute	Healthcare Insurer Dk
Key Attribute	Referred Procedure Code Dk
Key Attribute	Referral Reason Dk
Key Attribute	Referring Organization Specialty Dk
Key Attribute	Referring Practitioner Specialty Dk
Key Attribute	Origination Calendar Dk
Key Attribute	Performing Practitioner Dk
Key Attribute	Performed Calendar Dk
Key Attribute	Performing Practitioner Specialty Dk
Key Attribute	Performing Organization Specialty Dk
Key Attribute	Performing Provider Dk
Key Attribute	Performing Encounter Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model