SDSHOWTO:Merging people

This depends on who you are merging:

Duplicate students

Usually this happens if the parent submitted an online application as a student and admissions didn't catch it.

• Determine the person_id of the duplicate and the real student in SDS (search for the name and hover over the link, capture the person_id of the student and the person_id of the duplicate)
• Determine the target person_id that you can merge the online app and payment information into. You cannot merge this into a student, as the parent needs to be able to access it from parent portal:
  • Search for the student and go into edit person by clicking on their name
  • Go into the person's parents tab
  • Click into their family (usually mother and father, but you have to use your judgement here)
  • Click into the person who has an email address. If both have an email address, click into both until you find someone with a username
  • Pull the person_id from that user the same way you captured the student and duplicate person_ids (through the URL)
• You should now have three person_ids: actual student, duplicate student, target parent
• Sign into phpMyAdmin as root/st...
• In the sidebar, go to SDS -> Tables
• Filter by app_app, then click into the app_application table
• Click search in the top bar, and search for person_id of the duplicate student
• Assuming a record comes up, click the Edit link and change the person_id to the target parent, then click Go
• Back in the sidebar, filter by theatre_rec and click into the theatre_receipt table
• Click search in the top bar, and search for person_id of the duplicate student
• Assuming a record comes up, click the Edit link and change the person_id to the target parent, then click Go
• Back in the sidebar, filter by person_ses and click into the person_session table
• Click search in the top bar, and search for person_id of the duplicate student
• Assuming a record comes up, delete the record
• Back in the sidebar, filter by person and click into the person table
• Click search in the top bar, and search for person_id of the duplicate student
• Assuming a record comes up, scroll across and make note of the username
• Delete the record if possible. If it is not possible, you need to look at the error message and figure out what it means. Usually there are records in other tables pointing to this person_id that you need to look at. Most records can be found in the same way as described above, but you need to decide whether to link to the actual student person_id or the target parent person_id. Most additional data will need to be relinked to the actual student person_id.