3/4/2019 – 3/15/2019
Work Complete
Applicant Review
This cycle was focused on building out our Application Data Warehouse data set in preparation for Deleting Application Data.
- (Complete) Red Flag, both short tag and note, are included in CSV spreadsheet downloads.
- (Fixed) Reviewer recommendation now correctly saves and refreshes the current view. When a review entered their admit recommendation the input was saved, but the old recommendation still showed on the current page.
- (Complete) Add database schema foreign key rules at the database level. Previously record relationships were managed exclusively at the application level. Having additional checks enforced by the database gives us extra security when we implement Application Delete.
- (Complete) Update fields in Applicant Review to handle graduated and undergraduate applications more consistently. Remove dead fields with missing or bad data.
- (Complete) Import additional demographic data from Grad School and UW SDB. Our Application Data Warehouse is populated from Applicant Review operational records. In order to populate the warehouse with demographic fields for historical reporting, those fields have to be part of the operation record.
- (Complete) Add scheduled jobs that load demographic data and populate the Application Data Warehouse data set.
Courses
- (Complete) Change default SCH value for new course release records from 85 to 100.