IT Connect

Information technology tools and resources at the UW

Archive for category: News

Enterprise Data & Analytics and Enterprise Data Warehouse news item

Helpful New Tool: UW Calendar Lookup

This morning you probably arrived at work and thought to yourself, “what Biennium are we in?” Or maybe you already knew that, but got hung up on the fact that the 2020 FY is in the 2019 Biennium (WHAT!?). You panicked, feverishly googled, got frustrated, lost confidence, and moved on to an easier pursuit, like contemplating infinity.

If you’re thinking, “there’s got to be a better way!” Well, now there is, with a new calendar lookup tool built by Data Architect, Courtney Drake, in Office of Planning and Budgeting (OPB).  It’s using EDW data and is hosted on our Tableau servers. Check it out yourself, and never get confused by the 5 overlapping UW calendars again!

You can find it in a couple of places –

Report Update: Class List By Curriculum Course Section (removed Pending Major)

The Report Prioritization Group released an update to the Class List By Curriculum Course Section report. This post summarizes those changes.

Change Summary:

  • Temporarily removed Pending Major Column: 

    • In early August 2019 we released an update to the report to add a student’s Pending Major as a column in the report. 
    • The initial response to this release was positive, but we recently learned that the update was causing the report to fail to run when users selected to view multiple quarters of data. 
    • Removing the column resolved the bug, but we are now investigating a resolution for how we can provide this data. 

Please Provide Feedback: 

  • The challenge with providing this data in the Class List report is that “Pending Major” is an attribute of a student at the current point in time. However, this report allows users to view data across time. This time dimension is what caused the report to fail. 
  • If you are a user who finds value in the Pending Major data, can you please write us to share how you use it in your work? We especially want to know:
    • Do you need to know a student’s historical pending majors?
    • Or, are you mostly interested in a list of students for the current quarter that are in your Department’s classes and have a pending major that you advise?
    • What do you do with this data? 
  • To provide feedback please write help@uw.edu with “RPG: Class List Report Pending Major Feedback” in the subject line

Questions?

This report references the term Pending Major. If you have questions about the meaning of this or any other term, please explore the link above or find more detail in the Knowledge Navigator

As always, if you have any questions, please write help@uw.edu and put “RPG: Class List By Curriculum Course Section” in the subject line.

 

New Report Release: Immunization Report

The Report Prioritization Group is excited to announce the release of the new Immunization Report.

Summary: 

We are offering a new reporting tool on the BI portal that provides information about students and their immunization status. The report is intended to be used by Hall Health and Health Sciences Immunization Program (HSIP) to identify students who have or have not fulfilled their immunization requirements.

Questions? 

To run the Immunization Report or any report on the BI Portal, you will need permission to access data in the Enterprise Data Warehouse (EDW). If you do not already have EDW access, follow this link to the enterprise data site to find your authorizer and request access. 

As always, if you have any questions or feedback about the report please email help@uw.edu and include “RPG: Immunization Report” in your subject line.

Report Update: Undergraduates Eligible to Register – Removed Applied to Graduate Filter

The Report Prioritization Group released an update to the Undergraduates Eligible to Register. This post summarizes those changes.

Change Summary:

  • Based on user feedback we have removed the Applied to Graduate (Y/N) Filter, and the applied to graduate column from the Undergraduates Eligible to Register report. 

More Detail: 

  • We received feedback from several users that the Y/N field was returning unexpected results. We were told the the Y or N was clear, but what wasn’t clear was the logic used to derive the flag. 
  • We decided to replace the Y/N flag with the actual Year and Quarter (e.g. Autumn 2020) when the student has applied to graduate. This will provide more detail for users than the simple Y/N field did. 
  • The Student Applied to Graduate field and Year Quarter will be added in the next release of updates to the report. We are currently working on implementing these changes. 
  • In the next release, we will also include several more enhancements to the report, including: 

Questions?

If you have questions about the meaning of Eligible to Register, please find more details in the Knowledge Navigator

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

 

New Report and Data Release: Cost Share Commitments and Contributions

Now Available in the EDW: Cost Share Commitments and Contributions data and report 

Do you find managing Cost Share with the Unmet Cost Share Report difficult because of the way commitments and contribution details are organized? If you could, would you like to dive deeper into how Cost Share commitments roll up to the Financial Organization at the Dean, Major, Department, and Subdivision levels?  Would it make your life easier if you could filter out closed Cost Share Commitments or analyze data by the Award End Date? 

Thanks to the partnership between Information Management team in UW-IT and Kirsten DeFries, Andra Sawyer, and Matt Gardner of the Post Award Fiscal Compliance team, access to this information and more is now available in the EDW, BI Portal, and Knowledge Navigator. 

New Report:
The new Cost Share Commitments and Contributions report, available in the BI Portal, shows summary information on all active Sponsored Awards with a Cost Share Commitment entered into the Cost Share Summary system. 

The report gives users detailed and summary information and the ability to analyze Cost Share commitments by the four levels of the Org Code (Dean, Major, Department, Subdivision), Award PI, and days until award end date. 

New Data:
The report sources all of the data from a new table in the EDW. The new EDW data sourced from the Sponsored Award as entered into the SAGE suite and the Cost Share Summary system. 

This data can be accessed via ODS.sec.CostShareBalancePeriod. You will find fields that relate revenue source, object code, expiration days, commitment descriptions, Cost Share type (mandatory or voluntary), and more. The table can be easily joined using budget number or account code to other financial tables within ODS.

Server: edwpub.s.uw.edu
Database: ODS
View: sec.CostShareBalancePeriod

Questions:
If you have any questions about the meaning of Cost Share or any other terms referenced in this report, please visit Knowledge Navigator.

If you have any questions about the report or would like to provide feedback, please write gcafco@uw.edu and put “BI Portal Cost Share Commitments and Contributions Report” in the subject line.



Report Update: Time Schedule Information

The Report Prioritization Group released important updates to the Time Schedule Information Report. This post summarizes those changes.

Change Summary:

  • In response to user inquiry, we investigated and updated the data source for the “students denied” field in the report.
  • Based on input from the Office of the University Registrar, the report was updated to source students denied information from the sr_unmet_request table, instead of the timeschedule.students_denied column.

Questions?

“Students Denied” is a synonym for the concept of an “Unmet Course Section Request“. If you would like more detail about the meaning of these or other terms referenced in this report, please visit Knowledge Navigator.

If you have any questions about the report, please write help@uw.edu and put “RPG: Time Schedule Information” in the subject line.

Report Update: Research Budget Expenditures

Enterprise Reporting and Analytics has partnered with the Office of Research Information Services to release several updates to the Research Budget Expenditures Report. This post summarizes those changes.

Change Summary:

Based on user feedback, we made the following changes:

  • Budget Name Filter: An optional filter was added to the report that allows users to filter the report by budget name.
  • Org Unit Nbr Column: The column previously displayed an organization’s 7 digit department organization number. The column now displays the full 10 Digit Financial Organization Number (Organization Code).
  • Column Sort: You can now sort many of the columns in the report with the click of a button and without having to export to Excel. The sort feature works by clicking the two opposing triangles in the column header row.

Upcoming Training Opportunities: 

Interested in learning more about Research Administration Data (RAD)? The Office of Research Information Services offers classes on RAD Visualizations and Reports and the RAD Cube.  The next round of classes will be offered this fall and are available for registration through the Collaborative for Research Education (CORE):

Questions?

If you have any questions about what constitutes a Sponsored Research Expenditure or any other terms referenced in this report, please visit Knowledge Navigator.

If you have any questions about the report, please write help@uw.edu and put “Research Budget Expenditures Report Changes” in the subject line.

Report Update: Class List By Curriculum Course Section

The Report Prioritization Group released important updates to the Class List By Curriculum Course Section Report. This post summarizes those changes.

Change Summary:

Based on user feedback, we made the following changes:

  • Added Pending Major  into the report.
  • Added Pending Major Effective Quarter to report.
  • Fixed minor campus display bug at the report footer information.
  • Updated definition at BI Portal Interpretation tab with added fields.

Questions?

If you have any questions about what constitutes a Class List By Curriculum Course Section or any of other terms referenced in this report, please visit Knowledge Navigator.

If you have any questions about the report, please write help@uw.edu and put “RPG: Report Update: Class List By Curriculum Course Section Report Changes” in the subject line

Report Update: Learning Spaces Policy

The Report Prioritization Group released important updates to the Learning Spaces Policy Report. This post summarizes those changes.

Change Summary:

Based on user feedback, we made the following changes:

  • Bug Fixes:
    • Fixed a bug that was causing the report to drop sections with a null in time schedule meeting time.
    • Also removed 250 clause. These classrooms are part of Learning Spaces Policy, and has to be scheduled directly with the TS office.

Questions?

If you have any questions about what constitutes a Learning Spaces Policy or any of other terms referenced in this report, please visit Knowledge Navigator.

If you have any questions about the report, please write help@uw.edu and put “RPG: Report Update: Learning Spaces Policy Report Changes” in the subject line.

Report Update: SEVIS Immigration Reporting

The Report Prioritization Group released important updates to the SEVIS Immigration Reporting Report. This post summarizes those changes.

Change Summary:

Based on user feedback, we made the following changes:

  • Bug Fixes:
    • Fixed a bug that was causing the report to display incorrect enrollment information for students who had withdrawn or who had low scholarship

Questions?

If you have any questions about what constitutes a SEVIS-Reportable International Student or any of other terms referenced in this report, please visit Knowledge Navigator.

If you have any questions about the report, please write help@uw.edu and put “RPG: Report Update: SEVIS Immigration Reporting Report Changes” in the subject line.