This page is Work In Progress
Travel Tables
...
title | Travel Request Tables |
---|
Temp Column
...
Travel Data Sets in Power BI are the basis for the Pending report set. They are made available to analysts to create their own reports to meet on-the-fly and seasonal needs. Information available in the data sets is delineated below. The data sets are refreshed every morning with actions taken the day before.
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
This data set includes information about Expense Reports, no matter their status in Archivum. Once an Expense Report is submitted, the information for that ER is available in this data set the next day.
Day of the Week
Month YYYYMM
Begin Date
Short Name
Begin Date
Last Action Person Last Name Last Action Person MDM ID Last Action Person Middle Name
Last Send Back Person Last Name
Last Send Back Person Middle Name
Traveler Department ID
Traveler Department | Traveler Department ID Traveler First Name Traveler GEMS Employee ID Traveler Middle Name Traveler Last Name Traveler MDM ID Traveler Middle Name Traveler Name
Calendar Year Day of Week
Fiscal Month Fiscal Quarter Fiscal Year FYYY Quarter KEY Day Leap
Monday Thru Friday Flag Month - YYYYMM Month Abbreviation Month Name Saturday Date Of Week Sunday Date Of Week Week Label Sunday Saturday Week of Cal Year Week of Month Week Sunday to Saturday Since FY00
Days After Travel
Fiscal Quarter
FYYY
KEY Day
Saturday Of Week Sunday Of Week
Week Label Sunday to Saturday Week Of Calendar Year Week Of Month Week Sunday to Saturday Since FY00
TR
Chartfield KEY USF Department Initiative Code KEY Travel
KEY USF Fund ID KEY USF Project ID KEY USF Project Profile
Travel Request ID
KEY Travel Location
KEY Person Record KEY TR Begin Day KEY TR Create Day KEY TR End Day KEY TR Last Modification Day KEY Travel Details KEY Travel Doc Status KEY Travel Location KEY Travel Purpose Key Person RecordSend Back
Submitter Name TAR Number TR Created by MDM ID TR Total Amount TR Updated by MDM ID TR_TOTAL_AMOUNT_ZERO Travel Request ID Traveler Appt Global Department KEY Traveler Employee Record Traveler GEMS Employee ID Traveler GEMS KEY Department Profile
Traveler College Code Traveler Department Name HSC Directory Traveler Global Department Abbreviated Name - Travel Traveler Global Department Name Traveler Global Department Type Indicator
|