Archiving Report: 2013 Base Year Paid FTE Report

On November 19, 2019, the ERA Team archived the 2013 Base Year Paid FTE Report due to low usage and outdated information.

Archiving: What does that mean?

Archiving simply means that we removed this report from the BI Portal, and it will no longer be accessible. The purpose of archiving is to allow our team to reduce the volume of redundant or unnecessary tools that we support, and to focus on building new higher value solutions for you!

Replacement: Where can I get this info after the report is archived?

You can still access this information by connecting to Research Admin Data (RAD) cube. Here is a link on how to connect to the cube – Data Cubes. You can also find this information in Research Budget Expenditures report in BI Portal.

Questions?

If you have any questions about this transition, please don’t hesitate to write us at help@uw.edu and put “2013 Base Year Paid FTE Report” in the subject line.

Table Reorg for the UWSDBDataStore Curriculum Management objects on December 16, 2019

Hello,

The Curriculum Management tables in UWSDBDataStore will have some changes on Dec. 16, 2019. These changes to the objects (listed below) will be available in the UWSDBDataStore on Dec 17, 2019 .
However, data on the new objects will be visible as soon as the Data Custodians submit the security role definitions.

(last updated: 11.25.2019)

New columns to be added:

Table Name	Column Name	Data Type
CM_Programs	CIPCode_title	nvarchar(300)
CM_Programs	program_dateEndLabel	varchar(25)
CM_Credentials	credential_dateEndLabel	varchar(25)
	CIPCode_title	nvarchar(300)
	stemCIP	varchar(10)
	alt_thesis_requirement	varchar(100)

Existing columns to be deleted:

Table Name	Column Name
CM_Programs	Program_Status
CM_Credentials	credential_Status

Please Note: The scope of the reorg may still change. Please check this page frequently to see changes to the scope.

RPG Release: New Fields Added to Time Schedule Information Report

We recently shared that you can now access Jointly-listed course information in the Time Schedule Report. Based on user feedback, the Report Prioritization Group just released several more updates to the BI Portal report, Time Schedule Information.

Change Summary:

Based on user requests, we added several new columns to the Time Schedule report. You can find these fields in the Columns to Display dropdown:

Instructor Netid
- Displays the UW Netid for the instructor(s) associated with this course.
Census Major Enrollment
- Displays total enrollments of major students in a course on census day of the quarter.
Census Non-Major Enrollment
- Displays total enrollment of non-major students in a course on census day of the quarter.
Census Enrollment
- Displays the the sum of the major and non-major enrollments at census day.
Census Student Credit Hours
- Displays the total number of student credit hours for a course on census day.This is equaled to the actual enrollment count multiplied by the course’s credit amount on census day.

Withdraw/Suspend:
- Based on the status of a course, this field displays “Withdrawn”, “Suspended” or blank if the course is neither withdrawn nor suspended.
Online Learn Type:
- Displays the online learning type for a course. Options include: “No Online Learning”, “All Online”, “Hybrid”, and “Enhanced”.
Distance Learn Type:
- Displays the distance learning type for courses that have an online component.
Three new columns that display a “Y” if a course meets these requirements:
- Research
- Service
- Writing

We also released a few other enhancements to the report including:

Building Map Link:
- Now when you click the hyperlinked building name, the UW map opens in a new tab.
- How? Select “Building” from the columns to display filter and a hyperlinked “Bldg” field will display in the report. Click the field to open the location on the UW map.
- Note: Since the map application only displays UW-Seattle, this feature only works for UW Seattle buildings.
Quarter Filter:
- The quarter filter now includes future quarters of Time Schedule data.
Bug fixes:
- Fixed the alignment of the Instructor filter label

Questions and Feedback:

This report references many concepts like Distance Learning and Joint Course Loop. To get detailed definitions for these and other terms, please check out Knowledge Navigator!

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

RPG Release: Updates to Time Schedule Information report

Based on user feedback, the Report Prioritization Group released updates to the BI Portal report, Time Schedule Information.

Change Summary:

The Time Schedule Information report now includes summary and detailed joint course loop information.

Joint Course Summary Info:
- New Filters
  - The following filters have been added to the Columns to Display parameter:
    - Loop Joint Course Flag
    - Loop Current Enrollment
    - Loop Limit / Est Enrollment
    - Loop Joint Limit
    - Loop Joint Courses

Joint Course Detail Info:
- You can now drill down to a subreport that contains detailed course loop info.
- Look for the column “Loop Jnt Course Flag”, and click the hyperlinked “Yes”.
- The detailed subreport will open in a new tab.

What is Next?

In response to these updates, users have requested additional fields to be added to the report. We are also prototyping a visualization that will display course enrollments by time and day based on the Time Schedule data. Stay tuned!

Questions and Feedback:

This report references many concepts like Joint Course Section and Joint Course Limit. To get detailed definitions for these and other terms, please check out Knowledge Navigator!

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

Course Sections that are offered simultaneously (taught by the same instructional faculty and at the same time and place) but listed separately on the Time Schedule are Joint Course Sections. Joint Course Sections fall into three categories: sections of Permanent Joint Courses, Ad-hoc Joint Course Sections, and Faux Joint Course Sections.

Click to Learn More in Knowledge Navigator

EDW & EWS Data Changes Coming to Support Northwest Hospital (NWH) and UW Physicians (UWP)

This is a heads up on upcoming changes to both the Enterprise Data Warehouse (EDW) and Enterprise Web Services (EWS).

As you may be aware, UW Medicine is currently in the process of consolidating activities across two of its major entities:

Northwest Hospital (NWH) will become a second campus of the University of Washington Medical Center (UWMC)
UW Physicians (UWP) staff will become part of the UW Medicine Health System (UWMHS) supervisory org structure in Workday and part of the School of Medicine otherwise

A major component of this consolidation effort includes integration of ~2600 NWH and UWP employees into Workday and UW-IT systems. A dedicated project is in progress to support this transition. The project has successfully completed design, configuration, and 2 rounds of end-to-end testing. The final round of end-to-end testing is now in progress. The cutover and data migration activities are planned for the last two weeks of December 2019, with the final cutover planned for January 1, 2020.

We do not think the changes impact you.

However, we want to make sure you aware of what is happening. Over the last few months both EDW & EWS teams worked very hard to evaluate, adapt, and test the changes. The goal is to ensure a smooth transition for NWH and UWP units while minimizing impact on the rest of campus.

Existing fields are not changing as part of this work. There are no new data elements. So what are the changes?

New values will appear in existing fields. The new values will start showing up in mid-December with a final implementation date of January 1, 2020.

The new values fall into two categories: 1) data additions that could happen at any time, and 2) changes that are unique to this project.

1. Data additions that could happen any time

We’re communicating them here because they are being added as part of the NWH/UWP project:

Supervisory orgs
Cost centers
Locations
Job profiles
Job classifications (absence related)
Compensation grades
Bargaining units/unions
Job families, related to unions

2. Changes that are unique to this project

New employee sub type (worker type):
- This new type of employee (worker) was added to support paying some NWH hourly employees the actual hours they work
- This new type of employee (worker) is for positions known as “regular, hourly”
- Currently, only relevant to a subset of the NWH population
- “Regular, hourly” subtype will function the same as the subtype “regular”
- The assumption can no longer be made that an hourly employee is temporary
- Hourly employees can be temporary or regular, depending on their job profile
New pay component code (earning code):
- Associated with the new employee subtype
- The new value is RGH
- RGH is typically treated like regular earnings, REG, except the pay type is hourly
- RGH is treated as “REG Equivalent”

How can you tell if you are impacted by #1 or #2’s new values?

Consider how you filter or query on these concepts. If a new value shows up, will that impact your results?
If you do any filtering or querying around “regular earnings”, based on what you are trying to accomplish, you may need to include “RGH” in the long list of codes that are treated like “REG”.

We will continue to update this page with new information related to the NWH/UWP Implementation Project based on your questions and as new information emerges.

If you have any questions about these changes, as always, we’re here to help you. So are our partners with the NWH/UWP Implementation Project. The best way to reach us is:

For EDW questions, email help@uw.edu with the subject, “EDW Question about NWH/UWP”
For EWS questions, email hrpws-support@uw.edu

EA Showcase 2019 – Event Resources

The EA Showcase 2019 was a success. We had a good crowd from across campus join us for the morning. The morning started with high level challenges and trends and then moved on to table work on UW-specific concerns. All of this was used to demonstrate why Enterprise Architecture has moved away from developing “wiring diagrams” of the technology towards a much more collaborative and cross-cutting change leadership practice.

What did attendees take away?

“It was great to have a conversation at the enterprise level.” “Hearing from the panelists – their expertise and experience.” “It was good to talk to people from other parts of the University.” “I liked the direction and leadership based on the EA Charter and resources.” “There is so much to leverage from the website including the resources and the EA team’s expertise.” “Three hours was not enough time.”

Summary and Links to Resources:

Jim Phelps, Director of Enterprise Architecture & Strategy, started the morning talking about Digital Transformation and the impacts it will have on society and universities. Megan Kennedy, Interim Director of the UW Resilience Lab, followed up with a discussion about student well-being and student challenges around food, housing and mental health. Ann Anderson, Associate Vice President of Finance, then discussed the financial realities of higher education and how UW is meeting those challenges. Ann also discussed the drivers for the UWFT program.

These high-level challenges and trends set the stage for the rest of the morning which was spent doing group work at tables. The EA team; Rupert Berk, Jacob Morris and Piet Niederhausen; walked the room through the EA Value Chain and Architectural Value statements. The tables then worked on a architectural challenge in their space – developing a trends and drivers, a scope statement, and doing an engagement scan.

The closing highlighted how architectural problems are “adaptive problems” that is problems where the both problem is unclear and the solution is unclear. These problems require a collaborative and matrixed response to solve. The idea of the “virtual architect” – that is a collaborative architectural effort involving many participants – was introduced as the new way EA thinks about their practice.

The team highlighted resources (linked from our website) that are available to the attendees to help them in their own work.

Resources:

RPG: Updates to Student Course Distribution

Based on user feedback, the Report Prioritization Group released updates to the BI Portal visualization, Student Course Distribution.

Change Summary:

This is the first major update to the Course Progress in Major/Student Course Distribution visualization since it was implemented about 3 years ago. The changes discussed below are mostly usability enhancements based on feedback we collected from users.

Before

After

Display:
- Changed cells from circles to squares
- Removed Course Names from being displayed vertically on the top of a viz. Course information is now available in the tooltip.
- Updated the colors to be more intuitive (i.e. gray for “no activity”)
- Added a legend to clarify what is being displayed
New “Drill-down” Functionality:
- This visualization now includes a new drill-down represented by a “plus” sign next to a Student No column label
- This allows a user to drill to a course section level via curriculum code. If a user wants to go back to a starting point, just click on the “minus” sign next to a “Curriculum Code” label.
Filters:
- New Filters allow you to more easily narrow down the results
  - Campus
  - Curriculum Code
- Updated filters:
  - We moved the filters section from top of the viz to the left freeing up extra space for more filters.
  - We made the filters “cascading” so that each filter only shows relevant values based on the previous selections

What is Next?

We have additional updates planned for Course Progress in Major, including:

Splitting the three views into three distinct, but linked tools.
Update the data source to pull in more than just the 20 “most common” courses now that we have additional space in the chart.
Prototype the integration of MyPlan data to demonstrate if a student plans to take a course in the future.

Questions and Feedback:

These updates were based on feedback from users like you. We rely on your questions and comments to help us understand what we should build/change, so please don’t hesitate to write to share your experience, feedback, or suggestions for improvement.

As always, if you have any questions, please write help@uw.edu and put “RPG: Course Progress in Major” in the subject line.

EDWPresentation – UWProfilesStudent Reorg 11/4/2019

This table is scheduled to be updated on Monday, November 4^th, 2019.

Logic changes:

Table Name	Column	New Logic
UWProfilesStudent	VisaType	Blank values will show as NULL
UWProfilesStudent	RunningStart	Blank values will show as NULL

Columns to be deleted:

Table Name	Column Name	Notes
UWProfilesStudent	ToalUpdTransfer	There was a typo in the original column name. There is another column in the table, “TotalUpdTransfer”, that should be used instead.

Please send all questions and concerns to help@uw.edu, with the subject line “UWProfilesStudent Update 11/4/2019”.

EDW Disaster Recovery Exercise on October 23, 2019

On Wednesday, October 23, 2019 from 8 a.m. to 10:30 a.m. the Enterprise Data Warehouse team will complete our Annual Disaster Recovery Exercise. Because this exercise affects the EDWPUB SQL Server as well as Reporting Services Reports hosted on the BI Portal, your user experience may be impacted in the following ways:

System performance issues may occur during this time
Potential service disruptions
Potential delayed data

This exercise has been rescheduled from its original date of October 9, 2019.

If you have any questions or concerns, please contact us at help@uw.edu.

Update October 23, 9:22 a.m.: The EDW Annual DR Exercise is complete. All systems are back to normal.

EDW Disaster Recovery Exercise Rescheduled

Update Oct 9 2019 8:21AM: The EDW DR Exercise previously scheduled for this morning has been cancelled and will be rescheduled for a later date.

On Wednesday, October 9, 2019 from 8 a.m. to 10:30 a.m. the Enterprise Data Warehouse team will complete our Annual Disaster Recovery Exercise. Because this exercise affects the EDWPUB SQL Server as well as Reporting Services Reports hosted on the BI Portal, your user experience may be impacted in the following ways:

System performance issues may occur during this time
Potential service disruptions
Potential delayed data

If you have any questions or concerns, please contact us at help@uw.edu.