StudentContactRelationship mapping

Owned by James Overell
Last updated: Aug 29, 2020 by Hossein Jami

Record Selection

This object includes Student Contact records which meet the following criteria:

  • The Contact has a SIF RefID
  • Any Contact type value except 'SCT' 
  • Are linked to a Current Student (via the Contacts tab in Current Student Maintenance)
  • Where Primary Only Flag is unticked, the Spouse of the linked Contact is also included as long as they also satisfy the rest of the criteria
  • Is linked to a Current Student who has a SIF RefID
  • For a given Contact-Student Relationship, at least one of the following conditions is also met:
    • Parent Flag is ticked (on Contacts tab in Current Student Maintenance)
    • Lives With Flag is ticked (on Contacts tab in Current Student Maintenance)
    • Reports Flag is ticked (on Contacts tab in Current Student Maintenance)
    • Mail Flag is ticked (on Contacts tab in Current Student Maintenance)
    • Contact Type is one of the Emergency Contact values - 'SE1', 'SE2', 'SE3'  (on Contacts tab in Current Student Maintenance)
    • The person is linked as the Debtor for the Current Student (on Debtors tab in Current Student Maintenance
  • Where a Relationship record exists for the Contact (on Relations tab in Current Student Maintenance), the Relationship code must be mapped to a SIF value in Interface Settings
    • Where a Relationship record does not exist, the SIF value for 'Not Provided' will be used


Field Mapping