Travel - Completed Expense Report by Time Frame
- aross5
- Chukwuebuka Ezema
Report Description
The Travel - Completed Expense Report by Time Frame displays data fields that relate to ERs that are completed and in the status of Paid or Approved. The report has two tabs: Completed Expense Report Summary and Details. This dashboard is retrieving Archivum data for Travel and College Departments on a daily basis so they can review completed expense reports.
This report only shows data where the ER Begin Date is on or after "7/1/2017" and the ER Travel Status Category = "Completed". This should represent the completed ERs once the system was fully functional.
Travel - Completed Expense Reports Summary
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 Request Status
The date the travel request report was created.
Expense Report Created Day
The date the travel expense report was created.
Travel End Day
The date in which a travel trip ends.
Visualization
Travel Request by Status
Pie chart that displays the number of travel request reports in each status.
Drillable - The pie also allows you to drill to display count of travel request reports for Traveler College Name and Traveler Global Department Name separately.
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.
Number of Expense Reports
The number of expense reports.
Number Sent Back
Number of expense reports that had a send back at any point in time.
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.
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 in the morning. The date on the bottom right of the report displays the day and time 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.