Tool Search: SIF
The current version of SIF is v2.7.
This object contains information about the people who are referenced as student contacts.
SIF_Events are reported for this object.
Object Triggering
| 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 Contact's address is changed. |
| Change | When Contact's information in demographics is changed. |
| Change | When the household, household location &/or household membership are changed. |
| Change | When the identity is 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. |
| The Student must have a StudentPersonal Record. |
| The contact person must not have an enrollment in the zone year. |
Follow SIF Zone Options Rules for Zones |
| Do Not Report when the Calendar > 'Exclude from SIF Exchange' is selected. |
| Selecting or de-selecting the State Exclude on Enrollment for the Student will not send Deletes or Adds. |
Object Data Elements
| Data Element Label | Description | Business Rules | Data Source GUI Path | Database Field | M, C or O |
| @RefId | The Id (GUID) that uniquely identifies the instance of the object. | M | |||
| PersonInfo | Common element containing person demographic information. | Person.personID | M | ||
| PersonInfo/LocalId | The locally-assigned identifier for this person. Note: LocalId may be used as a unique person identifier rather than a unique contact identifier. In this case there may be more than one object instance with the same LocalId. | O | |||
| PersonInfo/OtherIdList | Lists all "other" identifiers associated with the person. | Optional. Do not report. | O | ||
| PersonInfo/OtherIdList/OtherId | The other Id entry. | Optional. Do not report. | MR | ||
| PersonInfo/OtherIdList/OtherId/@Type | Code that defines the type of this other Id. Note: A subset of valid values may be specified in data objects. | Optional. Do not report. | M | ||
| PersonInfo/Name | The name of the person. Note: Type attribute value of 04 must be used here. | M | |||
| PersonInfo/Name/@Type | Code that specifies what type of name this is. | Reports "04". | M | ||
| PersonInfo/Name/Prefix | A prefix associated with the name like Mr., Ms., etc. | Optional do not report. | O | ||
| PersonInfo/Name/LastName | Last name | identity.lastName | M | ||
| PersonInfo/Name/FirstName | First name | identity.firstName | M | ||
| PersonInfo/Name/MiddleName | Middle name. | identity.middleName | O | ||
| PersonInfo/Name/Suffix | Name suffix . | identity.suffix | O | ||
| PersonInfo/Name/PreferredName | Preferred name. | identity.alias | O | ||
| PersonInfo/Name/SortName | This is the name to be used for sorting purposes. | Last Name, First Name (space) Middle Initial | identity.lastName, identity.firstName, identity.middleName | O | |
| PersonInfo/Name/FullName | A free text field for the complete name. | First Name + Middle Name + Last Name | identity.firstName, identity.middleName, identity.lastName | O | |
| PersonInfo/OtherNames | Previous, alternate or other names or aliases associated with the Person. | Optional. Does Not Report. | O | ||
| PersonInfo/OtherNames/Name/@Type | Code that specifies what type of name this is, excluding "name of record." | Reports "01" for the earliest prior identity name record Reports "05" for the second most recent identity name record, only if there are 3 or more identity records. | M | ||
| PersonInfo/OtherNames/Name/LastName | The last name. | Reports the contact's Last Name. | identity.lastName | M | |
| PersonInfo/OtherNames/Name/FirstName | The first name. | Reports the contact's First Name. | identity.firstName | M | |
| PersonInfo/Demographics | This element contains information related to person's demographics. | Optional. Does Not Report. | O | ||
| PersonInfo/AddressList | The contact's address(es). | O | |||
| PersonInfo/AddressList/Address | A collection of the addresses that exist for the student. | Order address by: 1. Non-secondary 2. Most recent Start Date | MR | ||
| PersonInfo/AddressList/Address/@Type | Code that defines the location of the address. Note: A subset of specific valid values for each instance in a data object may be listed in that object. | Report Addresses in the following hierarchy:
| householdlocation.private householdmember.private | M | |
| PersonInfo/AddressList/Address/Street | The street element is a complex element and breaks the street down into several parts. | M | |||
| PersonInfo/AddressList/Address/Street/Line1 | Address line 1. | When address.postOfficeBox = checked, reports "P.O. Box " followed by address.number (e.g. "P.O. Box 1234" When address.postOfficeBox = not checked, reports address.number, prefix, street, tag, and dir separated by spaces | Address.number, .prefix, .street, .tag, .dir | M | |
| PersonInfo/AddressList/Address/Street/Line2 | Address line 2. | Census > Households > Addresses | Address.apt | O | |
| PersonInfo/AddressList/Address/Street/Line3 | Address line 3. | Reports in format: City, ST ZIP | Census > Households > Addresses | Address.city, .state, .zip | O |
| PersonInfo/AddressList/Address/Street/StreetNumber | The address number assigned to the building. | Census > Households > Addresses | Address.number | O | |
| PersonInfo/AddressList/Address/Street/StreetPrefix | Street prefix like NE | Census > Households > Addresses | Address.prefix | O | |
| PersonInfo/AddressList/Address/Street/StreetName | The name of the street. | Census > Households > Addresses | Address.street | O | |
| PersonInfo/AddressList/Address/Street/StreetType | The type of street. For example, Lane, Blvd., Ave., etc. | Census > Households > Addresses | Address.tag | O | |
| PersonInfo/AddressList/Address/Street/StreetSuffix | Street suffix like SW. | Census > Households > Addresses | Address.dir | O | |
| PersonInfo/AddressList/Address/Street/ApartmentNumber | Type of apartment, for example, Suite. | Census > Households > Addresses | Address.apt | O | |
| PersonInfo/AddressList/Address/City | The city part of the address. | Census > Households > Addresses | Address.city | M | |
| PersonInfo/AddressList/Address/County | The county part of the address. | Optional. Does Not Report. | Census > Households > Addresses | Address.county | O |
| PersonInfo/AddressList/Address/StateProvince | The state or province code. | Census > Households > Addresses | Address.state | M | |
| PersonInfo/AddressList/Address/Country | The country code. | N/A | default | M | |
| PersonInfo/AddressList/Address/PostalCode | The ZIP/postal code. | Census > Households > Addresses | Address.zip | M | |
| PersonInfo/PhoneNumberList | The contact's phone number(s). | O | |||
| PersonInfo/PhoneNumberList/PhoneNumber | Reports twice: one for household phone and one for contact phone | MR | |||
| PersonInfo/PhoneNumberList/PhoneNumber/@Type | Code that specifies what type of phone number this is. Note: A subset of valid values may be specified in data objects | Report 0096 for household Report 0350 for contact | M | ||
| PersonInfo/PhoneNumberList/PhoneNumber/Number | Phone number. Free-form, but typical U.S. formats include: (###) ###-#### or ###-#### | When reporting for household, report the household phone number for the household that the student is a member of today. When reporting for contact, if the student's Cell Phone is provided, report Cell Phone; otherwise report Work Phone. | Household Census > People > Demographics > Personal Contact Information | Household.phone Contact.cellPhone Contact.workPhone | M |
| PersonInfo/EmailList | The contact's e-mail address(es). | O | |||
| PersonInfo/EmailList/Email | The staff member's e-mail address(es). | Census > People > Demographics > Personal Contact Information | Contact.email | MR | |
| PersonInfo/EmailList/Email/@Type | Type of e-mail | Report "Primary" | M | ||
| EmployerType | Code that defines the employer type. | Optional. Does Not Report | O | ||
| EducationalLevel | The highest level of education completed by the person. | Optional. Does Not Report | O | ||
| OptOutEmail | A "yes" value indicates person may only be contacted as authorized via email. This usually indicates they have requested contact be limited to essential purposes and use/release of their contact information (e.g. to Parent Teacher organizations) may be limited. | Optional. Does Not Report | O | ||
| SIF_Metadata | O | ||||
| SIF_ExtendedElements |
