The scripts get run after add/drop has ended for the fall and spring semesters. The scripts look to registration to determine current and former student designations. Should the scripts be run before add/drop is complete changes could be made by students to their registration and the designations would be inaccurate.
- insert_currentstudent_attribute.sql
Run this script first. Follow the comments and be sure to update the variable values as appropriate.
- insert_formerstudent_attribute.sql
Run this script next. Follow the comments and be sure to update the variable values as appropriate.
- insert_student_giving_relationships.sql
Run these last.
This is a series of individual scripts. Begin and end dates must be updated as appropriate. Giving relationships/constituency codes need to be updated to have the current one be the default based on the hierarchy of the codes. If no record exists, then one must be created. These scripts will be difficult to run for someone who does not have knowledge of the dev_relations table, the codes and which codes IA have determined to take precedence based on their determine hierarchy.
Scripts attached to this article.