IT Connect

Information technology tools and resources at the UW

Archive for month: December, 2018

Archived BI Portal Reports: Legacy Reports No Longer Available on BI Portal

The Business Intelligence Team in EIIA archived about 50 legacy HR/P reports. As a result, these reports are no longer available in the BI Portal or on the SSRS Server.

This is an important change because it reduces the amount of technical debt the team carries and enables us to focus on building and maintaining more valuable analytics tools.

Change Summary:

During Workday go-live, many reports were updated to continue sourcing historical HEPPS-era HR/P data. Now a year after go-live, these reports were getting little to no usage. Rather than continue to maintain these tools, we opted to archive them.

Before archiving the reports, we reached out to users in order to understand legacy report usage. We learned that some legacy reports continue to offer business value, and those reports are still available on the BI Portal.

See the bottom of this post for a full list of the reports that we archived.

Questions:

If you have any questions about this change, or if you think we inadvertently archived a report that you still need in order to do your work, please write us at help@uw.edu and put “BI Portal Archived Reports Question” in the subject line.

Archived Report List:

  1. Legacy FEC Dashboard Report by FEC Cycle
  2. Legacy FEC Dashboard Report by OrgCode
  3. Legacy Advance Budget Number Report
  4. Legacy PFLB Mailing List
  5. Legacy PDDC Mailing List
  6. Legacy PDDC_GFL Mailing List
  7. Legacy Emeritus Faculty Earnings
  8. Legacy President Deans Mailing List
  9. Legacy 100 Percent Sponsor-Funded Faculty
  10. Legacy Active Job Classes
  11. Legacy Employee_GTN_Information
  12. Legacy GTN_Detail
  13. Legacy Paid Direct Faculty Earnings
  14. Legacy Faculty Effort Certification (FEC) Dashboard
  15. Legacy GFLE Mailing List
  16. Legacy Hepps Payroll and GL Payroll Cash Account
  17. Legacy Salary Cap Cost Share Report
  18. Legacy Creative Communications Mailing List
  19. Legacy Budget Detail by Payroll Unit
  20. Legacy Federal Withholding Exempt Employees
  21. Legacy Mailing Services by Org_Job
  22. Legacy 2013 Base Year Paid FTE Report
  23. Legacy My People Report Menu
  24. Legacy Payment Verification Detail
  25. Legacy Academic HR FAC Reappointment Download
  26. Legacy Employee and Payment Verification Download
  27. Legacy Travel_Card
  28. Legacy My People by Appointing Department
  29. Legacy Hepps Payroll Monthly Summaries
  30. Legacy Payroll Payment Verification
  31. Legacy My People by Home Department
  32. Legacy Current Online Check Register
  33. Legacy General Faculty Mailing List
  34. Legacy Expense Distribution by Payroll Unit Code PUC
  35. Legacy Academic Personnel Appointments with Demographics
  36. Legacy Formatted Employee Download
  37. Legacy Retroactive Salary Adjustment Report
  38. Legacy Current Employee with Active Appointment
  39. Legacy Employee Download by PUCs
  40. Legacy Paid FTE by Funding Source
  41. Legacy Historical Online Check Register
  42. Legacy Faculty Appointments by Appointment Term
  43. Legacy Employee Download by Organization
  44. Legacy Academic Personnel Appointments
  45. Legacy Time Schedule Information
  46. Legacy People Finder
  47. Legacy Salary and Wage Expense Detail

Report Update: Undergraduates Eligible to Register

The Report Prioritization Group released an important update to the Undergraduates Eligible to Register Report. This post summarizes those changes as well as upcoming enhancements to the report.

Change Summary:

We recently updated the data source for the Undergraduates Eligible to Register report to a new table in the Enterprise Data Warehouse called “ACAD_dsetEligibleToRegister”. This update benefits users by getting the logic for identifying the report’s student population out of the report and into a table. This makes the report run faster, and enables data analysts with appropriate access to query the EDW to get the data directly (without having to recreate the report logic).

Impact:

There were no changes to the report filters or display. However, the report’s student population (see the definition for Eligible to Register) did change as a result of this update.

Before this update, for any given selected quarter, the report did not include students who had “applied to graduate”. Here “applied to graduate” means for instance, a student who applied to graduate in Autumn quarter would not be eligible to register in Autumn or future quarters.

That changed with this update. In the current version that is available on the BI Portal, students that have applied to graduate are included in the population.

What’s Next:

Based on initial feedback, this report needs to be updated to exclude students that have “applied to graduate”. The Enrollment Information Services Office is currently working on a solution, and we are planning to publish the updated report in early January.

Additionally, two other updates will be included in the next release:

- First, by request, the report will be updated to remove students that are deceased from the report’s population of students.

- Second, the “Include Requested Majors” filter will be updated. The filter currently displays the major that the student requested on their application (“Major Requested”). By request, the filter will be updated to display the student’s “Intended Major” that they selected during registration. The report filter is changing, but the student’s “Major Requested” is not going away, and the data will still be displayed in the report. 

Questions?

When the updated report is published to the BI Portal, you will receive an email update.

In the meantime, if you have any questions, please write help@uw.edu and put “RPG: Undergraduates Eligible to Register Report” in the subject line.