Tool Search: SIF
The current version of SIF is v2.7.
This object contains information about the school.
SIF_Events are reported for this object.
Object Triggering
| Event Type | Requirement |
|---|---|
| Add | When a new School is created and saved OR school Number or State School Number Changes. |
| Do not send if the SIF Exclude checkbox is checked. | |
| Do not send if the general Exclude checkbox is checked. | |
| Do not send if the SchoolInfo Object is checked off in Data Access Rights. | |
| Add | When school gets its first calendar in the zone scope. |
| Change | Any field on System Administration> Reources > School > School Detail is changed and saved. |
| Change | Any change to School History (SchoolAttribute). |
| Change | When Grade Levels in the school are modified. |
| Delete | The reporting school is deleted. |
| Delete | When all the calendars for that school is deleted in the zone scope. |
Core Object Population and Business Rules
| Requirement |
|---|
| The SIF Agent and Zone must have access rights assigned to SchoolInfo. |
| The school must have an active calendar in the SIF Zone Year when "Exclude Schools with No Calendar" = Checked on the Zone Options tab. |
| The school must have an action calendar in the SIF Zone Year that does not have "Exclude from SIF Exchange" or "Exclude" - Checked. |
Core Object Data Elements (SIF 2.7)
| Data Element Label | Description | Business Rules | Data Source GUI Path | Database Field | ||||
|---|---|---|---|---|---|---|---|---|
| @RefId | The GUID that identifies this school. | Generated by Infinite Campus. | school.schoolId | GUIDType | M | 2.0r1 | ||
| LocalId | The locally-assigned identifier for this school. | school.schoolId | xs:normalizedString | O | 2.0r1 | |||
| StateProvinceId | The state-assigned identifier for this school. | When "Standard Code (SIF StatePrId" NOT = Null, reports School.standardCode. Otherwise, reports from "State School Number". | System Administration > Resources > School > School Detail > Standard Code (SIF StatePrId), State School Number | school.standardCode school.number | O | 2.0r1 | ||
| NCESId | The NCES-assigned identifier for this school. | System Administration > Resources > School > School Detail > NCES School Number | school.ncesSchoolID | xs:normalizedSt | O | 2.0r1 | ||
| SchoolName | Name of school. | System Administration > Resources > School > School Detail > School Name | school.name | xs:normalizedString | M | 2.0r1 | ||
| LEAInfoRefId | The Id (GUID) that references the school district of which this school is a member. | school.districtId | RefIdType | O | 2.0r1 | |||
| OtherLEA | The Id (GUID) of another related education agency, such as a regional service agency. | Optional do not report. | O | 2.0r1 | ||||
| OtherLEA/@SIF_ RefObject | The name of the object reference. | values: LEAInfo | M | 2.0r1 | ||||
| SchoolType | An indication of the level of the educational institution. | Optional do not report. | O | 2.0r1 | ||||
| SchoolFocusList | Optional do not report. | O | 2.0r1 | |||||
| SchoolFocusList/ SchoolFocus | The type of educational institution as classified by its focus. | Optional do not report. | MR | 2.0r1 | ||||
| SchoolURL | URL for the school. | System Administration > Resources > School > School Detail > URL | school.url | xs:anyURL | O | 2.0r1 | ||
| PrincipalInfo | Information about the school's principal. | O | 2.0r1 | |||||
| PrincipalInfo/ ContactName | The name of the principal. | System Administration > Resources > School > School Detail > Principal Name | school.principalName | xs:normalizedString | M | 2.0r1 | ||
| PrincipalInfo/ ContactTitle | The principal's title. | System Administration > Resources > School > School Detail > Principal Title | school.principalTitle | xs:normalizedString | O | 2.0r1 | ||
| SchoolContactList | A list of contact persons associated with a school. | List | O | 2.0r1 | ||||
| SchoolContactList/ SchoolContact | Information on contact persons for this school. | MR | 2.0r1 | |||||
SchoolContactList/ SchoolContact/ PublishInDirectory | Indicates whether or not this school contact's information should be published in a directory of school information. | Reports "Yes". | "Yes" | O | 2.0r1 | |||
| SchoolContactList/ SchoolContact/ ContactInfo | Common element used to supply information for a contact person at a school, LEA, or other institution. | ContactInfo | M | 2.0r1 | ||||
SchoolContactList/ SchoolContact/ContactInfo/ Name | The name of the contact person. Note that Name is redefined here to allow for LastName and FirstName to be omitted if they cannot be provided; when omitted, FullName must have a value. | xs:normalizedString | M | 2.0r1 | ||||
SchoolContactList/ SchoolContact/ContactInfo/ Name/ @Type | Code that specifies what type of name this is. | Name Type="04" | "04" | M | 2.0r1 | |||
SchoolContactList/ SchoolContact/ContactInfo/ Name/LastName | The last name. | System Administration > Resources > School | School.principalName, parse from LEFT | xs:normalizedString | O | 2.0r1 | ||
SchoolContactList/ SchoolContact/ContactInfo/ Name/FirstName | The first name. | System Administration > Resources > School | School.principalName, parse from RIGHT | xs:normalizedString | O | 2.0r1 | ||
SchoolContactList/ SchoolContact/ContactInfo/ Name/FullName | The full name. | System Administration > Resources > School | School.principalName | xs:normalizedString | C | 2.0r1 | ||
SchoolContactList/ SchoolContact/ContactInfo/ PositionTitle | The contact person's position title. | System Administration > Resources > School | School.principalTitle | xs:normalizedString | O | 2.0r1 | ||
| SchoolContactList/ SchoolContact/ContactInfo/EmailList | List of Email elements. | ActionList | O | 2.0r1 | ||||
SchoolContactList/ SchoolContact/ContactInfo/ EmailList/ @Type | This attribute specifies the type of e-mail address. | Type="Primary" | "Primary" | 2.0r1 | ||||
SchoolContactList/ SchoolContact/ContactInfo/ EmailList/Email | This element represents an e-mail address of one of a number of types and occurs in objects such as StudentPersonal, StaffPersonal, StudentContact, etc. | System Administration > Resources > School | School.principalEmail | xs:normalizedString | MR | 2.0r1 | ||
SchoolContactList/ SchoolContact/ContactInfo/ PhoneNumberList | Lists phone numbers associated with an entity. | System Administration > Resources > School | ActionList | O | 2.0r1 | |||
SchoolContactList/ SchoolContact/ContactInfo/ PhoneNumberList/ PhoneNumber | This element represents a phone number and occurs within objects such as StudentPersonal, StaffPersonal, etc. | System Administration > Resources > School | MR | 2.0r1 | ||||
SchoolContactList/ SchoolContact/ContactInfo/ PhoneNumberList/ PhoneNumber/ @Type | Code that specifies what type of phone number this is. | Where Type 0096 = School Phone Number When Type 2364 = School Fax Number | "0096" or "2364" | M | 2.0r1 | |||
SchoolContactList/ SchoolContact/ContactInfo/ PhoneNumberList/ PhoneNumber/Number | Phone number. | When System Administration > Resources > School > School Phone Number NOT = Null | School.phone | xs:normalizedString | M | 2.0r1 | ||
| When System Administration > Resources > School > School Fax Number NOT = Null | School.fax | |||||||
| AddressList | The school's addresses. | ActionList | O | 2.0r1 | ||||
| AddressList/Address | This element contains address data. | MR | 2.0r1 | |||||
| AddressList/ Address/@Type | Code that defines the location of the address. | When Address NOT = Null, Type="0123" | "0123" or "0765" | M | 2.0r1 | |||
| When Physical Address NOT = NULL, Type="0765" | ||||||||
| AddressList/ Address/Street | The street element is a complex element and breaks the street down into several parts. | M | 2.0r1 | |||||
| AddressList/Address /Street/Line1 | Address line 1. | System Administration > Resources > School | School.address School.physical Address | xs:normalizedString | M | 2.0r1 | ||
| AddressList/Address/ City | The city part of the address. | System Administration > Resources > School | School.city School.PhysicalCity | xs:normalizedString | M | 2.0r1 | ||
| AddressList/Address/StateProvince | The state or province code. | System Administration > Resources > School | School.state School.physicalState | M | 2.0r1 | |||
| AddressList/Address/ Country | The country code. | Reports "US". | "US" | O | 2.0r1 | |||
| AddressList/Address/ PostalCode | The ZIP/postal code. | School.zip School.physicalzip | xs:normalizedString | M | 2.0r1 | |||
| PhoneNumberList | The school's phone numbers. | When School Phone Number NOT = Null, reports the PhoneNumberList. | ActionList | O | 2.0r1 | |||
| PhoneNumberList/ PhoneNumber | This element represents a phone number and occurs within objects such as StudentPersonal, StaffPersonal, etc. | MR | 2.0r1 | |||||
| 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. | Type="0096" | "0096" | M | 2.0r1 | |||
| PhoneNumberList/ PhoneNumber/Number | Phone number. | System Administration > Resources > School | School.phone | xs:normalizedString | M | 2.0r1 | ||
| IdentificationInfoList | Other identification information associated with a school, such as the locally-defined code/identifier, etc. | Optional do not report | O | 2.0r1 | ||||
| SessionType | Code that specifies the session type. | System Administration > Resources > School | School.sessionType | Session Type code | O | 2.0r1 | ||
| GradeLevels | Collection of grade levels offered in this school. | List | O | 2.0r1 | ||||
| GradeLevels/GradeLevel | Grade or academic level. | gradelevel | MR | 2.0r1 | ||||
| GradeLevels/ GradeLevel/Code | Code representing the grade level. | When gradelevel.standardCode is any of 01 - 12, PK, KG, PG, or UN, report the code. Otherwise, reports Unknown. If multiple unknown grades, only report "Unknown" once | System Administration > Resources > Grade Level Definitions | GradeLevel. standardCode | gradelevel | M | 2.0r1 | |
| Excludes grade levels from reporting that have (System Admin>Calendar>Calendar>Grade Levels>Grade Level Detail>Exclude from SIF reporting) = Checked. | ||||||||
| Does NOT exclude grade levels from reporting that have (System Admin>Calendar>Calendar>Grade Levels>Grade Level Detail>Exclude from State Reporting) = Checked | ||||||||
| Title1Status | Status of the school's Title I eligibility. Certain schools are designated under appropriate state and federal regulations as being eligible for participation in programs authorized by Title I of Public Law 103-382. | Report "Targeted" when Title 1 is any of the following: 1. Targeted Assistance Eligible - No Program 2. Targeted Assistance Program Report "SchoolWide" when Title 1 is any of the following: 1. Schoolwide Eligible - Targeted Assistance 2. Schoolwide Eligible - No Program 3. Schoolwide Program Otherwise, reports "NA". | System Administration > Resources > School > School History > Title 1 | SchoolAttribute.title1 | Targeted, Schoolwide, or NA | O | 2.0r1 | |
| OperationalStatus | Operational condition of a school. | This is Optional. Does not Report. | O | 2.0r1 | ||||
| CongressionalDistrict | Number for the US congressional district of the school location. | This is Optional. Does not Report. | O | 2.0r1 | ||||
| ActiveSchoolYear | School year for active (current) year, expressed as the four-digit year in which the school year ends (e.g. 2012 for the 2011-12 school year). | This is Optional. Does not Report. |
