Travel - Potential Duplicate Payments

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.