The Facility Excel Report provides CTDIvol, DLP, and SSDE data for your facility compared to the DIR registry and facilities with the same location type, facility type, Trauma Center Level, and in the same Census Division. This color-coded report provides the number of exams and percentiles, including medians, for dose indices with national and regional comparisons. It also provides trend reports for dose indices that shows changes in a dose index in your facility over time for a specific exam.
This report is provided on a quarterly basis and is available in the Aggregate Reports section of the DIR Reports menu.
A sample report is available here.
The About This Report tab provides important information, including a list of each table in the report.
There are three types of data reports:
The Body Part table summarizes all CTDIvol, DLP, and SSDE data for exams by body part in a single tab, benchmarked against similar facilities and the entire registry. This table is a comprehensive listing of data by scan and by exam and is designed to let you filter and analyze data quickly – e.g. compare SSDE per Exam across different body part exams.
The dose indices tabs show data for the most recent quarter for CTDIvol, DLP, and SSDE. There are two tabs per dose index: one by scan, and another for data across all scans in an exam, for a total of six tabs. You can filter and sort by any column and use the highlighted rows to identify outliers. The conditional formats are as follows:
If the facility median is greater than the 75th percentile of the DIR then the exam is color coded in orange.
If the median of your facility is less than the DIR 25th percentile value then the exam is color coded in blue.
Rows with median values falling between the 25th and 75th percentiles are highlighted in tan.
Trend tabs show data by quarter, for just your facility, so you can see how percentiles and medians change over time. This is especially useful for a PQI project or protocol optimization initiative.
There are two additional tables that provide reference data for the report:
The Short Name RPID Lookup table shows the mapping of RPIDs, assigned by other DIR facilities, to the report Short Name displayed in the report.
The Study Description RPID Lookup table lists the exam name mapping for each Study Description for your facility.
Master Facility Excel Reports
Facilities with a Master-Child hierarchy receive an additional Master Facility Excel report listing data for each site and for all sites combined. Comparison benchmarks and conditional formatting are provided using the entire registry, and trend data are provided for all sites combined.
||Previous: Leapfrog Report
||Next: Standardized Dose Index Reports