Travel - Status Discrepancies Between FAST and Archivum Report

Report Description

The Travel - Status Discrepancies Between FAST and Archivum Report displays data fields that relate to current status of Travel Reports with one tab Status Discrepancies Between FAST.  This report is retrieving Archivum and FAST data for Travel 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).

Archivum Total Reimburse

Displays the total reimburse from Archivum associated with a travel.

FAST Total Reimburse

Displays the total reimburse from FAST associated with a travel.

Reimburse Difference

Displays the total Reimburse difference between Archivum and FAST mismatches.

FAST Employee ID

The Employee ID is the unique element assigned to every employee over the course of their employment. An employee has only one Employee ID.

Source: FAST

Archivum Employee ID

The Employee ID is the unique element assigned to every employee over the course of their employment. An employee has only one Employee ID.

Source: Archivum

Archivum Cash Advance 

This Archivum field calculates the cash advance associated with the travel expense submitted.

Data Type: Number

FAST Cash Advance

This FAST field calculates the cash advance associated with the travel expense submitted.

Data Type: Number

Cash Advance Difference

Displays the total Cash Advance difference between Archivum and FAST mismatches.


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.

Disclaimer

This report displays values as they are currently in Archivum and FAST. 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.