Tool Search: SIF
This article explains how the Utah SIF model has been set up, which objects and elements are being sent and the Campus configuration required to successfully use SIF on UT versions of Campus.
This article will explain the following items:
Business Requirements
A SIF framwork is used in Infinite Campus to connect to the UTREx/Data Clearinghouse to gather and store student data throughout the year. Many of the student data elements collected through the UTREx data submissions are used in funding formulas for Minimum Schools Program (MSP). The data collected on October 1 are used for the legislative budget estimates each year.
Architecture
The Utah State Board of Education uses the eTranscript and Record Exchange (UTREx) to gather and store student data throughout the year.
Version
The current active SIF version in Utah is v2.4.
Objects and Elements
See the sections below for details about each SIF object and element.
CalendarSummary
This object provides a summary of a school's calendar information for a given school year. In Utah, a CalendarSummary may only be reported once, regardless of the number of calendars associated with the school. Calendar information can be viewed and modified by navigating to System Administration > Calendar > Calendar > Calendar Info.
Object Triggering
| Event Type | Requirement |
|---|---|
Add | When a calendar is added in the Zone Scope and Year, and does not have "Exclude From SIF Reporting" = checked on the Calendar. |
Change | When a calendar that does not have “Exclude from SIF Exchange” = checked is modified on System Administration > Calendar > Calendar Info. |
Delete | When a non-SIF-excluded calendar in the Zone Scope and Year is deleted. |
Object Population and Business Rules
The SIF Agent and Zone must have access rights assigned to CalendarSummary. |
The calendar must be active in the SIF Zone Year, and “Exclude from SIF Exchange” is not checked. |
The CalendarSummary object is reported only for the calendar associated with the school that has the lowest “Sequence”, else null “Sequence”, lowest Calendar ID. |
Object Data Elements
| Data Element Label | Description and Business Rules | Data Source GUI Path and Database Field |
|---|---|---|
LocalId | The locally assigned identifier for this calendar. Generated by Infinite Campus. | calendar.calendarId |
Description | Textual description of the school calendar. Reports the name of the calendar. | System Administration > Calendar > Calendar > Calendar Info > Name calendar.name |
DaysInSession | The total number of days that the school was or is anticipated to be in session during the school year. Reports the total number of days marked “School Day” and “Instruction” in the calendar. | System Administration > Calendar > Calendar > Days > Day Detail > School Day, Instruction |
StartDate | The first calendar date, whether or not instruction was provided. The earliest day in day.date in the calendar. | System Administration > Calendar > Calendar > Days |
EndDate | The last calendar date, whether or not instruction was provided. The latest day in day.date in the calendar. | System Administration > Calendar > Calendar > Days |
FirstInstruction | The first day of student instruction. The earliest instructional day in day.date in the calendar. | System Administration > Calendar > Calendar > Days > Day Detail > Instruction |
LastInstruction | The last day of student instruction. The latest instructional day in day.date in the calendar. | System Administration > Calendar > Calendar > Days > Day Detail > Instruction |
Instructional | The total number of instructional minutes for this calendar for the school year. When Calendar.studentDay is not Null, reports the Calendar.studentDay minutes multiplied by the number of unique instructional days in the calendar: DaysInSession x MinutesPerDay Otherwise, reports 0. | System Administration > Calendar > Calendar > Calendar Info > Student Day (instructional minutes) |
MinutesPerDay | The number of minutes in the day in which the school is normally in session. When Calendar.studentDay is not null, reports the value in Calendar.studentDay. When Calendar.studentDay is null, reports 0. | System Administration > Calendar > Calendar > Calendar Info > Student Day (instructional minutes) |
GradeLevels | Collection of grade levels applicable to this school calendar. | |
GradeLevels/ | Grade or academic level. | |
GradeLevels/ | Code representing the grade level. When gradelevel. standardCode is any of 01 - 12, PK, KG, PG, or UN, reports the Standard Code. Otherwise, reports UN. Excludes grade levels from reporting that have System Administration > Calendar > Calendar > Grade Levels > Grade Level Detail > Exclude from SIF reporting = Checked. | System Administration > Resources > Grade Level Definitions |
DisciplineIncident
This object contains information related to the student discipline incident events. The discipline incidents can be viewed in the following locations:
- Behavior > Behavior Management > Incident Management Editor
- Student Information > General > Behavior > Incident Detail
Object Triggering
A Behavior Event associated with the incident where State Event Code is not null is changed
| Event Type | Requirement |
|---|---|
ADD | A Behavior Event associated with the incident where State Event Code is not null.
|
ADD | Student Role changed from non-Offender to Offender. |
CHANGE | |
CHANGE | A Behavior Resolution is changed. |
DELETE | A Behavior Event associated with the incident where State Event Code is not null is deleted |
Object Population and Business Rules
The SIF Agent and Zone must have access rights assigned to DisciplineIncident. |
Student is assigned to the section in the SIF Zone Year and Calendar. |
Reported students must have an enrollment associated with a calendar that is not excluded: |
Student must have an enrollment in the Zone Scope that is not excluded on the SIF Zone Options: |
A behavior event exists that is associated with a behavior incident record with a Date of Incident >= the Zone calendar Start Date, and <= the current date. |
Object Data Elements
The common elements belonging to the DisciplineIncident object. Those elements indicated as “required” are listed in the UTREx profile.
| Data Element | Description and Business Rules | Data Source GUI Path and Database Field |
|---|---|---|
AgencyReporting | The Id (GUID) of the school or LEA reporting the incident, usually the school in which the incident occurred. The calendar to which the incident belongs. | |
IncidentNumber | Incident number The behavior incident Id. | |
IncidentDate | The date of the incident. | Behavior > Behavior Management > Incident Management Editor > Incident Detail Information > Date of Incident behaviorIncident.timeStamp |
IncidentTime | The time when the incident occurred. Type = "397" | behaviorIncident.timeStamp |
IncidentLocation | The locally-defined identifier or description of the location where the incident occurred. Type = "9997" | behaviorIncident.location |
IncidentLocationRefId | GUID of the SIF object that relates to the school or location where the incident occurred, if applicable. Reports the RefId of the school. | calendar.schoolId |
IncidentCost | If the incident resulted in a quantifiable monetary loss for any entity involved, identify and record the value of that loss. Reports the cost associated incurred by the incident. | behaviorIncident.damages |
IncidentReporter | Information regarding the individual who reported the incident. Type = "3422" | |
IncidentReporter/Name Type | Identifies the type of individual who reported the incident. Type = "04" when Submitted By field is not null. | |
IncidentReporter/ | The last name of the Submitted By user. | identity.lastName |
IncidentReporter/ | The first name of the Submitted By user. | identity.firstName |
IncidentReporter/ | The name of the SIF object to which the GUID relates. SIF_RefObject = "StaffPersonal" Reports the StaffPersonal RefId of the Submitted By user. | identity.personalId |
RelatedToList | List of categories to which the incident is related. Reports null when Gang Related is not checked. | Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Gang Related behaviorEvent.gangRelated |
RelatedToList/RelatedTo | Incident gang related? When Gang Related checkbox is checked, reports "3068". | Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Gang Related behaviorEvent.gangRelated |
WeaponTypeList | List of weapons involved in the incident. Reports blank. | N/A |
IncidentCategory | The category or description for this incident. | |
IncidentCategory/Code | Identifies the type of incident being reported. Reports “9000”. | |
OffenderList | List of offenders. | |
OffenderList/Offender Type | Identifies the type of offender involved in the incident. = "0126" | |
Offender/Name type | The name of the offender. | |
Offender/Name/LastName | The offender's Last Name when exists. Otherwise, reports element as null. | Census > People > Demographics > Person Information > Last Name identity.lastName |
Offender/Name/FirstName | The offender's First Name when exists. Otherwise, reports element as null. | Census > People > Demographics > Person Information > First Name identity.firstName |
Offender/Name/MiddleName | The offender's Middle Name when exists. Otherwise, does not report this element. | Census > People > Demographics > Person Information > Middle Name identity.middleName |
Offender/Name/Suffix | The offender's name Suffix when exists. Otherwise, does not report this element. | Census > People > Demographics > Person Information > Suffix identity.suffix |
Offender/Name/PreferredName | The offender's nickname when exists. Otherwise, does not report this element. | Census > People > Demographics > Person Information > Nickname identity.alias |
Offender/Name/SortName | Last Name, First Name + Middle initial | Census > People > Demographics > Person Information > First Name, Last Name, Middle Name identity.LastName, identity.firstName, identity.middleName |
Offender/Name/FullName | First Name + Middle Name + Last Name | Census > People > Demographics > Person Information > First Name, Last Name, Middle Name identity.LastName, identity.firstName, identity.middleName |
Offender/SIF_RefId | If the Offender Type attribute identifies the offender as a Student or Staff Member, then this element should contain the Id (GUID) of the student or staff to whom this information relates. The SIF PersonId of the Offender. | identity.personId |
Offender/Injury | Was the student injured? Reports based on the injury selected in the Offender record when exists. | Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Participant(s) Details > Injury behaviorRole.injury |
Offender/ActionList | Information regarding the action(s) taken against the offender in response to the incident. Reports when a Behavior Resolution exists. | Behavior > Behavior Management > Incident Management Editor > Behavior Resolution |
Offender/ActionList/Action | List of offender action code association with the Incident. Repeats for each Behavior Resolution attached to the offender when the Resolution Type is mapped to a State Resolution Code. | |
Offender/ActionList/ | When Resolution Type is mapped to:
| Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Resolution Details > Reolution Type, Additional actions Behavior.stateResCode BehaviorResolution. |
Offender/ActionList/ | The date on which the disciplinary action begins. Reports from the Resolution Start Date. | Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Resolution Details > Reolution Start Date behaviorResolution.timeStamp |
Offender/ActionList/ | The date through which the disciplinary action is in effect, inclusive. Reports from the Resolution End Date. | Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Resolution Details > Reolution End Date behaviorResolution.timeStamp |
Offender/ActionList/ | How many days? When Duration in School Days field is not null, reports the value entered. When null, reports the number of days on and between the Resolution StartDate and the Resolution EndDate. | Behavior > Behavior Management > Incident Management Editor > Incident Detail Information > Resolution Details, Resolution Start Date, Resolution End Date behaviorResolution. behaviorRole.demerits |
Offender/ActionList/Action/ | Identifies whether or not this action taken against a student was imposed as a consequence of state or local zero tolerance policies. | |
Offender/ActionList/Action/ | Identifies whether or not the action involved an expulsion with or without services for a period of one full year (i.e., 365 days). | |
Offender/ActionList/Action/ | Identifies whether or not the action involved an expulsion with or without services that is shortened to a term of less than one year by the superintendent or chief administrator of a school district. | |
Offender/ActionList/Action/ | Identifies whether or not the offender's action included notification of local law enforcement, regardless of whether official action was taken. Reports “Yes” when Additional Actions field has 2: Referred To Police selected. | Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Resolution Details > Additional Actions behaviorResolution. |
Offender/ActionList/ | Identifies whether or not the offender was arrested. Reports “No”. | |
Offender/ActionList/Action/ | Alternative placement? Reports “Yes” when Additional actions field has 1: Alternative Placement selected. | Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Resolution Details > Additional Actions behaviorResolution. |
Offender/WeaponTypeList | List of weapons involved in the incident used by the offender. Container element for weapons associated with the Offender. | |
Offender/WeaponTypeList/ | Identifies the type of weapon used by the offender during an incident. Repeats for each weapon.
| Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Weapon behaviorWeapon. |
VictimList | List of victim(s) if the incident is directed toward specific persons or their property. | |
VictimList/Victim | Information regarding the victim(s) in the incident. Repeats for each victim associated with the Incident. | |
VictimList/Victim Type | Identifies the type of individual victimized in the incident. = "0126" | |
VictimList/Name type | Code that specifies what type of name this is. = "04" | |
VictimList/Name/LastName | The offender's Last Name when exists. Otherwise, reports element as null. | Census > People > Demographics > Person Information > Last Name identity.lastName |
VictimList/Name/FirstName | The offender's First Name when exists. Otherwise, reports element as null. | Census > People > Demographics > Person Information > First Name identity.firstName |
VictimList/Name/MiddleName | The offender's Middle Name when exists. Otherwise, does not report this element. | Census > People > Demographics > Person Information > Middle Name identity.middleName |
VictimList/Name/Suffix | The offender's name Suffix when exists. Otherwise, does not report this element. | Census > People > Demographics > Person Information > Suffix identity.suffix |
VictimList/Name/PreferredName | The offender's Nickname when exists. Otherwise, does not report this element. | Census > People > Demographics > Person Information > Nickname identity.alias |
VictimList/Name/SortName | Last Name, First Name + Middle initial | Census > People > Demographics > Person Information > Last Name, First Name, Middle Name identity.LastName, identity.firstName, identity.middleName |
VictimList/Name/FullName | First Name + Middle Name + Last Name | Census > People > Demographics > Person Information > Last Name, First Name, Middle Name identity.LastName, identity.firstName, identity.middleName |
VictimList/SIF_RefId | The SIF PersonId of the Offender. | identity.personId |
VictimList/Injury | Identifies whether or not this specific victim was physically injured, and if so, identify whether the injury was major or minor. Reports based on the injury selected in the Victim record when exists. | Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Participant(s) Details > Injury behaviorRole.injury |
IncidentDescription | Incident description Reports the value entered in Context Description when not null. | Behavior > Behavior Management > Incident Management Editor > Incident Detail Information > Context, Details behaviorIncident. behaviorIndex.description |
| PhysicalArrestFlag | Indicates if the incident resulted in a physical arrest.
This element must report Y or N regardless of Offender Type. It must never report null. | Behavior > Behavior Management > Resolution Details > Physical Arrest BehaviorResolution.arrest |
| SearchAndSeizureFlag | Indicates if the incident resulted in a search and seizure.
This element must report Y or N regardless of Offender Type. It must never report null. | Behavior > Behavior Management > Resolution Details > Search and Seizure BehaviorResolution. auxiliaryCode |
| CriminalCitationFlag | Indicates if the incident resulted in a criminal citation.
This element must report Y or N regardless of Offender Type. It must never report null. | Behavior > Behavior Management > Resolution Details > Criminal Citation BehaviorResolution. lawEnforcement |
| NonCriminalCitationFlag | Indicates if the incident resulted in a non-criminal citation.
This element must report Y or N regardless of Offender Type. It must never report null. | Behavior > Behavior Management > Resolution Details > Non Criminal Citation BehaviorResolution. inconsistent.CodeOfConduct |
| Retaliation | Indicates if the incident was a retaliation or an alleged retaliation as defined in Utah Code.
This element must report Y or N regardless of Offender Type. It must never report null. | Behavior > Behavior Management > Incident > Event Details > Retaliation BehaviorEvent. retaliationRelated |
LEAInfo
The LEAInfo object contains information about the school district. Elements from this object are referenced throughout the UTREx File Specifications. The district information can be viewed and modified by navigating to System Administration > Resources > District Information.
Object Triggering
| Event Type | Requirement |
|---|---|
Change | A Save is made on the District Detail tab. |
Object Population and Business Rules
The SIF Agent and Zone must have access rights assigned to LEAInfo. |
The district must belong to the same calendar and year assigned to the SIF Zone in order to populate. |
Object Data Elements
| Data Element | Description and Business Rules | Data Source GUI Path and Database Field |
|---|---|---|
LocalId | The locally-assigned identifier for this LEA. Generated by Infinite Campus. | district.districtId |
StateProvinceId | The state-assigned identifier for this LEA. | System Administration > Resources > District Information > District Detail > State District Number district.number |
NCESId | The NCES-assigned identifier for this LEA. | System Administration > Resources > District Information > District Detail > NCES DistrictID district.ncesDistrictId |
LEAName | Name of LEA. | System Administration > Resources > District Information > District Detail > Name district.name |
LEAURL | URL for the LEA. | System Administration > Resources > District Information > District Detail > URL district.url |
LEAContactList | Repeatable list of contact persons. | |
LEAContactList/LEAContact | Information on contact persons for this LEA. | |
LEAContactList/LEAContact/ | Indicates whether or not this LEA contact's information should be published in a directory of LEA information. | |
LEAContactList/LEAContact/ | Common element used to supply information for a contact person at a school, LEA, or other institution. | |
LEAContactList/LEAContact/ | 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. | |
LEAContactList/LEAContact | The last name. | System Administration > Resources > District Information > District Detail > District Contact Last Name district.contactLastName |
LEAContactList/LEAContact/ | The first name. | System Administration > Resources > District Information > District Detail > District Contact First Name district.contactFirstName |
LEAContactList/LEAContact/ | A free text field for the complete name. Mandatory if LastName and FirstName are omitted. | System Administration > Resources > District Information > District Detail > District Contact Last Name, District Contact First Name district.contactFirstName + district.contactLastName |
LEAContactList/LEAContact/ | The contact person's position title. | System Administration > Resources > District Information > District Detail > District Contact Title district.contactTitle |
LEAContactList/LEAContact/ | List of Email elements. | |
LEAContactList/LEAContact/ | 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 > District Information > District Detail > Email |
LEAContactList/LEAContact/ | Lists phone numbers associated with an entity. | |
LEAContactList/LEAContact/ContactInfo/ | Code that specifies what type of phone number this is. Note: A subset of valid values may be specified in data objects. | System Administration > Resources > District Information > District Detail > Phone If district.phone is entered. If district.fax is entered.
|
LEAContactList/LEAContact/ContactInfo/ | Phone number. | System Administration > Resources > District Information > District Detail > Phone district.phone district.fax |
LEAContactList/PhoneNumber Type | Code that specifies what type of phone number this is. Note: A subset of valid values may be specified in data objects. | System Administration > Resources > District Information > District Detail > Phone If district.phone is entered. If district.fax is entered. |
LEAContactList/PhoneNumber | This element represents a phone number and occurs within objects such as StudentPersonal, StaffPersonal, etc. | System Administration > Resources > District Information > District Detail > Phone district.phone district.fax |
LEAContactList/AddressList | A list of Address elements. | |
LEAContactList/ | 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. | System Administration > Resources > District Information > District Detail > Address If district.address is entered. If district. |
LEAContactList/AddressList/Address Type/Street | The street element is a complex element and breaks the street down into several parts. | |
LEAContactList/AddressList/Address Type/Street/Line1 | Address line 1. | System Administration > Resources > District Information > District Detail > Address If district.address is entered, Type = "0123". |
LEAContactList/AddressList/ | The city part of the address. | System Administration > Resources > District Information > District Detail > City If district.address is entered, district.city. If district. |
LEAContactList/AddressList/Address Type/StateProvince | The state or province code. | System Administration > Resources > District Information > District Detail > State If district.address is entered, district.state. If district.physicalAddress is entered, district.physicalState. |
LEAContactList/AddressList/Address Type/Country | The county part of the address. | |
LEAContactList/AddressList/Address Type/PostalCode | The ZIP/postal code. | System Administration > Resources > District Information > District Detail > Zip If district.address is entered, district.zip If district.physicalAddress is entered, district.physicalZip. |
SchoolCourseInfo
This object provides about a specific course in a given school year and calendar. The course information can be viewed and modified by navigating to Scheduling > Courses > Course > Course Information.
Object Triggering
| Event Type | Requirement |
|---|---|
Add | A course is created with the following:
|
Change | A change is made on a reported course. |
Delete | A reported course is deleted. |
Object Population and Business Rules
The SIF Agent and Zone must have access rights assigned to SchoolCourseInfo. |
Does not report for any course belonging to a calendar with Exclude from SIF Exchange = Checked. |
The course must have Active checked to report. |
Course must not have State Exclude checked to report. |
| When finding courses, logic checks for courses where active = 1 (in active trials) and ignores courses in inactive trials. |
Object Data Elements
| Data Element | Description and Business Logic | Data Source GUI Path and Database Field |
|---|---|---|
CourseCode | School-defined local code for the course. Reports the course Number. | Scheduling > Courses > Course > Course Information > Number course.number |
StateCourseCode | State-defined standard course code used to report information about courses. Reports the value in the State Code field on the course.
| Scheduling > Courses > Course > Course Information > State Code course.stateCode |
DistrictCourseCode | The corresponding district course code. Reports the course Number. | Scheduling > Courses > Course > Course Information > Number course.number |
SubjectAreaList | A list of subject areas. Requires a SCED Subject Area (Course.scedSubjectArea) is entered. | |
SubjectAreaList/SubjectArea | Subject matter. | |
SubjectAreaList/SubjectArea/Code | The subject area code (i.e., the first two digits of the course classification code). Report the SIF mapped code for the selection in (Scheduling > Courses > Course > NCES data > SCED Subject Area). When no Subject Area is selected, reports based on the SIF mapping to the the attribute Default Value entered. When no Subject Area is selected and no valid (matching a code in the attribute dictionary) attribute Default Value exists, does not report the SubjectAreaList or associated child elements. When Subject Area is NOT Null, including the valid attribute Default Value, and is not a code in the mapping table, reports "22". | Scheduling > Courses > course.scedSubjectArea |
SubjectAreaList/SubjectArea | Requires an entry in Course.type to report. | |
SubjectAreaList/SubjectArea/ | 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. Reports the Code selected in Course.type. | Scheduling > Courses > course.type |
SubjectAreaList/SubjectArea/ | Describes the other code element content as either a state/province code, a local code, other code, or text string. Reports "StateProvince" | |
CourseTitle | Title of the course. Reports the course name. | Scheduling > Courses > course.name |
Description | Textual description of the course. Reports from the Description field on Course. | course.description |
CourseCredits | The number of credits awarded upon course completion. Sum of GradingTaskCredit.credit on the Course. | gradingTaskCredit.credit |
CourseCredits/@Type | The type of credit offered. Reports "0585" | |
| SIF_ExtendedElement Name=”UTExtensions”> | ||
| SemesterLength (required for CTE courses) | This is a one-digit numeric code that indicates the time frame or length of a CTE class or in the case of a trimester school that the class duration is for a single trimester. Reports the code selected in the Semester Length field. When blank, reports the extended element with a null value. | Scheduling > Courses > Course Information > Semester Length course.pseoType |
| TermCode (required) | This is the term the class is taught. TermCode will report the State Term Code calculated for the course. Courses must have one of the following State Term Codes in order to properly report.
If the course does not have a state term code, it MUST have a Term Code Override value selected on the course. Courses without a State Term Code or Term Code Override value will report blank to the state and produce an error. | Scheduling > Courses > Course Information > Term Code Override System Administration > Calendar > Calendar > Calendar Info > Summer School course.termType |
SchoolInfo
The SchoolInfo object contains information about the school. Elements from this object are referenced throughout the UTREx File Specifications. The school information can be viewed and modified by navigating to System Administration > Resources > School.
Object Triggering
Event Type | Requirement |
|---|---|
| Add | A non-excluded school is added in the SIF Zone Year. |
| Change | Any field on System Administration > Resources > School > School Detail is changed and saved. |
| Delete | A reporting school is deleted. |
Object Population and Business Rules
| 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 active calendar in the SIF Zone Year that does not have “Exclude from SIF Exchange” = Checked. |
Object Data Elements
| Data Element | Description and Business Rules | Data Source GUI Path and Database Field |
|---|---|---|
| /@RefId | The GUID that identifies this school. This attribute is generated by Infinite Campus. | school.schoolId |
LocalId | The locally-assigned identifier for this school. Generated by Infinite Campus. | school.schoolId |
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 > State School Number School.standardCode school.number |
NCESId | The NCES-assigned identifier for this school. | System Administration > Resources > School > School Detail > NCES School Number school.ncesSchoolID |
SchoolName | Name of school. | System Administration > Resources > School > School Detail > School Name school.name |
LEAInfoRefId | The Id (GUID) that references the school district of which this school is a member. | school.districtId |
SchoolURL | URL for the school. | System Administration > Resources > School > School Detail > URL school.url |
PrincipalInfo | Information about the school's principal. | |
PrincipalInfo/ContactName | The name of the principal. | System Administration > Resources > School > School Detail > Principal Name school.principalName |
PrincipalInfo/ContactTitle | The principal's title. | System Administration > Resources > School > School Detail > Principal Title school.principalTitle |
SchoolContactList | A list of contact persons associated with a school. | |
SchoolContactList/SchoolContact | Information on contact persons for this school. | |
SchoolContactList/SchoolContact/ | Indicates whether or not this school contact's information should be published in a directory of school information. Reports "Yes". | |
SchoolContactList/ | Common element used to supply information for a contact person at a school, LEA, or other institution. | |
SchoolContactList/SchoolContact/ | The name of the contact person. Note that | |
SchoolContactList/SchoolContact/ | Code that specifies what type of name this is. Name Type="04" | |
SchoolContactList/SchoolContact/ | The last name. | System Administration > Resources > School > Principal Name School.principalName, parse from LEFT |
SchoolContactList/SchoolContact/ | The first name. | System Administration > Resources > School > Principal Name School.principalName, parse from RIGHT |
SchoolContactList/SchoolContact/ | The full name. | System Administration > Resources > School > Principal Name School.principalName |
SchoolContactList/SchoolContact/ | The contact person's position title. | System Administration > Resources > School > Principal Title School.principalTitle |
SchoolContactList/SchoolContact/ | List of Email elements. | |
SchoolContactList/SchoolContact/ | 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 > Principal Email School.principalEmail |
SchoolContactList/SchoolContact/ | This attribute specifies the type of e-mail address. Type="Primary" | |
SchoolContactList/SchoolContact/ | Lists phone numbers associated with an entity. | System Administration > Resources > School > Phone Number, Fax |
SchoolContactList/SchoolContact/ | This element represents a phone number and occurs within objects such as StudentPersonal, StaffPersonal, etc. | |
SchoolContactList/SchoolContact/ContactInfo/ | Code that specifies what type of phone number this is. Where Type “0096” = School Phone Number Where Type “2364” = School Fax Number | |
SchoolContactList/SchoolContact/ | Phone number or fax number. When School Phone Number NOT = Null
| System Administration > Resources > School > School Phone Number School.phone System Administration > Resources > School > Fax School.fax |
AddressList | The school's addresses. | |
AddressList/Address | This element contains address data. | |
AddressList/Address/@Type | Code that defines the location of the address. When Address NOT = Null, Type="0123" 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. | |
AddressList/Address/Street/Line1 | Address line 1. | System Administration > Resources > School > Address, Physical Address School.address School.physicalAddress |
AddressList/Address/City | The city part of the address. | System Administration > Resources > School > City, Physical City |
AddressList/Address/StateProvince | The state or province code. | System Administration > Resources > School > State, Physical State School.state School.physicalState |
AddressList/Address/Country | The country code. Reports "US". | |
AddressList/Address/PostalCode | The ZIP/postal code. | System Administration > Resources > School > Zip, Physical Zip School.zip School.physicalZip |
PhoneNumberList | The school's phone numbers. When School Phone Number NOT = Null, reports the PhoneNumberList | |
PhoneNumberList/PhoneNumber | This element represents a phone number and occurs within objects such as StudentPersonal, StaffPersonal, etc. | |
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" | |
PhoneNumberList/PhoneNumber/Number | Phone number. | System Administration > Resources > School > Phone school.phone |
SessionType | YEAR schedule type for the school. From the calendar associated with the school that has the lowest “Sequence”, else null “Sequence”, lowest Calendar ID: Reports “0828” (Semester) when the primary term schedule has 2 terms. | System Administration > Calendar > Terms |
GradeLevels | Collection of grade levels offered in this school. | |
GradeLevels/GradeLevel | Grade or academic level. | |
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 UN. Excludes grade levels from reporting that have System Administration > Calendar > Calendar > Grade Levels > Grade Level Detail > Exclude from SIF reporting = Checked. | System Administration > Resources > Grade Level Definitions GradeLevel.standardCode |
Title1Status | Status of the school's Title I eligibility. Reports "Targeted" when Title 1 is any of the following:
Reports "SchoolWide" when Title 1 is any of the following:
Otherwise, reports "NA" | System Administration > Resources > School > School History > Title 1 SchoolAttribute.title1 |
| SIF_ExtendedElement Name=”UTExtensions”> | ||
| SchoolInfoExtensions/ScheduleDayType (required) | DAY schedule type for the school. From the calendar associated with the school that has the lowest “Sequence”, else null “Sequence”, lowest Calendar ID: Reports the Code selected in the Schedule Day Type field. When the Schedule Day Type field is left blank, this extended element will report blank. | System Administration > Calendar > Calendar > Schedule Day Type calendar.type |
SectionInfo
This object provides about a specific information about the section – the specific time period a session of the course meets. The section information can be viewed and modified by navigating to Scheduling > Courses > Section > Section Editor.
Object Triggering
| Event Type | Requirement |
|---|---|
Add | A section is created, and the following are true:
|
Add | A Section Schedule Placement is added for a section that had none. |
Add/Delete | Checking / unchecking the course Active checkbox. |
Change | A change is made on a reported section. |
Change | A change is made to the Section Schedule Placement |
Delete | A reported section is deleted. |
Object Population and Business Rules
The SIF Agent and Zone must have access rights assigned to SectionInfo. |
Does not report for any section belonging to a calendar with Exclude from SIF Exchange checked. |
The associated course must have Active checked. |
The associated course must not have State Exclude checked. |
Object Data Elements
| Data Element | Business Requirements and Rules | Data Source GUI Path and Database Field |
|---|---|---|
LocalId | The locally-assigned identifier for this course section. Reports the section Number. | Scheduling > Courses > Section > Section Editor > Section Number section.number |
ScheduleInfoList | System Administration > Calendar > Calendar > Terms sectionPlacement.termId | |
ScheduleInfoList/ScheduleInfo | The schedule-related information for a section repeating for each term in which the section is scheduled. The TermInfoRefId attribute value should repeat as necessary to show the appropriate relationship between meeting times, teachers and rooms. Repeatable element. | |
ScheduleInfoList/ScheduleInfo/ | The Id (GUID) of the term to which this schedule information relates. | System Administration > Calendar > Calendar > Terms IdRefType |
ScheduleInfoList/ | List | |
ScheduleInfoList/ScheduleInfo/ | The Id (GUID) of the teacher. | Census > People > Demographics IdRefType |
ScheduleInfoList/ScheduleInfo/ | List | |
ScheduleInfoList/ScheduleInfo/ | The Id (GUID) of the room in which this section is taught. | System Administration > Resources > Resources > Rooms IdRefType |
ScheduleInfoList/ScheduleInfo/ | Describes the | List |
ScheduleInfoList/ScheduleInfo/ | Time(s) this section meets. | |
ScheduleInfoList/ScheduleInfo/ | This is a two-digit field containing the class period. | Scheduling > Courses > Course > Section > Section Schedule Placement |
ScheduleInfoList/ScheduleInfo/ | The period within the day when this section takes place. | System Administration > Calendar > Calendar > Period Info > Name |
MediumOfInstruction | Medium through which the student receives instructional communication from the teacher. | Scheduling > Courses > Course > Section > Section Editor > Medium Of Instruction |
MediumOfInstruction/Code | Code representing the medium of instruction. | Scheduling > Courses > Course > Section > Section Editor > Medium Of Instruction |
MediumOfInstruction/ | 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. | |
MediumOfInstruction/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. | Scheduling > Courses > Course > Section > Section Editor > Medium Of Instruction |
MediumOfInstruction/ | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | |
LocationOfInstruction | Description of the location in which the section is taught. | Scheduling > Courses > Course > Section > Section Editor > Where Taught Campus |
LocationOfInstruction/Code | Code representing the location of instruction. | Scheduling > Courses > Course > Section > Section Editor > Where Taught Campus |
SummerSchool | Is this a summer school assignment? | System Administration > Calendar > Calendar > Summer School |
CourseSectionCode | This is the unique alphanumeric course + section number that is used to identify a unique class within a school (block classes are the exception). | Scheduling > Courses > Course > Number |
| SIF_ExtendedElement Name=”UTExtensions”> | ||
| WhereTaughtDist (required for CTE sections) | This field is to designate the LEA where the class is taught. This field is used in conjunction with Where Taught School. Reports the first 2 characters of the code selected in the Where Taught field on section when Where Taught is not null. When Where Taught field on section is null, reports from the Where Taught field on course when not null. When the Where Taught field on both section and course are null, reports the extended element with a null value. | Scheduling > Courses > Section > Section Editor > Where Taught Scheduling > Courses > Course Information > Where Taught section.altSchoolCode course.specialCode |
| WhereTaughtSchl (required for CTE sections) | This field is to be used only if the class is taught at some other school. This other school includes schools in the same LEA or other LEAs as well as any type of online school. Reports the last 3 characters of the code selected in the Where Taught field on section when not null. When Where Taught field on section is null, reports from the Where Taught field on course when not null. When the Where Taught field on both section and course are null, reports the extended element with a null value. | Scheduling > Courses > Section > Section Editor > Where Taught Scheduling > Courses > Course Information > Where Taught section.altSchoolCode course.specialCode |
| Teacher1ID (required) |
| Scheduling > Courses > Section > Section Editor > Where Taught Scheduling > Courses > Course Information > College Granting Credit Census > People > Demographics > Person Identifiers > Staff State ID Scheduling > Courses > Section > Staff History > Start Date, End Date section.altSchoolCode section.serviceDistrict course.specialCode course.serviceDistrict person.staffStateId sectionStaffHistory.startDate sectionStaffHistory.endDate |
| Teacher2ID | When the Teacher1ID field is populating from the section's assigned staff, reports the Staff State ID for the 2nd staff person WHEN Role is NOT = NR, if present, who is assigned to the section prioritized by the following: When the Staff has Section > Staff History > Role = NR, this staff person must NOT be reported. | Census > People > Demographics > Person Identifiers > Staff State ID Scheduling > Courses > Section > Staff History > Start Date, End Date person.staffStateId sectionStaffHistory.startDate sectionStaffHistory.endDate |
| Teacher3ID | When the Teacher1ID field is populating from the section's assigned staff, reports the Staff State ID for the 3rd staff person WHEN Role is NOT = NR, if present, who is assigned to the section prioritized by the following: 1. Staff History Start Date is null or <= current date 2. Staff History End Date is the latest on the Staff History tab, or is null. 3. When null Start/End Dates, considered section term Start/End Date. 4. Reporting priority: 1. Null Start/End Date 2. Primary Teacher 3. Teacher 4. Section Staff 5. Earliest Staff History ID When the Staff has Section > Staff History > Role = NR, this staff person must NOT be reported. | Census > People > Demographics > Person Identifiers > Staff State ID Scheduling > Courses > Section > Staff History > Start Date, End Date person.staffStateId sectionStaffHistory.startDate sectionStaffHistory.endDate |
| CollegeGranting (required for concurrent sections) | The two character “district” number of the college granting the college credit portion of the concurrent enrollment course. Reports the first 2 characters of the code selected in the College Granting Credit field on section when College Granting Credit is not null. When College Granting Credit field on section is null, reports from the College Granting Credit field on course when not null. When the College Granting Credit field on both section and course are null, reports the extended element with a null value. | Scheduling > Courses > Section > Section Editor > College Granting Credit Scheduling > Courses > Course Information > College Granting Credit section.serviceDistrict course.serviceDistrict |
StudentAcademicRecord
This object contains information related to the student’s current and historical courses.
Object Triggering
| SIF events are not provided for this object. |
Object Population and Business Rules
The SIF Agent and Zone must have access rights assigned to StudentAcademicRecord. |
Student has an enrollment in grade 9-12 in the Zone Scope that is not excluded. |
Reports a StudentAcademicRecord object for a student when the student has a transcript record. |
Student must have an enrollment associated with a calendar that is not excluded: |
Student has a 9-12 grade enrollment in the Zone Scope that is not excluded on the SIF Zone Options: |
Object Data Elements
| Data Element | Description and Business Rules | Data Source GUI Path and Database Field |
|---|---|---|
ReportingDate | The date this record was prepared. Reports the current date. | xs:date |
StudentSchoolEnrollmentData/ | Collects elements of interest from StudentSchoolEnrollment. Campus generated RefId. | GUID based on school.schoolID |
StudentSchoolEnrollmentData/GradeLevel | Grade or academic level. | |
StudentSchoolEnrollmentData/ | Code representing the grade level. Reports the Standard Code (SIF code) mapped to the student’s grade level. |
|
StudentSchoolEnrollmentData/GradeLevel/ | 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. The student’s enrollment grade. | Student Information > General > Enrollments > General Enrollment Information > Grade gradeLevel.name |
StudentSchoolEnrollmentData/GradeLevel | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. “StateProvince” | |
SchoolAttendanceHistory | Chronology of schools attended in the student's academic career, including the current school if enrolled. | |
SchoolAttendanceHistory/ | Data about each individual school attended. Id used internally to StudentAcademicRecord to avoid duplication of school-related data. Generated by Infinite Campus. | school.schoolId |
SchoolAttendanceHistory/ | Collects elements of interest from LEAInfo. | |
SchoolAttendanceHistory/SchoolAttended/ | The identifier for this entity as assigned by the state or province. Reports the State District Number. | System Administration > Resources > District Information > State District Number district.number |
SchoolAttendanceHistory/SchoolAttended/ | Name of Local Education Agency. The name of the district. | System Administration > Resources > District Information > Name district.name |
SchoolAttendanceHistory/ | Collects elements of interest from SchoolInfo. | |
SchoolAttendanceHistory/SchoolAttended/ | This is a common element used to define the locally assigned identifier associated with an entity. It is used in StudentPersonal, StaffPersonal, SchoolInfo, and other objects. Reports the School Number. | System Administration > Resources > School > State School Number school.number |
SchoolAttendanceHistory/SchoolAttended/ | The identifier for this entity as assigned by the state or province. Reports the Standard Code when not null. Otherwise, reports the School Number. | System Administration > Resources > School > Standard Code, State School Number school.standardCode school.number |
SchoolAttendanceHistory/SchoolAttended/ | The name of the school. The School Name for where the student was enrolled. |
|
SchoolAttendanceHistory/SchoolAttended/ | A list of contact persons associated with a school.o | |
SchoolAttendanceHistory/SchoolAttended/ | Information on contact persons for this school. | |
SchoolAttendanceHistory/ | Common element used to supply information for a contact person at a school, LEA, or other institution. | |
SchoolAttendanceHistory/SchoolAttended/ | The name of the contact person. Code that specifies what type of name this is. | |
SchoolAttendanceHistory/ | The last name. | |
SchoolAttendanceHistory/ | The first name. | |
SchoolAttendanceHistory/ | The contact person's position title. | |
SchoolAttendanceHistory/ | List of PhoneNumber elements. | |
SchoolAttendanceHistory/ | Code that specifies what type of phone number this is. | |
SchoolAttendanceHistory/ | Phone number. | |
SchoolAttendanceHistory/ | Mandatory if school of record. Marking systems/grading tables used by the school. | |
SchoolAttendanceHistory/SchoolAttended/ | Marking system/grading table used by the school. Id used internally to StudentAcademicRecord to link marks to their marking systems. | |
SchoolAttendanceHistory/SchoolAttended/ | The text name of the value list. | |
SchoolAttendanceHistory/SchoolAttended/ | Indicates whether a letter Mark is accepted. | |
SchoolAttendanceHistory/SchoolAttended/ | List of specific valid letter Marks. | |
SchoolAttendanceHistory/SchoolAttended/ | String representing the actual Mark that would appear on the report card. | |
EnrollmentHistory | A list of each enrollment in the schools above (see SchoolAttended). | |
EnrollmentHistory/ | Collects elements of interest from StudentSchoolEnrollment. | |
EnrollmentHistory/ | Reference to SchoolAttended. | |
EnrollmentHistory/ | Date student entered high school. The Date First Entered the 9th Grade. | Student Information > General > Graduation > Date First Entered the 9th Grade graduation.grade9Date |
CurrentCourseActivity | Mandatory if coursework is underway. Conveys a student's current coursework along with mid-term marks if applicable. | |
CurrentCourseActivity/ | Collects elements of interest from TermInfo. Reference to the school of record for the courses being taken (see SchoolAttended). | |
CurrentCourseActivity/ | School year for which this information is applicable, expressed as the four-digit year in which the school year ends. | |
CurrentCourseActivity/TermInfoData/StartDate | A year, with an optional month/day, or an optional month by itself. | |
CurrentCourseActivity/ | Code for session type. | |
CurrentCourseActivity/TermInfoData/Courses | Courses being taken. | |
CurrentCourseActivity/ | Course being taken. | |
CurrentCourseActivity/TermInfoData/Courses/ | Reference to the school where the course is being taken. | |
CurrentCourseActivity/TermInfoData/Courses/ | Collects elements of interest from SchoolCourseInfo. | |
CurrentCourseActivity/TermInfoData/Courses/ | School-defined local code for a course. | |
CurrentCourseActivity/TermInfoData/Courses/ Course/SchoolCourseInfoData/ | State-defined standard course code used to report information about courses. | |
CurrentCourseActivity/TermInfoData/Courses/ Course/SchoolCourseInfoData/ | A district course code. | |
CurrentCourseActivity/TermInfoData/Courses/ | Title of a course. | |
CurrentCourseActivity/TermInfoData/Courses/ Course/SchoolCourseInfoData/MarkingPeriod | Information related to the span of time associated with the marking period. CourseCreditsAttempted attribute reports when Credit Attempted is not null. | |
CourseHistory | Conveys the coursework completed, performance and attendance information for a student's academic career. 1: Courses posted in current district | |
CourseHistory/Term | Time spans by which courses are grouped. | |
CourseHistory/Term/ |
| |
CourseHistory/Term/ | Number Century and Year Reports the calendar end year. | System Administration > Calendar > Calendar |
CourseHistory/Term/TermInfoData/StartDate | Course Start Date. 1: The Start Date of the term. | term.startDate transcriptCourse.termStartDate |
CourseHistory/Term/ TermInfoData/EndDate | Course End Date. 1: The End Date of the term. | term.endDate transcriptCourse.termEndDate |
CourseHistory/Term/ TermInfoData/TermCode | The course Term Code 1: The term name. | term.name |
CourseHistory/Term/ TermInfoData/TermSpan | Course Term Span. | |
CourseHistory/Term/ | Code for session type. 1: When Calendar > Summer School = checked: 0833
Otherwise: 9999 2,3: 9999 | System Administrator > Calendar > Calendar > Summer School calendar.summerSchool |
CourseHistory/ Term/Courses | Courses the student has completed. Reports when student has any historical course records. | |
CourseHistory/ Term/Courses/Course | The individual course. Reports for each course on the student’s transcript. | |
CourseHistory/Term/Courses/ | Reference to the school where the course was taken. Generated by Campus. | |
CourseHistory/ Term/Courses/Course/ | Collects elements of interest from SchoolCourseInfo. | |
CourseHistory/ Term/Courses/Course/ | Local course number if available. The Course Number when not null. Otherwise, blank. | Student Information > General > Transcript > Course Number course.number |
CourseHistory/ Term/Courses/Course/ | State Core code for Utah public school courses. The course State Code. Otherwise, blank. | Student Information > General > Transcript > State Code course.stateCode |
CourseHistory/ Term/Courses/Course/ | A district course code. The Course Number when not null. Otherwise, blank. | Student Information > General > Transcript > Course Number course.number |
CourseHistory/ Term/Courses/Course/ | Title of course, up to 20 characters. Reports the Course Name. | Student Information > General > Transcript > Course Name course.name |
CourseHistory/ Term/ | Date course section started. Reports the term Start Date. | Scheduling > Courses > Section > Section Schedule Placement > Term term.startDate |
CourseHistory/ Term/ | Date course section ended. Reports the term End Date. | Scheduling > Courses > Section > Section Schedule Placement > Term term.endDate |
CourseHistory/ Term/Courses/Course/MarkingPeriods | Student performance/attendance data for each marking period. | |
CourseHistory/ Term/Courses/Course/ | Student performance/attendance data for a marking period. | |
CourseHistory/ Term/Courses/Course/ | Reference to the school where student took the course during the marking period, if different from schools above. The GUID for the schoolId. | school.schoolId |
CourseHistory/ Term/Courses/Course/MarkingPeriods/ | Container element for GradeLevelWhenTaken/Code |
|
CourseHistory/ Term/ | Student grade level when course taken. Reports the Standard Code when not null. Otherwise, reports the Name when not null. Else, reports reports based on the transcript course grade. | System Administrator > Calendar > Calendar > Grade Levels > Grade Level Editor > Standard Code, State Grade Level, Name Student Information > General > Transcript > Grade GradeLevel.standardCode GradeLevel.stateGrade GradeLevel.name TranscriptCourse.grade |
CourseHistory/ Term/Courses/Course/ | Reference to marking system at school of record. Generated by Campus. | |
CourseHistory/ Term/Courses/Course/ | The percent score for this mark (0.00 - 100.00). The transcript course percent when the mark is a percentage. | Student Information > General > Transcript > Score transcriptCourse.percent |
CourseHistory/ Term/Courses/Course/ | The raw numeric score for this mark. The transcript course number when the mark is numeric. | Student Information > General > Transcript > Score transcriptCourse.score |
CourseHistory/ Term/ | Credits attempted by the student. Reports the number of credits attempted. | Student Information > General > Transcript > Transcript Credit > Attempted transcriptCourse.creditsAttempted |
CourseHistory/ Term/ | Credits actually earned for the course. Reports the number of credits earned. | Student Information > General > Transcript > Transcript Credit > Earned TranscriptCredit.creditsEarned |
CourseHistory/ Term/Courses/Course/ | Type of credit Reports “0585”. | |
CourseHistory/ Term/Courses/Course/ | Information related to the span of time associated with the marking period. | |
CourseHistory/ Term/ | Grading term as recorded in SIS. When Calendar > Summer School = checked: 0833 Otherwise, count of terms in calendar: When 1 term: 0827 | System Administration > Calendar > Calendar > Summer School calendar.summerSchool |
AcademicPerformanceHistory | Provides a summary of a student's academic performance by reporting period. Container element for AcademicPerformanceHistory/ | |
AcademicPerformanceHistory/ | Reports a single TermPerformance element for each grade the student has been enrolled. This element will summarize the values per student grade level. Repeats for each Term the course belongs. |
|
AcademicPerformanceHistory/ | Reports the grade level for which this TermPerformance applies. Reports the grade in which the student belonged during this term. | Student Information > General > Transcript > Grade enrollment.grade |
AcademicPerformanceHistory/ | Total Credits Earned, repeated per Grade Reports the total number of credits earned during the term across all course records. | Student Information > General > Transcript > Actual Term transcriptCredit.creditsEarned |
AcademicPerformanceHistory/ | The grade point average the student earned during this session. Blank is ok.
| Student Information > General > Transcript > GPA Value, Unweighted GPA Value, Weighted GPA Value TranscriptCourse.gpaWeight TranscriptCourse.gpaValue TranscriptCourse. |
CourseHistory/ Term/Courses/Course/ | Letter grade as recorded in SIS, typically A, B,C Reports the Score if a letter mark. | Student Information > General > Transcript > Transcript Credit > Current Score transcriptCourse.score |
AcademicPerformanceSummary | Conveys a cumulative summary of a student's entire academic performance at the time the transcript was generated. | |
| AcademicPerformanceSummary/ TotalCreditsAttempted (required) | Total credits attempted by the student The sum of Attempted credits from across all course records on the transcript. | Student Information > General > Transcript > Transcript Course Editor > Attempted TranscriptCredit.creditsAttempted
|
| AcademicPerformanceSummary/ TotalCreditsEarned (required) | Total credits earned The sum of Earned credits from across all course records on the transcript. | Student Information > General > Transcript > Transcript Course Editor > Earned TranscriptCredit.creditsEarned
|
| AcademicPerformanceSummary/ CumulativeGPACreditsEarned | The number of credits or credit hours used to calculate the GPA that the student has earned to the present time. Reports the total number of credits in use to calculate the GPA. | Student Information > General > Credit Summary TranscriptCourse.gpaValue TranscriptCredits.creditsEarned |
| AcademicPerformanceSummary/ CumulativeGradePoints | Cumulative number of grade points earned during academic career. The sum of Unweighted GPA Value from across all course records on the transcript. When Null, reports from the GPA Value field. | Student Information > General > Transcript > Transcript Course Editor > Unweighted GPA Value, GPA Value TranscriptCourse.gpaValue TranscriptCourse. |
| AcademicPerformanceSummary/ CumulativeGPA (required) | The grade point average the student earned during this session. Blank is ok Reports the student’s transcript-based cumulative GPA.
| Student Information > General > Transcript > GPA Weight, GPA Value, Unweighted GPA Value TranscriptCourse.gpaWeight TranscriptCourse.gpaValue TranscriptCourse. |
| AcademicPerformanceSummary/ ClassRank (required) | The rank order number of the student compared to other students in the grade level based on GPA. Reports the student’s class rank. |
|
| AcademicPerformanceSummary/ ClassTotalNumber (required) | The total number of students in the grade level to compare students against. The number of students included in the class rank. |
|
| AcademicPerformanceSummary/ ProjectedGraduationDate (required) | Projected graduation date Reports the year in NGA Cohort End Year, followed by the month in which the student’s latest year calendar ends, priorize first by latest Start Date, then Primary enrollment. In order for the ProjectedGraduationDate to currently populate, the student must have a Primary enrollment in the Zone Year. | Student Information > General > Graduation > State Reported Graduation Fields > NGA Cohort End Year Graduation. cohortYearNGA
|
| AcademicPerformanceSummary/ GraduationDate (required if graduated) | Graduation date if graduated. Reports the Diploma Date entered when not null and <= current date. Otherwise, reports blank. | Student Information > General > Graduation > Diploma Date graduation.diplomaDate
|
| AcademicPerformanceSummary/ GraduationDiplomaType (required if graduated) | Basic, GED, Adult, or Certificate of Completion Reports based on the Attribute/Dictionary Value mapped to the Diploma Type selected when not null and when Diploma Date is not null and <= current date. Otherwise, reports blank. | Student Information > General > Graduation > Diploma Type
graduation.diplomaType |
| AssessmentPerformanceHistory (required when an assessment exists) | Conveys a history of assessments that the student has taken throughout his/her academic career. Reports blank when the student does not have an assessment assigned that has the following: | Student Information > General > Assessment test.type test.nationalCode
|
| AssessmentPerformanceHistory/ Assessment | A record of performance on an individual assessment. The SubtestCategory must report when Subject is selected on the Test Setup, and the Assessment/Name must report Test Setup > Test Detail > National Test National Code from the topmost parent assessment with National Test > National Code = "AP", "SAT" or "ACT". Repeats a record for each assessment assigned to the student that has the following: | Student Information > General > Assessment test.type test.nationalCode |
| AssessmentPerformanceHistory/ Assessment/Name (required when an assessment exists) | Assessment Name Reports the name of the assessment from the topmost parent assessment. | Assessment > Test Setup > Test Detail > Name test.name |
| AssessmentPerformanceHistory/ Assessment/AdministrationDate (required when an assessment exists) | Date the assessment was administered, year is required. Reports the date entered on the assessment. | Student Information > General > Assessment > Test Score Detail > Date test.date |
| AssessmentPerformanceHistory/ Assessment/ StudentGradeLevelWhenAssessed | Student’s grade level when assessed. Reports the student’s highest grade level. | Student Information > General > Enrollment > Grade enrollment.grade
|
| AssessmentPerformanceHistory/ Assessment/SubTestCategory (required for ACT and SAT) | The subtest or subject category of the assessment, e.g. 'English' or 'Composite'. Required for ACT and SAT. Blank is ok. Reports the Subject name. | Assessment > Test Setup > Test Detail > Subject test.type |
| AssessmentPerformanceHistory/ Assessment/TestScore (required when an assessment exists) | Test Score Reported. Reports the score based on the following hierarchy: | Assessment > Test Setup > Test Detail > Scores testScore |
| SIF_ExtendedElement Name=”UTExtensions”> | ||
| WeightedGPA (required) | The average of all class grades based on a 4.0 scale. Accelerated classes may increase GPA up to a max of 5.0. Reports the student’s weighted GPA. | Student Information > General > Credit Summary > Cumulative GPA v_CumGPAStats.cumGPA |
| PercentileRank (required) | The student’s percentile based upon student class rank and the number of students. Reports the student’s percentile rank, capped at 99.99% | v_CumGPAStats.rank / v_CumGPAStats.out_of |
StudentAttendanceSummary
This object contains information related to the student attendance in each enrollment.
Object Triggering
| SIF_Events are not reported for this object. |
Object Population and Business Rules
Reports one instance of StudentAttendanceSummary per non-excluded enrollment in the SIF Zone scope. |
The SIF Agent and Zone must have access rights assigned to StudentAttendanceSummary. |
Student’s enrollment calendar must not be excluded: |
Student’s enrollment in the SIF Zone Year is not excluded on the SIF Zone Options:
System Administration > Data Interchange > Zones > SIF Zone Options |
Object Data Elements
| Data Element | Description and Business Rules | Data Source GUI Path and Database Field |
|---|---|---|
StartDate | The starting date on which the information in this object instance is applicable. The student's earliest date of instruction in this enrollment up to and including the current date. | Student Information > General > Enrollments > General Enrollment Information > Start Date day.date |
StartDay | Number of the first school day to which this object instance applies. The instructional day number in this enrollment the student first attended in the calendar. | Student Information > General > Enrollments > General Enrollment Information > Start Date day.date |
EndDate | The ending date on which the information in this object instance is applicable. The student's latest date of instruction in this enrollment up to the current date. | Student Information > General > Enrollments > General Enrollment Information > End Date day.date |
EndDay | Number of the last school day to which this object instance applies. The instructional day number the student last attended in this enrollment. | Student Information > General > Enrollments > General Enrollment Information > End Date day.date |
Resident | An indication as to whether or not the student's legal residence was within the boundaries of the school during the time between the StartDate and EndDate, inclusive. When the District of Residence is the same as the enrollment district, reports "Yes". When the District of Residence is not the same as the enrollment district, reports "No". When the enrollment Resident District is null, reports "Unknown". | Student Information > General > Enrollments > State Reporting Fields > District of Residence enrollment.residentDistrict |
DaysAttended | The number of days the student attended school when school was in session between the StartDate and EndDate, inclusive.
| Student Information > General > Enrollments > Start Date, End Date System Administration > Calendar > Calendar > Days > Day Detail > Instruction day.instructional enrollment.startDate enrollment.endDate attendance.status attendance.excuse |
ExcusedAbsences | The number of days the student was absent from school with a valid excuse when school was in session between the StartDate and EndDate, inclusive.
| System Administration > Calendar > Calendar > Days > Day Detail > Instruction day.instructional attendance.status attendance.excuse |
UnexcusedAbsences | The number of days the student was absent from school without a valid excuse when school was in session between the StartDate and EndDate, inclusive. Sums the unique instructional days the student is enrolled where all instructional periods in the day are assigned an attendance code with: | System Administration > Calendar > Calendar > Days > Day Detail > Instruction day.instructional attendanceExcuse.status attendance.status attendance.excuse |
DaysTardy | The number of days the student was tardy when school was in session between the StartDate and EndDate, inclusive. Sums the unique instructional days the student is enrolled where any instructional period in the day is assigned an attendance code with: | System Administration > Calendar > Calendar > Days > Day Detail > Instruction day.instructional attendance.status attendance.excuse |
DaysInMembership | School aggregate membership
| Student Information > General > Enrollments > Local Start Status System Administration > Attendance > Attendance Codes > Attendance Excuses Editor > Attendance Excuse Detail enrollment.startStatus enrollment.startDate OR attendance.status OR attendance.excuse |
StudentSchool | RefId (GUID) of the StudentSchoolEnrollment object instance that corresponds to this object instance. Reports the RefId for the StudentSchoolEnrollment associated with this StudentAttendanceummary instance. | |
| AbsencesDue ToSuspension | Indicates the number of absences due to suspension. Report "000" when the following is true:
| System Administrator > Calendar > Grade Levels > Grade Level Detail > Half Day Absence (minutes) |
StudentDemographicRecord
This object contains information related to the student demographics. The student demographic information can generally be viewed and modified by navigating to the following:
- Census > People > Demographics
- Census > People > Households
Object Triggering
| SIF events are not reported for this object. |
Object Population and Business Rules
The SIF Agent and Zone must have access rights assigned to StudentDemographicRecord. |
Student’s enrollment calendar must not be excluded: |
Student has an enrollment in the SIF Zone Year that is not excluded on the SIF Zone Options
System Administration > Data Interchange > Zones > SIF Zone Options |
Object Data Elements
| Data Element | Description and Business Rules | Data Source GUI Path and Database Field |
|---|---|---|
ReportingDate | The date this record was prepared. Reports the current date. | day.date YYYY-MM-DD |
StudentPersonalData | Collects elements of interest from StudentPersonal. | |
StudentPersonalData/LocalId | The ending date on which the information in this object instance is applicable. Reports the Student Number when not Null. | Census > People > Demographics > Student Number person.studentNumber |
StudentPersonalData/StateProvinceId | Number of the last school day to which this object instance applies. Reports the Student State ID when not Null. | Census > People > Demographics > Student State ID person.stateId |
StudentPersonalData/SSN | Social Security Number. Reports the Social Security Number when not Null. | Census > People > Demographics > Social Security Number identity.ssn |
StudentPersonalData/Name/@Type | Name of the student. Note: Type value of 04 must be used here. Reports “04” | |
StudentPersonalData/Name/LastName | The last name. Reports the student’s last name. | identity.lastName |
StudentPersonalData/Name/FirstName | The first name. Reports the student’s first name. | identity.firstName |
StudentPersonalData/Name/MiddleName | The middle name or initial. Reports the student’s middle name. | identity.middleName |
StudentPersonalData/Name/Suffix | Generation of suffix like II, Jr., etc. Reports the student’s suffix when exists. | Census > People > Demographics > Person Information > Suffix identity.suffix |
StudentPersonalData/ | This is a name that the person prefers to be called by. Reports the student’s Nickname when exists. | Census > People > Demographics > Person Information > Nickname identity.alias |
StudentPersonalData/Name/SortName | This is the name to be used for sorting purposes. Last Name, First Name + Middle Initial | Census > People > Demographics > Person Information > Last Name, First Name, Middle Name identity.lastName , identity.firstName + identity.Middle Name |
StudentPersonalData/Name/FullName | A free text field for the complete name. First Name + Middle Name + Last Name | Census > People > Demographics > Person Information > First Name, Middle Name, Last Name identity.firstName + identity.Middle Name + identity.lastName |
StudentPersonalData/DemographicsData | Collects elements of interest from Demographics. | |
StudentPersonalData/ | ||
StudentPersonalData/ | ||
StudentPersonalData/DemographicsData/ | The general racial category which reflects the individual's recognition of his or her community or with which the individual most identifies. Report’s the student’s race(s) from the checkboxes. | Census > People > Demographics > Person Information > Race/Ethnicity > Is the individual from one or more of these races? raceEthnicity.code |
StudentPersonalData/DemographicsData/ | ||
StudentPersonalData/DemographicsData/ | Indian tribal affiliation. Reports the Tribal Affiliation selection when present | Census > People > Demographics > Person Information > Race/Ethnicity > Tribal Affiliation identity.raceSubcategory |
StudentPersonalData/ | A person's gender.
| Census > People > Demographics > Person Information > Gender identity.gender |
StudentPersonalData/ | A person's date of birth. | Census > People > Demographics > Person Information > Birth Date identity.birthDate |
StudentPersonalData/DemographicsData/ | List of languages an individual uses to communicate. Requires an entry in Home Primary Language or Native Language. | Census > People > Demographics > Person Information > Home Primary Language, Native Language |
StudentPersonalData/DemographicsData/ | Container for language elements. | |
StudentPersonalData/DemographicsData/ | The code representing the specific language that an individual uses to communicate. Reports the SIF code mapped to the student’s Home Primary Language or Native Language | Census > People > Demographics > Person Information > Home Primary Language, Native Language identity.homePrimaryLanguage identity.languageAlt |
StudentPersonalData/DemographicsData/ | List of other codes or strings that crosswalk to or serve as translations of the Code element paired with this common element. | |
StudentPersonalData/DemographicsData/ | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. Reports "StateProvince" | |
StudentPersonalData/DemographicsData/ | 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. Reports the State Code selected in Home Primary Language or Native Language. | Census > People > Demographics > Person Information > Home Primary Language, Native Language |
StudentPersonalData/ | An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central or South America, or other Spanish cultures, regardless of race. When Yes, reports Yes. | Census > People > Demographics > Person Information > Race/Ethnicity > Is the individual Hispanic/Latino? identity.hispanicEthnicity |
StudentPersonalData/DemographicsData/ | A country code. Reports the student’s birth country. | Census > People > Demographics > Person Information > Birth Country identity.birthCountry |
StudentPersonalDataAddressList | A list of Address elements. A collection of the addresses that exist for the student. Orders address by:
| Census > People > Households > Address |
StudentPersonalDataAddressList/ | 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. For each reported address: Reports "0123" when address.postOfficeBox = checked on the student's household. Reports "0765" for the first non-secondary address. Reports "1073" for the first secondary address. Subsequent addresses report "2382", then "0124", then "1074", and then "1075" for the remaining addresses. | address.postOfficeBox householdLocation.secondary |
StudentPersonalDataAddressList/Street | The street element is a complex element and breaks the street down into several parts. When address.postOfficeBox = checked, reports "P.O. Box" + address.number When address.postOfficeBox NOT = checked, reports address.number + address.prefix + address.street + address.tag + address.dir | address.postOfficeBox address.number address.dir |
StudentPersonalDataAddressList/ | Address line 1. When address.postOfficeBox = checked, reports "P.O. Box" + address.number When address.postOfficeBox NOT = checked, reports address.number + address.prefix + address.street + address.tag + address.dir | Census > People > Households > Address address.postOfficeBox address.number |
StudentPersonalDataAddressList/ | Address line 2. Reports the Apt when exists. | Census > People > Households > Address > Apt address.apt |
StudentPersonalDataAddressList/ | Address line 3. address.city, address.state + address.zip | Census > People > Households > Address address.city address.state address.zip |
StudentPersonalDataAddressList/ | The address number assigned to the building. Reports the address Number. | Census > People > Households > Address > Number address.number |
StudentPersonalDataAddressList/ | Street prefix like NE Reports the address Prefix when exists. | Census > People > Households > Address > Prefix address.prefix |
StudentPersonalDataAddressList/ | The name of the street. Reports the address Street. | Census > People > Households > Address > Street address.street |
StudentPersonalDataAddressList/ | The type of street. For example, Lane, Blvd., Ave., etc. Reports the address Tag when exists. | Census > People > Households > Address > Tag address.tag |
StudentPersonalDataAddressList/ | Street suffix like SW. Reports the address Direction when exists. | Census > People > Households > Address > Direction address.dir |
StudentPersonalDataAddressList/ | The number of the apartment. Reports the address Apt when exists. | Census > People > Households > Address > Apt address.apt |
StudentPersonalDataAddressList/ | The city part of the address. Reports the address City when exists. | Census > People > Households > Address > City address.city |
StudentPersonalDataAddressList/ | The county part of the address. Reports the address County when exists. | Census > People > Households > Address > Country address.county |
StudentPersonalDataAddressList/ | The state or province code. Reports the address State when exists. | Census > People > Households > Address > State address.state |
StudentPersonalDataAddressList/ | The country code. Hardcoded to "US" | |
StudentPersonalDataAddressList/ | The ZIP/postal code. Reports the address Zip when exists. | Census > People > Households > Address > Zip address.zip |
StudentPersonalData/PhoneNumberList | Lists phone numbers associated with an entity. Reports the household phone, and either cell phone or work phone. | Census > People > Households > Household Info > Phone Number household.phone contact.cellPhone |
StudentPersonalData/ | Code that specifies what type of phone number this is. Note: A subset of valid values may be specified in data objects. When household.phone is not null, reports "0096". When contact.cellPhone or contact.workPhone is not null, reports "0350". | |
StudentPersonalData/ | Phone number. Reports household.phone. When contact.cellPhone is not null, reports this number first. Otherwise reports contact.workPhone | Census > People > Households > Household Info > Phone Number household.phone |
StudentPersonalData/IDEA | Is the student IDEA-eligible ("special education")? When either are not null, reports "Yes". Otherwise, "No" | planState.specialEdStatus or enrollment.specialEdStatus |
StudentPersonalData/Migrant | Is this a migrant student? Reports Yes when: | Student Information > Program Participation > Migrant Migrant. lastQualifyingArrivalDate COEStatusIndicator |
StudentPersonalData/Title1 | Is the student in Title 1 programs? Reports Yes when: | Student Information > Program Participation > Title 1 Title1.startDate |
StudentPersonalData/GiftedTalented | Is the student in Gifted/Talented programs? Reports Yes when: | Student Information > Program Participation > Gifted Gifted.startDate |
StudentPersonalData/ | Does the student meet the State criteria for classification as having an economic disadvantage? Reports Yes when: | FRAM > Eligibility > Eligibility Detail posEligibility.eligibility |
StudentPersonalData/ELL | Is the student an English Language Learner under Title 3? Reports Yes when: | Student Information > Program Participation > English Learners (EL) lep.identifiedDate lep.exitDate |
StudentPersonalData/Homeless | Is the student homeless? Reports Yes when: | Student Information > General > Program Participation > Homeless > Start Date, End Date homeless.startDate |
StudentPersonalData/Section504 | Is the student a qualified individual under Section 504 of the Rehabilitation Act? Reports Yes when: | Student Information > Program Participation > Section 504 Section504.startDate |
StudentPersonalData/ | Does the student meet the State criteria for classification as a vocational concentrator? Reports Yes when: | Student Information > Program Participation > Title 1 Title1.startDate |
StudentPersonalData/Immigrant | Does the student meet the State criteria for classification as being an immigrant? Reports Yes when: | Census > People > Person Information > Immigrant identity.immigrant |
StudentPersonalData/NeglectedDelinquent | Is the student participating in programs for neglected, delinquent, or at risk children? Reports Yes when: | Student Information > Program Participation > State Programs > Youth In Care YouthProgram.startDate |
StudentContactsSummary | Reports up to two parents/guardians of the student. | |
StudentContactsSummary/ParentGuardian1 | First parent/guardian. Reports based on the following priority when the guardian exists on a student household:
| |
StudentContactsSummary/ | Code that specifies what type of name this is. Reports “04” | |
StudentContactsSummary/ParentGuardian1/ | The Last Name of the first guardian Reports the guardian’s Last Name. | Student Information > General > Households > Members > Demographics > Last Name relatedPair.name identity.lastName |
StudentContactsSummary/ParentGuardian1/ | The First Name of the first guardian Reports the guardian’s First Name. | Student Information > General > Households > Members > Demographics > First Name relatedPair.name identity.firstName |
StudentContactsSummary/ParentGuardian2 | Second parent/guardian. | |
StudentContactsSummary/ | Code that specifies what type of name this is. Reports “04” | |
StudentContactsSummary/ParentGuardian2/ | The Last Name of the second guardian Reports the guardian’s Last Name. | Student Information > General > Households > Members > Demographics > Last Name relatedPair.name identity.lastName |
StudentContactsSummary/ParentGuardian2/ | The First Name of the second guardian Reports the guardian’s First Name. | Student Information > General > Households > Members > Demographics > First Name relatedPair.name identity.firstName |
StudentParticipation
This object contains information related to the student program participation in special education, youth in care, and section 504.
The student program participation information can be viewed and modified by navigating to the following:
- S2: Student Information > Special Ed > General > Documents > Plans
- S3: Student Information > Program Participation > State Programs > Youth In Care
- S4: Student Information > Program Participation > Section 504
Object Triggering
SIF events are not reported for this object. |
Object Population and Business Rules
- SCRAM (S2) Record Population and Business Rules
- Youth In Care (S3) Record Population and Business Rules
- Section 504 (S4) Record Population and Business Rules
SCRAM (S2) Record Population and Business Rules
Special Ed plan dates must align with the student's enrollment dates in order to properly report. If the Special Ed plan has ended, the enrollment must be end dated as well.
The SIF Agent and Zone must have access rights assigned to StudentParticipation. |
A SCRAM (S2) record reports for each locked Data Plan in the Zone Year and Calendar that has:
Student Information > Special Ed > General > Documents |
Student has an enrollment in the SIF Zone Year and Calendar with:
* Object elements are reported from the latest qualifying, non-excluded enrollment with the most recent Start Date <= current date. |
Student must have an enrollment associated with a calendar that is not excluded: |
Student must have an enrollment in the Zone Scope that is not excluded on the SIF Zone Options: |
Youth In Care (S3) Record Population and Business Rules
The SIF Agent and Zone must have access rights assigned to StudentParticipation. |
A YIC (S3) StudentParticipation object reports for each Youth In Care record in the Zone Year and Calendar that has:
Student Information > Program Participation > State Programs > Youth In Care |
Student has an enrollment in the SIF Zone Year and Calendar with:
|
Student must have an enrollment associated with a calendar that is not excluded: |
Student must have an enrollment in the Zone Scope that is not excluded on the SIF Zone Options: |
Section 504 (S4) Record Population and Business Rules
The SIF Agent and Zone must have access rights assigned to StudentParticipation. |
A Section 504 (S4) StudentParticipation object reports for each Section 504 record in the Zone Year and Calendar that has:
Student Information > Program Participation > State Programs > Section 504 |
Student has an enrollment in the SIF Zone Year and Calendar with:
|
Student must have an enrollment associated with a calendar that is not excluded: |
Student must have an enrollment in the Zone Scope that is not excluded on the SIF Zone Options: |
Object Data Elements
- SCRAM (S2) Record Object Data Elements
- Youth In Care (S3) Object Data Elements
- Section 504 (S4) Object Data Elements
SCRAM (S2) Record Object Data Elements
The common elements belonging to the StudentParticipation object. Those elements indicated as “required” are listed in the UTREx profile.
| Data Element | Description and Business Requirements | Database Field | |
|---|---|---|---|
StudentParticipationAsOfDate | The date this record was prepared. Reports the current date. | day.date | YYYY-MM-DD |
ProgramType | Parent element to ProgramType/Code. | ||
ProgramType/Code | Identifies the individualized program for which the student's participation is described in this instance.
| NCES Code | |
ExceptionalityCategories | List | ||
ExceptionalityCategories/ | Container element for Exceptionality/Code | ||
ExceptionalityCategories /ExceptonalityCategory/Code | Disability Type
| Student Information > General > Enrollments > Special Ed Fields > Disability 1 | NCES Code |
ProgramPlacementDate | SCRAM Placement Date
| Student Information > Special Education > Documents > UT Data Plan > Education Plan > Start Date | xs:date |
LeastRestrictiveEnvironment | Educational environment
| Student Information > General > Enrollments > Special Ed Fields > Special Ed Setting | |
LeastRestrictiveEnvironment/Code | Educational environment Reports “9999”. | Student Information > General > Enrollments > Special Ed Fields > Special Ed Setting enrollment.specialEdSetting | NCES Code |
LeastRestrictiveEnvironment/ | Educational environment Reports the code selected in the enrollment Special Ed Setting field. | Student Information > General > Enrollments > Special Ed Fields > Special Ed Setting enrollment.specialEdSetting | For Ages 3-5: C, F, G, J, K, R, S, I, M, P. |
ProgramExitDate | SCRAM Exit Date Reports the enrollment Exit Date + 1 day when Exit Date is not null. | Student Information > General > Enrollments > Special Ed Fields > Exit Date enrollment.spedExitDate | xs:date |
ProgramExitReason |
| Student Information > General > Enrollments > Special Ed Fields > Exit Reason enrollment. spedExitReason | |
ProgramExitReason/Code | Review by program / state
| Student Information > General > Enrollments > Special Ed Fields > Exit Reason enrollment. spedExitReason | NCES Code |
ProgramExitReason/ | SCRAM Exit Reason code Reports the code selected in the Exit Reason field. | Student Information > General > Enrollments > Special Ed Fields > Exit Reason enrollment. spedExitReason | A, D, P, S, X |
StudentSpecialEducationFTE | Percent in regular setting.
| Student Information > Special Education > Documents > UT Data Plan > Education Plan > Regular Percent plan.regularPercent | xs:decimal |
| TimeCode (required) | Reports the Time code selected when A, B, or C. Otherwise, reports blank. | Student Information > Special Education > Documents > UT Data Plan > Education Plan > Time plan.time | |
| DaysInMembership (required) |
| Student Information > General > Enrollments > General Enrollment Information > Local Start Status System Administration > Enrollment > Start Status Type > Start Status Type Detail > Start Status Code (Mapping) Student Information > General > Enrollments > Special Ed Fields > Exit Date enrollment.StartStatus enrollment. spedExitDate | |
| IsOnePercent | A Student with a Significant Cognitive Disability, (SCD), as defined in Board Rule R277705-2 Reports “Y” when DLM 1% field = Yes. Otherwise, reports blank. | Student Information > Special Education > Documents > UT Data Plan > Education Plan > DLM 1% | |
| ExtendedSchoolYear | Student is eligible for Extended School Year (ESY) Reports Y when Extended School Year = Yes, student is receiving ESY Services. Otherwise, reports blank. | Student Information > Special Education > Documents > UT Data Plan > Enrollment Information > Extended School Year |
Youth In Care (S3) Object Data Elements
The common elements belonging to the StudentParticipation object. Those elements indicated as “required” are listed in the UTREx profile.
| Data Element | Description and Business Requirements | Database Field | |
|---|---|---|---|
StudentParticipationAsOfDate | The date this record was prepared. Reports the current date. | day.date | YYYY-MM-DD |
ProgramType | Parent element to ProgramType/Code. | ||
ProgramType/Code | Identifies the individualized program for which the student's participation is described in this instance.
| ||
| ExceptionalityCategories | Reports blank in the S3 record. | ||
| ExceptionalityCategories /ExceptonalityCategory | Does not populate in the S3 record. | ||
| ExceptionalityCategories /ExceptonalityCategory/Code | Does not populate in the S3 record. | ||
| ProgramPlacementDate (required) | YIC Entry Date Reports the Start Date of the Youth In Care record. | Student Information > Program Participation > State Programs > Youth In Care > Start Date YouthProgram.startDate | |
| LeastRestrictiveEnvironment (required) | Parent element to LeastRestrictiveEnvironment/Code Reports blank when Environment field is blank. | Student Information > Program Participation > State Programs > Youth In Care > Environment | |
| LeastRestrictiveEnvironment/Code (required) | Category represents the optimal educational setting in which the student should be placed (setting where child has most desirable learning environment). Relates specifically to special education. Reports “9999”. When blank, element does not report. | Student Information > Program Participation > State Programs > Youth In Care > Environment | |
| LeastRestrictiveEnvironment/ OtherCodeList/OtherCode (required) | Educational environment Reports the code selected in the Environment field. When blank, element does not report. | Student Information > Program Participation > State Programs > Youth In Care > Environment | |
| ProgramExitDate (required when exited) | YIC Exit Date Reports the Youth In Care Exit Date + 1 day when Exit Date is not null. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Youth In Care > Exit Date | |
| ProgramExitReason (required when exited) | Reports blank when Exit Reason is blank. | Student Information > Program Participation > State Programs > Youth In Care > Exit Reason | |
| ProgramExitReason/Code (required when exited) | YIC Exit Reason code Reports “9999”. When blank, element does not report. | Student Information > Program Participation > State Programs > Youth In Care > Exit Reason | |
| ProgramExitReason/ OtherCodeList/OtherCode (required when exited) | YIC Exit Reason code Reports the code selected in Exit Reason. When blank, element does not report. | Student Information > Program Participation > State Programs > Youth In Care > Exit Reason | |
| StudentSpecialEducationFTE |
| Student Information > Special Education > Documents > UT Data Plan > Education Plan > Regular Percent plan.regularPercent | |
| TimeCode (required) | Reports the Time code selected when A, B, or C. When blank, reports blank. | Student Information > Program Participation > State Programs > Youth In Care > Time Code | |
| DaysInMembership (required) |
| Student Information > General > Enrollments > General Enrollment Information > Local Start Status System Administration > Enrollment > Start Status Type > Start Status Type Detail > Start Status Code (Mapping) Student Information > Program Participation > State Programs > Youth In Care > End Date enrollment.StartStatus enrollment. spedExitDate | |
| CustodyType (required) | Reports the code selected in Custody Type when not blank. When blank, reports blank. | Student Information > Program Participation > State Programs > Youth In Care YouthProgram.custodyType | |
| ExcludeYICMembership | Indicates membership should be excluded. Reports “Y” when Exclude YIC Membership field is checked. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Youth In Care > Exclude YIC Membership YouthProgram.excludeMembership | |
| DJJSFacility | For Time Code ‘C’ for YIC students. Reports the code selected in DJJS Facility when not blank. When DJJS Facility is blank, reports blank. | Student Information > Program Participation > State Programs > Youth In Care > DJJS Facility YouthProgram.facility | |
| RTCFacility | Reports the code selected in the Residential Treatment Center field on the Youth in Care program. Reports blank if the Residential Treatment Center field = null. | Student Information > State Programs > Youth In Care > Residential Treatment Center | |
| IsNeglectedAndDelinquent | Used for Time code ‘C’ for YIC Students. Identifies a student receiving education services as funded by Title 1/D. Reports the code selected in Neglected / Delinquent when not blank. When Neglected / Delinquent is blank, reports blank. | Student Information > Program Participation > State Programs > Youth In Care > Neglected / Delinquent YouthProgram.neglectedDelinquent |
Section 504 (S4) Object Data Elements
The common elements belonging to the StudentParticipation object. Those elements indicated as “required” are listed in the UTREx profile.
| Data Element | Description and Business Requirements | Database Field | |
|---|---|---|---|
StudentParticipationAsOfDate | The date this record was prepared. Reports the current date. | day.date | YYYY-MM-DD |
ProgramType | Parent element to ProgramType/Code. | ||
| ProgramType/Code | Identifies the individualized program for which the student's participation is described in this instance. Reports “3200”. | ||
| ExceptionalityCategories | Reports blank in the S4 record. | ||
| ExceptionalityCategories/ ExceptonalityCategory | Reports blank in the S4 record. | ||
| ExceptionalityCategories /ExceptonalityCategory/Code | Reports blank in the S4 record. | ||
| ProgramPlacementDate (required) | Section 504 Entry Date Reports the Start Date of the Section 504 record. | Student Information > Program Participation > State Programs > Section 504 > Start Date | |
| LeastRestrictiveEnvironment | Reports blank in the S4 record. | ||
| LeastRestrictiveEnvironment/Code | Reports blank in the S4 record. | ||
| LeastRestrictiveEnvironment/ OtherCodeList/OtherCode | Reports blank in the S4 record. | ||
| ProgramExitDate (required when exited) | Section 504 Exit Date Reports the Section 504 End Date + 1 day when End Date is not null. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Section 504 > End Date Section504. endDate | |
| ProgramExitReason (required when exited) | Reports blank when Exit Reason is blank. | Student Information > Program Participation > State Programs > Section 504 > Exit Reason Section504. exitReason | |
| ProgramExitReason/Code (required when exited) | Section 504 Exit Reason code Reports “9999”. When blank, element does not report. | Student Information > Program Participation > State Programs > Section 504 > Exit Reason Section504. exitReason | |
| ProgramExitReason/ OtherCodeList/OtherCode (required when exited) | Section 504 Exit Reason code Reports the code selected in Exit Reason. When blank, element does not report. | Student Information > Program Participation > State Programs > Section 504 > Exit Reason Section504. exitReason | |
| StudentSpecialEducationFTE | Reports blank in the S4 record. | ||
| Autism | Student receives Section 504 accommodations for Autism Reports “Y” when Disability has Autism selected. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Section 504 > Disability Section504. disability | |
| BrainInjury | Student receives Section 504 accommodations for a brain injury or concussion impairment Reports “Y” when Disability has Brain Injury or Concussion Impairment selected. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Section 504 > Disability Section504. disability | |
| HearingImpairment | Student receives Section 504 accommodations for a hearing impairment Reports “Y” when Disability has Hearing Impairment selected. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Section 504 > Disability Section504. disability | |
| LearningImparment | Student receives Section 504 accommodations for a learning impairment Reports “Y” when Disability has Learning Impairment selected. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Section 504 > Disability Section504. disability | |
| BodilyFunctionImpairment | Student receives Section 504 accommodations for a major bodily function impairment Reports “Y” when Disability has Major Bodily Function Impairment selected. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Section 504 > Disability Section504. disability | |
| MedicalImpairment | Student receives Section 504 accommodations for a medical impairment Reports “Y” when Disability has Medical Impairment selected. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Section 504 > Disability Section504. disability | |
| MentalHealthImpairment | Student receives Section 504 accommodations for a mental health impairment Reports “Y” when Disability has Mental Health Impairment selected. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Section 504 > Disability Section504. disability | |
| OrthopedicImpairment | Student receives Section 504 accommodations for an orthopedic impairment Reports “Y” when Disability has Orthopedic Impairment selected. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Section 504 > Disability Section504. disability | |
| OtherImpairment | Student receives Section 504 accommodations for a disability or impairment not included in one of the eight categories Reports “Y” when Disability has Other Impairment selected. Otherwise, reports blank. | Student Information > Program Participation > State Programs > Section 504 > Disability Section504. disability |
StudentPersonal
This object contains all the personal information related to the student. The student information, generally, can be viewed and modified by navigating to the following:
- Census > People > Demographics
- Student Information > General > Enrollments
Object Triggering
| Event Type | Requirement |
|---|---|
Add | Adding the student to Infinite Campus. |
Change | A change is made on the student’s enrollment in the SIF Zone Scope. |
Change | A change is made on the student’s Demographics record. |
Change | A change on the following tabs occur: Early Learning, Foster Care, FRAM, Graduation, English Learners (EL) |
Delete | Deleting the student from Infinite Campus. |
Object Population and Business Rules
The SIF Agent and Zone must have access rights assigned to StudentPersonal. |
Student’s enrollment grade level must not be excluded from SIF reporting. |
Student’s enrollment calendar must not be excluded: |
Student has an enrollment in the SIF Zone Year that is not excluded on the SIF Zone Options: |
Object Data Elements
| Data Element | Description and Business Requirements | Database Field |
|---|---|---|
LocalId | The locally-assigned identifier for this student. Reports the student’s Local Student Number. | Census > People > Demographics > Person Information > Local Student Number person.studentNumber |
StateProvinceId | The state-assigned identifier for this student. Reports the Student State ID. | Census > People > Demographics > Person Identifiers > Student State ID person.stateId |
OtherIdList | Lists all "other" identifiers associated with the student. Reports when Social Security Number is entered and Zone Options > Publish Social Security Number = Checked. | |
OtherIdList/OtherId | Lists an "other" identifier associated with the student. Reports the Social Security Number. | Census > People > Demographics > Person Information > Soc Sec Number identity.ssn |
OtherIdList/OtherId/@Type | Code that defines the type of this other Id. Reports "0004" | |
Name/@Type | Name of the student. Note: Type value of 04 must be used here. | |
Name/LastName | Reports the student’s last name. | Census > People > Demographics > Person Information > Last Name identity.lastName |
Name/FirstName | Reports the student’s first name. | Census > People > Demographics > Person Information > First Name identity.firstName |
Name/MiddleName | Reports the student’s middle name. | Census > People > Demographics > Person Information > Middle Name identity.middleName |
Name/Suffix | Reports the student’s name suffix. | Census > People > Demographics > Person Information > Suffix identity.suffix |
Name/PreferredName | This is a name that the person prefers to be called by. | Census > People > Demographics > Person Information > Nickname identity.alias |
Name/SortName | This is the name to be used for sorting purposes. | Census > People > Demographics > Person Information > Last Name, First Name, Middle Name identity.lastName, identity.firstName, identity.middleName |
Name/FullName | A free text field for the complete name. First Name + Middle Name + Last Name | Census > People > Demographics > Person Information > First Name + Middle Name + Last Name identity.firstName, identity.middleName, identity.lastName |
OtherNames | Previous, alternate or other names or aliases associated with the student. Reports when student has a different name in a prior Identities record. | Census > People > Identities > Identities Editor > Identity Information identity.firstName, identity.middleName, identity.lastName |
OtherNames/Name @Type | Code that specifies what type of name this is, excluding "name of record." Reports "01" for the earliest prior Identities name record. | Census > People > Identities > Identities Editor > Identity Information |
OtherNames/LastName | Reports the student’s last name. | Census > People > Demographics > Person Information > Last Name identity.lastName |
OtherNames/FirstName | Reports the student’s first name. | Census > People > Demographics > Person Information > First Name identity.firstName |
Demographics | This element contains information related to student demographics. | |
Demographics/RaceList | List of races that apply to the student. | |
Demographics/RaceList/Race | Container element for Race. | |
Demographics/RaceList/ Race/Code | The general racial category which reflects the individual's recognition of his or her community or with which the individual most identifies. Reports the student’s race code. | Census > People > Demographics > Person Information > Race/Ethnicity raceEthnicity.code |
Demographics/RaceList/Race/ | List of other codes or strings that crosswalk to or serve as translations of the Code element paired with this common element. Codeset = “StateProvince” | |
Demographics/RaceList/Race/ | Indian tribal affiliation. Reports the Tribal Affiliation selection when present. | Census > People > Demographics > Person Information > Race/Ethnicity > Tribal Affiliation identity.raceSubcategory |
Demographics/HispanicLatino | An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central or South America, or other Spanish cultures, regardless of race. When Yes, reports Yes. | Census > People > Demographics > Person Information > Race/Ethnicity > Is the individual Hispanic/Latino? Identity. hispanicEthnicity |
Demographics/Gender | Person's gender.
| Census > People > Demographics > Person Information > Gender identity.gender |
Demographics/BirthDate | Reports the student’s date of birth. | Census > People > Demographics > Person Information > Birth Date identity.birthDate |
Demographics/PlaceOfBirth | The person's place of birth—like village, town, city etc. | Census > People > Demographics > Person Information > Birth City identity.birthCity |
Demographics/StateOfBirth | The person's state of birth. | Census > People > Demographics > Person Information > Birth State Identity.stateOfBirth |
Demographics/CountryOfBirth | The person's country of birth. | Census > People > Demographics > Person Information > Birth Country Identity.countryOfBirth |
Demographics/LanguageList | List of languages an individual uses to communicate. | Census > People > Demographics > Person Information > Home Primary Language, Native Language |
Demographics/ | Container for language elements. | |
Demographics/LanguageList/ | The code representing the specific language that an individual uses to communicate. Reports the SIF code mapped to the student’s Home Primary Language or Native Language | Census > People > Demographics > Person Information > Home Primary Language, Native Language identity.homePrimaryLanguage identity.languageAlt |
Demographics/LanguageList/ | List of other codes or strings that crosswalk to or serve as translations of the Code element paired with this common element. | |
Demographics/LanguageList/ | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | |
Demographics/LanguageList/ | 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. Reports the State Code selected in Home Primary Language or Native Language. | Census > People > Demographics > Person Information > Home Primary Language, Native Language identity.homePrimaryLanguage |
Demographics/LanguageList/ | An indication of the function and context in which an individual uses a language to communicate. When Home Primary Language, reports “1037” | Census > People > Demographics > Person Information > Home Primary Language, Native Language identity.homePrimaryLanguage |
Demographics/ DwellingArrangement | Setting/environment in which the person resides. | |
Demographics/Dwelling | Code representing the setting/environment in which the person resides. Reports “9999” | |
Demographics/ DwellingArrangement/ | Student’s ‘Homeless’ status. Codeset=’StateProvince’ | |
Demographics/ DwellingArrangement/ | Reports the code selected in Homeless Status from the student’s Homeless tab record with Start Date <= current date and End Date of null or >= current date. When null or when no qualifying Homeless record exists, reports “0”. | Student Information > General > Program Participation > Homeless > Homeless Status homeless.primaryNight |
AddressList | A list of Address elements. A collection of the addresses that exist for the student. Orders address by: 1. Non-secondary | Census > People > Households > Address |
Address | This element contains address data. | |
AddressList/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. Reports "0765" | |
AddressList/Street | The street element is a complex element and breaks the street down into several parts. | |
AddressList/Street/Line1 | Address line 1. When address.postOfficeBox = checked, reports "P.O. Box" + address.number When address.postOfficeBox NOT = checked, reports address.number + address.prefix + address.street + address.tag + address.dir | Census > People > Households > Address
address.number |
AddressList/Street/Line2 | Address line 2. Reports the Apt when exists. | Census > People > Households > Address > Apt address.apt |
AddressList/Street/Line3 | Address line 3. The City, State, and Zip Code. | Census > People > Households > Address address.city |
AddressList/Street/ | The address number assigned to the building. | Census > People > Households > Address > Number address.number |
AddressList/Street/ | Street prefix like NE | Census > People > Households > Address > Prefix address.prefix |
AddressList/Street/StreetName | The name of the street. | Census > People > Households > Address > Street address.street |
AddressList/Street/StreetType | The type of street. For example, Lane, Blvd., Ave., etc. | Census > People > Households > Address > Tag address.tag |
AddressList/Street/StreetSuffix | Street suffix like SW. | Census > People > Households > Address > Direction address.dir |
AddressList/Street/ | Type of apartment, for example, Suite. | Census > People > Households > Address > Apt address.apt |
AddressList/City | The city part of the address. | Census > People > Households > Address > City address.city |
AddressList/County | The county part of the address. | Census > People > Households > Address > Country address.county |
AddressList/StateProvince | The state or province code. | Census > People > Households > Address > State address.state |
AddressList/Country | The country code. Reports "US". | |
AddressList/PostalCode | The ZIP/postal code. | Census > People > Households > Address > Zip address.zip |
| AddressList/Address[@Type ='0765']/GridLocation | This element contains information related to the address grid location. | |
| AddressList/Address[@Type ='0765']/GridLocation/Latitude | Reports the entry in Address Info > Address Information > Latitude when Latitude is not null. When Latitude is null for the address, reports blank. | Address Info > Address Information > Latitude |
| AddressList/Address[@Type ='0765']/GridLocation/Longitude | Reports the entry in Address Info > Address Information > Longitude when Longitude is not null. When Longitude is null for the address, reports blank. | Address Info > Address Information > Longitude |
PhoneNumberList | The student's phone number(s). Reports the household phone, and either cell phone or work phone. | Census > People > Households > Household Info > Phone Number household.phone |
PhoneNumberList/Type | Code that specifies what type of phone number this is. Note: A subset of valid values may be specified in data objects. When household.phone is not null, reports "0096". When contact.cellPhone or contact.workPhone is not null, reports "0350". | |
PhoneNumberList/Number | Phone number. Reports household.phone when exists, otherwise: | Census > People > Households > Household Info > Phone Number household.phone |
EmailList | A list of e-mail addresses associated with an individual. | Census > People > Personal Contact Information > Email contact.email |
EmailList/@Type | This attribute specifies the type of e-mail address. Report “Primary”. | |
ProjectedGraduationYear | Currently projected graduation year. Reports the year selected in the "NGA Cohort End Year" field when not Null.
When no value is selected in Graduation > Date First Entered the 9th Grade field, looks to the student's Grade level in the most recent enrollment to calculate the ProjectedGraduationYear. | Student Information > General > Graduation > NGA Cohort End Year GraduationcohortYearNGA |
OnTimeGraduationYear | First projected graduation year, usually determined when student is accepted into 9th grade. Reports the NCLB Cohort End Year. | Student Information > General > Graduation > NCLB Cohort End Year graduation. cohortYearNCLB |
GraduationDate | Date student officially graduated from secondary education. Reports the student’s Diploma Date when present. | Student Information > General > Graduation > Diploma Date graduation. diplomaDate |
MostRecent | Container for elements reflecting the most recent enrollment of a student. If the student is currently enrolled in the district, the elements contain current information. | |
MostRecent/SchoolLocalId | Local identifier representing the school in which the student is or was most recently enrolled in the district. The school.number associated with the student's most recent enrollment ordered first by primary enrollment, and then non-primary. | System Administrator > Resources > School > School Detail > State School Number school.number |
IDEA | Is the student IDEA-eligible ("special education")? (Mutually exclusive with Section 504 classification.) Reports Yes when: The plan Special Ed Status = 1, or when the enrollment Special Ed Status field = 1. | Student Information > Special Ed > General > Documents > Enrollment Status > Special Ed Status planState.specialEdStatus, enrollment.specialEdStatus |
Migrant | Is this a migrant student? Reports Yes when: | Student Information > Program Participation > Migrant Migrant. lastQualifyingArrivalDate |
Title1 | Is the student in Title 1 programs? Reports Yes when: | Student Information > Program Participation > Title 1 Title1.startDate |
GiftedTalented | Is the student in Gifted/Talented programs? Reports Yes when: | Student Information > Program Participation > Gifted Gifted.startDate |
EconomicDisadvantage | Does the student meet the State criteria for classification as having an economic disadvantage?
| FRAM > Eligibility > Eligibility Detail posEligibility.eligibility |
ELL | Is the student an English Language Learner under Title 3? Reports Yes when: | Student Information > Program Participation > English Learners (EL) lep.identifiedDate lep.exitDate |
Homeless | Is the student homeless? Reports Yes when: | Student Information > General > Program Participation > Homeless > Start Date, End Date homeless.startDate |
Section504 | Is the student a qualified individual under Section 504 of the Rehabilitation Act? (Mututally exclusive with IDEA classification.) Reports Yes when: | Student Information > Program Participation > Section 504 Section504.startDate |
VocationalConcentrator | Does the student meet the State criteria for classification as a vocational concentrator? Reports Yes when: | Student Information > Program Participation > Title 1 Title1.startDate |
Immigrant | Does the student meet the State criteria for classification as being an immigrant? Reports Yes when: | Census > People > Person Information > Immigrant identity.immigrant |
NeglectedDelinquent | Is the student participating in programs for neglected, delinquent, or at risk children? Reports Yes when: | Student Information > Program Participation > State Programs > Youth In Care YouthProgram.startDate |
FirstUSEnrollment | The date on which the student was first enrolled in the US school system. Reports the date if present in Date Entered US School | Census > People > Person Information > Date Entered US School identity.dateEnteredUSSchool |
| HighSchlComplStatus | High School Completion status. Reports the code selected in The Diploma Type field on the student Graduation tab. Reports blank when no code is selected. | Student Information > General > Graduation > Diploma Type graduation.diplomaType |
| LimitedEnglish | This code identifies the student’s English Language Learner (ELL) status. Reports from the student’s English Learners (EL) record with the most recent Identified Date <= the current date. Reports Y when: 4a. Service Type not mapped to “ELSS” or “Not a State Reported Type”. 4b. Start Date <= current date4c. End Date is null or >= current date. 4d. Date Refused is null or > current date. Reports O when: 1. Program Status is EL or Exited EL. 2. Program Exit Date is null or >= current date. 3. Parent Declined Date is <= current date OR All EL Service records in this EL record not mapped to “ELSS” or “Not a State Reported Type” that have a Start Date <= current date, and End Date that is null or >= current date have Date Refused <= current date. Reports F when: 1. Program Status is Exited EL. 2. Program Exit Date is < current date. Reports N when: 1. Program Status is Not EL. Reports blank when none of the above apply to the student. | Student Information > Program Participation > English Learners (EL) LEP.identifiedDate LEPService.LEPServiceTypeID |
| ResidentStatus | This code identifies the resident status of all students. Reports the code selected in the Resident Status field on the student’s enrollment. Reports blank when no code is selected. | Student Information > General > Enrollments > State Reporting Fields > Resident Status enrollment.stateAid |
| ELLMonitoredDate (required if LimitedEnglish is “F”) | The last day of the last school year in which the student was identified as Limited English ‘Y’ or ‘O’. (Former ELL student exited an ELL program and entered monitoring). Reports the Program Exit Date from the student’s English Learners (EL) record with the most recent Identified Date < the current date when: 1. Program Status is Exited EL. 2. Program Exit Date is < current date. Reports blank when the reporting criteria are not met. | Student Information > Program Participation > English Learners (EL) > Active El Record > Program Exit Date LEP.exitDate |
| MESAProgram | Identifies the degree of student involvement in the MESA (Math, Engineering, Science Achievement) program during the year. Reports the code selected in the Participation Level field when student has a MESA record where: 1. Start Date <= current date 2. End Date is null or >= current date Reports blank when the reporting criteria are not met. | Student Information > Program Participation > MESA > MESA Detail > Participation Level MESA. participationLevel |
| DistrictOfResidence (required for charter schools) | This is the Regular district number (01-40, 42) of the district in which the PERMANENT address of the student is located. Reports the code selected in the District Of Residence field on the student’s enrollment. Reports blank when no code is selected. | Student Information > General > Enrollments > State Reporting Fields > District Of Residence enrollment.residentDistrict |
| ELLInstructionType (required if Limited English is “Y” or “O”) | The type of ELL instruction the student receives. From the the student’s English Learners (EL) record with the most recent Identified Date <= the current date: Reports the State Service Type mapped to the Service Type selected in the EL Services record with the most recent Start Date <= current date (otherwise: null End Date, latest End Date, most recent record) when State Service Type NOT = “Not a State Reported Type” or “ELSS”. 1. Program Status is EL or Exited EL. 4b. End Date is null or >= current date. 4c. Service Type not mapped to “Not a State Reported Type or “ELSS”. Reports blank when the reporting criteria are not met. | Student Information > Program Participation > English Learners (EL) > Identified Date Student Information > Program Participation > English Learners (EL) > EL Services > Service Type Program Admin > EL Setup > EL Service Types > State Service Type LEP.identifiedDate LEPService.LEPServiceTypeID LEPServiceType.code LEPServiceType.name |
| NCLBSuppServLang | Indicates whether the student received supplemental services in Language Arts, funded out of the LEA’s NCLB Title I Part A allocation, by identifying the approved provider of that service. Reports the code selected in the Language Support field on the NCLB tab when: 1. Start Date <= current date 2. End Date is null or >= current date Reports blank when the reporting criteria are not met. | Student Information > Program Participation > State Programs > NCLB > NCLB Detail > Language Support NCLB. languageSupport |
| NCLBSuppServMath | Indicates whether the student received supplemental services in Mathematics, funded out of the LEA’s NCLB Title I Part A allocation, by identifying the approved provider of that service. Reports the code selected in the Math Support field on the NCLB tab when: 1. Start Date <= current date 2. End Date is null or >= current date Reports blank when the reporting criteria are not met. | Student Information > Program Participation > State Programs > NCLB > NCLB Detail > Math Support NCLB.mathSupport |
| CumulativeGPA | Cumulative GPA to three decimal places as you would provide it to a college when a student requests that a transcript be sent to an admissions office. This calculation is a standard GPA and not a weighted GPA. Reports the student’s transcript-based cumulative GPA. 1. Takes “Unweighted GPA” on Transcript * the “GPA Weight” for each course on the student’s transcript. 1a. When “Unweighted GPA” is null, uses the “GPA Value” * “GPA Weight” for each course on the student’s transcript. 2. Sums the above and divides by the total number of credits (GPA Weight) from across all transcript records. | Unweighted GPA Value on Score Group is posted to Transcript. |
| SpecialEdExitDate | The date the student in special education has completely exited from all special education and related services. Reports the Enrollment > Special Ed Fields > Exit Date +1 day when Exit Date is not null. Otherwise, reports blank. | Student Information > General > Enrollments > Special Ed Fields > Exit Date enrollment.spedExitDate |
| MilitaryChild | Should be marked for all children of military parents as defined by the Interstate Compact on Educational Opportunity for Military Children. Reports Y when the following are true: Student has an active (Start Date <= current date, End Date = null or >= current date) Guardian relationship (Guardian = Checked) that has a Military Connections record with: 1. Start Date <= the current date or is null. | Census > People > Relationships > Guardian Census > People > Military Connections > Military Connections Editor relatedPair.Guardian impactAidEmployment.militaryStatus |
| RefugeeStudent | Identifies the student as having refugee status. Reports Y when: Refugee is checked. Otherwise, reports blank. | Census > People > Person Information > Refugee identity.refugee |
| ReadGradeLevel (conditionally required | Does student read on grade level (mid-year)? Reports the code selected in the Read Grade Level field on the assessment when either the child assessment or parent assessment have the following: 1. Test Type = State Test 2. State Code selection has an Attribute/Dictionary Value = “Mid-Year” 3. State Code selection has an Attribute/Dictionary Standard Code = “ROGL” 4. Student’s assessment Date is in the SIF Zone year When the Read Grade Level field is null: Reports Y when student has a passing score. Reports N when the student does not have a passing score. When the above criteria are not met, reports blank. | Assessment > Test Setup > Tests > Read Grade Level *Reports the latest qualifying assessment assigned to the student. Student Information > General > Assessment > Test Scores > Read Grade Level testScore.nonParticipationReason |
| ReadGradeLevelFall (conditionally required) | Does student read on grade level (fall)? Reports the code selected in the Read Grade Level field on the assessment when either the child assessment or parent assessment have the following: 1. Test Type = State Test 2. State Code selection has an Attribute/Dictionary Value = “Fall” 3. State Code selection has an Attribute/Dictionary Standard Code = “ROGL” 4. Student’s assessment Date is in the SIF Zone year When the Read Grade Level field is null: Reports Y when student has a passing score. Reports N when the student does not have a passing score. When the above criteria are not met, reports blank. | Assessment > Test Setup > Tests > Reason No Assessment Score *Reports the latest qualifying assessment assigned to the student. Student Information > General > Assessment > Test Scores > Read Grade Level testScore.nonParticipationReason |
| ReadGradeLevelSpring (conditionally required) | Does student read on grade level (spring)? Reports the code selected in the Read Grade Level field on the assessment when either the child assessment or parent assessment have the following: 1. Test Type = State Test 2. State Code selection has an Attribute/Dictionary Value = “Spring” 3. State Code selection has an Attribute/Dictionary Standard Code = “ROGL” 4. Student’s assessment Date is in the SIF Zone year When the Read Grade Level field is null: Reports Y when student has a passing score. Reports N when the student does not have a passing score. When the above criteria are not met, reports blank. | Assessment > Test Setup > Tests > Reason No Assessment Score *Reports the latest qualifying assessment assigned to the student. Student Information > General > Assessment > Test Scores > Reason No Assessment testScore.nonParticipationReason |
| BeginYearROGL CompositeScore | Early Literacy Program Beginning-of-year (BOY) reading composite score. Reports score from either the child assessment or parent assessment when: 1. Test Type = State Test 2. State Code selection has an Attribute/Dictionary Value = “Fall” 3. State Code selection has an Attribute/Dictionary Standard Code = “ROGL” 4. Student’s assessment Date is in the SIF Zone year Reports the score based on the following hierarchy: 1. Scale Score 2. Result 3. Raw Score 4. Percentile 5. Percent 6. Normal Curve Equivalent When the above criteria are not met, reports blank. | Assessment > Test Setup > Tests Student Information > General > Test Scores |
| MidYearROGL CompositeScore | Early Literacy Program Middle-of-year (MOY) reading composite score. Reports score from either the child assessment or parent assessment when: 1. Test Type = State Test 2. State Code selection has an Attribute/Dictionary Value = “Mid-Year” 3. State Code selection has an Attribute/Dictionary Standard Code = “ROGL” 4. Student’s assessment Date is in the SIF Zone year Reports the score based on the following hierarchy: 1. Scale Score 2. Result 3. Raw Score 4. Percentile 5. Percent 6. Normal Curve Equivalent When the above criteria are not met, reports blank. | Assessment > Test Setup > Tests Student Information > General > Test Scores |
| EndYearROGL CompositeScore | Early Literacy Program End-of-year (EOY) reading composite score. Reports score from either the child assessment or parent assessment when: 1. Test Type = State Test 2. State Code selection has an Attribute/Dictionary Value = “Spring” 3. State Code selection has an Attribute/Dictionary Standard Code = “ROGL” 4. Student’s assessment Date is in the SIF Zone year Reports the score based on the following hierarchy: 1. Scale Score 2. Result 3. Raw Score 4. Percentile 5. Percent 6. Normal Curve Equivalent When the above criteria are not met, reports blank. | Assessment > Test Setup > Tests Student Information > General > Test Scores |
| ReadingIntervention (required for grades 1-3) | Indicates whether the student was given a reading intervention in the LEA at any time during the school year. | |
| RaceObserved (required) | Reports the code selected in the Reading Intervention field on the Assessment when: 1. Test Type = State Test 2. State Code selection has an Attribute/Dictionary Standard Code = “ROGL” 3. Student’s assessment Date is in the SIF Zone year When no value is selected, or when the criteria are not met, reports blank. | System Admin > Assessment > Test Setup > Reading Intervention Student Info > General > Assessment > Test Scores > Reading Intervention testScore.modification2 |
| ReadingIntervention (required for grades 1-3) | Indicates whether the student was given a reading intervention in the LEA at any time during the school year. Reports the code selected in the Reading Intervention field on the Assessment when: 1. Test Type = State Test 2. State Code selection has an Attribute/Dictionary Standard Code = “ROGL” 3. Student’s assessment Date is in the SIF Zone year When no value is selected, or when the criteria are not met, reports blank. | System Admin > Assessment > Test Setup > Reading Intervention Student Info > General > Assessment > Test Scores > Reading Intervention testScore.modification2 |
| EarlyNumeracyStatusBOY | Reports the code selected in the ."ROGL or ENS Explanation" on the assessment when either the child assessment or parent assessment have the following:
| |
| EarlyNumeracyStatusMOY | Reports the code selected in the "ROGL or ENS Explanation" on the assessment when either the child assessment or parent assessment have the following:
| |
| EarlyNumeracyStatusEOY | Reports the code selected in the "ROGL or ENS Explanation" on the assessment when either the child assessment or parent assessment have the following:
| |
| EarlyNumeracyIntervention | Reports the code selected in the "Reading or Numeracy Intervention" field on the Assessment when:
When no value is selected, or when the criteria are not met, reports blank. | |
| RaceObserved (required) | Indicate if the student’s Race was determined by observer identification. Reports Y when: Race/Ethnicity Determination = 03: Observer Determined. Otherwise, reports N. | Census > People > Demographics > Person Information > Race/Ethnicity > Race/Ethnicity Determination identity. raceEthnicityDetermination |
| AccompaniedStudent (required if Homeless) | This field is to supplement the Homeless field. It cannot be Blank if student is indicated as homeless. Reports the code selected in the Accompanied Student field on the student’s Homeless record with Start Date <= current date and End Date of null or >= current date. Otherwise, reports blank. | Student Information > General > Program Participation > Homeless > Accompanied Student homeless.unaccompaniedYouth |
| ELProficiencyAssessment | Pre-registered for the English Language Proficiency exam? Reports Y when: Student has an assessment assigned with the Date falling inside the current year, where Assessment Type = LID or LPF. Otherwise, reports blank. | Student Info > General > Assessment System Admin > Assessment > Test Setup > Assessment Type Test. assessmentType |
| PassedCivicsExam | Indicates if a student has passed a basic civics exam or an alternative civics exam as defined by Utah Code 53E-4205 or Board Rule R277-7008. Allows ‘Y’ or blank. Student has a state reported (State Reported = checked) Graduation Program with Code = “Civics” that has the Test Requirements criteria met on the student’s Progress tab. When Evaluation Mode = Count of passing tests, the student must have a passing Result on their civics assessment. When Evaluation Mode = One score at or above, the student must have a score that meets the passing criteria set on the Test Requirements Detail. The Graduation Program > Test Requirements > State Code(s) must match the Test Setup > State Test > State Code that the student is assigned. | Student Info > Academic Planning > Programs > Graduation Program Detail > Program Program Admin > Programs > Graduation Programs > Test Requirements Student Info > Academic Planning > Progress Student Information > General > Assessments Assessment > Test Setup programParticipation.programID testRequirement.displayValue testRequirement.evaluationMode testRequirement.minRawScore, testRequirement.minScaleScore, testRequirement.testCount testScore.rawScore or testScore.scaleScore |
| Biliteracy1Level | For the Seal of Biliteracy if they pass a board approved test with an Intermediate-Mid score or a language portfolio. Intermediate-Mid level means a level of language proficiency in terms of speaking, writing, listening in real world situations. See Board Rule R277-499. Reports IM when: 1. State Seal has 1: Seal of Biliteracy selected. 2. Date Earned is the earliest date among biliteracy seal records with “1” selected. When the above criteria are not met, reports blank. | Student Information > General > Graduation > State Seal Information graduationSeal.stateSeal graduationSeal.earnedDate graduationSeal.language |
| Biliteracy1Language | If present, it must be listed in the “Language Codes” section of this document. Reports the language selected in the Language field when Biliteracy1Level reports “IM”. Otherwise, reports blank. | Student Information > General > Graduation > State Seal Information > Language graduationSeal.language |
| Biliteracy2Level | For the Seal of Biliteracy if they pass a board approved test with an Intermediate-Mid score or a language portfolio. Intermediate-Mid level means a level of language proficiency in terms of speaking, writing, listening in real world situations. See Board Rule R277-499. Reports IM when: 1. State Seal has 1: Seal of Biliteracy selected. 2. Date Earned is the 2nd earliest date among biliteracy seal records with “1” selected. When the above criteria are not met, reports blank. | Student Information > General > Graduation > State Seal Information graduationSeal.stateSeal graduationSeal.earnedDate graduationSeal.language |
| Biliteracy2Language | If present, it must be listed in the “Language Codes” section of this document. Reports the language selected in the Language field when Biliteracy2Level reports IM. Otherwise, reports blank. | Student Information > General > Graduation > State Seal Information > Language graduationSeal.language |
| HighSchoolExitDate (required if exited from high school) | The day following the last day of school membership. Reports the enrollment End Date + 1 day from the student’s latest enrollment with a Start Date <= current date in the SIF Zone Year when: 1. Student’s latest enrollment has Grade mapped to Standard Code (SIF code) = 09, 10, 11, or 12. 2. The enrollment has a non-null End Date <= current date. When the latest enrollment End Date is null, reports blank. | Student Information > General > Enrollments > General Enrollment Information > End Date System Administration > Calendar > Calendar > Grade Levels > Grade Level Detail > Standard Code (SIF code) Enrollment.endDate gradeLevel.standardCode |
| WIDAScreenerScore |
| |
| WIDAScreenerDate |
| |
| GeoCode | 1. Reports the entry in Address Info > Address Information > LocationCode when LocationCode NOT = null.
| Address Info > Address Information > Location Code |
StudentSchoolEnrollment
This object contains information related to the student enrollment. The student enrollment information can generally be viewed and modified by navigating to the following:
- Student Information > General > Enrollments
- Student Information > Program Participation
Object Triggering
| Event Type | Requirement |
|---|---|
Add | Adding an enrollment for the student. |
Add | Setting “State Exclude” / “No Show” NOT = checked. |
Change | A change is made on the student’s enrollment in the SIF Zone Scope. |
| Change | A change is made on the student’s enrollment record. |
| Change | A change on the following tabs occur: Enrollment, Foster Care, Early Learning |
| Delete | Deleting a student enrollment. |
| Delete | Setting “State Exclude” / “No Show” = checked.
|
Object Population and Business Rules
The SIF Agent and Zone must have access rights assigned to StudentSchoolEnrollment. |
Student’s enrollment calendar must not be excluded: |
Student has an enrollment in the SIF Zone Year that is not excluded on the SIF Zone Options:
System Administration > Data Interchange > Zones > SIF Zone Options |
| When a student has > 1 enrollment that belongs to the same School, where the enrollment Start Date and End Dates (or null End Date) overlap, and the Service Type of the overlapping enrollment(s) is NOT Primary, only 1 StudentSchoolEnrollment record must be reported, which will be from the Primary enrollment. Note: When an enrollment End Date is entered, End Date +1 is reported, which means that if the subsequent enrollment begins on the End Date +1, the prior End Dated enrollment will overlap the subsequent enrollment, and so this would be considered an overlapping enrollment. |
Object Data Elements
| Data Element | Description and Business Rules | Data Source GUI Path and Database Field |
|---|---|---|
EntryDate | School entry date Reports the enrollment Start Date. | Student Information > Genera > Enrollments > General Enrollment Information > Start Date |
EntryType | Container for EntryType element. | |
EntryType/Code | The state-assigned identifier for this student. Reports “9999” | Student Information > Genera > Enrollments > General Enrollment Information > Local Start Status NCES Code |
GradeLevel | Grade or academic level of student for this enrollment. GradeLevel list | System Administration > Resources > Grade Levels |
GradeLevel/Code | Code representing the grade level. 1. Reports the SIF code in Standard Code (SIF code) when present. 2. When Standard Code (SIF code) is null, reports from the Grade field on enrollment. 3. Otherwise, reports “UN” *Valid NCES Grade Levels: 01, 02, 03, 04, 05, 06, 07, 08, 09, 0K, 10, 11, 12, KG, PK, PG, UN | System Administration > Resources > Grade Levels > Grade Level Editor > Grade Level Detail > Standard Code (SIF code) |
GradeLevel/OtherIdList/ | Code that defines the type of this other Id. Reports “StateProvince” | StateProvince |
GradeLevel/OtherIdList/ OtherCode | enrollment.grade | |
Homeroom | Homeroom for this enrollment. 1. When the student has > 1 homeroom section they are enrolled during the same term or day, reports the RoomInfo RefId from the section with the student's latest section enrollment Start Date. 1a. When the student is enrolled into > 1 homeroom section during the same term or day and > 1 section enrollment has the same Start Date, reports from the section with the latest End Date (or null End Date). Null End Date takes priority. | Scheduling > Courses > Section > Section Editor > Homeroom IdRefType |
Calendar | The calendar assigned to this enrollment. Reports the calendar ID. | System Administrator > Calendar > Calendar > Calendar ID IdRefType |
ExitDate | Day following the last day of school membership. Reports the enrollment End Date + 1 day when End Date is not null. | Student Information > General > Enrollments > General Enrollment Information > End Date |
ExitType | Container for ExitType elements. Reports when Local End Status is not null. | Student Information > General > Enrollments > General Enrollment Information > Local End Status |
ExitType/Code | Code indicating the closure status for this enrollment. Reports “9999” | NCES Code |
ExitType/OtherCodeList/ | “StateProvince” Reports “StateProvince”. | |
ExitType/OtherCodeList/ OtherCode | School exit code Reports the State End Status Code (Mapping) code associated with the selection in the enrollment Local End Status | Student Information > General > Enrollments > General Enrollment Information > Local End Status State Code |
FTPT | An indication of whether the student is enrolled full time or part time. When Grade Code is A or C, then "PartTime". | System Administration > Calendar > Grade Levels > Grade Level Editor > Grade Code FullTime |
| PartTimeHomeSchool | Part-time indicator Reports “H” when: Student’s Local Start Status is mapped to 01. Reports “P” when: Student’s Local Start Status is mapped to 02. Reports “S” when: Student’s Local Start Status is mapped to 03. Reports null when none of the above apply. | Student Information > General > Enrollments> General Enrollment Information > Local Start Status System Administration > Enrollment > Start Status Type > End Status Type Editor > End Status Type Detail > State Start Status Code(Mapping) enrollment.startStatus |
| KindergartenType (required when student in KG) | Reports the code selected in the Kindergarten Course Type field from the student’s earliest instructional period course in their period schedule during this enrollment when their enrollment grade is mapped to a State Grade Level Code of 00: Kindergarten. When Kindergarten Course Type is null from the qualifying course, reports null. | Scheduling > Courses > Course > Course Information > Kindergarten Course Type course.programType |
| Title1Math | Title I Targeted Assistance Program - Additional Math services provided. Reports “Y” when:
| Student Information > Program Participation > Title 1 > Supplemental Services title1.startDate title1.endDate title1. title1Services |
| Title1ELA | Title I Targeted Assistance Program - Additional ELA services provided. Reports “Y” when:
| Student Information > Program Participation > Title 1 > Supplemental Services title1.startDate title1.endDate title1. title1Services |
| Title1Science | Title I Targeted Assistance Program - Additional Science services provided. Reports “Y” when:
| Student Information > Program Participation > Title 1 > Supplemental Services title1.startDate title1.endDate title1. title1Services |
| Title1Health | Title I Targeted Assistance Program - Student received Health/Dental assistance supported by Title I funds. Reports “Y” when:
| Student Information > Program Participation > Title 1 > Supplemental Services title1.startDate title1.endDate title1. title1Services |
| Title1AcademicGuidance | Title I Targeted Assistance Program - Student received Academic guidance assistance supported by Title I funds. Reports “Y” when:
| Student Information > Program Participation > Title 1 > Supplemental Services title1.startDate title1.endDate title1. title1Services |
| Title1SocialStudies | Title I Targeted Assistance Program - Additional Social Studies services provided. Reports “Y” when:
| Student Information > Program Participation > Title 1 > Supplemental Services title1.startDate title1.endDate title1. title1Services |
| Title1Vocational | Title I Targeted Assistance Program - Student received vocational/career services supported by Title I funds. Reports “Y” when:
| Student Information > Program Participation > Title 1 > Supplemental Services title1.startDate title1.endDate title1. title1Services |
| Title1ParaPros | Student received services from SB81 funding of Title I ParaPros. Reports “Y” when:
| Student Information > Program Participation > Title 1 > Supplemental Services title1.startDate title1.endDate title1. title1Services |
| Intergenerational PovertyGrant | Student was a direct beneficiary of services supported by Intergenerational Poverty Grant. Reports “Y” when:
| Student Information > Program Participation > State Programs > Other Supplemental Services > Intergenerational Poverty Grant supplementalServices.startDate supplementalServices.endDate supplementalServices.supplementalService1 |
| AfterSchool21CCLC | Student is a participant of Afterschool Program on or off site supported by 21st Century Community Learning Center Grant - 21 CCLC Reports “Y” when:
| Student Information > Program Participation > State Programs > Other Supplemental Services > After School 21st Century Grant supplementalServices. startDate supplementalServices. endDate supplementalServices.supplementalService2 |
| ELStateSoftware | Student participated in State Provided EL Software. Reports “Y” when: Student's EL record with the latest (most recent) Identified Date that is <= the current date has an EL Service record with:
Student’s enrollment grade is mapped to a Standard Code (SIF code) NOT = KG, 01, 02, or 03 Otherwise, reports null. | Student Information > Program Participation > English Learners (EL) > Identified Date System Administration > Program Admin > English Learners (EL) > EL Service Types System Administrator > Calendar > Calendar > Grade Levels > Grade Level Editor > Standard Code (SIF code) LEP.identifiedDate LEPService.LEPServiceTypeID gradeLevel.StandardCode |
| EarlyChildhoodReading StateSoftware | Student participated in State Provided Early Childhood Reading Software. Reports “Y” when: Student's EL record with the latest (most recent) Identified Date that is <= the current date has an EL Service record with:
Student’s enrollment grade is mapped to a Standard Code (SIF code) of KG, 01, 02, or 03 Otherwise, reports null. | Student Information > Program Participation > English Learners (EL) > Identified Date System Administration > Program Admin > English Learners (EL) > EL Service Types System Administrator > Calendar > Calendar > Grade Levels > Grade Level Editor > Standard Code (SIF code) LEP.identifiedDate LEPService.LEPServiceTypeID gradeLevel.StandardCode |
| EnrollmentValidation Type | For each course the student has been enrolled in the enrollment calendar on and between the enrollment Start Date and enrollment End Date (or calendar End Date when enrollment End Date is null), report based on the Code selected in the Attendance Type field:
| Scheduling > Courses > Course > Course Info Course.wblCourseType |
StudentSectionEnrollment
This object contains information related to the student’s enrollment in a section.
- Scheduling > Courses > Section
Object Triggering
| Event Type | Requirement |
|---|---|
Add/Delete | Checking/unchecking course.active. |
Add/Delete | The course Active checkbox is modified |
Change | Any change made to the roster batch edit for the section.
|
Object Population and Business Rules
The SIF Agent and Zone must have access rights assigned to StudentSectionEnrollment. |
Student is assigned to the section in the SIF Zone Year and Calendar. |
Course does not have “State Exclude” set to checked. |
Student must have an enrollment associated with a calendar that is not excluded: |
Student must have an enrollment in the Zone Scope that is not excluded on the SIF Zone Options: |
Object Data Elements
| Data Element | Description and Business Rules | Data Source GUI Path and Database Field |
|---|---|---|
| /@RefId | The Id (GUID) that uniquely identifies this StudentSectionEnrollment entity. This attribute is generated by Infinite Campus. | N/A |
| /@SectionInfoRefId | The Id (GUID) of the section in which this student is enrolled. This attribute is generated by Infinite Campus. | roster.sectionId |
| /@StudentPersonalRefId | The Id (GUID) of the student to whom the enrollment information applies. This attribute is generated by Infinite Campus. | roster.personId |
| /@SchoolYear | School year for which the information is applicable, expressed as the four-digit year in which the school year ends (e.g. 2007 for the 2006-07 school year).This attribute is generated by Infinite Campus. | calendar.endYear |
| EntryDate (required) | Course (Section) Entry Date Reports the student’s section enrollment Start Date. | Student Information > General > Schedule or System Administration > Calendar > Calendar > TermWhen Roster Start Date is null, reports the earliest term start date for the section. roster.startDate When roster.startDate is null, term.startDate term.startDate |
| ExitDate (required) | Course Exit Date Reports the student’s section enrollment End Date. | Student Information > General > Schedule or System Administration > Calendar > Calendar > Term When Roster End Date is null, reports the latest term end date for the section. roster.endDate When roster.endDate I null,Term.endDate |
| CreditsAttempted (required) | Number of HS credits attempted Reports sum of the credit field(s) in state reported grading tasks assigned to the course. When 0, or when no State Reported grading tasks exist, reports “0.000”. | Scheduling > Courses > Course > Grading Tasks > Course Grading Task Detail > Credit Grading & Standards > Grading Tasks > Grading Task Detail > State Reported v_CourseGradingTask.credit (pulls from GradingTaskCredit.credit) gradingTask.stateReported |
| CreditsAttempted/@Type (required) | The type of credit. Reports “0585” (Carnegie unit) | N/A |
| GradeEarned | The grade earned for the course.
| Grading & Standards > Score Groups & Rubrics > Score Group List Items Detail > Score gradingScore.score gradingTask.stateReported gradingTask.isFinal |
| CourseMembership | Actual Membership (CTE)
| Scheduling > Courses > Course Information > State Code Scheduling > Courses > Section > Section Editor > Section Schedule Placement Scheduling > Courses > Section > Roster Batch Edit > Start Date, End Date section.altSchoolCode course.specialCode |
| ConcurrEnrolled | Student attempting college credit indicator. Reports “Y” when either of the following scenarios are true: 1. Section has Where Taught Campus field NOT = blank 2. When Where Taught Campus is blank on section, the course must have Where Taught Campus field NOT = blank. Otherwise, reports blank. | Scheduling > Courses > Section > Section Editor > Where Taught Campus Scheduling > Courses > Course Information > Where Taught Campus section.distanceCode course.distanceCode |
| CreditsEarned | Number of HS credits earned Reports the sum of all State Reported grading tasks for which the student received a passing score on the grading task’s Score Group. | Scheduling > Courses > Section > Grading By Task > Score Grading & Standards > Score Group & Rubrics > Sore Group List Items Detail > Passing Score Scheduling > Courses > Grading Tasks > Course Grading Task Detail > Credit scoreListItem.passingScore, v_courseGradingTask.credit (Pulls from GradingTaskCredit.credit) |
TermInfo
This object provides information about a term; i.e., a reportable period of time
Object Triggering
Event Type | Requirement |
|---|---|
| Add | A term is added |
| Change | A term is changed |
| Delete | A term is deleted |
Object Population and Business Rules
| The SIF Agent and Zone must have access rights assigned to TermInfo |
| The district must belong to the same calendar and year assigned to the SIF Zone in order to populate. |
Object Data Elements
| Data Element | Description and Business Rules | GUI Path and Database Field |
|---|---|---|
| @RefId | The Id (GUID) that uniquely identifies this TermInfo entity. | Term.termID, District.districtGUID |
| @SchoolInfoRefId | The Id (GUID) that identifies the school where the term is used. | |
| @SchoolYear | School year for which the information is applicable, expressed as the four-digit year in which the school year ends (e.g., 2007 for the 2006-07 school year). | |
| StartDate | Starting date of the term. | System Administration > Calendar > Calendar > Term Term.StartDate |
| EndDate | Ending date of the term (CCYYMMDD). | System Administration > Calendar > Calendar > Term Term.endDate |
| Description | Text-based description of the term. | System Administration > Calendar > Calendar > Term Term.name |
| RelativeDuration | Portion of the school year represented by this term, expressed in decimal form precise to 4 decimal places (e.g., 0.1333). Optional do not report | |
| TermCode | Locally-defined code. | System Administration > Calendar > Calendar > Term TermSchedule.name |
| Track | The name, description, or code of the track that contains this term. This is used when there are multiple tracks within a school. For instance, kindergarten commonly has a different set of terms than other grades within the school. | |
| TermSpan | ||
| TermSpan/Code | Code for session type Calculated value based upon COUNT(terms) | Calculated value based upon COUNT(terms) |
| TermSpan/OtherCodeList | ||
| TermSpan/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. | |
| TermSpan/OtherCodeList/ OtherCode/@Codeset | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | |
| MarkingTerm | Does this TermInfo represent a marking period? Optional do not report | |
| SchedulingTerm | Does this TermInfo represent a scheduling term? Optional do not report | |
| AttendanceTerm | Does this TermInfo represent an attendance term? Optional do not report |
FAQ
Does Campus use a single SIF Agent or multiple agents for differing types of data?
A: Campus provides a fully functioning ZIS which allows multiple agents to be connected and can communicate will all of them.
Is Any Special Software/Hardware Required to Host the Zone Integration Server (ZIS)?
A: No. Infinite Campus provides every customer with a free embedded ZIS.
How Does the Campus Data Integration Server (DIS) compare to the standard ZIS?
A: DIS is how Campus sends XML messages for different purposes (State Edition, Food Service, National Records Exchange). SIF is a subset of DIS. Campus' ZIS is SIF certified and we were the first company to receive SIF 2.0 ZIS certification.
Can I Modify and Customize Campus SIF Agent?
A: No. The SIF Agent is hard coded and does not allow for modification or customization.
What SIF Agents is Campus able to Connect With?
A: Campus can establish a SIF connection with every SIF agent that exists. Campus just needs to know which objects should to be sent to the SIF vendor.
Is There a Way to Send Only Certain Elements of a SIF Object?
A: No. When Campus sends information for a SIF object, all elements within that object are sent. There is no way to specify which elements within an object should be sent.
If a Student's Enrollment Record is Ended, Will SIF Messages Still be Sent for this Student?
A: Yes. As long as the enrollment record is in the zone it will send a SIF message that will include the Entry Date and Exit Date.
