Travel - TRs Approved with No ER

Report Description

The Travel - TRs Approved with No ER Report displays data fields that relate to current status of Travel Request Reports with two tabs: Travel Requests Approved with No ER and Details.  This dashboard is retrieving Archivum data for Travel and College Departments on a daily basis so they can track creation of ERs after travel has ended. 

This report only shows data where the ER Exists Flag = "N" and the TR Status is "Request Approved". This represents approved TRs that do not have a submitted ER.

Travel Requests Approved with No ER

Filters

Traveler College Name

Name of College associated with person traveling.

Traveler Global Department Name

Global Department name associated with person listed as the traveler.

Traveler Name

First and last name of traveler.

Travel End Day

The date in which a travel trip ends.


Visualization 

TRs by College and Department

Heat Map that displays the number of TRs by College and Department.

Drillable - The Heat Map also allows you to drill to display count of TRs by College and Department.

Number of Expense Reports per Day Range for Last Status

Bar chart that displays the number of expenses per each range. Ranges are broken down as follows: 7 days or less, 8 to 29 days, 30 to 59 days, 60 to 89 days, and 90 days or greater.

Total TR Approved with No ER

Total number of the Approved Travel Requests with No Expenses Report.

 

This report only pulls data for TRs with travel end dates before today. Setting the travel end date to a date after today will not bring back more requests.


Details

Status

Current status of travel expense report: Canceled, Deleted, Deletion in Progress, Fiscal Review, Paid, Prepay Auditor, Request Approved, Submission in Progress, Supervisor Review

Days Since Last Action

Number of days that an expense report has been in a particular status.

Submitted Days Before Travel

The difference between the begin date of travel and the creation date of the travel request.

Archivum TR Number

Travel request number created by the Archivum database.

Traveler Name

First and last name of traveler.

Travel Title

Travel title entered by traveler for travel request and expense report.

Traveler Global Department Name

Global Department name associated with person listed as the traveler.

Traveler College Name

Name of College associated with person traveling.

TR Total Amount

Total dollar amount for a travel request report.

Expense Report Number

Expense report number per the Travel department.

FAST TAR

A six digit numeric code to determine FAST Department. The default is for all codes to be selected; individual or multiple codes may be selected.


Data Refreshed On

Data in this report is not live, but refreshed once daily. The date on the bottom right of the report displays the last day the data was refreshed from Archivum.

Disclaimer

This report displays values as the are currently in Archivum. Those values are subject to change over time. Unauthorized use of this report is prohibited. If you log on to this computer system, you acknowledge your awareness of and concurrence with the University of South Florida policies. The University will prosecute violators to the full extent of the law.