Cycle 64

8/14/2017 – 8/25/2017

Work Complete

Course fee fields are only displayed on offerings that have fees, previously labels and empty fields were displayed on all offering details. (This update is complete, but will be put on production with an upcoming release.)

Grants web database has been retired. Over the last few year UW grants reporting and tracking tools have improved to the point that this system is no longer needed. We will continue to maintain this database as a back end system for college reporting and to support the faculty merit helper tool.

Update reporting of test scores for certified teachers required by WA state. Reporting from the new Student 2 database, added logic to select single applicable tests for each basic skills and endorsement category.
Letters of recommendation from application are now included in Student attachments.
Institution option list in edit placement form displays City, ST to differentiate institutions with the same name.
Built tools to support long term reporting of career data for teachers who recieved certification through College of Education. The final report shows percent of certified teachers who are teaching for the ten years following certification. Create table, import process, and web form for managing this data.

Fixed the "How did you hear about us?" question on the public "half sheet" form for prospective students. It was showing label and help text for college staff.

Update the test score assessment configuration views. Break down into assessements by test type to make list more usable.

7/31/17 – 8/11/17

Report filter for Online component. This is based on UW Time Schedule value where course can be traditional, partially online, or completely online. Courses database allows filter to "only traditional" or "courses that are partially or completely online".
Added filter to Course Responsibility report for academic year. This report shows which college area, program, etc is responsible for scheduling and staffing a particular course. Academic year filter helps us prioritize active courses for Area reorg.

Further refined spam URL remover to better handle email addresses embedded in question field.

Added import and comparison tools for WA State OSPI eCert file. This file includes state teacher and administrator records for people with certification recommended by the College of Education. We use this file to quality check our local certification data. This feature provides tools for reviewing differences and quickly reconciling them.
Ignore feature for eCert file comparison. This is used when a former student's certification status changes, but not based on recommendation through the college.
Report for OSPI Certificates that have a recommended date, but no issued date. OSPI response generally comes within two weeks. This report helps us with data entry and to surface problems during certification process.
Always display UW email in student database. In some cases a student's UW email address was not displayed in the student database. If a student has a UW NetID their UW email is, now, always displayed first. Also the same email address should not be displayed multiple times.
When student contact information has an empty value "0" for a phone number, that is no longer displayed.
Add advisor form uses student's first enrolled quarter as the default advisor start quarter.
Inactive students are included in the Students with Multiple Advisors reports. This report is used by OSS to accurately maintain advisor relationships.

7/17/2017 – 7/28/2017

Added Online Learning Type field. This is a new field in UW Time Schedule construction which captures whether courses are traditional (in-person), hybrid, or fully online. Default value and comparisons set up so no data entry required for this field on traditional courses. Online Learning Type field is not displayed on traditional course detail, but gets special highlighting for online courses. Online courses are indicator with sticker in list views.
Removed the redundant Distance Learning (yes/no) field.

Migrate appointment import from HEPPS data to Workday data. Appointment data is used primarily for updating authorizations in college info systems. Update person views for new data model.
Converted authorization "glance" icons from plain color coded bubbles to pills with an inital for the information system represented.

Migrated email system from SMTP to external email service. This provides better email handling, reduces spam false positives, and provides excellent tracking.
Show count of applications from persons who RSVP'd for an event. Match on email address.
Update to Ask a Question prompt for Student Services.
Fixed broken links on "bulk add email" results page.

X grade tracked issues are rechecked nightly for grade that are submitted late and resolved automatically.
Placement types can be modified. Previously type attribute was locked due to difference in fields between types. When placement type is modified placement edit form reloads with appropriate fields.
Special Education placements types can be changed without disrupting automated placement creation. Placement rules system creates implied placements from course records using general placement type. These placements can be changed to the correct, more specific types.
Implied placement configuration for EDC&I 561 and 601, special rule with unique handling that looks for these two courses taken during the same quarter.
Add "Download as CSV" for placements by institution report. This includes the Generated Placement report which uses the null value "Unknown Institution". Prototyped a CSV field manager that provides reusable components for assembling export files.
Update the data importer for Doctoral Committee data, Grad School changed report format.