Report Update: Undergraduate Eligible to Register (Columns to Display, Major/Minor and Intended Major Filters)

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

Change Summary:

UPDATE – Minors
1. When “Default” value is selected in “Columns to Display” filter, Minors columns is displayed in the report.
2. “Minors” is no longer an option in “Columns to Display” filter.
3. The Majors/Minors filter order is consistent with updates to Student Degree Information.

NEW – Applied to Graduate
1. A field in the “columns to display” dropdown is added called “Applied to Graduate”
2. When the user selects the “Applied to Graduate” field the report displays a student’s year qtr that they applied to graduate in the format YYYYQ
3. If a student has not applied to graduate the field displays a blank.
4. A student’s Applied to graduate status is sourced from ACAD_dsetEligibleToRegister applied to graduate (degreeearnedyrqtr) column.

FIXED – Include Intended Majors filter
- We received questions on the behavior for the “Include Intended Majors” filter in Undergraduate Eligible to Register report. Previously, when users selected ‘Y’ for “Include Intended Majors”‘, the student population did not always display intended major students in the report. Students that showed up with intended major in a selected department were either declared majors within that department or pending major in the next quarter of enrollment. The report did not report other students who had intended major in the selected department. This issue has been resolved.
- Included below is a list of “Include Intended Majors” filter behavior:
  1. When “Include Intended Majors” filter is selected to value ‘Y’, and a student is a pre-major with the selected intended major, a student will be listed in the report.
  2. When “Include Intended Majors” filter is selected to value ‘Y’, and a student currently in other department/major, with the selected intended major, a student will be listed in the report.
  3. When “Include Intended Majors” filter is selected to value ‘Y’, and a student is a pending-major, with the selected intended major, a student will be listed in the report.

UWSDBDataStore Reorg on October 19, 2019

Hello,

The student database (SDB) will go through a reorganization on Oct. 19, 2019 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on Monday, Oct. 21, 2019 . (However, data on the new objects will be available as soon as the Data Custodians submit the security role definitions and the SIS team loads the data.) *

New columns to be added:
(last updated: 10.14.2019)

Table Name	Column Name	Data Type	Description
budget_resources	br_pkg_formula_no	tinyint	The packaging formula being used for the student for the specified quarter
sa_sf_fund	osfa_group_code	char(1)	Code for grouping Awards (“G”rants “W”ork Study “L”oans “P”lus Loans blank=not assigned)
sdb_security	sdb_sf_power_user	char(1)	Specifies someone in OSFA who can edit restricted fields on finaid screens.
sf_evaluation	s_filed_sched1	char(1)	Student filed a Schedule 1? (2, yes 1, no 3, don’t know, or blank)
	s_untax_ira_pensn	int	Student’s Untaxed Portions of IRA Distributions and Pensions
	p_filed_sched1	char(1)	Parents filed a Schedule 1? (2, yes 1, no 3, don’t know, or blank)
	p_untax_ira_pensn	int	Parents Untaxed Portions of IRA Distributions and Pensions
	child_fallen_hero	char(1)	Children of Fallen Heroes Indicator (1=yes, 2=no, blank=no determination made)
sr_adm_appl	cnet_account_id	integer	CollegeNet account ID.
	slate_appl_id	integer	Slate application ID
	pg_schol_amt	integer	Purple and Gold Scholarship amount
student_1	cnet_account_id	integer	CollegeNet account ID.
student_1	slate_appl_id	integer	Slate application ID
student_2	s2_iso_stat_id	char(12)	ID of S2-ISO-STATUS updater.

*Please Note: The scope of the reorg may still change. Please check this site constantly to see changes to the scope.

EA Showcase October 22, 2019

Transformative change in higher education and at the UW is creating new opportunities to improve teaching and learning, research, and administration. These opportunities challenge us to find new ways to adapt and collaborate.

Please join the Enterprise Architecture (EA) team and your colleagues from across the UW in a hands-on workshop to:

Explore the digital transformation already under way and national trends in higher education with a panel of experts
Discuss how this context impacts your work
Learn how architecture work is changing in this context
Work with peers to scan the landscape and plan collaborations to address architectural problems
Understand how the EA team and its resources can support you in this work

UPDATE: Registration is now closed. Summary and resource materials from the event can be found here.

When: October 22, 2019 at 9:00am-12:00pm – Meet & greet over coffee starting at 8:30am

Where: Husky Union Building (HUB) Lyceum (1st floor)

More information on Enterprise Architecture

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.

Introducing Ally: Accessible formats for course files

Ally, provided by Blackboard, generates alternative formats of course files uploaded by instructors—such as text that is readable by a screen reader, electronic braille, or audio—that students can download and use to support their learning.

Ally’s alternative formats feature is now available in all Canvas courses. To make course content easily accessible to all students, Ally converts files to formats that work better for everyone, not just those with particular learning requirements. For example, some students may prefer to listen rather than read. Ally provides audio conversions of text-based files. Or some students may need an electronic braille format or a format that is more easily used by a screen reader. Ally alternative formats are designed to make course content more accessible to everyone.

New features and updates

Newly added LTI tools available for all courses

Office 365 LTI This LTI tool offers integration with Microsoft Office 365 in Assignments, Collaborations, Modules, and the Rich Content Editor. Students and instructors can use, create, share, and collaborate on Office 365 files within Canvas. Providing an easy selection and embedding of files from OneDrive, students can submit files from OneDrive. Using the Office 365 LTI instructors can also share a template for student assignments. Prefer Google to Office 365? A Google LTI to use with Canvas will be released in winter quarter 2019.
GALE virtual reference library Gale Virtual Reference Library (GVRL) is a collection of over 60 Reference eBooks that can be cross-searched, browsed, and viewed on your e-reader. Now you can make the GVRL available to students directly in your course; just make the GVRL visible in the course navigation.

Newly released features from Canvas

Anonymous grading Graders cannot identify students associated with each submission that helps remove grading bias. When anonymous grading is enabled in a course, content creators can create assignments with the option to hide student names from graders.
Non-scoring rubrics Rubrics can be created without point values to create a non-scoring rubric. This feature promotes learning engagement by helping students focus on assignment feedback instead of point values.
Analytics BETA An all new course analytics tool that provides average course grade analytics, comparisons for selected assignments, sections, or students, and the ability to message students individually or based on specific criteria. You can opt-in to the analytics beta by adding it to your course navigation in course settings. Analytics is visible only to instructors, TAs, and admins.

UW-IT teams plan approach to container-based applications

Container technology has had a significant impact on automating software delivery practices. As Docker and Kubernetes have become de facto container standards, automated pipeline tools have emerged that can result in increased speed and reliability of application release and operation. Vendors, including Amazon, Microsoft, and Google, now provide managed Kubernetes services that simplify the complexity of running container clusters.

In response to the opportunities presented by container technology, the EA team worked with UW-IT application and infrastructure teams to develop a discovery project. In an eleven week period from May to July, 2018, teams from across UW-IT participated in a project to assess the viability of leveraging container-based applications (CBAs) in the organization.

In partnership with the UW-IT PMO, the EA team ran weekly three hour working meetings to develop an assessment framework and review research on application containers conducted by project team members.

The outputs of the project are a reference architecture and a whitepaper.

The reference architecture provides recommendations to application teams considering CBAs and shared services teams considering how best to enable CBAs regarding:

Scenarios in which CBAs are recommended
Team readiness, roles, and responsibilities for using CBAs
Effective and safe configuration of container clusters (such as accounts, clusters, pods, services, and networking)
Design of container based applications in different scenarios
Use of an effective pipeline for changes to applications and clusters

The whitepaper recommends a roadmap for opportunistic adoption of container based applications (CBAs) by UW-IT on behalf of the UW. That roadmap consists of three phases:

In Phase I (Early Adoption), we expect that a handful of application teams will adopt CBAs, relying on their own learning and the recommended reference architecture, with minimal change to shared services.
In Phase II (Invest in Expertise), UW-IT should support increased adoption of CBAs through training, consultation, and some growth in shared services.
In Phase III (Containers as a Service), UW-IT should develop an infrastructure shared service that enables teams with limited expertise in infrastructure to run applications, enabling the widest adoption.

Reminder: End-of-quarter checklist

The end-of-quarter checklist provides pointers for wrapping up your Canvas course: submitting grades, conducting an inventory of course content for use in a future session, exporting course content, and marking the course read-only for students. And because quarters come and go so quickly, you may want to check out the start-of-quarter UW Canvas checklist.

New imaging process available

Managed Workstation has a new process available for imaging a workstation called Operation System Deployment (OSD). The old process, called Litetouch or MDT, will remain available until October 31, 2019.

Why should I use this new process?

There are a number of enhancements immediately available via OSD including:

Computer is automatically joined to the domain as part of the process
You can choose to enable Bitlocker¹ as part of the process
The computer name by default is the serial number (you can override)
You can choose a custom image, if you’ve previously requested creation of a custom image that meets your needs

¹ Bitlocker encrypts the hard disk so that if the computer is stolen, the data is protected

How do I use this new process?

To use the new OSD imaging process: https://it.uw.edu/wares/mws/hardware/osd-image-installation/.

Can you tell me more about the custom image option?

Use this form to request a new computer image from the Managed Workstation service.

One of the enhancements possible with our new imaging process is the ability to easily create a custom image that builds on top of the standard MWS image. You may have a set of computers that need a specific set of applications installed. We can create a custom image that installs those applications as part of the imaging process, so that you don’t have to manually install them after imaging. Because your custom image is built on top of our standard image, it will be kept up to date with the latest Windows version.

How do I get local administrator privileges using this new image option?

When you ask for a computer account to be created via the Enable a computer for Managed Workstation services form, you can specify which users should be added to the local administrator group. In most cases, this should happen nearly immediately after the image completes, but in some cases, it may take up to 30 minutes.

What if I have more questions?

Please send email to help@uw.edu with a subject of “MWS OSD imaging process” with any additional questions.

Brian Arkills
Managed Workstation service manager & owner
UW-IT

MWS file service maintenance

On January 14th, 2019 starting at 7pm, maintenance will be performed on the MWS file service. This maintenance period will end on January 15th at 5am.

During this period, users may not be able to access their files.

After this period, if you experience problems accessing your files, please logout and log back in–this should clear the issue.