3/18/2019 – 3/29/2019
Work Complete
Work continues toward Deleting Application Data. This cycle I implemented some tools to help Institutional Research team code records for the application warehouse and did refactoring of the warehouse data model. We want the warehouse vetted and settled before we begin the historical delete process.
Applicant Review
- (Complete) Forms for Institutional Research hand-coding. There are a few attributes we would like in the application warehouse that are not consistently represented in the application.
- (Complete) Refactor previous UW enrollment fields to capture specific previous COE undergraduate majors. We want the data warehouse to let us look at how graduates feed into other programs.
- (Complete) Refactor and rename simplified race/ethnicity fields. Frequently reporting requires us to report a single race/ethnicity value per application even though applicants are allowed to provide multiple. Different data audiences have different strategies to get to a single value. This change added multiple strategies to the data warehouse and made the field labeling more clear.
- (Complete) Refactor EDW Ethnicity maintenance routine.
- (Complete) Delete GRE fields from our local Application Data Warehouse. We have an established strategy for GRE reporting using UW institutional data.
- (80% complete) Application delete routine that purges the graph of records related to a single application. This routine also handles the move of specified items to the student record for enrolled students. (Specific application documents and rubric scores.)