This page is Work In Progress
...
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Temp Column Verify lang. |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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.
Days Before Travel
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
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
|