The Facility Excel Report provides CTDIvol, Dose Length Product (DLP), and Size-Specific Dose Estimate (SSDE) data for your facility and corporate account compared to all DIR sites and facilities with the same location type, facility type, Trauma Center Level, and in the same Census Division. Refer to DIR Comparison Reports for a general overview of the data contained in the report.
This report is available from the Aggregate Reports link under the Facility Management menu.
The Facility Excel Report provides data in a format suitable for download in .CSV format, using a layout similar to the former Excel reports that were published quarterly. In addition to the About this Report tab, the report contains three tabs of data
DIR Measures – contains facility statistics with comparisons to all DIR sites for each Short Name and Age Group, as well as comparison data for one other selected Peer Group (e.g. sites in the same Census Division)
Trend Data – contains all historical data for a selected facility, without comparisons. Data may be aggregated by monthly, quarterly, or semiannual time periods.
Short Name Lookups – displays how a facility’s RPIDs map to the Short Name values in the report, as well as how RPIDs for the comparison data set map to Short Names. This tab also contains the facility’s exam name mappings, i.e. how each study description maps to each RPID for the facility.
To generate a report, select a facility from the Facility filter. By default, the report shows data for Q1 of the most recent year available.
The table displays the number of exams and the measure percentiles for the facility by Body Part, Short Name, and Age Group. The facility data columns are followed by the data for all DIR sites and for one peer group. By default, sites with the same location type are displayed.
Note: If there are insufficient registry data to provide meaningful comparisons, the code -9 appears in the DIR Standing column and comparison data for all DIR sites and peer groups are not displayed.
The DIR Standing column provides a code value to denote the result of comparing the facility median value with the percentiles for all DIR sites – e.g. a value of 25 indicates the facility median falls below the registry 25th percentile, 50 indicates the facility median is between the registry 25th and 75th percentiles, etc. See Percentiles and Comparisons for details. You can also hover over the iconfor more information.
Note: The DIR Standing code value -999 indicates exams exist but Size-Specific Dose Estimate (SSDE) measures are not available for the body part. SSDE is calculated for torso body parts only.
To download the report, click the Download icon, in the lower right corner, then select Crosstab.
Note: If the Crosstab option is greyed out, click in the white space above the table column headers, then click the Download icon again.
Several report filters are available to refine the data displayed. In addition to the Study Year filter, the Time Periods and Selected Period filters can be used to change the time frame of data displayed for the facility. Possible Time Periods include Semiannual, Quarterly, and Monthly. The possible values in Selected Period change automatically, based on the Time Periods selection.
Use the Show Data By filter to show data by exam Short Name or by Body Part. Use the remaining filters to focus on specific DIR Measures, Peer Groups, Short Names, Body Parts, and Age Groups.
Note: The Short Name filter will be blank when Show Data By is set to Body Part.
Exams from a fixed six-month timeframe are used for all comparison groups, including All DIR Sites (registry) and various peer groups (e.g. sites within the same Census Division). The comparison time period is displayed in the report title.
Short Name Lookups
The Short Name Lookups tab lists the each RPID and the Short Name to which it is mapped for the facility and reporting period. The facility’s Study Description is also displayed, reflecting the exam name mapping created for the facility.
To see the RPIDs for a specific Short Name, click on the Short Name from the DIR Measures tab, then click on the Look Up Short Name link.