Employee Travel Summary (ETSM)

Employee Travel Summary (ETSM) shows summary information on the traveler's account balance. It is used to inquire against the employee travel records. This table lists all employees and the number of trips completed per employee. It also records the cumulative advances received by the employee and the year-to-date expenses incurred by the employee. It keeps track of the last date the employee records were updated and the amount owed to or by the employee.

Lines are added to this table when a Travel Authorization (TE) or Expense Voucher (TP) is accepted by MARS, and lines are changed when modifications to these documents are submitted. Employee Travel Balance and Employee Expenses Year to Date are updated when a Travel Check (TC) is accepted or disbursements are processed.

  •  
  •  

Traveler ID

Key field. Enter the employee ID or vendor ID of the person making the trip.

Traveler Name

Display only. This field identifies the name of employee making the trip and is inferred based on the value entered in the Traveler ID field.

Last Action Date

Display only. This field identifies the date of the last transaction that updated this file.

Trips YTD

Display only. This field identifies the total number of trips this traveler has made this year.

Amounts

Outstanding Advances

Display only. This field identifies the total amount of advances yet to be settled.

Traveler Expenses YTD

Display only. This field identifies the total travel expenses this employee has incurred this fiscal year.