News content type for use by UW-IT Services on IT Connect
The EDW successfully upgraded our user-facing servers (EDWPub.s.uw.edu) to SQL Server 2019.
We believe you will experience minimal impact, however, if you do experience any issues, please reference our IT Connect article titled, “Preview available for upcoming EDW server upgrade” which contains a list of known issues.
Reporting issues
If you experience any issues you are not able to resolve, please write help@uw.edu and put “EDWPub Server Upgrade” in the subject line.
UW-IT and UW Learning Technologies developed a basic course template to help instructors quickly create courses that are easy for students to navigate. The template, which organizes course content within modules, is designed to accommodate a range of disciplines and teaching approaches. The design of the template was guided by two priorities: 1) to ease and simplify course creation, 2) to help students find the information they need. Our goal is for the template to empower instructors: to help them confident that they are creating a course that students will find easy to use.
Explore resources for teaching remotely: UW information hubs from Bothell, Seattle, and Tacoma, including the Roadmap to Effective Online Teaching. Also included are Canvas course templates, Canvas model courses, a Canvas course readiness checklist and guides for teaching with UW technologies. Get support for remote teaching from video resources and workshops and webinars. Review the resources now.
Check out the course readiness checklist when setting up a Canvas course for remote instruction. From setting up your Canvas site, adding course content to modules, customizing navigation, creating assignments and quizzes, setting up grading, helping students get started, making content accessible to all learners, and establishing your presence as instructor in a remote environment, the checklist can help you feel more confident when approaching remote instruction.
This resource was created by the UW Tri-Campus Committee for Online Learning Resources and Practices.
Updated April 25, 2023
The Enterprise Data Platform is working closely with our partners to ensure that our services are in place to support you in your efforts to prepare for UW Finance Transformation (UWFT). If you would like to better understand the current state of the UWFT program, please visit the Finance Transformation home page. If you have not engaged with the Finance Program yet and would like to learn more about how your specific processes may be impacted by UWFT, we encourage you to review the resources on the UWFT Change Network.
When FT goes live, we will be retiring the current version of FWS and replacing it with a new service, FWS v2, that will reflect the Workday Foundation Data Model (FDM), which is the technical framework that organizes financial data to support both financial and managerial reporting in Workday.
We are currently developing the new Financial Web Service (FWS v2) and provisioning data from Workday Test tenants. This data is available to you today in DEV and EVAL environments in order to help inform future state design of your own services and processes.
Update on 2/12/2021:
EDW team is going to deploy this change on Saturday February 27th to give room for our Payroll data processing to take place in the week of March 1st. If you have any concerns with the 2/27 deployment, please let us know as soon as possible by emailing help@uw.edu with the subject: “EDW WorkerPosition Changes”.
Thank you,
EDW team
2/2/2021
We’d like to share upcoming changes to the following columns in the views of the ODS and HumanResources databases.
The Impacted columns are:
| Views | Columns |
| ODS.sec.WorkerPosition | RecordLoadDttm, RecordUpdateDttm |
| ODS.sec.WorkerPositionDetail | RecordLoadDttm, RecordUpdateDttm |
| ODS.sec.WorkerPositionJobClassificationDetail | RecordLoadDttm, RecordUpdateDttm |
| HumanResources.sec.WorkerPosition (history data) | RecordLoadDttm, RecordUpdateDttm, RecordEffBeginDate, RecordEffEndDate |
If you have not used or care about these columns in these views, please stop reading and disregard the message. Otherwise, please see the following details.
Changes and Impacts:
There was a minor issue found in some EDW filtering logic for WorkerPosition’s daily loading process, which was not consistent with EDW’s rule of no data loading on Saturdays.
If there are Worker Positions whose end dates in the WorkerPositionEndDate column fall on a Saturday, then such rows will be correctly handled in the fixed filtering logic. All rows after October 2019 (when the filtering logic in question started being applied) will be reloaded; these rows will have either a new RecordLoadDttm and/or RecordUpdateDttm value. Some records (6000+) in the history data will have slightly different RecordEffBeginDate and RecordEffEndDate values, based on the fixed logic.
EDW team plans to deploy the change in the week of March 1st 2021.
If you have any questions about any of these upcoming changes, please email help@uw.edu with the subject: “EDW WorkerPosition Changes”.
Thank you,
EDW team
Based on user feedback, the Report Prioritization Group just released an update to the report: Class List By Curriculum Course Section. The report now includes student degree information.
Advisers requested the ability to see student “degree information” fields on the report. The report still allows you to filter down to a specific quarter and course and get a list of students enrolled in the course, but the degree info now allows you to also see:
We updated Columns to Display filter to expose several degree attributes.
Columns to Display filter:
This report references many UW institutional concepts, including Degree Status and Degree Year Quarter. 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: Class List Report/Degree Info” in the subject line.
The Report Prioritization Group (RPG) just released new changes to the BI Portal report Major Codes.
Based on feedback from the Graduate School and RPG, we updated the Major Codes filters and columns in the following ways:
We added a new filter “Degree Level” to the report:
The new filter allows you to restrict the report dataset to only the degree levels you want to see, like Bachelor or Professional.
We also added several new columns:
This report references important institutional concepts like Student Major, Fee Based, Tuition Based and many others. If you have questions about the meaning of these or any other terms, please explore the links or find more detail in the Knowledge Navigator.
As always, if you have any questions, please write help@uw.edu and put “BI Portal Report Question: Major Codes Report” in the subject line.
If you participated in the EDW’s Customer Survey, thank you! Understanding how you use the EDW helps us improve our services and enhances our ability to support you now and in the future.
Over One Million
You queried the EDW over one million times from August 2019 to August 2020.
By Popular Demand
By far, the type of data you want most is Finance (75%), HR/Payroll (62%) and Academic (54%). Among the variety of databases that you access, the top three are ODS, UWSDBData, and FinancialSumMart.
Roles and Responsibilities
At least half of you have multiple roles in your department and we know you have added responsibilities as a result. Data accessibility is vital to your work. Half of you access the EDW for data every day. With 36 distinct organizations accessing the EDW, the data you need is varied and unique to the work you need to do.
Finance Transformation
Finance Transformation and what it means for your work is top of mind for you. Many of you are keeping up to date on the changes to data that you access daily. And you’re aware that the way you work may need to change in the future.
Want More Survey Details?
To see more information, including a presentation deck and full results from the EDW Customer Survey, click the link below.
Stay in the Loop
You can find the latest news and updates for the EDW and Finance Transformation through the link below.
Hear About EDW and FT at the next UW Tableau User Group
Dawn Hemminger, Enterprise Data Platform Product Manager, UW-IT: IM, will be discussing the EDW and FT during the upcoming meeting for the Tableau User Group.
Register for UW Tableau User Group Event
Have a question or need help?
Some change will come with Finance Transformation and how you access data may be impacted. We’re here to help. Contact us at help@uw.edu with EDW Customer Survey in the subject line.
*data sourced from EDW access logs August 2019 through August 2020
Pronouns are now editable in Identity.UW.
Pronouns are now available in your MyUW profile and in MyUW Class Lists.
During the 2020-2021 academic year, UW will introduce a central pronoun option to enable students and other members of the UW community to express what pronouns they go by in their everyday lives.
Identity.UW will be central to this implementation by enabling the collection and distribution of pronoun data. Person Web Service (PWS) and Student Web Service (SWS) will be providing pronoun data from Identity.UW for campus systems to consume.
Although pronoun support in Identity.UW is not available in production yet, we have deployed the capability to support pronoun data in SWS and PWS in both EVAL and Production environments so that you can evaluate integrating pronouns support into your own system(s) if you choose.
For more information on the UW-IT Pronouns implementation and campus-wide rollout, we encourage you to learn more at: https://it.uw.edu/connect/identity/pronouns.
Learn more about integrating pronouns into your own tool(s) via an Enterprise Web Service at https://it.uw.edu/connect/identity/integrate-pronouns-from-identity-uw.
For PWS, please contact us at pws-support@uw.edu
For SWS, please contact us at sws-support@uw.edu