...
Retrieve Student Comms where Students are from Student Records AND Educational Institutional’s School Code = {school code} AND Active = true
...
Mapping
Contact (Wonde) | Student Comms (Salesforce) |
title | Related Contact → |
Salutation |
surname | Related Contact → |
Related Contact → Gender
gender
Related Contact → Id
id
Related Contact → Last Name
surname, legal_surname
Last Name |
forename, legal_forename
students → student_id | Student |
students → relationship | Carer |
students → priority | Emergency Contact Priority |
students → lives_with_pupil | Lives With |
phone | Related Contact → |
Phone |
id | Related Contact → |
Id |
mis_id
Student
students → id
Emergency Contact Priority
students → priority
Lives With
students → lives_with_pupil
--
gender | Related Contact → Gender |
forename | Related Contact → First Name |
Related Contact → Email |