Skip to main content
All CollectionsCapacity IQ®Capacity IQ® - Help ContentGuides to Access Reports
Guide to Accessing Capacity IQ® PreAdmit Application Reports
Guide to Accessing Capacity IQ® PreAdmit Application Reports
Ashley Ware avatar
Written by Ashley Ware
Updated over 2 weeks ago

Guide to Accessing PreAdmitTracking Application Reports

If you have one of the following permissions, you have access to a page that allows you to generate historical and statistical reports for the PreAdmitTracking® application.

If you do not have both of the following permissions, then some of the reports will not be available to you.

  • Run Any Reports, Including Those That Reveal Patient Information

  • Run Only Reports That Do Not Reveal Patient Information

The reports are listed under categories on the Report Selection page. Click the plus sign beside a category to display the report names. Then, click a report name to begin generating the report.

The following is an alphabetical listing of the reports, displaying the categories under which they are listed. Use this guide to quickly locate a report to generate.

To locate this report. . .

On the Report Selection page, click the plus sign beside this category>subcategory. . .

Assignment Timer Metrics

PreAdmitTracking>Analysis

Average Discharges/Transfers

PreAdmitTracking>Discharge/Transfer

Bed Priority Assignment by the Hour

PreAdmitTracking>Analysis

Bed Priority Assignment History

PreAdmitTracking>Analysis

Bed Wait Time Analysis with Milestones

PreAdmitTracking>Analysis

Census Analysis by Day of Week

PreAdmitTracking>Analysis

Census Analysis by Hour of Day

PreAdmitTracking>Analysis

Census Analysis by Month

PreAdmitTracking>Analysis

Census Analysis per 12-Week Period

PreAdmitTracking>Analysis

Census Analysis per Year

PreAdmitTracking>Analysis

Daily Transfers

PreAdmitTracking>Discharge/Transfer

Hold Audit Report Description

PreAdmitTracking>Analysis

Hold Compliance Report Description

PreAdmitTracking>Analysis

Milestone Delay

PreAdmitTracking>Analysis

Observation Compliance

PreAdmitTracking>Analysis

Occupied Timer Metrics

PreAdmitTracking>Analysis

Notification History

PreAdmitTracking>Analysis

Patient Attribute History

PreAdmitTracking>Analysis

Patient Isolation History

PreAdmitTracking>Analysis

Pending Status Compliance

PreAdmitTracking>Proper Pending

Physician Summary

PreAdmitTracking>Master

Processing Time Analysis

PreAdmitTracking>Analysis

Proper Pending Usage

PreAdmitTracking>Proper Pending

Ready to Move Timer Metrics

PreAdmitTracking>Analysis

Volume Analysis by Day of Week

PreAdmitTracking>Analysis

Volume Analysis by Hour of Day

PreAdmitTracking>Analysis

Weekly Discharges/Transfers

PreAdmitTracking>Discharge/Transfer

Generating PreAdmitTracking® Application Analysis Reports

About Analysis Reports

Analysis reports provide statistics, volume, and timing information about patient placements and the census. Examples of analysis reports are:

  • The Assignment Timer Metrics report

  • Census Analysis by Month report

  • Processing Time Analysis report

  • Volume Analysis by Day of Week report.

To generate an analysis report you:

  1. Select the report criteria.

  2. Select the output type and run the report.

Descriptions of each report are available in this help. In the table of contents, expand the Report Descriptions folder, and then the PreAdmitTracking® Application folder, locate the report description that you want to read, and then click the report description name.

Permissions

You must have at least one of the following permissions to generate an analysis report. Permissions vary by report. See the report descriptions.

  • Run Any Reports, Including Those that Reveal Patient Information

  • Run Only Reports that Do Not Reveal Patient Information

Selecting the Report Criteria

  1. On the Report Selection page, click the plus sign next to PreAdmitTracking, and then click the plus sign next to Analysis to display the available reports.

  2. Under Analysis, click one of the following to display a page for selecting report criteria:

    • Assignment Timer Metrics

    • Bed Assignment Priority by the Hour

    • Bed Assignment History

    • Bed Wait Time Analysis with Milestones

    • Census Analysis by Day of Week

    • Census Analysis by Hour of Day

    • Census Analysis by Month

    • Census Analysis per 12-Week Period

    • Census Analysis Per Year

    • Hold Audit

    • Hold Compliance

    • Milestone Delay Report

    • Notification History Report

    • Observation Compliance

    • Occupied Timer Metrics

    • Patient Attribute History

    • Patient Isolation History

    • Processing Time Analysis

    • Ready to Move Timer Metrics

    • Volume Analysis by Day of Week

    • Volume Analysis by Hour of Day

Selecting Report Criteria for Specific Reports

Assignment Timer Metrics

  • Group by: Data can be displayed by user who assigned the bed OR by the assigned unit or origin unit associated with the placement. Select Assigned by User, Assigned Unit or Origin Unit.

  • Unit: Select the units that should be included on the report. Click the magnifying glass next to the Units box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Units box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Units box. If you do not select any units, all units associated with the selected campus and to which you have membership will be included.

  • Request Date: To include only placements that have a requested date within a certain date range, select the date range.

    • Click the calendar icon next to the From box. Click the arrows at the top to select the month and year, and then click a date for the beginning of the range (for example, May 1, 2009).

    • Click the calendar icon next to the To box. Click the arrows at the top to select the month and year, and then click a date for the end of the range (for example, May 31, 2009).

  • Shift Time: To choose specific shifts to be included on the report, in the Start and End boxes, type the start and end times of the shifts. For example, to include the 8:00 AM to 3:59 PM AND the 4:00 PM to 11:59 PM shift, in the Start box, type 08:00 AM and in the End box, type 11:59 PM. If a shift starts on one date and ends on the next, the report will include data from the entire shift. If a shift starts on the last date of a date range ends one day later, data from the entire shift, including the part of the shift that is after the end date of the report, still will be on the report. A message appears indicating that a shift that crosses over the midnight boundary was selected and that the report end date will actually be the day after the selected end date.

    • Important Note: If you change the database selection after selecting dates, times, and other options, the dates and times that you selected will not change. However, other options will change and you will have to re-select them.

  • Include Standard Deviation?: To include standard deviation on the report, select Yes. Including standard deviation can be helpful if you want to examine variations from the average (for example, variations from the average time between bed assignment and placement request activation or target unit selection).

  • Summary View (Yes or No): To show a summary view of the report, select Yes. To show a detailed view, select No. The summary view displays total durations, average durations, group durations, and group standard deviations. The detailed view shows per unit or per user, detailed information such as the request time and the bed that was occupied.

Bed Assignment Priority by the Hour

  • Unit: Select the units that should be included on the report. Click the magnifying glass next to the Units box to display a list of units in the selected campus. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Units box. To return to having all units in the campus included on the report, click the restore icon next to the Units box. If you do not select any units, all units associated with the selected campus will be included.

  • Date Range: Only beds that had bed assignment priorities during the range that you select will appear on the report. Click the calendar icons to select beginning and ending date ranges. Only beds that had priorities assigned after the PreAdmitTracking® application version 3.2 was installed will be included on the report. If a bed priority was assigned before version 3.2 was installed, and then removed in version 3.2 or later, then the removal will not be included in the report.

Bed Assignment Priority History

  • Unit: Select the units that should be included on the report. Click the magnifying glass next to the Units box to display a list of units in the selected campus. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Units box. To return to having all units in the campus included on the report, click the restore icon next to the Units box. If you do not select any units, all units associated with the selected campus will be included.

  • Date Range and Time Period: Only beds that had bed assignment priorities during the date range and time that you select will appear on the report. Click the calendar icons to select beginning and ending date ranges and type times in the boxes in 24-hour format (for example, 23:59 for 11:59 PM). Only beds that had priorities assigned after the PreAdmitTracking® application version 3.2 was installed will be included on the report. If a bed priority was assigned before version 3.2 was installed, and then removed in version 3.2 or later, then the removal will not be included in the report.

  • Patients: If only beds that were occupied by or assigned to certain patients and that had bed assignment priorities removed should appear on the report, select those patients. If you do not make any selections, data about all patients who meet the selected criteria appear on the report.

    • To Select Patient Names:

      1. Click the magnifying glass icon next to the Patient box to display the Search Patients dialog.

      2. In the Patient Attribute list, select Visit Number, MRN, First Name or Last Name. In the Filter String box, type part of the patient's visit number, medical record number, first, or last name, and then click Go.

      3. Patients who have had multiple visits can appear in search results multiple times. To ensure that you are selecting the row for the appropriate patient visit, view the **

Visit Number**, Admit Date, and Discharge Date columns.

  1. Select the check boxes for the patients whom you want to include on the report OR to include all patients who appear on the list currently, select the check box in the title bar.

  2. Click Selected Patients to close the dialog and place the selected patient names in the Patient(s) box on the Report Criteria page. To return to having all patients included, click the restore icon next to the Patient(s) box.

  • Priority Removal Source: A bed assignment priority can be removed from a bed in the following ways. These are called priority removal sources. If the report should include data about priority removal only for beds where assignment priorities were removed through a specific source, then select one or more of the following. If you do not select anything, then the report will include beds where assignment priorities were removed through all sources.

    • Bed Assignment: Priority was removed because the bed was assigned to a patient.

    • Clear Priority-by User: A user manually removed the priority in the PatientTracking Portal® application. The user name will appear on the report.

    • Occupy Bed-ADT: Priority was removed because an ADT system transaction marked the bed occupied automatically. The report will show that the change was made by "system user." It could also show an actual user name in the Removed by column if the sender of the ADT message can be mapped to a valid user account.

    • Occupy Bed-by User: Priority was removed because a user manually marked the bed occupied in the PatientTracking Portal® application. The user's user name will appear on the report.

    • Occupy Bed-RTLS Movement: Priority was removed because a patient movement that was tracked through the TeleTracking RTLS system marked the bed occupied automatically. The report will show that the change was made by a "system user."

    • Occupy Bed-Transport Job: Priority was removed because the completion of a patient transport job marked the bed occupied automatically. The identification number of the transport job will be shown on the report as well as the user name of the user who requested the transport job.

Bed Time Wait Analysis with Milestones

  • Group By: You can group information on the Bed Time Wait Analysis report by origin unit, assigned bed, unit of the assigned bed (assigned unit), patient, or a single admit source. In the Group By list, select one of the following:

    • Patient: You can select a maximum of 5 patients to display on the report. Select Patient from the list, then click the magnifying glass icon, select a filter option to search for patients by, type text from the filter options, and then click Go. Patients who have had multiple visits can appear in search results multiple times. To ensure that you are selecting the row for the appropriate patient visit, view the Visit Number, Admit Date, and Discharge Date columns. Select check boxes for as many as 5 patients in the search results list, and then click Selected Patients.

    • Admit Source: Select Admit Source, and then click one Admit Source in the list. Data about only the selected admit source will appear on the report.

    • Origin Unit: You can select one unit from which patients were moved to group data by. Only data about that origin unit will appear on the report. Select Origin Unit in the list, and then select one unit from the Origin Unit list.

    • Assigned Unit: You can select one unit to which patients are assigned to group data by. Only data about that assigned unit will appear on the report. Select Assigned Unit in the list, and then select one unit from the Assigned Unit list.

    • Assigned Bed: You can select a maximum of 5 locations (beds) to which patients are assigned to group data by. Only data about these assigned beds will appear on the report. Select Assigned Bed in the list, and then click the magnifying glass icon, select the check boxes for the units in which the beds are located, click Click to Search, select as many as 5 beds in the location results list, and then click Selected Locations.

  • Date Range: Only data about completed placement requests with requested dates and times that are within the range that you select will appear on the report. Click the calendar icons to select beginning and ending date ranges and type times in the boxes in 24-hour format (for example, 23:59 for 11:59 PM).

  • Request to Occupied Minimum (in hrs): Select a number of hours. Only placement requests that were completed in fewer than this number of hours will appear on the report. If you do not want to use this criterion, select 0.

Census Analysis by Day of Week

  • Unit: Select the units that should be included on the report. Click the magnifying glass next to the Units box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Units box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Units box. If you do not select any units, all units associated with the selected campus and to which you have membership will be included.

  • Statistics Date: For the Census Analysis by Day of Week report, select the first date that will appear on the report. Data for this date and the six days that follow it will appear on the report. For the Census Analysis by Hour of Day report, select the date for which statistics will appear. On the Census Analysis by Hour of Day report, data for only one day can appear.

  • Census Time: You must select a census time for the following reports: Census Analysis by Day of Week, Census Analysis by Month, Census Analysis per 12-Week Period, and Census Analysis per Year. This is the time for which data will be displayed on the report. For example, if you select 12:00 PM, only the data that was valid at 12:00 PM will appear on the report.

  • Include Unit Details: To include a separate section for each unit that displays detailed data about that unit only, select Yes. The overall summary will appear at the end of the report. If you select No, then only the overall summary will appear.

Census Analysis by Hour of Day

  • Unit: Select the units that should be included on the report. Click the magnifying glass next to the Units box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Units box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Units box. If you do not select any units, all units associated with the selected campus and to which you have membership will be included.

  • Statistics Date: For the Census Analysis by Day of Week report, select the first date that will appear on the report. Data for this date and the six days that follow it will appear on the report. For the Census Analysis by Hour of Day report, select the date for which statistics will appear. On the Census Analysis by Hour of Day report, data for only one day can appear.

  • Include Unit Details: To include a separate section for each unit that displays detailed data about that unit only, select Yes. The overall summary will appear at the end of the report. If you select No, then only the overall summary will appear.

Census Analysis by Month

  • Unit: Select the units that should be included on the report. Click the magnifying glass next to the Units box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Units box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Units box. If you do not select any units, all units associated with the selected campus and to which you have membership will be included.

  • Statistics Month (Census Analysis by Month Report): For the Census Analysis by Month report, select the month that will appear on the report. Data for every day of this month will appear on the report.

  • Census Time: You must select a census time for the following reports: Census Analysis by Day of Week, Census Analysis by Month, Census Analysis per 12-Week Period, and Census Analysis per Year. This is the time for which data will be displayed on the report. For example, if you select 12:00 PM, only the data that was valid at 12:00 PM will appear on the report.

  • Include Unit Details: To include a separate section for each unit that displays detailed data about that unit only, select **Yes**. The overall summary will appear at the end of the report. If you select No, then only the overall summary will appear.

Census Analysis Per 12 Week Period

  • Unit: Select the units that should be included on the report. Click the magnifying glass next to the Units box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Units box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Units box. If you do not select any units, all units associated with the selected campus and to which you have membership will be included.

  • Statistics Start Date: For the Census Analysis per 12-Week Period report, select the date on which the 12-week period will start. Data for each week of the 12-week period starting with this date will appear on the report.

  • Census Time: You must select a census time for the following reports: Census Analysis by Day of Week, Census Analysis by Month, Census Analysis per 12-Week Period, and Census Analysis per Year. This is the time for which data will be displayed on the report. For example, if you select 12:00 PM, only the data that was valid at 12:00 PM will appear on the report.

  • Include Unit Details: To include a separate section for each unit that displays detailed data about that unit only, select Yes. The overall summary will appear at the end of the report. If you select No, then only the overall summary will appear.

Census Analysis Per Year

  • Unit: Select the units that should be included on the report. Click the magnifying glass next to the Units box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Units box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Units box. If you do not select any units, all units associated with the selected campus and to which you have membership will be included.

  • Statistics Year (Census Analysis by Year Report): For the Census Analysis by Year report, select the year that will appear on the report. Data for every month of this year will appear on the report.

  • Census Time: You must select a census time for the following reports: Census Analysis by Day of Week, Census Analysis by Month, Census Analysis per 12-Week Period, and Census Analysis per Year. This is the time for which data will be displayed on the report. For example, if you select 12:00 PM, only the data that was valid at 12:00 PM will appear on the report.

  • Include Unit Details: To include a separate section for each unit that displays detailed data about that unit only, select Yes. The overall summary will appear at the end of the report. If you select No, then only the overall summary will appear.

Hold Audit Report

  • Campus: Select the campus in which are located the patients whose hold data you wish to audit.

  • Patient: Select one or more patients to appear in the report.

  • Date Time Range From: The report will display holds that were updated within the date and time range that you select. Click the calendar icons for the From and To boxes to select dates.

  • Date Time Range To: The report will display holds that were updated within the date and time range that you select. Click the calendar icons for the From and To boxes to select dates.

  • Sort by: Select the order that the report will display the information. The options are displaying by the patient's name or the employee who interacted with the patient's behavioral health hold timer. The options can be sorted in Ascending or Descending order.

  • Output: Select either Acrobat (.pdf) or Excel (.xls) output.

Hold Compliance Report

  • Campus: Select the campus that includes the units where the behavioral health holds took place.

  • Unit: Select the unit where the behavioral health hold happened to include the unit in the report. Click the magnifying glass next to the Unit box to display a list of units in your membership. Select the check box for the unit that should be included on the report, and then click Select to save the selection and return to the Unit box.

    • Note: At their observation start times, patients must have home locations, current locations, or specialty locations in the selected units to be included on the report.

  • Hold Type: The hold type selected for each patient. Hold types are associated with durations and can be selected on the Patient/Placement Details form.

  • Patient Display Name: Select whether patients' first or last names or their medical record numbers will appear on the detailed report (if No is selected for Summary View).

  • Hold Start Date Time: The report will display only completed holds that started within the date and time range that you select. If a patient had multiple completed holds within this date and time range, only the most recent one will appear. Click the calendar icons for the From and To boxes to select dates. Type the beginning and ending times for the range in 24-hour format (for example, 15:59 for 3:59 PM). For example, if you selected November 15, 2011, and 07:00 AM for From and November 16, 2011, and 09:00 AM for To, then only behavioral health holds that started between 7 AM on November 15 and 9 AM on November 16 can appear on the report.

  • Include Only Patients Who Exceeded Hold (Summary View): To display data for all patients within each unit on the report, select No. To display only unit patients whose behavioral health hold exceeded the duration, select Yes.

Milestone Delay Report

The Milestone Delay Report shows details about Milestone Delays that were set for patients in either a Discharge or Transfer status. This report is useful in identifying common delays and how much time is associated with the delays. Although there are not any specific metrics captured in this report, it is still important to monitor. Delays can be both external (ex. a nursing home search) or internal (ex. pharmacy providing discharge meds) and knowing what these delays are will help highlight potential areas for improvement. The delays available while generating this report were provided by your hospital and should reflect the common delays that you typically experience at your facility. This report is also frequently used in conjunction with the Proper Pending Usage Report to help explain why certain discharges may have taken longer than anticipated.

  • Date Time Range: Click the calendar icon next to the From box, and then select the beginning date of the date range for which you want to generate the report. In the box next to it, type the beginning time in 24-hour format (for example, 16:00 for 4 PM). Click the calendar icon next to the To box, and then select the end date of date range. In the box next to it, type the end time in 24-hour format (for example, 23:59 for 11:59 PM). If you are generating a report on discharge milestone delays, then the report will include data about patients whose discharge dates and times were on or after the From date and time and on or before the To date and time. If you are generating a transfer milestone delay report, then the report will include data about patients whose placements were completed on or after the From date and time and on or before the To date and time. If you select a different campus after you have selected dates and time, the dates and times will change to the default date and time based on the time zone settings for the campus. For example, if you select dates and times for a campus in the U.S. Eastern time zone, and then at noon you select a different campus that is in the U.S. Pacific time zone, the end time for the range will change to 9:00 AM, which is the local time in the U.S. Pacific time zone.

  • Milestone Type: Select Discharge to generate a discharge milestone delay report or Transfer to generate a transfer milestone delay report. If you select Transfer, an option called Origin/Destination becomes available under the Milestone Delays box. If you select Discharge, the Origin/Destination option is not available.

  • Group by: If data should appear by unit, select Unit. Each unit will be listed and patient and milestone data will be shown under each unit. A unit summary will also appear. If data should appear by patient name, select Patient. Each patient will be listed and unit and milestone data will be shown under each patient. A patient summary will also appear. If data should appear by milestone name and delay reason, then select Milestone Delay. Each milestone will be listed with reasons underneath and patient and unit data will be shown under that. A milestone delay reasons summary will appear. If you select Microsoft Excel (.xls) as the output type, the Group by selection acts as a primary sorting option. Items are not grouped in .xls files as they are in .pdf files. In .xls files, all data appears in rows and columns rather than in groups. For example, if there are 10 patients who are associated with the same 3 milestones, 30 rows of data would appear in a .xls file.

  • Milestone Delay: If only certain milestones and delay reasons should appear on the report, select those milestones and reasons. If you do not make any selections, all milestones and reasons will be included on the report. Click the magnifying glass icon. To include all reasons for a milestone on the report, select the check box for the milestone. To include only certain reasons for a milestone on the report, click the plus sign (+) icon next to a milestone to display the reasons, and then select the check boxes for the reasons that you want to include. Repeat this procedure for each milestone that should be included. Then, click Select.

  • Origin/Destination: If you selected Transfer in the Milestone Type section, then select whether the report will display data about the origin unit (units from which patients were transferred) or destination unit (units that received transferred patients). Select Origin or Destination.

  • Units: Choose any unit in the selected campus to place on the report, even if your membership does not include that unit. If the report should include only certain units, select those units. Click the magnifying glass next to the Units box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Units box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Units box. For a discharge milestone delay report, only data about patients whose last known home locations are in the selected units appear on the report. For a transfer milestone delay report, either the origin or destination units will appear. If Origin was selected in the Group by section, then the units that patients were transferred from will appear. If Destination was selected, then the units to which patients were transferred will appear.

  • Patients: If only certain patients should appear on the report, select those patients. If you do not make any selections, data about all patients who meet the selected criteria appear on the report.

    • To Select Patient Names:

      1. Click the magnifying glass icon next to the Patient(s) box to display the Search Patients dialog.

      2. In the Patient Attribute list, select Visit Number, MRN, First Name or Last Name. In the Filter String box, type part of the patient's visit number, medical record number, first, or last name, and then click Go.

      3. Patients who have had multiple visits can appear in search results multiple times. To ensure that you are selecting the row for the appropriate patient visit, view the Visit Number, Admit Date, and Discharge Date columns.

      4. Select the check boxes for the patients whom you want to include on the report OR to include all patients who appear on the list currently, select the check box in the title bar.

      5. Click Selected Patients to close the dialog and place the selected patient names in the Patient(s) box on the Report Criteria page. To return to having all patients included, click the restore icon next to the Patient(s) box.

  • Sort by: Within the grouping that you selected, data can be sorted by the delay start date and time, by the milestone and delay reason or by patient name (if Unit was selected in the Group by section) or by unit (if Patient was selected in the Group by section). In the three lists, select the first, second, and third items by which data will be sorted within a grouping. To sort in alphabetical order by milestones name and delay reason, select Milestone Delay. To sort in alphabetical order by patient last name or unit, select Patient Name or Unit. To sort in chronological order by delay start date and time, select Delay Start. Then select Ascending or Descending. For example, if you select Milestone Delay first, then Delay Start, then Patient Name, and then select Ascending for each, the data within each unit section will be listed in ascending alphabetical order by milestone name, then in ascending chronological order by delay start date and time, then in ascending alphabetical order by patient last name.

Generating PreAdmitTracking® Application Discharge and Transfer Reports

About Discharge Transfer Reports

Discharge and transfer reports display information about discharges and transfers from units in a campus. There are three Discharge/Transfer reports: The Average Discharge/Transfer report, the Daily Transfers report, and the Weekly Discharges/Transfers report. To generate a discharges/transfers report you:

  1. Select the report criteria.

  2. Select the output type and run the report.

Report Data

The Average Discharges and Transfers report and Weekly Discharges/Transfers report display only discharges and transfers with an origin unit that is within the selected campus and units and within your membership. The Daily Transfer Report only displays transfers with an origin unit or destination unit that is within the selected campus and units and within your membership.

Permissions

You must have at least one of the following permissions to generate a discharge/transfer report:

  • (Required for Daily Transfers Report) Run Any Reports, Including Those that Reveal Patient Information.

  • (Not applicable to Daily Transfers Report) Run Only Reports that Do Not Reveal Patient Information.

To Select the Report Criteria:

  1. On the Report Selection page, click the plus sign next to PreAdmitTracking, and then click the plus sign next to Discharge/Transfer to display the available reports.

  2. Click one of the following:

  • Average Discharges/Transfers

  • Daily Transfers

  • Weekly Discharges/Transfers

  1. Do one of the following to generate a report with data that:

  • Has been archived and is in the archive database, select Archive.

  • Is still in the production database, select Production.
    Important Note: If you change the database selection after selecting dates, times, and other options, the dates and times that you selected will not change. However, other options will change and you will have to re-select them. Data that has been archived is available in the archive database after a database synchronization occurs. It remains in the production database until it is purged.

  1. If you have membership in multiple campuses (for example, ABC Children's Hospital and ABC Women's Hospital), then in the Campus list, select the campus for which you wish to generate a report.

  2. Depending on the report that you are generating, select report criteria. Click the links below for descriptions of the criteria that can be selected for each report:

Average Discharges/Transfers

The Average Discharges/Transfers Report provides the total number and percentage of discharges and/or transfers that occurred within a selected time range. This is a very useful report for both EVS Supervisors and Nursing Units because it shows when the bulk of discharges are happening. This helps units see if they are meeting their early discharge goals and it also helps EVS Supervisors manage staffing to ensure that the busiest times are being covered. This report is also used by Transport Supervisors (in conjunction with the Activity Detail by Job Report) to determine the % of discharges completed by the transport department.

Best Practice Metrics Captured In Average Discharges/Transfers Report

Metric

Best Practice Goal

% of Discharges by 11 AM

25%

% of Discharges by 2 PM

50%

% of Discharges Completed by Transport Department

Note: See the Discharge by Transport section of this reference guide for additional details on this metric

70%

  • Origin Unit: To include only transfers and discharges from specific origin units, click the magnifying glass next to the Origin Unit box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Origin Unit box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Units box.

  • Discharge/Transfer Date: You may choose to include only discharges and/or transfers that were completed within a certain date range. Click the calendar icons next to the From box and the To box to select beginning and ending dates for the date range. (For example, select May 15, 2011 in the From box and May 22, 2011 in the To box).

    • Important Note: If you change the database selection after selecting dates, times, and other options, the dates and times that you selected will not change. However, other options will change and you will have to re-select them.

  • Time Periods: Select the number of time periods to be included on the report. Only discharges and transfers occurring within these time periods will be included on the report. The time periods appear on the report as Period 1 through up to Period 10. The Report Parameter section displays the time represented by each period (for example, Period 1: 00:00 to 07:59 and Period 2: 08:00 to 15:59).

    • To select time periods:

      • In the Periods list, select the number of time periods (for example, 3).

      • To select when each time period begins and ends, in each Begin box type a time (for example 08:00) and in each End box type a time (for example, 15:59).

  • Events to Include: Select whether to include discharges, transfers, or both on the report. Select the Discharges check box, the Transfers check box, or both.

  • Include Weekends: Select whether to include discharges and transfers that occur on weekends. Organizations where very few transfers and discharges occur on weekends might want to exclude weekends to avoid skewing data. To include transfers and discharges that occur on weekends, select Yes. To exclude them, select No.

Daily Transfers

  • Origin Unit and Destination Unit: To include only transfers from specific origin units, and/or destination units, click the magnifying glass next to the Origin Unit or Destination Unit box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Origin Unit or Destination Unit box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Origin Unit or Destination Unit box.

  • Date: Select the date for which transfer records should appear. Click the calendar icon and select a month and date. Important Note: If you change the database selection after selecting dates, times, and other options, the dates and times that you selected will not change. However, other options will change and you will have to re-select them.

  • Transfers to Include: Select whether to include transfers that were completed or canceled or both on the selected date. Select the Completed or Canceled check box or both.

  • Group by: Data can be displayed by the origin unit or the destination unit of the transfers. Select Origin Unit or Destination Unit.

Weekly Discharges/Transfers

  • Origin Unit: To include only transfers and discharges from specific origin units, click the magnifying glass next to the Origin Unit box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Origin Unit box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Units box.

  • Start Date: Select the date on which the week starts. Data for seven days, starting with the selected date, appears on the report. Click the calendar icon to select the date.

  • Include Weekends: Select whether to include discharges and transfers that occur on weekends. Organizations where very few transfers and discharges occur on weekends might want to exclude weekends to avoid skewing data. To include transfers and discharges that occur on weekends, select Yes. To exclude them, select No.

Selecting the Output Type and Running the Report

  1. In the Output list, select one of the following formats for the report:

  • Adobe Acrobat: To generate the report as a .pdf file. (This format is selected by default.)

  • Microsoft Excel: To generate the report as an .xls file that can be opened in Microsoft Excel.

  • Microsoft Excel (Unformatted) (Available for Average Discharges/Transfers): The Microsoft Excel (Unformatted) report output option produces an .xls file that is suitable for performing your own calculations and analysis. Data will appear in simple rows and columns and will not be totaled, grouped, or summarized.

  1. Click Run Report.

  2. If a security message appears at the top of the page, right-click the message bar, and then select Download File.

  3. When you are prompted to save or open the report, do one of the following:

  • To save the report on a network drive or hard drive, click Save. When the Save As dialog box appears, select a location to save the report to, and then click Save.

  • To open the report immediately in the appropriate program, click Open.

Discharges By Transport

As mentioned previously, the Average Discharges/Transfers Report is also used to help calculate the Best Practice Metric for Discharges Completed by Transport. In order to ensure the accuracy of data, there are two specific reports that will need to be run to capture data points for a calculation. The two reports are the Activity Detail by Job Number and the Average Discharges/Transfers Report.

Report To Run

Instructions For Generating Report Parameters

Metric To Capture

Activity Detail By Job Number

Origin: Include All Home Locations.

Destination: Include All Discharge Locations.

Total Discharges/Transfers

Average Discharges/Transfers

Events To Include: Discharges Only

Total # Of Requests

Once the reports are generated and you have captured the metrics, the following calculation will provide the Best Practice Metric for Discharges Completed by Transport:

Total Discharges/Transfers / Total # of Requests = Discharges Completed by Transport

Generating a PreAdmitTracking® Application Proper Pending Report

About Proper Pending Reports

Proper pending reports compare the numbers of patients who were in Pending Transfer status to actual transfers and the number of patients who were in Pending Discharge and Confirmed Discharge status to actual discharges. There are two Proper Pending reports: The Pending Status Compliance report and the Proper Pending Usage report. To generate a proper pending report, you:

  1. Select the report criteria.

  2. Select the output type and run the report.

Report Data

Only discharges and transfers with an origin unit that is within the selected campus and units and within your membership are included on the report.

Permissions

You must have at least one of the following permissions to generate a proper pending report:

  • Run Any Reports, Including Those that Reveal Patient Information

  • Run Only Reports that Do Not Reveal Patient Information

To Select the Report Criteria:

  1. On the Report Selection page, click the plus sign next to PreAdmitTracking, and then click the plus sign next to Proper Pending to display the available reports.

  2. Click either Pending Status Compliance or Proper Pending Usage.
    A page for selecting report criteria appears.

  3. Do one of the following. To generate a report with data that:

  • Has been archived and is in the archive database, select Archive.

  • Is still in the production database, select Production.

  • Important Note: If you change the database selection after selecting dates, times, and other options, the dates and times that you selected will not change. However, other options will change and you will have to re-select them.

Data that has been archived is available in the archive database after a database synchronization occurs. It remains in the production database until it is purged.

  1. If you have membership in multiple campuses (for example, ABC Children's Hospital and ABC Women's Hospital), then in the Campus list, select the campus for which you wish to generate a report.

  2. Depending on the report that you are generating, select report criteria. Click the links below for descriptions of the criteria that can be selected for each report:

Pending Status Compliance

The Pending Status Compliance Report provides an overview of usage for entering transfer bed requests and updating discharge statuses. The report compares the number of pending transfers or discharges to the number of actual events for each. The primary reason to run this report is to monitor compliance with setting discharge statuses which is a vital component to efficient patient flow and a reportable best practice metric. However, transfer compliance should also be closely monitored to ensure that bed requests are not being made outside of the system.

Best Practice Metrics Captured In The Pending Status Compliance Report

Metric

Best Practice Goal

Pending Discharge Compliance

70% or above

Confirmed Discharge Compliance

90% or above

  • Unit—Select the units that should be included on the report. Click the magnifying glass next to the Units box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Units box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Units box. If you do not select any units, all units associated with the selected campus and to which you have membership will be included.

  • Discharge/Transfer Date—You may choose to include only discharges and/or transfers that were completed within a certain date range. Click the calendar icons next to the From box and the To box to select beginning and ending dates for the date range. (For example, select May 15, 2011 in the From box and May 22, 2011 in the To box).

  • Important Note: If you change the database selection after selecting dates, times, and other options, the dates and times that you selected will not change. However, other options will change and you will have to re-select them.

  • Shift Time—To choose specific shifts to be included on the report, in the Start and End boxes, type the start and end times of the shifts. For example, to include the 8:00 AM to 3:59 PM AND the 4:00 PM to 11:59 PM shift, in the Start box, type 08:00 AM and in the End box, type 11:59 PM. If a shift starts on one date and ends on the next, the report will include data from the entire shift. If a shift starts on the last date of a date range ends one day later, data from the entire shift, including the part of the shift that is after the end date of the report, still will be on the report. A message appears indicating that a shift that crosses over the midnight boundary was selected and that the report end date will actually be the day after the selected end date.

  • Important Note: If you change the database selection after selecting dates, times, and other options, the dates and times that you selected will not change. However, other options will change and you will have to re-select them.

Proper Pending Usage

  • Origin Unit—To include only transfers and discharges from specific origin units, click the magnifying glass next to the Origin Unit box to display a list of units in your membership. Select the check boxes for the units that should be included on the report, and then click Select to save the selection and return to the Origin Unit box. To return to having all units in the campus that are within your membership included on the report, click the restore icon next to the Units box.

  • Discharge/Transfer Date—You may choose to include only discharges and/or transfers that were completed within a certain date range. Click the calendar icons next to the From box and the To box to select beginning and ending dates for the date range. (For example, select May 15, 2011 in the From box and May 22, 2011 in the To box).

  • Important Note: If you change the database selection after selecting dates, times, and other options, the dates and times that you selected will not change. However, other options will change and you will have to re-select them.

  • Shift Time—To choose specific shifts to be included on the report, in the Start and End boxes, type the start and end times of the shifts. For example, to include the 8:00 AM to 3:59 PM AND the 4:00 PM to 11:59 PM shift, in the Start box, type 08:00 AM and in the End box, type 11:59 PM. If a shift starts on one date and ends on the next, the report will include data from the entire shift. If a shift starts on the last date of a date range ends one day later, data from the entire shift, including the part of the shift that is after the end date of the report, still will be on the report. A message appears indicating that a shift that crosses over the midnight boundary was selected and that the report end date will actually be the day after the selected end date.

  • Important Note: If you change the database selection after selecting dates, times, and other options, the dates and times that you selected will not change. However, other options will change and you will have to re-select them.

  • Events to Include—Select whether to include discharges, transfers, or both on the report. Select the Discharges check box, the Transfers check box, or both.

  • Summary View (Yes or No)—To show a summary view of the report, select Yes. To show a detailed view, select No. The summary view displays summary information for each date within each unit such as the total records for a unit and the pending compliance percentages for a unit. The detailed view shows per unit, detailed information such as the daily and unit duration averages, daily and unit compliance percentages, and the bed that was occupied. If you select No, the Microsoft Excel (Unformatted) option will be available in the Output list.

If you would like to perform your own calculations and analysis in Microsoft® Excel, then Microsoft Excel (Unformatted) is a good option.

  • Include PHI—Select whether to include Protected Health Information (PHI), such as patient names, in the report. Select Yes to include PHI and No to exclude it. (On the report, a line will appear in place of the excluded PHI.) It is helpful to exclude PHI if you are sharing the report with others who need to see the data, but should not see personal information about individual patients.

To Select the Output Type and Run the Report

  1. In the Output list, select one of the following formats for the report:

  • Adobe Acrobat—To generate the report as a .pdf file. (This format is selected by default.)

  • Microsoft Excel—To generate the report as an .xls file that can be opened in Microsoft Excel.

  • Microsoft Excel (Unformatted)—(for Proper Pending Usage report only.) This option is only available if you selected No for **Summary View?**. The Microsoft Excel (Unformatted) report output option produces an .xls file that is suitable for performing your own calculations and analysis. Data will appear in simple rows and columns and will not be totaled, grouped, or summarized. If you would like to perform your own calculations and analysis in Microsoft® Excel, then Microsoft Excel (Unformatted) is a good option.

  1. Click Run Report.

  2. If a security message appears at the top of the page, right-click the message bar, and then select Download File.

  3. When you are prompted to save or open the report, do one of the following:

  • To save the report on a network drive or hard drive, click Save. When the Save As dialog box appears, select a location to save the report to, and then click Save.

  • To open the report immediately in the appropriate program, click Open.

Generating the Ready To Move Timer Metrics Report

Database - Where Your Facility's Data Is Stored

  • Production - Data that is stored in the production database (this is your current data).

    • Use when live up-to-the-minute data is needed.

    • Contains the data from the current time and for the past number of days as defined in Archive Management. This is typically 7 days but may range between 1 and 30 days. If you do not know the number of days, your TeleTracking System Administrator should be able to assist.

  • Archive - Data that is stored in the archive database (this is your older data).

    • Does not capture data for the current day.

    • Users can access reports as far back as the go-live date.

Campus

  • Campus Drop-Down

    • Defaults to your campus. The only exception is if you have access to multiple campuses. If you have membership in multiple campuses (for example, ABC Children's Hospital and ABC Women's Hospital), then in the Campus list, select the campus for which you wish to generate a report.

Group By

  • Group By Drop-Down

    • Group By allows you to choose how you want the report data sorted.

  • Origin Unit (most common): Select when you want to run metrics for bed requests leaving a specific unit.

    • Note: Data appears by the user who requested the placement, by target unit, or by origin unit, depending on criteria selected by the user who generated the report.

Unit Selection

  • Magnifying Glass

    • Clicking on the magnifying glass allows you to select specific units.

    • If no units are selected, the report will run for all units by default.

Date & Time

  • Request Date

    • Click on the Calendar Icon to select the needed dates.

  • Shift Time

    • The system defaults to the entire day, however you may want to isolate specific shifts if you are trying to investigate issues with not meeting metrics.

    • Only placements with requested dates within the selected date range and the selected shift appear in the report. However, if a shift starts on the end date of the report date range and ends on the next day, data from the entire shift will be included in the report.

      • For example, if the end date of the report is March 19, 2024, and a shift started at 11:00 PM on March 19 and ended at 7:00 AM on March 20, then data from the entire shift, including the part on March 20, will be on the report.

Standard Deviation

  • Include Standard Deviation

    • Standard Deviation is the average distance from the average Ready to Move time for compliant placements.

    • Leave this set to Yes.

Summary View

  • Summary View - Select Yes (most common): Displays total durations, average durations, group durations, and group standard deviations.

    • Leave this set to Yes.

  • Summary View - Select No: Displays per unit or per user, detailed information such as the request time and the bed that was occupied.

Output

  • Choose the format of the report data. Options include Adobe and Excel.

  • Adobe Acrobat (Summary View) - Here is the summary view using Adobe Acrobat. This lists counts per unit or user for each day.

  • The following information is displayed on the summary report for each user or target unit or origin unit, for each day within the date range selected.

Name

Description

Date

  • Requested Date of the placement.

Day of the Week

  • The day of the week on which the requested date occurred.

Total Records

  • The total number of placements for this requested date for this user or unit.

Compliant Records

  • The total number of placements for this requested date and this user or unit for which the patients have been marked Ready To Move.

Invalid Timers

  • The total number of completed placements with this requested date for this user or unit that have negative Ready to Move timer durations (Total Records minus Total Compliant Records).

Total Duration

  • Total Ready to Move time for all compliant placement records for this requested date for this user or unit. Invalid timers are excluded.

    • Example: Two compliant placements have the same requested date. For one placement, twenty minutes elapsed between the time that the placement request was activated and the time that the patient was marked Ready to Move. For the other placement, 40 minutes elapsed. The total duration for the requested date is 60 minutes.

Average Duration

  • Average Ready to Move time duration of all completed placement records with this requested date (Total Records divided by Total Compliant Records).

Standard Deviation

  • Average distance from the average Ready to Move time for compliant placements. The user who generates the report can choose to include or exclude standard deviation.

Group Duration Average

  • Average occupied time duration of all compliant placement records for the unit or user within the selected date range and shift.

Group Standard Deviation

  • Average distance from the average Ready to Move time for compliant placements for the unit or user within the selected date range and shift. The user who generates the report can choose to include or exclude standard deviation.

Invalid Timer Values

  • Number of placements with negative occupied timer values for the unit or user within the selected date range and shift.

# of # for % of placements were excluded (missing RTM dates and times)

  • Number of the total completed placements for this unit or user that were excluded from calculations because they did not have Ready to Move dates and times. The percentage of placements that were excluded for this reason also appears.

  • Excel (Detailed View) - The detailed report displays specifics about completed placements per target or origin unit or per requesting user, such as the occupied bed, the requested time, and the time that the patient was marked ready to move.

  • The following information is displayed on the detailed report for each user or target unit or origin unit, for each day within the date range selected.

Name

Description

Date

  • Requested Date of the placement.

Day of the Week

  • The day of the week on which the requested date fell.

Patient Name

  • The last and first name of the patient associated with the placement.

Target Unit (only if data is grouped by user or origin unit)

  • The Target Unit selected for placement.

Requested by User (only if data is grouped by target unit)

  • The user who requested the placement.

Bed Occupied

  • The abbreviation of the bed that the patient occupies.

Request Time

  • The time that the bed is needed.

RTM Time (Ready to Move Time)

  • The time that the patient was marked Ready to Move.

Duration

  • The time that the Ready to Move timer ended minus the time that it began. The beginning time is when the patient placement request was activated, The end is when the patient is marked Ready to Move. If the duration is negative, it appears in red. Negative values are excluded from calculations.

Daily Duration Average

  • Average Ready to Move time duration of all compliant placement records for the unit or user for the date.

Group Duration Average

  • Average Ready to Move time duration of all compliant placement records for the unit or user within the selected date range and shift. Compliant placements are those that have positive durations.

Invalid Timer Values

  • Number of placements with negative Ready to Move timer values for the unit or user within the selected date range and shift.

# of # for % of placements were excluded (missing RTM dates and times)

  • Number of the total completed placements for this unit or user that were excluded from calculations because they did not have Ready to Move dates and times. The percentage of placements that were excluded for this reason also appears.

Run Report

  • Click Run Report once all fields are populated.

Analyzing the Ready To Move Timer Metrics Report

The above is an example of a generated Ready to Move Timer Metrics report. We will now break down the information to help you better understand how to read the data.

  • Total Records: total number of bed requests generated from the unit(s) per date.

  • Compliant Records: total number of bed requests generated from the unit(s) per date that had an RTM timer activated in the request.

  • % of Placements Excluded- Shows the % of records that were missing an RTM timer. In the above example, if 33% of placements were excluded, this would mean that the unit was 67% compliant with the RTM timer. This calculation provides the Ready to Move Compliance %

Generating a PreAdmitTracking® Application Master Report

About Master Reports

You may generate a PreAdmitTracking® application master report called the Physician Summary Report. The report provides information about all physicians associated with the selected campus. To generate the report, you:

  1. Select the report criteria.

  2. Select the output type and run the report.

Report Data

Only physicians associated with the selected campus appear on the report.

Permissions

You must have the Run Master Reports permission to generate a master report.

To Select the Report Criteria:

  1. On the Report Selection page, click the plus sign next to PreAdmitTracking and then the plus sign next to PAT Master to display the available report.

  2. Click Physician Summary to display a page for selecting report criteria.

  3. Do one of the following. To generate a report with data that:

  • Has been archived and is in the archive database, select Archive.

  • Is still in the production database, select Production.

  • Note: Data that has been archived is available in the archive database after a database synchronization occurs. It remains in the production database until it is purged.

  1. If you have membership in multiple campuses (for example, ABC Children's Hospital and ABC Women's Hospital), then in the Campus list, select the campus for which you wish to generate the report.

  2. In the Sort by list, select whether the physician data should be sorted by physician last name or physician ADT ID code and select whether data should be sorted in Ascending or Descending order.

To Select the Output Type and Run the Report

  1. In the Output list, select one of the following formats for the report:

  • Adobe Acrobat—To generate the report as a .pdf file. (This format is selected by default.)

  • Microsoft Excel—To generate the report as an .xls file that can be opened in Microsoft Excel.

  1. Click Run Report.

  2. If a security message appears at the top of the page, right-click the message bar, and then select Download File.

  3. When you are prompted to save or open the report, do one of the following:

  • To save the report on a network drive or hard drive, click Save. When the Save As dialog box appears, select a location to save the report to, and then click Save.

  • To open the report immediately in the appropriate program, click Open.

Generating a PreAdmitTracking® Application Master Report

About Master Reports

You may generate a PreAdmitTracking® application master report called the Physician Summary Report. The report provides information about all physicians associated with the selected campus. To generate the report, you:

  1. Select the report criteria.

  2. Select the output type and run the report.

Report Data

Only physicians associated with the selected campus appear on the report.

Permissions

You must have the Run Master Reports permission to generate a master report.

To Select the Report Criteria:

  1. On the Report Selection page, click the plus sign next to PreAdmitTracking and then the plus sign next to PAT Master to display the available report.

  2. Click Physician Summary to display a page for selecting report criteria.

  3. Do one of the following. To generate a report with data that:

    • Has been archived and is in the archive database, select Archive.

    • Is still in the production database, select Production.

    Note: Data that has been archived is available in the archive database after a database synchronization occurs. It remains in the production database until it is purged.

  4. If you have membership in multiple campuses (for example, ABC Children's Hospital and ABC Women's Hospital), then in the Campus list, select the campus for which you wish to generate the report.

  5. In the Sort by list, select whether the physician data should be sorted by physician last name or physician ADT ID code and select whether data should be sorted in Ascending or Descending order.

To Select the Output Type and Run the Report

  1. In the Output list, select one of the following formats for the report:

    • Adobe Acrobat—To generate the report as a .pdf file. (This format is selected by default.)

    • Microsoft Excel—To generate the report as an .xls file that can be opened in Microsoft Excel.

  2. Click Run Report.

  3. If a security message appears at the top of the page, right-click the message bar, and then select Download File.

  4. When you are prompted to save or open the report, do one of the following:

    • To save the report on a network drive or hard drive, click Save. When the Save As dialog box appears, select a location to save the report to, and then click Save.

    • To open the report immediately in the appropriate program, click Open.

Did this answer your question?