Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Service Line Cost Analysis

Description

Analysis of cost accounting across various service lines of a healthcare organization such as LAB, OR, Radiology, ED and so on. Dimensions (and sample axes of analysis): - Calendar (Reporting Year) - Service Line (ED, LAB, OR) - Patient (Age, Gender, Smoker Status, BMI) - Health Insurer - Diagnosis Related Group - Practitioner - Provider - Order Set Dimension

Attributes

Adjustment Amount Per Visit

Amount of Uncovered Charges

Average Adjustments Per Visit

Average Charge Per Visit

Average Charge Per Visit With Order Set Use

Average Charge Per Visit Without Order Set Use

Average Cost Per Visit With Order Set Use

Average Cost Per Visit Without Order Set Use

Average Costs Per Day

Average Costs Per Visit

Average Direct Costs Per Visit

Average LOS Per Visit With Order Set Use

Average LOS Per Visit Without Order Set Use

Average Patient Charge Amount Per Visit

Average Payer Charge Amount Per Visit

Average Profit Per Visit

Average Profit Per Visit With Order Set Use

Average Profit Per Visit Without Order Set Use

Average Uncovered Charges Per Visit

Calendar Dk

Charge Of Visit With Order Set Use

Charge Of Visit Without Order Set Use

Charges Per Visit

Cost Of Visit With Order Set Use

Cost Of Visit Without Order Set Use

Diagnosis Related Group Dk

Direct Costs

Healthcare Insurer Dk

Indirect Costs

LOS With Order Set Use

LOS Without Order Set Use

Number Of 30 Day Readmissions With Order Set Use

Number Of 30 Day Readmissions Without Order Set Use

Number Of Visits

Number Of Visits With Order Set

Number Of Visits Without Order Set Use

Order Set Dk

Patient Charge Amount

Patient Dk

Payer Charge Amount

Percentage Of 30 Day Readmission With Order Set Use

Percentage Of 30 Day Readmission Without Order Set Use

Percentage Of Visits With Order Set Use

Practitioner Dk

Profit Per Visit

Profit With Order Set Use

Profit Without Order Set Use

Provider Dk

Service Days

Service Line Dk

Relationship

Service Line Cost Analysis _Service Line Dimension_FK

Service Line Cost Analysis _Healthcare Insurer Dimension_FK

Service Line Cost Analysis _Diagnosis Related Group Dimension_FK

Service Line Cost Analysis_Patient Dimension_FK

Service Line Cost Analysis _Practitioner Dimension_FK

Service Line Cost Analysis _Calendar Dimension_FK

Service Line Cost Analysis _Provider Dimension_FK

Service Line Cost Analysis _Order Set Dimension_FK

Primary Key

Service Line Cost Analysis PK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 Adjustment Amount Per Visit

Description	The total amount by which line items bills are changed before billing to to the patient or the payer. Adjustment amounts may be positive or negative but are typically used ton reduce the total charge after negotiation.
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

---

 Amount of Uncovered Charges

Description	The total amount of charges not covered by a payer, typically an insurer, for visits.
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 Adjustments Per Visit

Description	The average amount for claim line items bills which are not charged to the patient or the payer. 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 Charge Per Visit

Description	The average amount for charges on patient accounts. 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 Charge Per Visit With Order Set Use

Description	Average charged amount to the patient for visits where an order set was used. 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 Charge Per Visit Without Order Set Use

Description	Average charged amount to the patient for visits where an order set was not used. 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 Cost Per Visit With Order Set Use

Description	Average cost of visits where an order set was used. 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 Cost Per Visit Without Order Set Use

Description	Average cost of visits where an order set was not used. 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 Costs Per Day

Description	Average costs per day. Sum of Direct and indirect costs. Formula: [(A+B)/C)] (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 Costs Per Visit

Description	Average costs per visit. Sum of Direct and indirect costs. Formula: [(A+B)/C)] (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 Direct Costs Per Visit

Description	Average costs directly associated with an encounter. For example Direct costs can be Practitioner/Labor Costs (Surgeons,lab technicians,nurses salaries and wages) Materials costs (chemicals, consumables etc). 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 LOS Per Visit With Order Set Use

Description	The average length of stay for patients where an order set was used. 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 LOS Per Visit Without Order Set Use

Description	The average length of stay for patients where an order set was not used. 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 Patient Charge Amount Per Visit

Description	The average amount of charges billed directly to patient for an encounter. 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 Payer Charge Amount Per Visit

Description	The average amount of charges billed to a payer other than the patient, typically an insurer, for an encounter. 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 Profit Per Visit

Description	The Average profit generated by a visit 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 Profit Per Visit With Order Set Use

Description	Average profit generated by visits where an order set was used. 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 Profit Per Visit Without Order Set Use

Description	Average profit generated by visits where an order set was not used. 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 Uncovered Charges Per Visit

Description	The average amount for charges on patient accounts that are not covered by the payer. 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

---

 Charge Of Visit With Order Set Use

Description	The total charge to patients or payers (insurers) for visits where an order set is used.
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

---

 Charge Of Visit Without Order Set Use

Description	The total charge to patients or payers (insurers) for visits where an order set is not used.
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

---

 Charges Per Visit

Description	Total charges is the sum of all charges for visits within a period of analysis.
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

---

 Cost Of Visit With Order Set Use

Description	The total cost (direct+indirect) of visits where an order set is used.
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

---

 Cost Of Visit Without Order Set Use

Description	The total cost (direct+indirect) of visits where an order set is not used.
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

---

 Direct Costs

Description	The total costs directly associated with an encounter. For example: direct costs can be labor costs (surgeons,lab technicians,nurses salaries and wages), materials costs (medications, chemicals, consumables etc).
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

---

 Indirect Costs

Description	The total indirect costs within a period of analysis. The indirect costs are not directly associated with a visit and incur collectively for all the visits within a period of analysis. For Example: Maintenance Costs, Administrative costs, Depreciation, Facility costs etc.
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

---

 LOS With Order Set Use

Description	Length of stay where an order set is used.
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

---

 LOS Without Order Set Use

Description	Length of stay where an order set is not used.
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 30 Day Readmissions With Order Set Use

Description	Total number of admissions where the order set was used during the previous visit and the patients were readmitted within 30 days of discharge.
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 30 Day Readmissions Without Order Set Use

Description	Total number of visits within a period of analysis where order set is not used.
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 Visits

Description	Number of discharged encounters within a 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 Visits With Order Set

Description	Total number of visits within a period of analysis where order set is used.
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 Visits Without Order Set Use

Description	Total number of visits within a period of analysis where order set is not used.
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

---

 Order Set 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 Charge Amount

Description	The total amount of charges billed directly to the patient for visits within a period of analysis.
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

---

 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

---

 Payer Charge Amount

Description	The total amount of charges billed to a payer other than the patient, typically an insurer for visits within a period of analysis.
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 Of 30 Day Readmission With Order Set Use

Description	Rate of readmissions within 30 days of discharge where an order set was used during the encounter. 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 30 Day Readmission Without Order Set Use

Description	Rate of readmissions within 30 days of discharge where an order set was not used during the encounter. 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 Visits With Order Set Use

Description	The percentage of total visits where the order set has been used. 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

---

 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 Per Visit

Description	Total Profits is the sum of all the profits gained for providing health service within a period of analysis. This measure is the difference between charges billed for a visit and the total costs incurred. Formula: [(A - (B+C))] (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

---

 Profit With Order Set Use

Description	Total Profits is the sum of all the profits gained for providing health service when Order set is used. This measure is the difference between charges billed to a patient for a visit and the total costs incurred. 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

---

 Profit Without Order Set Use

Description	Total Profits is the sum of all the profits gained for providing health service when Order set is not used. This measure is the difference between charges billed to a patient for a visit and the total costs incurred. 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

---

 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 Days

Description	The number of days the service is provided within a 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

---

 Service Line 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

Relationship Details

 Service Line Cost Analysis _Service Line Dimension_FK

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

---

 Service Line Cost Analysis _Healthcare Insurer Dimension_FK

Is Identifying Relationship	true
Child Table	Service Line Cost 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

---

 Service Line Cost Analysis _Diagnosis Related Group Dimension_FK

Is Identifying Relationship	true
Child Table	Service Line Cost 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

---

 Service Line Cost Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Service Line Cost 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

---

 Service Line Cost Analysis _Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Service Line Cost 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

---

 Service Line Cost Analysis _Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Service Line Cost 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

---

 Service Line Cost Analysis _Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Service Line Cost 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

---

 Service Line Cost Analysis _Order Set Dimension_FK

Is Identifying Relationship	true
Child Table	Service Line Cost 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	Order Set 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

 Service Line Cost Analysis PK

Key Attribute	Service Line Dk
Key Attribute	Healthcare Insurer Dk
Key Attribute	Diagnosis Related Group Dk
Key Attribute	Patient Dk
Key Attribute	Practitioner Dk
Key Attribute	Provider Dk
Key Attribute	Order Set Dk
Key Attribute	Calendar Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model