Classic View: System Administration > Data Utilities > SIF
Search Term: SIF
This object defines a relationship between a contact person and a student.
SIF_Events are reported for this object.
Object Triggering
| Event Type | Requirement |
|---|---|
| Add | When a Relationship is created for the student |
| Add | When the relationship previously did not overlap today's date, and it is changed so that it overlaps today's date. |
| Add | When a student was previously Excluded and when it's changed to Not Excluded. |
| Add | When two people have relationship and one of them get enrolled . |
| Change | When the relationship type is changed. |
| Change | When the household, &/or household membership are changed. |
| Delete | When the contact is deleted. |
| Delete | When a relationship is ended before today's date, the record will be deleted for that year. |
| Delete | When all of the students non Enrollments are deleted. |
| Delete | When the Student is changed to Excluded. |
| Delete | When the relationship previously overlapped today's date, and it is changed so that it does not overlap today's date. |
Object Population and Business Rules
| Requirement |
|---|
| StudentContact exists when a relationship is created. |
| The relationship must overlap today's date. |
| At least one of the child elements of Contact Flags must have a Yes value. Do not publish the Student Contact instance if one of the child elements does not have a Yes value. |
| The Student must have a StudentPersonal Record. |
Object Data Elements
| Data Element Label | Description | Business Rules | Data Source GUI Path | Database Field | M, C or O |
| @RefId | The GUID of this contact | M | |||
| @StudentPersonalRefId | The GUID of the student whose contact this is. | Person.personID | M | ||
| @StudentContactPersonalRefId | GUID that identifies the contact person for the relationship. | M | |||
| Relationship | Defines the relationship of the contact to the student. | M | |||
| Relationship/Code | Code representing the relationship. | Report from Relationship Code section from below | M | ||
| Relationship/OtherCodeList | List of other codes or strings that crosswalk to or serve as translations of the Code element paired with this common element. If Code changes and OtherCodes are supported, both Code and all associated OtherCode elements must be present. | O | |||
| Relationship/OtherCodeList/OtherCode | A state/province code, local code, other code or a text string that crosswalks to or serves as a translation of an associated Code element. | MR | |||
| Relationship/OtherCodeList/@Codeset | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | M | |||
| ContactFlags | Contains Yes/No characteristics of the contact person's role. Provide a Yes value for all that apply. At least one of the child elements of ContactFlags must have a Yes value. Do not publish the StudentContact instance if one of the child elements does not have a Yes value. | M | |||
| ContactFlags/ParentLegalGuardian | Does the individual have parental or legal guardianship responsibility for the student? |
| Census> People> Relationships> Guardian | RelatedPair.guardian | C |
| ContactFlags/PickupRights | This element tells whether or not the contact has pickup rights. |
| Census> People> Relationships> Guardian | C | |
| ContactFlags/LivesWith | Does the student live with this contact? |
| Census> People> Households | HouseholdMember | C |
| ContactFlags/AccessToRecords | Does this contact have access to the student's records? |
| C | ||
| ContactFlags/EmergencyContact | Should this contact be notified in case of emergency? |
| RelatedPair.seq | C | |
| ContactFlags/HasCustody | Does this contact have or share custody of the student? |
| C | ||
| ContactFlags/DisciplinaryContact | Is this person to be contacted in case of disciplinary action? |
| C | ||
| ContactFlags/PrimaryCareProvider | Does this person provide daily living or personal assistance to the student? |
| C | ||
| ContactFlags/Other | This person has a relationship to student(s) that the school needs to document but no other contact flag value is 'Yes'. An example is a parent who enrolled the student but is deceased and is no longer a valid contact. | C | |||
| ContactSequence | Number indicating the order in which the person should be contacted. | Reports sequence field from RelatedPair. | O | ||
| SIF_Metadata | O | ||||
| SIF_ExtendedElements |
