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