This page is Work In Progress
Travel Tables
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.
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
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 Record Send Back
| Traveler
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
|