Adding Relationships from Admissions CRM to CX

relationshipFATH.sql

relationshipMOTH.sql

These are written to find students in SEM tables who are registered for the session and year at R status.  You will need to update the session and year appropriately.  This program also updates the gender field in the profile_rec and the id_rec.correct_addr field to "Y".  You can change the "commit work" at the bottom of the file to "rollback work" to test the program first and then change it back to "commit work" once you're satisfied with the program results.