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.
Mismatch (Reimburse)
Displays the number of reports with mismatches related to the reimburse amount.
Mismatch (Cash Advance)
Displays the number of reports with mismatches related to the cash advance amount.
Mismatch (Status)
Displays the number of reports with mismatches related to the Archivum or FAST status.
Mismatch (Employee ID)
Displays the number of reports with mismatches related to the Employee ID.
Reimburse Difference
Displays the total Reimburse difference between Archivum and FAST mismatches.
Cash Advance Difference
Displays the total Cash Advance difference between Archivum and FAST mismatches.
Details
FAST Creation Date
The date in FAST the travel request or expense report was created.
Type: Date
FAST TER Number
Numeric code to determine FAST Department. The default is for all codes to be selected; individual or multiple codes may be selected.
Archivum ER Number
Travel expense report number created by the Archivum database.
Archivum Status
Current status of Archivum travel: Examples: (Request Approved, Prepay Auditor,Fiscal Review).
FAST Status
Current status of FAST travel: Examples: (PD, SUB, PND).
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.