{"id":3234,"date":"2019-04-15T15:17:31","date_gmt":"2019-04-15T15:17:31","guid":{"rendered":"https:\/\/www.education.uw.edu\/technologycenter\/?p=3234"},"modified":"2019-04-15T15:17:31","modified_gmt":"2019-04-15T15:17:31","slug":"cycle-101","status":"publish","type":"post","link":"https:\/\/coedev.education.uw.edu\/technologycenter\/workplans\/cycle-101\/","title":{"rendered":"Cycle 101"},"content":{"rendered":"<p>4\/1\/2019 &#8211; 4\/12\/2019<\/p>\n<h2>Work Complete<\/h2>\n<h3>Applicant Review<\/h3>\n<ul>\n<li>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.<\/li>\n<li>Moved applicant contact information from Person record to Application record. This gives a clear relationship so contact information can be deleted with Application.<\/li>\n<li>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.<\/li>\n<li>Copy applicant email address to person record. We want to keep this for enrolled students after application is deleted.<\/li>\n<li>Added contact information, self-report test scores, Grad School application web service cache to the Application delete routine.<\/li>\n<li>Created a batch routine that deletes all applications in a given quarter.<\/li>\n<\/ul>\n<h3>Person<\/h3>\n<ul>\n<li>Create a person reference report that shows all references to a person record in the system grouped by the person&#8217;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 &#8220;Person-Reference&#8221; configuration which provides concise listing and categorization of database relationships to the <code>persons<\/code> table.<\/li>\n<li>Refactor the person merge system to use the &#8220;Person-Reference&#8221; configuration.<\/li>\n<li>Added a person delete process that deletes a Person record and all of its child records. This process also uses the &#8220;Person-Reference&#8221; configuration.<\/li>\n<li>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.<\/li>\n<li>Remove use of person id: 0 in logging fields to represent actions performed by the system.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>4\/1\/2019 &#8211; 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&#8230;<\/p>\n<div><a class=\"more-link\" href=\"https:\/\/coedev.education.uw.edu\/technologycenter\/workplans\/cycle-101\/\">Continue reading <span class=\"screen-reader-text\">Cycle 101<\/span><\/a><\/div>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[10,13],"tags":[],"class_list":["post-3234","post","type-post","status-publish","format-standard","hentry","category-workplans","category-workreviews"],"aioseo_notices":[],"featured_image_urls_v2":{"full":"","thumbnail":"","medium":"","medium_large":"","large":"","1536x1536":"","2048x2048":"","320w":"","480w":"","800w":"","mug-shot":"","sidebar-width":"","full-content":""},"post_excerpt_stackable_v2":"<p>4\/1\/2019 &#8211; 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&hellip;<\/p>\n<div><a class=\"more-link\" href=\"https:\/\/coedev.education.uw.edu\/technologycenter\/workplans\/cycle-101\/\">Continue reading <span class=\"screen-reader-text\">Cycle 101<\/span><\/a><\/div>\n","category_list_v2":"<a href=\"https:\/\/coedev.education.uw.edu\/technologycenter\/category\/workplans\/\" rel=\"category tag\">Work Plans<\/a>, <a href=\"https:\/\/coedev.education.uw.edu\/technologycenter\/category\/workreviews\/\" rel=\"category tag\">Work Reviews<\/a>","author_info_v2":{"name":"Paul Hanisko","url":"https:\/\/coedev.education.uw.edu\/technologycenter\/author\/haniskowashington-edu\/"},"comments_num_v2":"0 comments","_links":{"self":[{"href":"https:\/\/coedev.education.uw.edu\/technologycenter\/wp-json\/wp\/v2\/posts\/3234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coedev.education.uw.edu\/technologycenter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coedev.education.uw.edu\/technologycenter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coedev.education.uw.edu\/technologycenter\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/coedev.education.uw.edu\/technologycenter\/wp-json\/wp\/v2\/comments?post=3234"}],"version-history":[{"count":2,"href":"https:\/\/coedev.education.uw.edu\/technologycenter\/wp-json\/wp\/v2\/posts\/3234\/revisions"}],"predecessor-version":[{"id":3236,"href":"https:\/\/coedev.education.uw.edu\/technologycenter\/wp-json\/wp\/v2\/posts\/3234\/revisions\/3236"}],"wp:attachment":[{"href":"https:\/\/coedev.education.uw.edu\/technologycenter\/wp-json\/wp\/v2\/media?parent=3234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coedev.education.uw.edu\/technologycenter\/wp-json\/wp\/v2\/categories?post=3234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coedev.education.uw.edu\/technologycenter\/wp-json\/wp\/v2\/tags?post=3234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}