Report Description
The Travel - Status Discrepancies Between FAST and Archivum Report displays data fields that relate to current status of Travel Expense Reports with one tabs Status Discrepancies Between FAST and Archivum Report. This report is retrieving Archivum data for Travel and College Departments on a daily basis so they can review, track, and monitor the discrepancies between FAST and Archivum within travel reporting system.
Status Discrepancies Between FAST and Archivum
Filters
Status Mismatch
This flag (Y/N) indicates whether the travel status has a discrepancy between FAST and Archivum.
Data Type: Text
Emp ID Mismatch
This flag (Y/N) indicates whether the travel Employee ID has a discrepancy between FAST and Archivum.
Data Type: Text
Cash Adv Mismatch
This flag (Y/N) indicates whether the travel Cash Advance has a discrepancy between FAST and Archivum.
Data Type: Text
Reimbursement Mismatch
This flag (Y/N) indicates whether the travel Reimbursement has a discrepancy between FAST and Archivum.
Data Type: Text
ER Missing in Archivum
This flag (Y/N) indicates whether the Expense Report Number is missing in Archivum.
Data Type: Text
FAST Creation Date
The date in FAST the travel request or expense report was created.
Type: Date
Visualizations
Total Count by Archivum and FAST Status Mismatch
Number of expense reports with mismatch for selected status. Visualization can be drilled to display status for Archivum and FAST specifically.
Total Account by Reimburse Difference Range
Bar chart that displays the number of mismatches per each range. Ranges are broken down as follows: R0 - Less than $0, R1 - $0 to $50, R2 - $51 to $99, R3 - $100 to $149, R4 - $150 to $199 and R5 - More than $200.
Total Count by Employee ID Mismatch
Number of expense reports with mismatch for Employee ID. Visualization can be drilled to display Employee ID for Archivum and FAST specifically.
Total Account by Cash Advance Difference Range
Bar chart that displays the number of mismatches per each range. Ranges are broken down as follows: R0 - Less than $0, R1 - $0 to $50, R2 - $51 to $99, R3 - $100 to $149, R4 - $150 to $199 and R5 - More than $200.
Hold Required
Displays the number of Hold Required expense reports. Usually it can be counted by Prepay Auditor name.
Sendback Required
Displays the number of Sendback Required expense reports. Usually it can be counted by Prepay Auditor name.
Details
Expense Report ID
This field contains the system-assigned ID of the expense report associated with this travel request or expense report.
Data Type: Text
PPA UID Number
This field stores the Prepay Auditor U identification number associated with a travel request or expense report.
Data Type: Text
Prepay Auditor Name
This field stores the Prepay Auditor name associated with a travel request or expense report. Prepay Auditor name concatenates the person last name and the person first name.
Data Type: Text
Status
Current status of travel expense report: Canceled, Deleted, Deletion in Progress, Fiscal Review, Paid, Prepay Auditor, Request Approved, Submission in Progress, Supervisor Review
PPA Review
This field stores the review time in days for the travel expense approved PPA.
Data Type: Number
PPA Sendback
This field stores the senback value for the travel expense approved PPA.
Data Type: Number
Payment Type
Type of payment associated with the travel expense report such as PCard Payment or Traveler Paid - Reimburse.
Data Type - Text.
Cash Advance
This field calculates the cash advance associated with the travel expense submitted.
Data Type: Number
Hold Count
Expense report total count on hold.
On Hold Duration
Expense report duration in days currently on hold.
Type: Text
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 they 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.