4/1/2019 – 4/12/2019
Work Complete
Applicant Review
- When an Application is deleted system checks if that Application was only reference to a Person record. If if was the only reference the Person record is deleted also. If it was not the only reference (person had other applications, is a student, is a college employee) the Person record is preserved.
- Moved applicant contact information from Person record to Application record. This gives a clear relationship so contact information can be deleted with Application.
- Moved self-reported test scores to the Application context. This clarifies the origin of these scores and allows the self-reported scores to be deleted with the Application.
- Copy applicant email address to person record. We want to keep this for enrolled students after application is deleted.
- Added contact information, self-report test scores, Grad School application web service cache to the Application delete routine.
- Created a batch routine that deletes all applications in a given quarter.
Person
- Create a person reference report that shows all references to a person record in the system grouped by the person’s role in that context (e.g. person is an Applicant, person is a Student, person is an User). This query is based on a “Person-Reference” configuration which provides concise listing and categorization of database relationships to the
personstable. - Refactor the person merge system to use the “Person-Reference” configuration.
- Added a person delete process that deletes a Person record and all of its child records. This process also uses the “Person-Reference” configuration.
- Add foreign key constraints to database schema. Application deletes will impact person data and I want an extra level of validation that related records are considered and handled correctly.
- Remove use of person id: 0 in logging fields to represent actions performed by the system.