Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Labor Utilization Analysis

Description

Labor Utilization metrics are typically comprised of hours worked and expense incurred for various jobs and payroll categories. They can be used to understand labor allocation and budgeting.

Attributes

Account Dk

Account Entry Dk

Average Hrly Rate Lab Exp Tot Pd Rt

Average Monthly Volume Rt

Expense Adjusted Discharge Demographics Rt

Expense Adjusted Discharges CMI Demographics Rt

Expense Dollar Labor Num

Expense Dollar Other Num

Expense Dollar Supply Num

Expense Labor Num

Expense Other Num

Expense Per Adjusted Discharge CMI Labor Rt

Expense Per Adjusted Discharge CMI Other Rt

Expense Per Adjusted Discharge CMI Supply Rt

Expense Per Adjusted Discharge Labor Rt

Expense Per Adjusted Discharge Other Rt

Expense Per Adjusted Discharge Supply Rt

Expense Supply Num

Expense Total Num

FTE Paid Rt

FTE Worked Rt

Hours Agency Num

Hours Education Num

Hours Holiday Num

Hours Other Num

Hours Overtime Num

Hours Per Unit Paid Rt

Hours Per Unit Worked Rt

Hours Regular Num

Hours Sick Num

Hours Total Paid Time Off Num

Hours Total Worked Num

Hours Vacation Num

Information Services Expense As Percent of Total Expense Rt

Job Dk

Liquidity Leverage Gross Days in A/R Rt

Liquidity Leverage Long Term Debt to Equity Rto

Measure Definition Dk

Operating ALOS - CMI Rt

Operating ALOS Rt

Operating Average Daily Census Rt

Operating CMI Rt

Operating FTE / AOB - CMI Rt

Operating FTE / AOB Rt

Operating Overtime Percent Rt

Operating Paid FTE Rt

Operating Total Discharges Rt

Percent Benefit Rt

Percent Overtime Rt

Posted Calendar Dk

Practitioner Dk

Profit Acid Test Rto

Profit Current Ratio Rto

Profit Operating Profit Margin Rt

Profit Total Profit Margin Rt

Revenue Bad Debt Rt

Revenue Contractual Allowance Rt

Revenue Outpatient Rt

Total Expense Per Adjusted Discharge Rt

Total Expense Per Adjusted Disch CMI Rt

Relationship

Labor Utilization Analysis_Measure Dimension_FK

Labor Utilization Analysis_Practitioner Dimension_FK

Labor Utilization Analysis_Account Dimension_FK

Labor Utilization Analysis_Account Entry Fact_FK

Labor Utilization Analysis_Job Dimension_FK

Primary Key

Labor Utilization Analysis PK

Dependencies

Reverse Dependencies

Attribute Details

 Account 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

---

 Account Entry 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

---

 Average Hrly Rate Lab Exp Tot Pd Rt

Label	Average Hrly Rate(Lab Exp/Tot Pd)$
Description	calculation is within the business name
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Average Monthly Volume Rt

Label	Average Monthly Volume
Description	Sum of the volume for the three months in the quarter divided by 3
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Adjusted Discharge Demographics Rt

Label	Demographics Expense Adjusted Discharges
Description	Total Discharges / (1 - (Gross Outpatient Revenue / Gross Patient Revenue))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Adjusted Discharges CMI Demographics Rt

Label	Demographics Expense Adjusted Discharges - CMI
Description	CMI * (Total Discharges / (1 - (Gross Outpatient Revenue / Gross Patient Revenue)))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Dollar Labor Num

Label	Labor Expense Dollar
Description	total dollars for expenses mapped to the owning organization's definition of labor expense
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Dollar Other Num

Label	Other Expense Dollar
Description	total dollars for expenses mapped to the owning organization's definition of supply expense
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Dollar Supply Num

Label	Supply Expense Dollar
Description	total dollars for expenses mapped to the owning organization's definition of supply expense
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Labor Num

Label	Labor Expense
Description	Sum of Labor expense.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Other Num

Label	Other Expense
Description	Other expense category (basically all that isn't labor or supply expenses)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Per Adjusted Discharge CMI Labor Rt

Label	Labor Expense Per Adjusted Discharge - CMI
Description	Labor Expense / (CMI * (Total Discharges / (1 - (Gross Outpatient Revenue / Gross Patient Revenue)))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Per Adjusted Discharge CMI Other Rt

Label	Other Expense Per Adjusted Discharge - CMI
Description	Other Expense / (CMI * (Total Discharges / (1 - (Gross Outpatient Revenue / Gross Patient Revenue)))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Per Adjusted Discharge CMI Supply Rt

Label	Supply Expense Per Adjusted Discharge - CMI
Description	Supply Expense / (CMI * (Total Discharges / (1 - (Gross Outpatient Revenue / Gross Patient Revenue)))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Per Adjusted Discharge Labor Rt

Label	Labor Expense Per Adjusted Discharge
Description	Labor Expense / (Total Discharges / (1 - (Gross Outpatient Revenue / Gross Patient Revenue))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Per Adjusted Discharge Other Rt

Label	Other Expense Per Adjusted Discharge
Description	Other Expense / (Total Discharges / (1 - (Gross Outpatient Revenue / Gross Patient Revenue))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Per Adjusted Discharge Supply Rt

Label	Supply Expense Per Adjusted Discharge
Description	Supply Expense / (Total Discharges / (1 - (Gross Outpatient Revenue / Gross Patient Revenue))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Supply Num

Label	Supply Expense
Description	Sum of Supply expense category.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Expense Total Num

Label	Total Expense
Description	Sum of labor, supply, and other expense
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 FTE Paid Rt

Label	Paid FTE
Description	(Total Hours Paid In Quarter)/ ((2080 / 365) *Days in Quarter)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 FTE Worked Rt

Label	Worked FTE Num
Description	(Total Hours Worked In Quarter)/ ((2080 / 365) *Days in Quarter).
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Agency Num

Label	Agency Hours
Description	Sum of Agency Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Education Num

Label	Education Hours
Description	Sum of Education Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Holiday Num

Label	Holiday Hours
Description	Sum of Holiday Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Other Num

Label	Other Hours
Description	Sum of Other Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Overtime Num

Label	Overtime Hours
Description	Sum of Overtime Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Per Unit Paid Rt

Label	Paid Hours Per Unit
Description	sum of all the hours in the paid hours category divided by the total units for the period (where this can get a little "trickier" is when we deal with volumes that are considered fixed volumes and not cumulative/variable volumes. When dealing with the fixed volumes the definition varies slightly.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Per Unit Worked Rt

Label	Worked Hours Per Unit
Description	sum of all the hours in the worked hours category divided by the total units for the period (where this can get a little "trickier" is when we deal with volumes that are considered fixed volumes and not cumulative/variable volumes. When dealing with the fixed volumes the definition varies slightly.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Regular Num

Label	Regular Hours
Description	Sum of Regular Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Sick Num

Label	Sick Hours
Description	Sum of Sick Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Total Paid Time Off Num

Label	Total Paid Time Off Hours
Description	Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Total Worked Num

Label	Total Worked Hours
Description	Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Vacation Num

Label	Vacation Hours
Description	Sum of Vacation Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Information Services Expense As Percent of Total Expense Rt

Label	Information Services Expense as % of Total Expense
Description	Information Services Depreciation Expense / Total Operating Expense
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Job 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

---

 Liquidity Leverage Gross Days in A/R Rt

Label	Liquidity / Leverage Gross Days in A/R
Description	Gross Patient A/R / (Gross Patient Revenue / Days in Quarter)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Liquidity Leverage Long Term Debt to Equity Rto

Label	Liquidity / Leverage Long Term Debt to Equity Ratio
Description	Total Long Term Liabilities / Total Fund Balance
Data Type	Standards - Data Domains.ddm/Data Domains/Ratio [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Measure Definition 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

---

 Operating ALOS - CMI Rt

Label	Operating ALOS - CMI
Description	(Total Patient Days / Total Discharges) / Total Case Mix Index
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Operating ALOS Rt

Label	Operating ALOS
Description	Total Patient Days / Total Discharges
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Operating Average Daily Census Rt

Label	Operating Average Daily Census
Description	Total Patient Days / Days in Quarter
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Operating CMI Rt

Label	Operating CMI
Description	Case Mix Index
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Operating FTE / AOB - CMI Rt

Label	Operating FTE / AOB - CMI
Description	((Total Paid Hours / (Days in Quarter * 5.6986)) / (CMI * ((Total Patient Days / Days in Quarter) / (1 - (Gross Outpatient Revenue / Gross Patient Revenue))))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Operating FTE / AOB Rt

Label	Operating FTE / AOB
Description	((Total Paid Hours / (Days in Quarter * 5.6986)) / ((Total Patient Days / Days in Quarter) / (1 - (Gross Outpatient Revenue / Gross Patient Revenue)))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Operating Overtime Percent Rt

Label	Operating Overtime %
Description	Overtime Hours Worked of all Reported Departments / Paid Hours of all Reported Departments
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Operating Paid FTE Rt

Label	Operating Paid FTE
Description	Total Quarterly Paid Hours / (Days in Quarter * 5.6986)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Operating Total Discharges Rt

Label	Operating Total Discharges
Description	Total Discharges
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Percent Benefit Rt

Label	Benefit Percentage %
Description	benefit hours/total paid hours
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Percent Overtime Rt

Label	Overtime Percentage %
Description	overtime hours/total paid hours
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Posted 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	false
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

---

 Profit Acid Test Rto

Label	Profit Acid Test Ratio
Description	Cash & Cash Equivalents / Total Current Liabilities
Data Type	Standards - Data Domains.ddm/Data Domains/Ratio [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Profit Current Ratio Rto

Label	Profit Current Ratio
Description	Total Current Assets / Total Current Liabilities
Data Type	Standards - Data Domains.ddm/Data Domains/Ratio [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Profit Operating Profit Margin Rt

Label	Profit Operating Profit Margin %
Description	(Net Patient Revenue + Other Oper. Revenue - Total Oper. Expense) / (Net Patient Revenue + Other Oper.Revenue
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Profit Total Profit Margin Rt

Label	Profit Total Profit Margin %
Description	Net Profit / (Net Patient Revenue + Other Operating Revenue + Net Non-Operating Gains)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Revenue Bad Debt Rt

Label	Revenue Bad Debt %
Description	(Bad Debt Expense / Gross Patient Revenue) * 100
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Revenue Contractual Allowance Rt

Label	Revenue Contractual Allowance %
Description	(Total Deductions All Payors / Gross Patient Revenue) * 100
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Revenue Outpatient Rt

Label	Revenue Outpatient %
Description	(Gross Outpatient Revenue / Gross Patient Revenue) * 100
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Total Expense Per Adjusted Discharge Rt

Label	Total Expense Per Adjusted Disch
Description	Total Expense / (Total Discharges / (1 - (Gross Outpatient Revenue / Gross Patient Revenue))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Total Expense Per Adjusted Disch CMI Rt

Label	Total Exp Per Adjusted Disch. - CMI
Description	Total Expense / (CMI * (Total Discharges / (1 - (Gross Outpatient Revenue / Gross Patient Revenue)))
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

 Labor Utilization Analysis_Measure Dimension_FK

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

---

 Labor Utilization Analysis_Practitioner Dimension_FK

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

---

 Labor Utilization Analysis_Account Dimension_FK

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

---

 Labor Utilization Analysis_Account Entry Fact_FK

Is Identifying Relationship	true
Child Table	Labor Utilization 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	Account Entry Fact
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Labor Utilization Analysis_Job Dimension_FK

Is Identifying Relationship	true
Child Table	Labor Utilization 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	Job 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

 Labor Utilization Analysis PK

Key Attribute	Measure Definition Dk
Key Attribute	Practitioner Dk
Key Attribute	Account Dk
Key Attribute	Account Entry Dk
Key Attribute	Job Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model