Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Radiology Department Performance Analysis

Description

Analysis of the performance and utilization of the radiology department of a Healthcare Organization. Radiology involves the use of imaging for diagnosis and treatment of a disease visualized within the human body. Radiologists use various imaging technologies such as X-ray radiography, ultrasound, computed tomography (CT), positron emission tomography (PET) and magnetic resonance imaging (MRI) to diagnose or treat diseases. Dimensions (and sample axes of analysis): - Calendar (Reporting Year) - Geographic Area (Region, State) - Patient (Age, Gender, Smoker Status, BMI) - Imaging Procedure (MRI,CT,Ultrasound) - Point of Care Location - Plan Member - Practitioner - Provider

Attributes

Average Duration Between Radiology Procedure End And Report Ready Time

Average Duration Between Radiology Procedure Order And Start Time

Average Duration Between Radiology Procedure Start And End Time

Average Number Of Patients Referred Daily For Radiology Procedures

Average Number Of Radiology Procedures Completed Per Day

Calendar Dk

Duration Between Radiology Procedures End And Report Time

Duration Between Radiology Procedures Order And Start Time

Duration Between Radiology Procedures Start And End Time

Encounter Dk

Imaging Procedure Dk

Number Of Patients Referred for Radiology Procedures

Number Of Patients With Completed Radiology Procedures

Number Of Radiology Preregistrations

Number Of Radiology Procedures Completed

Number Of Radiology Procedures Days

Number Of Radiology Procedures Ordered

Number Of Radiology Procedures Reported

Number Of Radiology Rescheduled Procedures

Number Of Registered Patients For Radiology Procedures

Number Of Scheduled Radiology Procedures

Number Of Scheduled Radiology Procedures Canceled

Number Of Scheduled Radiology Procedures Completed

Number Of Scheduled Radiology Procedures With No Show

Ordering Practitioner Dk

Patient Dk

Percentage Of Completed Scheduled Radiology Procedures

Percentage Of Patients Processed For Radiology Procedures

Percentage Of Radiology Preregistrations

Percentage Of Radiology Procedures Completed

Percentage Of Radiology Procedures Reported

Percentage Of Rescheduled Radiology Procedures

Percentage Of Scheduled Radiology Procedures Canceled

Percentage Of Scheduled Radiology Procedures With No Show

Performing Practitioner Dk

Point Of Care Location Dk

Provider Dk

Reporting Practitioner Dk

Relationship

Radiology Department Performance Analysis_Patient Dimension_FK

Radiology Department Performance Analysis_Calendar Dimension_FK

Radiology Department Performance Analysis_Point Of Care Location Dimension_FK

Radiology Department Performance Analysis_Provider Dimension_FK

Radiology Department Performance Analysis_Imaging Procedure Dimension_FK

Radiology Department Performance Analysis_Ordering Practitioner_FK

Radiology Department Performance Analysis_Performing Practitioner_FK

Radiology Department Performance Analysis_Reporting Practitioner_FK

Radiology Department Performance Analysis_Encounter Dimension_FK

Primary Key

Radiology Department Performance Analysis PK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 Average Duration Between Radiology Procedure End And Report Ready Time

Description	Average time interval (in minutes) between the imaging procedure end time and the time when radiologist has interpreted and prepared the report of the procedure. 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 Duration Between Radiology Procedure Order And Start Time

Description	Average Time interval (in minutes) between the radiology procedure order request and the procedures start time. 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 Duration Between Radiology Procedure Start And End Time

Description	Average Time interval (in minutes) between the radiology procedure start time and the procedure end time. 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 Number Of Patients Referred Daily For Radiology Procedures

Description	Average number of patients referred daily to the radiology department. 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 Number Of Radiology Procedures Completed Per Day

Description	The average number of radiology procedures completed and reported per day. 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

---

 Duration Between Radiology Procedures End And Report Time

Description	Time interval (in minutes) between the imaging procedure end time and the time when radiologist has prepared the report for the radiology procedure.This measure is the sum of the time intervals (in minutes) for all the procedures within a time period for 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

---

 Duration Between Radiology Procedures Order And Start Time

Description	Total Time interval (in minutes) between the radiology procedure order request and the procedures start time.This measure is the sum of the time intervals (in minutes) for all the procedures within a time period for 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

---

 Duration Between Radiology Procedures Start And End Time

Description	Time interval (in minutes) between the imaging procedure start time and the procedure end time.This measure is the sum of the time intervals (in minutes) for all the procedures within a time period for 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

---

 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

---

 Imaging Procedure 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 Patients Referred for Radiology Procedures

Description	Number of Patients refered to the radiology department for imaging procedures.
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 Patients With Completed Radiology Procedures

Description	Number of Patients with one or more completed imaging procedures such as Computed Tomography (CT) Imaging,Magnetic Resonance Imaging (MRI),Plain Radiography etc
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 Radiology Preregistrations

Description	Number of Preregistration of the radiology procedures where a patient's details (eg demographics, insurance details, next of kin) are captured electronically before the patient presents to the healthcare facility. The same information is verified at the point of registration
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 Radiology Procedures Completed

Description	Number of completed Procedures using Computed Tomography (CT) Imaging or Magnetic Resonance Imaging (MRI) or Plain Radiography etc
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 Radiology Procedures Days

Description	The number of days the radiology procedures were carried out across the modalities.
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 Radiology Procedures Ordered

Description	Number of Radiology Procedures Ordered. The Clinical orders include orders received for Computed Tomography (CT) Imaging or Magnetic Resonance Imaging (MRI) or Plain Radiography etc
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 Radiology Procedures Reported

Description	Number of reported radiology Procedures where a radiologist has interpreted the image scan and compiled a report.
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 Radiology Rescheduled Procedures

Description	Number of radiology procedures where the scheduled exam date or time or both was changed.
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 Registered Patients For Radiology Procedures

Description	Number of Patients who had completed the registration for one or more imaging procedures.
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 Radiology Procedures

Description	Number of procedures scheduled by the radiology department.
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 Radiology Procedures Canceled

Description	Number of scheduled radiology procedures where the procedure was 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 Scheduled Radiology Procedures Completed

Description	Number of scheduled procedures which has been completed by the radiology department.
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 Radiology Procedures With No Show

Description	The Number of scheduled radiology procedures where the patient did not show up for the scheduled radiology procedure.
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

---

 Ordering 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

---

 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 Completed Scheduled Radiology Procedures

Description	The percentage measure of scheduled radiology Procedures where the radiology exam was completed and reported. 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 Patients Processed For Radiology Procedures

Description	Percentage of registered patients who had completed one or more radiology procedures. Formula: [(A/B) * 100] (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

---

 Percentage Of Radiology Preregistrations

Description	The percentage measure of Preregistration of the Radiology Procedures where a patient's details (eg demographics, insurance details, next of kin) are captured electronically before the patient presents to the healthcare facility. The same information is verified at the point of registration. 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 Radiology Procedures Completed

Description	The percentage measure of completed radiology procedures where an image scan has been captured for an ordered procedure. 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 Radiology Procedures Reported

Description	The percentage measure of reported radiology Procedures where a radiologist has interpreted the image scan and compiled a report. 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 Rescheduled Radiology Procedures

Description	The percentage measure of radiology Procedures where the scheduled date or time or both was changed. 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 Scheduled Radiology Procedures Canceled

Description	The percentage measure of scheduled radiology Procedures where the procedure was 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 Scheduled Radiology Procedures With No Show

Description	The percentage measure of scheduled radiology Procedures where the patient did not show up for the scheduled radiology procedure. 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

---

 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

---

 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

---

 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

---

 Reporting 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

Relationship Details

 Radiology Department Performance Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Radiology Department Performance 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

---

 Radiology Department Performance Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Radiology Department Performance 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

---

 Radiology Department Performance Analysis_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	Radiology Department Performance 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

---

 Radiology Department Performance Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Radiology Department Performance 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

---

 Radiology Department Performance Analysis_Imaging Procedure Dimension_FK

Is Identifying Relationship	true
Child Table	Radiology Department Performance 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	Imaging Procedure Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Radiology Department Performance Analysis_Ordering Practitioner_FK

Is Identifying Relationship	true
Child Table	Radiology Department Performance 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

---

 Radiology Department Performance Analysis_Performing Practitioner_FK

Is Identifying Relationship	true
Child Table	Radiology Department Performance 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

---

 Radiology Department Performance Analysis_Reporting Practitioner_FK

Is Identifying Relationship	true
Child Table	Radiology Department Performance 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

---

 Radiology Department Performance Analysis_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	Radiology Department Performance 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

Primary Key Details

 Radiology Department Performance Analysis PK

Key Attribute	Patient Dk
Key Attribute	Calendar Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Provider Dk
Key Attribute	Imaging Procedure Dk
Key Attribute	Ordering Practitioner Dk
Key Attribute	Performing Practitioner Dk
Key Attribute	Reporting Practitioner Dk
Key Attribute	Encounter Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model