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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Editing now...
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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
Short Name
Last Action Person Last Name Last Action Person MDM ID Last Action Person Middle Name
Last Send Back Person Last Name
Traveler Department ID
Days in Calendar Year
Leap Year Monday Thru Friday Flag Month - YYYYMM Month Abbreviation
Sunday Date Of Week Week Label Sunday Saturday Week of Cal Year Week of Month Week Sunday to Saturday Since FY00
Days After Travel Days in Calendar Year
KEY Day Leap Year
Saturday Of Week Sunday Of Week Todays dateTravel Request
Week Of Calendar Year Week Of Month Week Sunday to Saturday Since FY00
TR
Chartfield KEY USF Department Initiative Code KEY Travel
KEY USF Project ID KEY USF Project Profile OU USF Account Code Percentage Travel Request Amount Travel Request ID
KEY Travel Location
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
Traveler College Code Traveler Department Name HSC Directory Traveler Global Department Abbreviated Name Traveler Global Department Name Traveler Global Department
|