Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Medical Equipment Utilization Analysis

Description

Scheduling of medical equipment resource captures information related to the utilization of these medical equipment resources. A resource could include equipment such as an MRI machine, CT , Xray, Lab equipment, surgery equipment and so on.

Attributes

Calendar Dk

Encounter Dk

Medical Equipment Dk

Number Of Available Minutes

Number Of Canceled Appointments

Number Of Completed Appointments

Number Of Deferred Appointments

Number Of Delayed Appointments

Number Of Missed Appointments

Number Of Scheduled Appointments

Number Of Scheduled Minutes

Number Of Scheduled Minutes Used

Number Of Unscheduled Minutes

Number Of Unscheduled Minutes Used

Patient Dk

Percentage Of Appointments Canceled

Percentage Of Appointments Completed

Percentage Of Appointments Deferred

Percentage Of Appointments Delayed

Percentage Of Appointments Missed

Percentage Of Available Time Utilized

Percentage Of Scheduled Time Utilized

Point Of Care Location Dk

Practitioner Dk

Provider Dk

Service Line Dk

Time Of Day Dk

Relationship

Medical Equipment Utilization Analysis_Encounter Dimension_FK

Medical Equipment Utilization Analysis_Calendar Dimension_FK

Medical Equipment Utilization Analysis_Time Of Day Dimension_FK

Medical Equipment Utilization Analysis_Service Line Dimension_FK

Medical Equipment Utilization Analysis_Point Of Care Location Dimension_FK

Medical Equipment Utilization Analysis_Provider Dimension_FK

Medical Equipment Utilization Analysis_Medical Equipment Dimension_FK

Medical Equipment Utilization Analysis_Patient Dimension_FK1

Medical Equipment Utilization Analysis_Practitioner Dimension_FK

Primary Key

Medical Equipment Utilization Analysis PK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 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

---

 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

---

 Medical Equipment 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 Available Minutes

Description	The total time (in minutes) for which the resource is available.
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 Canceled Appointments

Description	Number of appointments that have been canceled.
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 Completed Appointments

Description	Number of appointments that have been completed.
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 Deferred Appointments

Description	The number of appointments which are postponed indefinitely, the appointment goes ahead at a later date and time.
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 Delayed Appointments

Description	Number of appointments that have been delayed.
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 Missed Appointments

Description	Number of appointments where the patient did not show up.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Scheduled Appointments

Description	Number of appointments that have scheduled a resource.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Scheduled Minutes

Description	The time (in minutes) scheduled for a resource.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Scheduled Minutes Used

Description	The actual time (in minutes) out of scheduled time for which the resource has been 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 Unscheduled Minutes

Description	The time (in minutes) where there is no appointment made. 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

---

 Number Of Unscheduled Minutes Used

Description	The actual time (in minutes) out of unscheduled time for which the resource has been 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

---

 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 Of Appointments Canceled

Description	Percentage of appointments that have been canceled. 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 Appointments Completed

Description	Percentage of scheduled appointments which have been completed. 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 Appointments Deferred

Description	The percentage of appointments which are postponed indefinitely, the appointment goes ahead at a later date and time. 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 Appointments Delayed

Description	Percentage of appointments that have been delayed. 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 Appointments Missed

Description	Percentage of appointments where the patient did not show up. 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 Available Time Utilized

Description	The percentage of resource available time utilized for scheduled and unscheduled time. Formula: [((A+B)/C) * 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 Scheduled Time Utilized

Description	The percentage of scheduled time utilized for the appointment. Formula: [(A/B) * 100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Point Of Care Location Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Practitioner Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

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

---

 Time Of Day 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

 Medical Equipment Utilization Analysis_Encounter Dimension_FK

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

---

 Medical Equipment Utilization Analysis_Calendar Dimension_FK

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

---

 Medical Equipment Utilization Analysis_Time Of Day Dimension_FK

Is Identifying Relationship	true
Child Table	Medical Equipment 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	Time Of Day Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Medical Equipment Utilization Analysis_Service Line Dimension_FK

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

---

 Medical Equipment Utilization Analysis_Point Of Care Location Dimension_FK

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

---

 Medical Equipment Utilization Analysis_Provider Dimension_FK

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

---

 Medical Equipment Utilization Analysis_Medical Equipment Dimension_FK

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

---

 Medical Equipment Utilization Analysis_Patient Dimension_FK1

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

---

 Medical Equipment Utilization Analysis_Practitioner Dimension_FK

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

Primary Key Details

 Medical Equipment Utilization Analysis PK

Key Attribute	Provider Dk
Key Attribute	Patient Dk
Key Attribute	Encounter Dk
Key Attribute	Calendar Dk
Key Attribute	Time Of Day Dk
Key Attribute	Service Line Dk
Key Attribute	Practitioner Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Medical Equipment Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model