Report Description
The Travel - Potential Duplicate Payments report displays data fields that relate to possible duplicate payments for Travel expense requests, with two tabs: Potential Duplicate Payments and Expense Details. This dashboard is retrieving Archivum data for Travel and College Departments on a daily basis so they can review and track payments of travel expense requests. This report only pulls data for ERs with overlapping travel dates.
Potential Duplicate Payments
Filters
Traveler College Name
Name of College associated with person traveling.
Traveler Name
First and last name of traveler.
Expense Report Status
Current status of travel expense report: Canceled, Deleted, Deletion in Progress, Fiscal Review, Paid, Prepay Auditor, Request Approved, Submission in Progress, Supervisor Review
Overlap Type
Travel overlap dates: full, partial, subset, superset
Expense Difference
The ER total expense difference between two ERs with overlapping travel dates.
Travel Begin Day
The date in which a travel trip begins.
Visualization
Count of Expense Reports
Number of expense reports.
Count of ERs by Overlap Type
Number of ERs with travel dates overlapping by type of overlap.
Count of ERs by College Name
Number of ERs by College Name.
Count of ERs by Traveler Name
Number of ERs by Traveler name.
This report only pulls data for ERs with overlapping travel dates.
Details
Traveler Name
First and last name of traveler.
Travel Begin Day
The date in which a travel trip begins.
Travel End Day
The date in which a travel trip ends.
ER Created Day
The day the travel expense report was created.
Overlap Type
Travel overlap dates: full, partial, subset, superset
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
Expense Report ID Overlap
Expense report ID for corresponding ER with overlapping travel dates
Total ER Expenses
Total dollar amount for a travel expense report.
ER Expenses Overlap Min Difference
ER total expense amount difference between two ERs with overlapping travel dates
ER Type
Indicates the type of expense report: Mileage/Incidentals Only, Travel Request/Post-Travel Authorization, or Unknown.
Data Type: Text
ER Description
This field is used to provide details on the traveler, travel description, and travel dates for the expense report.
Data Type: Text
Travel Title
Travel title entered by traveler for travel request and expense report.
Travel Description
User-entered description of the travel request or expense report.
Data Type: Text
ER Completed Flag
This flag indicates whether the travel has an expense report completed.
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
Submitter Name
The name of the person submitting the travel request, which may be different than the traveller.
Data Type: Text
Payment Type
Type of payment associated with the travel expense report such as PCard Payment or Traveler Paid - Reimburse.
Data Type - Text.
Expense Details
Filters
Traveler College Name
Name of College associated with person traveling.
Traveler Name
First and last name of traveler.
Expense Report Status
Current status of travel expense report: Canceled, Deleted, Deletion in Progress, Fiscal Review, Paid, Prepay Auditor, Request Approved, Submission in Progress, Supervisor Review
Overlap Type
Travel overlap dates: full, partial, subset, superset
Expense Difference
The ER total expense difference between two ERs with overlapping travel dates.
Travel Begin Day
The date in which a travel trip begins.
Details
Expense ID
This field contains the ID of the Travel Expenses associated with this travel.
Data Type: Number
TER Number
The Travel Expense Report(TER) Number with which the employee or traveler is associated.
Type: Text
TAR Number
The Travel Authorization Request(TAR) Number with which the employee or traveler is associated. A six digit numeric code to determine FAST Department.
Type: Text
ER Created Day
The day the travel expense report was created.
Traveler Name
First and last name of traveler.
Payment Type
Type of payment associated with the travel expense report such as PCard Payment or Traveler Paid - Reimburse.
Data Type - Text.
City State Country
This field contains City, State, and Country (if applicable) of the travel location.
Data Type: Text
Expense Description
The description for the Travel Expenses with which the employee or traveler is associated.
Type: Text
Chartfield Amount
The chartfield amount for the Expense Report Line Item with which the employee or traveler is associated.
Type: Number
Chartfield Percentage
The chartfield percentage for the Expense Report Line Item or the travel request with which the employee or traveler is associated.
Type: Number
College Name
Name of College associated with person traveling.
Type: Text
Project ID
Identification Number of the associated Project.
Type: Text
OU
Indicates the university location where the traveler in the traveler request is affiliated, such as USF Tampa or USF St Pete.
Data Type: Text
USF Account Code
The account is a five digit chartfield value used to indicate the nature of the transaction being processed; i.e. the type of commodity or service involved. These accounts are part of the General Ledger and are collectively known as the "Chart of Accounts."
Different account groups are used for budgets, expenditures, transfers, reporting, equity and revenue.
Data Type: Number
Data Refreshed On
Data in this report is not live, but refreshed once daily. The date and time on the bottom right of the report displays when it was refreshed from Archivum. The refresh is scheduled to occur between 7:00 and 7:45 am each morning.
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.