StudentContactRelationship mapping

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