SIF (Utah)

Last Modified on 10/22/2022 10:39 am CDT

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:

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 TypeRequirement

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 LabelDescription and Business RulesData 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
 (required)

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
Date

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
Date
 (required)

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
Minutes

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/
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, 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 TypeRequirement

ADD

A Behavior Event associated with the incident where State Event Code is not null.
  • If State Event Code is null, do not report

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:
 System Administration > Calendar > Calendar > Exclude from SIF Exchange

Student must have an enrollment in the Zone Scope that is not excluded on the SIF Zone Options:
 
 System Administration > Data Interchange > Zones > SIF Zone Options
 Exclude All Secondary Enrollments
 Exclude No Show Enrollments
 Exclude All State Exclude Enrollments

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 ElementDescription and Business RulesData 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
 (required)

Incident number


The behavior incident Id.


IncidentDate
 (required)

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"
 
 The time of the incident.

behaviorIncident.timeStamp

IncidentLocation

The locally-defined identifier or description of the location where the incident occurred.


Type = "9997"
 
 When Location is null, reports "Unknown Location".

 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/
Name Type/LastName

The last name of the Submitted By user.

 identity.lastName

IncidentReporter/
Name Type/FirstName

The first name of the Submitted By user.

 identity.firstName

IncidentReporter/
SIF_RefID SIF_RefObject

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".
 
Otherwise, reports blank.

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.
 
= "04"


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
 (required)

Was the student injured?


Reports based on the injury selected in the Offender record when exists.
 
 When 1: No Injury, or blank, “3065”.
 When 2: Minor Injury, “3963”.
 When 3: Major Injury, “3064”.
 when 4: Serious Bodily Injury, “3579”.

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/
Action/Code
 (required)

When Resolution Type is mapped to:

  • 1: In-School Suspension, “3100”.
  • 2: Out-of-School Suspension, and when Additional Actions > Services Offered OR SPED Service Offered is indicated, “3101”. When no services offered, “3102”.
  • 3: Expulsion, and when Additional Actions > Services Offere OR SPED Service Offered is indicated, “3086”.
    When no services offered, “3087”.
  • 4: Referred to Court, “3089”.
  • 5: Hearing Officer Removal, “3158”

Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Resolution Details > Reolution Type, Additional actions
 
 Behavior > Admin > Resolution Types > State Resolution Code (Mapping)


Behavior.stateResCode


BehaviorResolution.
additionalActions

Offender/ActionList/
Action/StartDate

The date on which the disciplinary action begins.


Reports from the Resolution Start Date.
 
When Start Date is null, reports based on the current date.
 

Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Resolution Details > Reolution Start Date


behaviorResolution.timeStamp

Offender/ActionList/
Action/EndDate

The date through which the disciplinary action is in effect, inclusive.


Reports from the Resolution End Date.
 
When End Date is null, reports based on the current date.

Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Resolution Details > Reolution End Date


behaviorResolution.timeStamp

Offender/ActionList/
Action/Duration
 (required)

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.
schoolDaysDuration, 


behaviorRole.demerits

Offender/ActionList/Action/
ZeroTolerance

Identifies whether or not this action taken against a student was imposed as a consequence of state or local zero tolerance policies.
 
Reports "No".


Offender/ActionList/Action/
FullYearExpulsion

Identifies whether or not the action involved an expulsion with or without services for a period of one full year (i.e., 365 days).
 
Reports "No" 


Offender/ActionList/Action/
ShortenedExpulsion

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.
 
Reports "No"


Offender/ActionList/Action/
PoliceNotification
 (required)

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.
 
Otherwise, reports “No”.

Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Resolution Details > Additional Actions


behaviorResolution.
additionalActions

Offender/ActionList/
Action/Arrest

Identifies whether or not the offender was arrested.


Reports “No”.


Offender/ActionList/Action/
AlternativeEducation
 (required)

Alternative placement?


Reports “Yes” when Additional actions field has 1: Alternative Placement selected.
 
 Otherwise, reports “No”.

Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Resolution Details > Additional Actions


behaviorResolution.
additionalActions

Offender/WeaponTypeList

List of weapons involved in the incident used by the offender.


Container element for weapons associated with the Offender.


Offender/WeaponTypeList/
WeaponType

Identifies the type of weapon used by the offender during an incident.


Repeats for each weapon.

  • When 1, “0011”
  • When 2, “0012”
  • When 3, “0012”
  • When 4, “0013"
  • When 5, “0020”
  • When 6, “0040”
  • When 7, “0050”
  • When 8, “0097”
  • Otherwise, or when no Weapon, "0098"

Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Weapon


behaviorWeapon.
weaponType

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.
 
 When 1: No Injury, or blank, “3065”.
 When 2: Minor Injury, “3963”.
 When 3: Major Injury, “3064”.
 when 4: Serious Bodily Injury, “3579”.

Behavior > Behavior Management > Incident Management Editor > Event and Participant Details > Participant(s) Details > Injury


 behaviorRole.injury

IncidentDescription
 (required)

Incident description


Reports the value entered in Context Description when not null.
 When the Context field is null, reports the value entered into the Details field on the Incident up to 250 characters.

Behavior > Behavior Management > Incident Management Editor > Incident Detail Information > Context, Details


behaviorIncident.
contextDescription, 


behaviorIndex.description

PhysicalArrestFlagIndicates if the incident resulted in a physical arrest.
  1. When checked, report Y
  2. When not checked, report N
Behavior > Behavior Management > Resolution Details > Physical Arrest

BehaviorResolution.arrest
SearchAndSeizureFlagIndicates if the incident resulted in a search and seizure.
  1. When checked, report Y
  2. When not checked, report N
Behavior > Behavior Management > Resolution Details > Search and Seizure

BehaviorResolution.
auxiliaryCode
CriminalCitationFlagIndicates if the incident resulted in a criminal citation.
  1. When checked, report Y
  2. When not checked, report N
Behavior > Behavior Management > Resolution Details > Criminal Citation

BehaviorResolution.
lawEnforcement
NonCriminalCitationFlagIndicates if the incident resulted in a non-criminal citation.
  1. When checked, report Y
  2. When not checked, report N
Behavior > Behavior Management > Resolution Details > Non Criminal Citation

BehaviorResolution.
inconsistent.CodeOfConduct
RetaliationIndicates if the incident was a retaliation or an alleged retaliation as defined in Utah Code.
  1. When checked, report Y
  2. When not checked, report N
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 TypeRequirement

Change

A Save is made on the District Detail tab.
 System Administration > Resources > District Information > District Detail


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 ElementDescription and Business RulesData Source GUI Path and Database Field

LocalId

The locally-assigned identifier for this LEA.

Generated by Infinite Campus.

district.districtId

StateProvinceId
 (required)

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
 (required)

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/
PublishInDirectory

Indicates whether or not this LEA contact's information should be published in a directory of LEA information.


LEAContactList/LEAContact/
ContactInfo

Common element used to supply information for a contact person at a school, LEA, or other institution.


LEAContactList/LEAContact/
ContactInfo/Name Type

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
/ContactInfo/Name/LastName

The last name.

System Administration > Resources > District Information > District Detail > District Contact Last Name


district.contactLastName

LEAContactList/LEAContact/
ContactInfo/Name/FirstName

The first name.

System Administration > Resources > District Information > District Detail > District Contact First Name


district.contactFirstName

LEAContactList/LEAContact/
ContactInfo/Name/FullName

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/
ContactInfo/PositionTitle

The contact person's position title.

System Administration > Resources > District Information > District Detail > District Contact Title


district.contactTitle

LEAContactList/LEAContact/
ContactInfo/EmailList

List of Email elements.


LEAContactList/LEAContact/
ContactInfo/EmailList/Email Type

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/
ContactInfo/PhoneNumberList

Lists phone numbers associated with an entity.


LEAContactList/LEAContact/ContactInfo/
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.

System Administration > Resources > District Information > District Detail > Phone


If district.phone is entered.


If district.fax is entered.


System Administration > Resources > District Information > District Detail > Fax

LEAContactList/LEAContact/ContactInfo/
PhoneNumberList/PhoneNumber Type/Number

Phone number.

System Administration > Resources > District Information > District Detail > Phone


district.phone
 
 System Administration > Resources > District Information > District Detail > Fax


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
 
Type = "0096"


If district.phone is entered.

System Administration > Resources > District Information > District Detail > Fax
 
 Type = "2364"


 If district.fax is entered.

LEAContactList/PhoneNumber
Type/Number

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
 
 System Administration > Resources > District Information > District Detail > Fax


district.fax

LEAContactList/AddressList

A list of Address elements.


LEAContactList/
AddressList/Address Type

Code that defines the location of the address. Note: A subset of specific valid values for each instance in a data object may be listed in that object.

System Administration > Resources > District Information > District Detail > Address
 
Type = "0123"


If district.address is entered.
 
System Administration > Resources > District Information > District Detail > Physical Address
 
 Type = "0765"


If district.
physicalAddress is entered.

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".
 
If district.
physicalAddress is entered, Type = "0765".

LEAContactList/AddressList/
Address Type/City

The city part of the address.

System Administration > Resources > District Information > District Detail > City


If district.address is entered, district.city.


If district.
physicalAddress is entered, district.physicalCity.

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 TypeRequirement

Add

A course is created with the following:

  1. Calendar > Exclude from SIF Exchange is not checked
  2. Course > Active is checked
  3. Course > State Exclude is not checked

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.
 Scheduling > Courses > Course > Course Information > Active

Course must not have State Exclude checked to report.
 Scheduling > Courses > Course > Course Information > State Exclude

Object Data Elements

Data ElementDescription and Business LogicData Source GUI Path and Database Field

CourseCode
 (required)

School-defined local code for the course.


Reports the course Number.

Scheduling > Courses > Course > Course Information > Number


course.number

StateCourseCode
 (required)

State-defined standard course code used to report information about courses.


Reports the value in the State Code field on the course.


When State Code is null, this element is not reported.

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 > NCES Data > SCED Subject Area


course.scedSubjectArea

SubjectAreaList/SubjectArea
/OtherCodeList

Requires an entry in Course.type to report.


SubjectAreaList/SubjectArea/
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.


Reports the Code selected in Course.type.

Scheduling > Courses > Course Information > Type


course.type

SubjectAreaList/SubjectArea/
OtherCodeList/OtherCode/@Codeset

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.


Reports "StateProvince"


CourseTitle
 (required)

Title of the course.


Reports the course name.

Scheduling > Courses > Course Information > Name


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.

Reports the code selected in the Term Code Override field when not null.
 
 When the Term Code Override field is null:		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

AddA non-excluded school is added in the SIF Zone Year.
ChangeAny field on System Administration > Resources > School > School Detail is changed and saved.
DeleteA 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 ElementDescription and Business RulesData Source GUI Path and Database Field
/@RefIdThe 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
 (required)

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
 (required)

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/
PublishInDirectory

Indicates whether or not this school contact's information should be published in a directory of school information.


Reports "Yes".


SchoolContactList/
SchoolContact/ContactInfo

Common element used to supply information for a contact person at a school, LEA, or other institution.


SchoolContactList/SchoolContact/
ContactInfo/Name

The name of the contact person. Note that Name is redefined here to allow for LastName and FirstName to be omitted if they cannot be provided; when omitted, FullName must have a value.


SchoolContactList/SchoolContact/
ContactInfo/Name/@Type

Code that specifies what type of name this is.


Name Type="04"


SchoolContactList/SchoolContact/
ContactInfo/Name/LastName

The last name.

System Administration > Resources > School > Principal Name


School.principalName, parse from LEFT

SchoolContactList/SchoolContact/
ContactInfo/Name/FirstName

The first name.

System Administration > Resources > School > Principal Name


School.principalName, parse from RIGHT

SchoolContactList/SchoolContact/
ContactInfo/Name/FullName

The full name.

 System Administration > Resources > School > Principal Name


 School.principalName

SchoolContactList/SchoolContact/
ContactInfo/PositionTitle

The contact person's position title.

System Administration > Resources > School > Principal Title


School.principalTitle

SchoolContactList/SchoolContact/
ContactInfo/EmailList

List of Email elements.


SchoolContactList/SchoolContact/
ContactInfo/EmailList/Email

This element represents an e-mail address of one of a number of types and occurs in objects such as StudentPersonal, StaffPersonal, StudentContact, etc.

System Administration > Resources > School > Principal Email


School.principalEmail

SchoolContactList/SchoolContact/
ContactInfo/EmailList/@Type

This attribute specifies the type of e-mail address.


 Type="Primary"


SchoolContactList/SchoolContact/
ContactInfo/PhoneNumberList

Lists phone numbers associated with an entity.

 System Administration > Resources > School > Phone Number, Fax

SchoolContactList/SchoolContact/
ContactInfo/PhoneNumberList/PhoneNumber

This element represents a phone number and occurs within objects such as StudentPersonal, StaffPersonal, etc.


SchoolContactList/SchoolContact/ContactInfo/
PhoneNumberList/PhoneNumber/@Type

Code that specifies what type of phone number this is.


Where Type “0096” = School Phone Number

Where Type “2364” = School Fax Number


SchoolContactList/SchoolContact/
ContactInfo/PhoneNumberList/
PhoneNumber/Number

Phone number or fax number.


When School Phone Number NOT = Null


When School Fax Number NOT = Null

System Administration > Resources > School > School Phone Number


School.phone


System Administration > Resources > School > Fax


School.fax

AddressList
 (required)

The school's addresses.


AddressList/Address
 (required)

This element contains address data.


AddressList/Address/@Type
 (required)

Code that defines the location of the address.


When Address NOT = Null, Type="0123"

When Physical Address NOT = NULL, Type="0765"
 (required)


AddressList/Address/Street
 (required)

The street element is a complex element and breaks the street down into several parts.


AddressList/Address/Street/Line1
 (required)

Address line 1.

System Administration > Resources > School > Address, Physical Address


School.address

School.physicalAddress

AddressList/Address/City
 (required)

The city part of the address.

System Administration > Resources > School > City, Physical City

AddressList/Address/StateProvince
 (required)

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
 (required)

The ZIP/postal code.

System Administration > Resources > School > Zip, Physical Zip


School.zip

School.physicalZip

PhoneNumberList
 (required)

The school's phone numbers.


When School Phone Number NOT = Null, reports the PhoneNumberList


PhoneNumberList/PhoneNumber
 (required)

This element represents a phone number and occurs within objects such as StudentPersonal, StaffPersonal, etc.


PhoneNumberList/PhoneNumber/@Type
 (required)

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
 (required)

Phone number.

System Administration > Resources > School > Phone


school.phone

SessionType
 (required)

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.
 
 Reports “0829” (Trimester) when the primary term schedule has 3 terms.
 
 Reports “0827” (Year Round) when the primary term schedule has 1 term.
 
 Reports “9999” (Other) when the primary term schedule does not have 1, 2, or 3 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:

  1. Targeted Assistance Eligible - No Program
  2. Targeted Assistance Program

Reports "SchoolWide" when Title 1 is any of the following:

  1. Schoolwide Eligible - Targeted Assistance
  2. Schoolwide Eligible - No Program
  3. Schoolwide Program

Otherwise, reports "NA"
 
 Reports from most recent School History record with Effective Date <= current date.

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 TypeRequirement

Add

A section is created, and the following are true:

  1. Calendar > Exclude from SIF Exchange is not checked
  2. Course > Active is checked
  3. Course > State Exclude is not checked

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
 Scheduling > Courses > Section > 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.
 Scheduling > Courses > Course > Course Information > Active

The associated course must not have State Exclude checked.
 Scheduling > Courses > Course > Course Information > State Exclude

Object Data Elements

Data ElementBusiness Requirements and RulesData 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/
@TermInfoRefId

The Id (GUID) of the term to which this schedule information relates.

System Administration > Calendar > Calendar > Terms


IdRefType

ScheduleInfoList/
ScheduleInfo/TeacherList


List

ScheduleInfoList/ScheduleInfo/
TeacherList/StaffPersonalRefId

The Id (GUID) of the teacher.

Census > People > Demographics


IdRefType

ScheduleInfoList/ScheduleInfo/
SectionRoomList


List

ScheduleInfoList/ScheduleInfo/
SectionRoomList/RoomInfoRefId

The Id (GUID) of the room in which this section is taught.

System Administration > Resources > Resources > Rooms


IdRefType

ScheduleInfoList/ScheduleInfo/
MeetingTimeList

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.

List

ScheduleInfoList/ScheduleInfo/
MeetingTimeList/MeetingTime

Time(s) this section meets.


ScheduleInfoList/ScheduleInfo/
MeetingTimeList/MeetingTime/
TimeTableDay
 (required)

This is a two-digit field containing the class period.

Scheduling > Courses > Course > Section > Section Schedule Placement

ScheduleInfoList/ScheduleInfo/
MeetingTimeList/MeetingTime/
TimeTablePeriod
 (required)

The period within the day when this section takes place.

Scheduling > Courses > Course > Section > Section Schedule Placement

MediumOfInstruction
 (required)

Medium through which the student receives instructional communication from the teacher.

Scheduling > Courses > Course > Section > Section Editor > Medium Of Instruction

MediumOfInstruction/Code
 (required)

Code representing the medium of instruction.

Scheduling > Courses > Course > Section > Section Editor > Medium Of Instruction

MediumOfInstruction/
OtherCodeList
 (required)

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
 (required)

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/
OtherCode/@Codeset
 (required)

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.


LocationOfInstruction
 (required for concurrent sections)

Description of the location in which the section is taught.

Scheduling > Courses > Course > Section > Section Editor > Where Taught Campus
 
 Scheduling > Courses > Course > Where Taught Campus

LocationOfInstruction/Code
 (required for concurrent sections)

Code representing the location of instruction.

Scheduling > Courses > Course > Section > Section Editor > Where Taught Campus
 
Scheduling > Courses > Course > Where Taught Campus

SummerSchool

Is this a summer school assignment?

System Administration > Calendar > Calendar > Summer School

CourseSectionCode
 (required)

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
 
 Scheduling > Course > Section > 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)

Reports the Standard Code in the Attribute/Dictionary aligned with the selection in the Where Taught field on the section when Where Taught is not null.


When Where Taught is null:
  1. Reports the Standard Code aligned with the selection in College Granting Credit on section when not null Where Taught Campus on section is not = H.

  2. When Where Taught Campus on section = H:

    1. Reports the Staff State ID for the staff person assigned to the section based on 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. Primary Teacher

        2. Teacher

        3. Section Staff

        4. Earliest Staff History ID

When both the Where Taught and College Granting Credit fields on section are null, reports the Standard Code aligned with the selection in the Where Taught field on course when not null.

When Where Taught field on the course is null, reports the Standard Code aligned with the selection in the College Granting Credit field on course when Where Taught Campus on course is not = H.


When Where Taught Campus on course = H:

  1. Reports the Staff State ID for the staff person assigned to the section based on 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. Primary Teacher

      2. Teacher

      3. Section Staff

      4. Earliest Staff History ID


When Where Taught fields and College Granting Credit fields on both the section and course are null or don’t have a Standard Code aligned with the selection, reports the Staff State ID for the staff person assigned to the section based on 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. Primary Teacher

    2. Teacher

    3. Section Staff

    4. Earliest Staff History ID

Scheduling > Courses > Section > Section Editor > Where Taught
 
Scheduling > Courses > Section > Section Editor > College Granting Credit
 
Scheduling > Courses > Course Information > 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
Teacher2IDWhen the Teacher1ID field is populating from the section's assigned staff, reports the Staff State ID for the 2nd staff person, 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. Primary Teacher

    2. Teacher

    3. Section Staff

    4. Earliest Staff History ID

Census > People > Demographics > Person Identifiers > Staff State ID
 
Scheduling > Courses > Section > Staff History > Start Date, End Date

person.staffStateId
sectionStaffHistory.startDate
sectionStaffHistory.endDate
Teacher3IDWhen the Teacher1ID field is populating from the section's assigned staff, reports the Staff State ID for the 3nd staff person, 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. Primary Teacher

    2. Teacher

    3. Section Staff

    4. Earliest Staff History ID

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.
 Student Information > General > Enrollments > State Reporting Fields > State Exclude

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:
 System Administration > Calendar > Calendar > Exclude from SIF Exchange

Student has a 9-12 grade enrollment in the Zone Scope that is not excluded on the SIF Zone Options:
 
 System Administration > Data Interchange > Zones > SIF Zone Options
 Exclude All Secondary Enrollments
 Exclude No Show Enrollments
 Exclude All State Exclude Enrollments

Object Data Elements

Data ElementDescription and Business RulesData Source GUI Path and Database Field

ReportingDate

The date this record was prepared.


Reports the current date.

xs:date

StudentSchoolEnrollmentData/
@SchoolAttendedRefId

Collects elements of interest from StudentSchoolEnrollment.


Campus generated RefId.

GUID based on school.schoolID

StudentSchoolEnrollmentData/GradeLevel

Grade or academic level.


StudentSchoolEnrollmentData/
GradeLevel/Code

Code representing the grade level.


Reports the Standard Code (SIF code) mapped to the student’s grade level.


 System Administration > Caendar > Grade Levels > Grade Level Detail > Standard Code (SIF code)
 
 Student Information > General > Enrollments > General Enrollment Information > Grade
 
 

StudentSchoolEnrollmentData/GradeLevel/
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.


The student’s enrollment grade.

Student Information > General > Enrollments > General Enrollment Information > Grade


gradeLevel.name

StudentSchoolEnrollmentData/GradeLevel
/OtherCodeList/OtherCode Codeset

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/
SchoolAttended RefId

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/
SchoolAttended/LEAInfoData

Collects elements of interest from LEAInfo.


SchoolAttendanceHistory/SchoolAttended/
LEAInfoData/StateProvinceId

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/
LEAInfoData/LEAName

Name of Local Education Agency.


The name of the district.

System Administration > Resources > District Information > Name


district.name

SchoolAttendanceHistory/
SchoolAttended/SchoolInfoData

Collects elements of interest from SchoolInfo.


SchoolAttendanceHistory/SchoolAttended/
SchoolInfoData/LocalId

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/
SchoolInfoData/StateProvinceId

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/
SchoolInfoData/SchoolName
 (required)

The name of the school.


The School Name for where the student was enrolled.


 Student Information > General > Transcript > Transcript Course Editor > School Name
 
 

SchoolAttendanceHistory/SchoolAttended/
SchoolInfoData/SchoolContactList

A list of contact persons associated with a school.o


SchoolAttendanceHistory/SchoolAttended/
SchoolInfoData/SchoolContactList/
SchoolContact

Information on contact persons for this school.


SchoolAttendanceHistory/
SchoolAttended/SchoolInfoData/
SchoolContactList/
SchoolContact/ContactInfo

Common element used to supply information for a contact person at a school, LEA, or other institution.


SchoolAttendanceHistory/SchoolAttended/
SchoolInfoData/
SchoolContactList/SchoolContact/
ContactInfo/Name Type

The name of the contact person. Code that specifies what type of name this is.


SchoolAttendanceHistory/
SchoolAttended/SchoolInfoData/
SchoolContactList/SchoolContact/
ContactInfo/Name/LastName

The last name.


SchoolAttendanceHistory/
SchoolAttended/SchoolInfoData/
SchoolContactList/SchoolContact/
ContactInfo/Name/FirstName

The first name.


SchoolAttendanceHistory/
SchoolAttended/SchoolInfoData/
SchoolContactList/SchoolContact/
ContactInfo/PositionTitle

The contact person's position title.


SchoolAttendanceHistory/
SchoolAttended/SchoolInfoData/
SchoolContactList/SchoolContact/
ContactInfo/PhoneNumberList

List of PhoneNumber elements.


SchoolAttendanceHistory/
SchoolAttended/SchoolInfoData/
SchoolContactList/SchoolContact/ContactInfo/
PhoneNumberList/PhoneNumber Type

Code that specifies what type of phone number this is.


SchoolAttendanceHistory/
SchoolAttended/SchoolInfoData/
SchoolContactList/SchoolContact/ContactInfo/
PhoneNumberList/PhoneNumber/Number

Phone number.


SchoolAttendanceHistory/
SchoolAttended/MarkingSystems

Mandatory if school of record. Marking systems/grading tables used by the school.


SchoolAttendanceHistory/SchoolAttended/
MarkingSystems/MarkValueInfoData RefId

Marking system/grading table used by the school. Id used internally to StudentAcademicRecord to link marks to their marking systems.


SchoolAttendanceHistory/SchoolAttended/
MarkingSystems/MarkValueInfoData/Name

The text name of the value list.


SchoolAttendanceHistory/SchoolAttended/
MarkingSystems/MarkValueInfoData/Letter

Indicates whether a letter Mark is accepted.


SchoolAttendanceHistory/SchoolAttended/
MarkingSystems/
MarkValueInfoData/Letter/ValidMark

List of specific valid letter Marks.


SchoolAttendanceHistory/SchoolAttended/
MarkingSystems/MarkValueInfoData/
Letter/ValidMark/Code

String representing the actual Mark that would appear on the report card.


EnrollmentHistory
 (required)

A list of each enrollment in the schools above (see SchoolAttended).


EnrollmentHistory/
StudentSchoolEnrollmentData
 (required)

Collects elements of interest from StudentSchoolEnrollment.


EnrollmentHistory/
StudentSchoolEnrollmentData/
@SchoolAttendedRefId
 (required)

Reference to SchoolAttended.


EnrollmentHistory/
StudentSchoolEnrollmentData/EntryDate
 (required)

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/
TermInfoData SchoolAttendedRefId

Collects elements of interest from TermInfo. Reference to the school of record for the courses being taken (see SchoolAttended).


CurrentCourseActivity/
TermInfoData/SchoolYear

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/
TermInfoData/TermSpan/Code

Code for session type.


CurrentCourseActivity/TermInfoData/Courses

Courses being taken.


CurrentCourseActivity/
TermInfoData/Courses/Course

Course being taken.


CurrentCourseActivity/TermInfoData/Courses/
Course/SchoolAttendedRefId

Reference to the school where the course is being taken.


CurrentCourseActivity/TermInfoData/Courses/
Course/SchoolCourseInfoData

Collects elements of interest from SchoolCourseInfo.


CurrentCourseActivity/TermInfoData/Courses/
Course/SchoolCourseInfoData/CourseCode

School-defined local code for a course.


CurrentCourseActivity/TermInfoData/Courses/ Course/SchoolCourseInfoData/
StateCourseCode

State-defined standard course code used to report information about courses.


CurrentCourseActivity/TermInfoData/Courses/ Course/SchoolCourseInfoData/
DistrictCourseCode

A district course code.


CurrentCourseActivity/TermInfoData/Courses/
Course/SchoolCourseInfoData/CourseTitle

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.
 
 Otherwise, reports null.


CourseHistory
 (required)

Conveys the coursework completed, performance and attendance information for a student's academic career.


1: Courses posted in current district
 
 2: Courses manually entered in current district
 
 3: Courses not tied to current district


CourseHistory/Term
 (required)

Time spans by which courses are grouped.


CourseHistory/Term/
TermInfoData/@ SchoolAttendedRefId

  1. SchoolID if that exists based on matching School Number/Name

  2. School Number if it is entered but not matching schoolID is found.

  3. School Number of student’s most recent enrolled school if no School Number is entered in transcript
  4. 9999


CourseHistory/Term/
TermInfoData/SchoolYear
 (required)

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.
 
 2,3: The Term Start Date entered onto the transcript record

term.startDate
 

transcriptCourse.termStartDate

CourseHistory/Term/ TermInfoData/EndDate

Course End Date.


 1: The End Date of the term.
 
 2,3: The Term End Date entered onto the transcript record

term.endDate


transcriptCourse.termEndDate

CourseHistory/Term/ TermInfoData/TermCode

The course Term Code


1: The term name.
 
 2,3: null

term.name

CourseHistory/Term/ TermInfoData/TermSpan

Course Term Span.


CourseHistory/Term/
TermInfoData/TermSpan/Code

Code for session type.


1: When Calendar > Summer School = checked: 0833
 
 Otherwise, count of terms in calendar:

  1. When 1 term: 0827
  2. When 2 terms: 0828
  3. When 3 terms: 0829
  4. When 4 terms: 0830
  5. When 5 terms: 0831
  6. When > 5 terms: 0832

Otherwise: 9999

2,3: 9999

System Administrator > Calendar > Calendar > Summer School
 
 System Administator > Calendar > Calendar > Terms > Term Detail


calendar.summerSchool

CourseHistory/ Term/Courses
 (required)

Courses the student has completed.


Reports when student has any historical course records.


CourseHistory/ Term/Courses/Course
 (required)

The individual course.


Reports for each course on the student’s transcript.


CourseHistory/Term/Courses/
Course/SchoolAttendedRefId

Reference to the school where the course was taken.


Generated by Campus.


CourseHistory/ Term/Courses/Course/
SchoolCourseInfoData
 (required)

Collects elements of interest from SchoolCourseInfo.


CourseHistory/ Term/Courses/Course/
SchoolCourseInfoData/CourseCode
 (required)

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/
SchoolCourseInfoData/StateCourseCode
 (required)

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/
SchoolCourseInforData/DistrictCourseCode

A district course code.


The Course Number when not null. Otherwise, blank.

Student Information > General > Transcript > Course Number


course.number

CourseHistory/ Term/Courses/Course/
SchoolCourseInforData/CourseTitle
 (required)

Title of course, up to 20 characters.


Reports the Course Name.

Student Information > General > Transcript > Course Name


course.name

CourseHistory/ Term/
Courses/Course/StartDate

Date course section started.


Reports the term Start Date.

Scheduling > Courses > Section > Section Schedule Placement > Term


term.startDate

CourseHistory/ Term/
Courses/Course/EndDate

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/
MarkingPeriods/MarkingPeriod

Student performance/attendance data for a marking period.


CourseHistory/ Term/Courses/Course/
MarkingPeriods/MarkingPeriod/
SchoolAttendedRefId

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/
MarkingPeriod/GradeLevelWhenTaken

Container element for GradeLevelWhenTaken/Code


 
 
 

CourseHistory/ Term/
Courses/Course/MarkingPeriods/
MarkingPeriod/GradeLevelWhenTaken/Code
 (required)

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/
MarkingPeriods/MarkingPeriod/
MarkData MarkValueInfoDataRefId

Reference to marking system at school of record.


Generated by Campus.


CourseHistory/ Term/Courses/Course/
MarkingPeriods/MarkingPeriod/MarkData MarkValueInfoDataRefId/Percentage

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/
MarkingPeriods/MarkingPeriod/MarkData MarkValueInfoDataRefId/Numeric

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/
Courses/Course/MarkingPeriods/
MarkingPeriod/CourseCreditsAttempted
 (required)

Credits attempted by the student.


Reports the number of credits attempted.

Student Information > General > Transcript > Transcript Credit > Attempted


transcriptCourse.creditsAttempted

CourseHistory/ Term/
Courses/Course/MarkingPeriods/
MarkingPeriod/CourseCreditsEarned
 (required)

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/
MarkingPeriods/MarkingPeriod/CreditType

Type of credit


Reports “0585”.


CourseHistory/ Term/Courses/Course/
MarkingPeriods/MarkingPeriod/
TermInfoData
 (required)

Information related to the span of time associated with the marking period.


CourseHistory/ Term/
Courses/Course/MarkingPeriods/
MarkingPeriod/TermInfoData/TermCode
 (required)

Grading term as recorded in SIS.


When Calendar > Summer School = checked: 0833

Otherwise, count of terms in calendar:

When 1 term: 0827
 When 2 terms: 0828
 When 3 terms: 0829
 When 4 terms: 0830
 When 5 terms: 0831
 When > 5 terms: 0832
 Otherwise: 9999

System Administration > Calendar > Calendar > Summer School
 
System Administration > Calendar > Calendar > Terms


calendar.summerSchool

AcademicPerformanceHistory
 (required)

Provides a summary of a student's academic performance by reporting period.


Container element for AcademicPerformanceHistory/
TermPerformance records.


AcademicPerformanceHistory/
TermPerformance
 (required)

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.


 Student Information > General > Transcript > Actual Term

AcademicPerformanceHistory/
TermPerformance/
GradeLevelWhenTaken/Code
 (required)

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/
TermPerformance/CreditsEarned
 (required)

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/
TermPerformance/GPA

The grade point average the student earned during this session. Blank is ok. 


Sums (# of credits * weighted gpa received) / the sum of the # of credits (if weighted GPA is null, then unweighted is used)

Student Information > General > Transcript > GPA Weight, GPA Value, Unweighted GPA Value


TranscriptCourse.gpaWeight

TranscriptCourse.gpaValue

TranscriptCourse.
unweightedGPAValue

CourseHistory/ Term/Courses/Course/
MarkingPeriods/MarkingPeriod/
MarkData/Letter
 (required)

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
 (required)

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.
unweightedGPAValue

AcademicPerformanceSummary/
CumulativeGPA
(required)

The grade point average the student earned during this session. Blank is ok


Sums (# of credits * weighted gpa received) / the sum of the # of credits (if weighted GPA is null, then unweighted is used)

Student Information > General > Transcript > GPA Weight, GPA Value, Unweighted GPA Value


TranscriptCourse.gpaWeight

TranscriptCourse.gpaValue

TranscriptCourse.
unweightedGPAValue

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.


 Student Information > General > Credit Summary > 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.


 Student Information > General > Credit Summary > 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


Student Information > General > Graduation > Diploma Date


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:
 1. Subject NOT = blank.
 2. National Test = AP, ACT, SAT

Student Information > General > Assessment
 
Assessment > Test Setup > Test Detail > Subject, National Test


 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:
 1. Subject NOT = blank.
 2. National Test = AP, ACT, SAT

Student Information > General > Assessment
 
Assessment > Test Setup > Test Detail > Subject, National Test


 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.
 
 When the Date field is blank, reports the Date from any parent assessments it’s attached, beginning with the direct parent and working up until a non-blank Date field is found.
 
 Otherwise, reports blank.
 

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:
 
 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 > 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:
 System Administration > Calendar > Calendar > Exclude from SIF Exchange


Student’s enrollment in the SIF Zone Year is not excluded on the SIF Zone Options:

  • Exclude All Secondary Enrollments
  • Exclude No Show Enrollments
  • Exclude All State Exclude Enrollments

System Administration > Data Interchange > Zones > SIF Zone Options

Object Data Elements

Data ElementDescription and Business RulesData 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
 
 System Administration > Calendar > Calendar > Days > Day Detail


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
 
 System Administration > Calendar > Calendar > Days > Day Detail


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
 (required)

The number of days the student attended school when school was in session between the StartDate and EndDate, inclusive.


  1. When DaysInMembership is mapped to "PVT", reports "000".

  2. When School Membership FTE Override field is null:

    1. Sums the unique instructional days the student is enrolled where the student had any period in the day not one of the following:

      1. Status = “Absent”

      2. Excuse = “Unknown”, “Excused” or “Unexcused”

  3. When DaysAttended > 180, calculates DaysAttended / the number of unique instructional days the student is enrolled and not absent in the enrollment and multiplies this value by 180, then rounds up to the next whole number.
  4. When School Membership FTE Override field is NOT null:
    1. Multiplies the actual days attended by the (School Membership FTE Override field value / 100).
  5. Rounded up to the next whole number.

Student Information > General > Enrollments > Start Date, End Date
 
System Administration > Attendance > Attendance Codes > Attendance Excuses Editor > Attendance Excuse Detail
 
Student Information > General > Enrollments > School Membership FTE Override


System Administration > Calendar > Calendar > Days > Day Detail > Instruction


day.instructional
 

enrollment.startDate


enrollment.endDate
 
attendanceExcuse.status
OR 

attendance.status
 
attendanceExcuse.excuse OR 

attendance.excuse
 
enrollment. percentEnrolled

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.


Report "000" when the following is true:
  1. Student's associated enrollment Local Start Status is mapped to 04 or 05.
When the enrollment Local Start Status is not mapped to 04 or 05:

  1. Counts the number of enrolled instructional days where the following is true for the student:

    1. Grade Level Half Day:
      1. When the student's enrollment gradelevel has (System Admin > Calendar > Grade Levels > Grade Level Detail > Half Day Absence (minutes)) NOT = null:
        1. When the student is absent for >= the value entered into the "Half Day Absence (minutes)" field where their absent code has:

          1. Status = “Absent”

          2. Excuse = “Excused”

      2. Calendar Half Day:
        1. When the student's enrollment gradelevel has (System Admin > Calendar > Grade Levels > Grade Level Detail > Half Day Absence (minutes)) = null:
          1. When (System Admin > Calendar > Calendar > Half Day Absence (minutes) NOT = null:
            1. When the student is absent for >= the value entered into the "Half Day Absence (minutes)" field on Calendar where their absent code has:

              1. Status = “Absent”

              2. Excuse = “Excused”

        2. Calculated Half Day:
          1. When (System Admin > Calendar > Calendar > Half Day Absence (minutes) = null:
            1. When the student is absent for half or more of the instructional minutes in the day, where their absent code has:

              1. Status = “Absent”

              2. Excuse = “Excused”

  2. Adds present minutes back in that exist in the student's Present Minutes field in the period.

System Administration > Calendar > Calendar > Days > Day Detail > Instruction
 
 Student Information > General > Enrollments > Start Date, End Date
 
 System Administration > Attendance > Attendance Codes > Attendance Excuses Editor > Attendance Excuse Detail


day.instructional
 
enrollment.startDate
 
enrollment.endDate
 
attendanceExcuse.status
OR 

attendance.status
 
attendanceExcuse.excuse OR 

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:
 Status = “Absent”
 Excuse = “Unexcused”

System Administration > Calendar > Calendar > Days > Day Detail > Instruction
 
Student Information > General > Enrollments > Start Date, End Date
 
System Administration > Attendance > Attendance Codes > Attendance Excuses Editor > Attendance Excuse Detail


day.instructional
 
enrollment.startDate
 
enrollment.endDate


attendanceExcuse.status
OR

attendance.status
 
attendanceExcuse.excuse OR 

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:
 Status = “Tardy”
 Excuse NOT = “Exempt”

System Administration > Calendar > Calendar > Days > Day Detail > Instruction
 
 Student Information > General > Enrollments > Start Date, End Date
 
 System Administration > Attendance > Attendance Codes > Attendance Excuses Editor > Attendance Excuse Detail


day.instructional
 
enrollment.startDate
 
enrollment.endDate
 
 attendanceExcuse.status
 OR 

attendance.status
 
attendanceExcuse.excuse OR 

attendance.excuse

DaysInMembership
 (required)

School aggregate membership


  1. When the enrollment Local Start Status is mapped to 04, reports “”PVT”.

  2. When the enrollment Local Start Status is mapped to 05, reports “”HSC”.

  3. When the enrollment Local Start Status is not mapped to 04 or 05:

    1. For any day where the student has either of the following, the day must not be counted as a membership day:
      1. Any day that falls on or between the student's locked IEP Start Date and End Date when the IEP Time field = "C"
      2. Any day that falls on or between the student's Youth In Care record Start Date and Exit Date when the YIC record has a Time Code field = "C"
        1. When the Youth In Care Exit Date is null, any day on or after the Youth In Care Start Date must be excluded

    2. When School Membership FTE Override field is null:

      1. Sums the unique instructional days the student is enrolled per enrollment.

    3. When School Membership FTE Override field is NOT null:

      1. Multiplies the membership days by the (School Membership FTE Override field value / 100) when Membership FTE Override is not null.

    4. Rounded up to the next whole number.

    5. When membership days > 180, report “180”.

Student Information > General > Enrollments > Local Start Status
 
 System Administration > Calendar > Calendar > Days > Day Detail > Instruction
 
Student Information > General > Enrollments > Start Date, End Date


System Administration > Attendance > Attendance Codes > Attendance Excuses Editor > Attendance Excuse Detail
 
Student Information > General > Enrollments > School Membership FTE Override


enrollment.startStatus

day.instructional


enrollment.startDate
 
enrollment.endDate
 
attendanceExcuse.status

OR 

attendance.status
 
attendanceExcuse.excuse 

OR 

attendance.excuse
 
enrollment. percentEnrolled

StudentSchool
EnrollmentRefId
 
 
 

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:
  1. Student's associated enrollment Local Start Status is mapped to 04 or 05.
When the enrollment Local Start Status is not mapped to 04 or 05:

  1. Counts the number of enrolled instructional days where the following is true for the student:

    1. Grade Level Half Day:
      1. When the student's enrollment gradelevel has (System Admin > Calendar > Grade Levels > Grade Level Detail > Half Day Absence (minutes)) NOT = null:
        1. When the student is absent for >= the value entered into the "Half Day Absence (minutes)" field where their absent code has:

          1. Status = “Absent”

          2. State Code = S

      2. Calendar Half Day:
        1. When the student's enrollment gradelevel has (System Admin > Calendar > Grade Levels > Grade Level Detail > Half Day Absence (minutes)) = null:
          1. When (System Admin > Calendar > Calendar > Half Day Absence (minutes) NOT = null:
            1. When the student is absent for >= the value entered into the "Half Day Absence (minutes)" field on Calendar where their absent code has:

              1. Status = “Absent”

              2. State Code = S

        2. Calculated Half Day:
          1. When (System Admin > Calendar > Calendar > Half Day Absence (minutes) = null:
            1. When the student is absent for half or more of the instructional minutes in the day, where their absent code has:

              1. Status = “Absent”

              2. State Code = S
  2. Adds present minutes back in that exist in the student's Present Minutes field in the period.
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:
 System Administration > Calendar > Calendar > Exclude from SIF Exchange

Student has an enrollment in the SIF Zone Year that is not excluded on the SIF Zone Options

  • Exclude All Secondary Enrollments
  • Exclude No Show Enrollments
  • Exclude All State Exclude Enrollments

System Administration > Data Interchange > Zones > SIF Zone Options

Object Data Elements

Data ElementDescription and Business RulesData 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.
 
Otherwise does not report the element.

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.
 
Otherwise does not report the element.

Census > People > Demographics > Student State ID 


person.stateId

StudentPersonalData/SSN

Social Security Number.


Reports the Social Security Number when not Null.
 
Otherwise does not report the element.

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.
 
Otherwise, does not report the element.

Census > People > Demographics > Person Information > Suffix


identity.suffix

StudentPersonalData/
Name/PreferredName
 
 
 

This is a name that the person prefers to be called by.


Reports the student’s Nickname when exists.
 
 Otherwise, does not report the element.

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/
DemographicsData/RaceList



StudentPersonalData/
DemographicsData/RaceList/Race



StudentPersonalData/DemographicsData/
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.


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/
RaceList/Race/OtherCodeList



StudentPersonalData/DemographicsData/
RaceList/Race/OtherCodeList/OtherCode

Indian tribal affiliation.


Reports the Tribal Affiliation selection when present

Census > People > Demographics > Person Information > Race/Ethnicity > Tribal Affiliation


identity.raceSubcategory

StudentPersonalData/
DemographicsData/Gender

A person's gender.


Report the Code selected in (Census > People > Demographics > Gender):
  1. When M, M.
  2. When F, F.
  3. When N, N.
  4. When P, P.
  5. When T, T.

Census > People > Demographics > Person Information > Gender


identity.gender

StudentPersonalData/
DemographicsData/BirthDate

A person's date of birth.

Census > People > Demographics > Person Information > Birth Date


identity.birthDate

StudentPersonalData/DemographicsData/
LanguageList

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/
LanguageList/Language

Container for language elements.


StudentPersonalData/DemographicsData/
LanguageList/Language/Code

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
 
 Reports "mis" when no SIF mapping found.

Census > People > Demographics > Person Information > Home Primary Language, Native Language


identity.homePrimaryLanguage

 identity.languageAlt

StudentPersonalData/DemographicsData/
LanguageList/Language/OtherCodeList

List of other codes or strings that crosswalk to or serve as translations of the Code element paired with this common element.


StudentPersonalData/DemographicsData/
LanguageList/Language/
OtherCodeList/@Codeset

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.


Reports "StateProvince"


StudentPersonalData/DemographicsData/
LanguageList/Language/
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.


Reports the State Code selected in Home Primary Language or Native Language.

Census > People > Demographics > Person Information > Home Primary Language, Native Language

StudentPersonalData/
DemographicsData/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.
 
Otherwise, reports No.

Census > People > Demographics > Person Information > Race/Ethnicity > Is the individual Hispanic/Latino?


identity.hispanicEthnicity

StudentPersonalData/DemographicsData/
CountryOfBirth

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:

  1. Non-secondary
  2. Most recent Start Date

Census > People > Households > Address

StudentPersonalDataAddressList/
Address @Type

Code that defines the location of the address. Note: A subset of specific valid values for each instance in a data object may be listed in that object.


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.number
address.prefix
address.street
address.tag

address.dir


StudentPersonalDataAddressList/
AddressList/Address/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.postOfficeBox
address.number

address.number
address.prefix
address.street
address.tag
address.dir

StudentPersonalDataAddressList/
AddressList/Address/Street/Line2

Address line 2.


Reports the Apt when exists.

Census > People > Households > Address > Apt


address.apt

StudentPersonalDataAddressList/
AddressList/Address/Street/Line3

Address line 3.


address.city, address.state + address.zip

Census > People > Households > Address


address.city

address.state

address.zip

StudentPersonalDataAddressList/
AddressList/Address/Street/StreetNumber

The address number assigned to the building.


Reports the address Number.

Census > People > Households > Address > Number


address.number

StudentPersonalDataAddressList/
AddressList/Address/Street/StreetPrefix

Street prefix like NE


Reports the address Prefix when exists.

Census > People > Households > Address > Prefix


address.prefix

StudentPersonalDataAddressList/
AddressList/Address/Street/StreetName

The name of the street.


Reports the address Street.

Census > People > Households > Address > Street


address.street

StudentPersonalDataAddressList/
AddressList/Address/Street/StreetType

The type of street. For example, Lane, Blvd., Ave., etc.


Reports the address Tag when exists.

Census > People > Households > Address > Tag


address.tag

StudentPersonalDataAddressList/
AddressList/Address/Street/StreetSuffix

Street suffix like SW.


Reports the address Direction when exists.

Census > People > Households > Address > Direction


address.dir

StudentPersonalDataAddressList/
AddressList/Address/Street/ApartmentNumber

The number of the apartment.


Reports the address Apt when exists.

Census > People > Households > Address > Apt


address.apt

StudentPersonalDataAddressList/
AddressList/Address/City

The city part of the address.


Reports the address City when exists.

Census > People > Households > Address > City


address.city

StudentPersonalDataAddressList/
AddressList/County

The county part of the address.


Reports the address County when exists.

Census > People > Households > Address > Country


address.county

StudentPersonalDataAddressList/
AddressList/Address/StateProvince

The state or province code.


Reports the address State when exists.

Census > People > Households > Address > State


address.state

StudentPersonalDataAddressList/
AddressList/Address/Country

The country code.


Hardcoded to "US"


StudentPersonalDataAddressList/
AddressList/Address/PostalCode

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
 
 Census > People > Personal Contact Information > Cell Phone, Work Phone


household.phone

contact.cellPhone
contact.workPhone

StudentPersonalData/
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".


StudentPersonalData/
PhoneNumberList/Number

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
 
 Census > People > Personal Contact Information > Cell Phone, Work Phone


household.phone
contact.cellPhone
contact.workPhone

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:
 1. Start Date <= current date
 2. End Date is null or >= current date
 3. Migrant Indicator is Y
 
 Otherwise, reports No.

Student Information > Program Participation > Migrant


Migrant. lastQualifyingArrivalDate
 
Migrant. eligibilityExpirationDate
 
Migrant. migrant

COEStatusIndicator

StudentPersonalData/Title1

Is the student in Title 1 programs?


Reports Yes when:
 1. Start Date <= current date
 2. End Date is null or >= current date
 
 Otherwise, reports No.

Student Information > Program Participation > Title 1


Title1.startDate
 
Title1.endDate

StudentPersonalData/GiftedTalented

Is the student in Gifted/Talented programs?


Reports Yes when:
 1. Start Date <= current date
 2. End Date is null or >= current date
 
 Otherwise, reports No.

Student Information > Program Participation > Gifted


Gifted.startDate
 
Gifted.endDate

StudentPersonalData/
EconomicDisadvantage

Does the student meet the State criteria for classification as having an economic disadvantage?


Reports Yes when:
 1. Start Date <= current date
 2. End Date is null or >= current date
 3. Eligibility = Free or Reduced
 
 Otherwise No.

FRAM > Eligibility > Eligibility Detail


posEligibility.eligibility

StudentPersonalData/ELL

Is the student an English Language Learner under Title 3?


Reports Yes when:
 Student's EL record with the latest (most recent) Identified Date that is <= the current date has:
 1. Program Exit Date of null or >= current date
 
 Otherwise No.

Student Information > Program Participation > English Learners (EL)


lep.identifiedDate

lep.exitDate

StudentPersonalData/Homeless

Is the student homeless?


Reports Yes when:
 The student has a Homeless record with Start Date <= current date and End Date of null or >= current date.
 
When no qualifying Homeless record exists, reports No.

Student Information > General > Program Participation > Homeless > Start Date, End Date


homeless.startDate
homeless.endDate

StudentPersonalData/Section504

Is the student a qualified individual under Section 504 of the Rehabilitation Act?


Reports Yes when:
 1. Start Date <= current date
 2. End Date is null or >= current date
 
 Otherwise No.

Student Information > Program Participation > Section 504


Section504.startDate
Section504.endDate

StudentPersonalData/
VocationalConcentrator

Does the student meet the State criteria for classification as a vocational concentrator?


Reports Yes when:
 1. Start Date <= current date
 2. End Date is null or >= current date
 3. Supplemental Services has Vocational selected
 
 Otherwise, No

Student Information > Program Participation > Title 1


Title1.startDate
Title1.endDate
Title1.title1Services

StudentPersonalData/Immigrant

Does the student meet the State criteria for classification as being an immigrant?


Reports Yes when:
Immigrant is checked.
 
 Otherwise, No.

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:
 1. Start Date <= current date
 2. End Date is null or >= current date
 3. Neglected / Delinquent is not null
 
 Otherwise, No.

Student Information > Program Participation > State Programs > Youth In Care


YouthProgram.startDate
 
 YouthProgram.endDate
 
 YouthProgram. neglectedDelinquent

StudentContactsSummary

Reports up to two parents/guardians of the student.


StudentContactsSummary/ParentGuardian1
 (required)

First parent/guardian.


Reports based on the following priority when the guardian exists on a student household:

  1. Father
  2. Mother
  3. Other guardians


StudentContactsSummary/
ParentGuardian1/Name @Type
 (required)

Code that specifies what type of name this is.


Reports “04”


StudentContactsSummary/ParentGuardian1/
Name/LastName
 (required)

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/
Name/FirstName
 (required)

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/
ParentGuardian2/Name @Type

Code that specifies what type of name this is.


Reports “04”


StudentContactsSummary/ParentGuardian2/
Name/LastName

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/
Name/FirstName

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

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:

  • Abbreviation = “UT”
  • Start Date <= current date
  • End Date >= calendar Start Date

Student Information > Special Ed > General > Documents
 System Administration > Special Ed > Plan Types

Student has an enrollment in the SIF Zone Year and Calendar with:

  • Enrollment Start Date <= current date
  • Enrollment Start Date <= locked Data Plan End Date
  • Enrollment End Date is null or >= locked Data Plan Start Date

* 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:
 System Administration > Calendar > Calendar > Exclude from SIF Exchange

Student must have an enrollment in the Zone Scope that is not excluded on the SIF Zone Options:
 
 System Administration > Data Interchange > Zones > SIF Zone Options
 Exclude All Secondary Enrollments
 Exclude No Show Enrollments
 Exclude All State Exclude Enrollments

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:

  • Start Date <= current date
  • End Date of null or >= calendar Start Date


Student Information > Program Participation > State Programs > Youth In Care

Student has an enrollment in the SIF Zone Year and Calendar with:

  • Enrollment Start Date <= current date

Student must have an enrollment associated with a calendar that is not excluded:
 System Administration > Calendar > Calendar > Exclude from SIF Exchange

Student must have an enrollment in the Zone Scope that is not excluded on the SIF Zone Options:
 
 System Administration > Data Interchange > Zones > SIF Zone Options
 Exclude All Secondary Enrollments
 Exclude No Show Enrollments
 Exclude All State Exclude Enrollments

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:

  • Start Date <= current date
  • End Date of null or >= calendar Start Date


Student Information > Program Participation > State Programs > Section 504

Student has an enrollment in the SIF Zone Year and Calendar with:

  • Enrollment Start Date <= current date

Student must have an enrollment associated with a calendar that is not excluded:
 System Administration > Calendar > Calendar > Exclude from SIF Exchange

Student must have an enrollment in the Zone Scope that is not excluded on the SIF Zone Options:
 
 System Administration > Data Interchange > Zones > SIF Zone Options
 Exclude All Secondary Enrollments
 Exclude No Show Enrollments
 Exclude All State Exclude Enrollments

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 ElementDescription and Business RequirementsDatabase 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 “0270”


NCES Code

ExceptionalityCategories
 (required)



List

ExceptionalityCategories/
ExceptonalityCategory
 (required)

Container element for Exceptionality/Code



ExceptionalityCategories /ExceptonalityCategory/Code
 (required)

Disability Type


 Reports the code selected in the enrollment Disability 1 field when not null. When Disability 1 is null, reports blank.
 
 
 

Student Information > General > Enrollments > Special Ed Fields > Disability 1
 
 

NCES Code

ProgramPlacementDate
 (required)

SCRAM Placement Date


  1. When the student has a qualifying (locked, "UT") IEP that has a Start Date during a prior calendar year that overlaps an enrollment in the current year:
    1. For this StudentParticipation record, report the Start Date of the student's earliest enrollment in the current SIF Zone Year.
  2. When the IEP causing the StudentParticipation record has a Start Date in the current year:
    1. Reports the Start Date of the locked UT Data Plan.

Student Information > Special Education > Documents > UT Data Plan > Education Plan > Start Date

xs:date

LeastRestrictiveEnvironment
 (required)

Educational environment


Reports blank when Special Ed Setting is blank.

Student Information > General > Enrollments > Special Ed Fields > Special Ed Setting


LeastRestrictiveEnvironment/Code
 (required)

Educational environment


Reports “9999”.
 
When blank, element does not report.
 
 

Student Information > General > Enrollments > Special Ed Fields > Special Ed Setting


 enrollment.specialEdSetting

NCES Code

LeastRestrictiveEnvironment/
OtherCodeList/OtherCode
 (required)

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.
 
 For Ages 6-21:  H, R, S, T, U, V, Y, P.

ProgramExitDate
 (required when exited)

SCRAM Exit Date


Reports the enrollment Exit Date + 1 day when Exit Date is not null.
 
 Otherwise, reports blank.

Student Information > General > Enrollments > Special Ed Fields > Exit Date


 enrollment.spedExitDate

xs:date

ProgramExitReason
 (required when exited)


 Reports blank when Exit Reason is blank.

Student Information > General > Enrollments > Special Ed Fields > Exit Reason


 enrollment. spedExitReason


ProgramExitReason/Code
 (required when exited)

Review by program / state


Reports “9999”.
 
When blank, element does not report.
 
 

Student Information > General > Enrollments > Special Ed Fields > Exit Reason


 enrollment. spedExitReason

NCES Code

ProgramExitReason/
OtherCodeList/OtherCode
 (required when exited)

SCRAM Exit Reason code


Reports the code selected in the Exit Reason field.
 
When blank, element does not report.

Student Information > General > Enrollments > Special Ed Fields > Exit Reason


 enrollment. spedExitReason

A, D, P, S, X

StudentSpecialEducationFTE
 (required)

Percent in regular setting.

  • When Regular Percent = 1, report ".90".
  • When Regular Percent = 2, report ".60".
  • When Regular Percent = 3, report ".20".
  • When Regular Percent = blank or N/A, report blank

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)
  1. When the latest associated enrollment has a Local Start Status mapped to 04 or 05, reports “000”.
  2. When Local Start Status is NOT mapped to 04 or 05:
  3. When "School Membership FTE Override" is null:
    1. Count of days on and between the IEP Plan Start Date and the earliest of (the current date, enrollment SPED Exit Date, IEP Plan End Date, and latest instructional day in the student's latest enrollment calendar in the Zone Year)
  4. When "School Membership FTE Override" is not null:
    1. Multiplies the membership days by the (School Membership FTE Override field value / 100) when Membership FTE Override is not null.
    2. Rounded up to the next whole number.
    3. When membership days > 180, report “180”.
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
IsOnePercentA 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%
ExtendedSchoolYearStudent 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 ElementDescription and Business RequirementsDatabase 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 “0270”


ExceptionalityCategoriesReports blank in the S3 record.
ExceptionalityCategories
/ExceptonalityCategory		Does not populate in the S3 record.
ExceptionalityCategories /ExceptonalityCategory/CodeDoes 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
  1. Reports null when:
    1. Regular Percent field is Null or N/A.
  2. Otherwise, reports the code selected in the Regular Percent field.
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)
  1. When the latest associated enrollment in the SIF Zone Scope that has a Local Start Status mapped to 04 or 05, reports “000”.
  2. When Local Start Status is NOT mapped to 04 or 05:
  3. When "School Membership FTE Override" is null:
    1. Count of days on and between the YIC Start Date and the earliest of (the current date, YIC End Date, latest Enrollment End Date, and latest instructional day in the student's latest enrollment calendar in the Zone Year)
    2. The End Date is considered to be the last instructional day in the student’s latest enrolled calendar.
  4. When "School Membership FTE Override" is not null:
    1. Multiplies the membership days by the (School Membership FTE Override field value / 100) when Membership FTE Override is not null.
    2. Rounded up to the next whole number.
    3. When membership days > 180, report “180”.
    4. Association enrollment:
      1. Enrollment Start Date <= current date
      2. Enrollment Start Date <= Youth In Care End Date when not null
      3. Enrollment End Date is null or >= Youth In Care record Start Date
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
ExcludeYICMembershipIndicates 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
DJJSFacilityFor 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
IsNeglectedAndDelinquentUsed 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 ElementDescription and Business RequirementsDatabase Field

StudentParticipationAsOfDate

The date this record was prepared.
 

Reports the current date.

day.date

YYYY-MM-DD

ProgramType

Parent element to ProgramType/Code.
 
 


ProgramType/CodeIdentifies the individualized program for which the student's participation is described in this instance.
Reports “3200”.
ExceptionalityCategoriesReports blank in the S4 record.
ExceptionalityCategories/
ExceptonalityCategory		Reports blank in the S4 record.
ExceptionalityCategories /ExceptonalityCategory/CodeReports 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
LeastRestrictiveEnvironmentReports blank in the S4 record.
LeastRestrictiveEnvironment/CodeReports 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
StudentSpecialEducationFTEReports blank in the S4 record.
AutismStudent 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
BrainInjuryStudent 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
HearingImpairmentStudent 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
LearningImparmentStudent 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
BodilyFunctionImpairmentStudent 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
MedicalImpairmentStudent 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
MentalHealthImpairmentStudent 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
OrthopedicImpairmentStudent 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
OtherImpairmentStudent 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 TypeRequirement

Add

Adding the student to Infinite Campus.

Change

A change is made on the student’s enrollment in the SIF Zone Scope.
 Student Information > General > Enrollments

Change

A change is made on the student’s Demographics record.
 Census > People > Demographics

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.
 System Administration > Calendar > Calendar > Grade Levels > Grade Level Editor > Grade Level Detail > Exclude from SIF reporting

Student’s enrollment calendar must not be excluded:
 System Administration > Calendar > Calendar > Exclude from SIF Exchange

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
 
 Exclude All Secondary Enrollments
 Exclude No Show Enrollments
 Exclude All State Exclude Enrollments

Object Data Elements

Data ElementDescription and Business RequirementsDatabase Field

LocalId
 (required)

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
 (required)

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
 (required)

Name of the student. 


Note: Type value of 04 must be used here.


Name/LastName
 (required)

Reports the student’s last name.

Census > People > Demographics > Person Information > Last Name


identity.lastName

Name/FirstName
 (required)

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.
 
Reports "05" for the second most recent 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
 (required)

List of races that apply to the student.


Demographics/RaceList/Race
 (required)

Container element for Race.


Demographics/RaceList/ Race/Code
 (required)

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/
OtherCodeList/
OtherCode/@Codeset

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/
OtherCodeList/OtherCode

Indian tribal affiliation.


Reports the Tribal Affiliation selection when present.

Census > People > Demographics > Person Information > Race/Ethnicity > Tribal Affiliation


identity.raceSubcategory

Demographics/HispanicLatino
 (required)

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.
 
Otherwise, reports No.

Census > People > Demographics > Person Information > Race/Ethnicity > Is the individual Hispanic/Latino?


Identity. hispanicEthnicity

Demographics/Gender
 (required)

Person's gender.


Report the Code selected in (Census > People > Demographics > Gender):
  1. When M, M.
  2. When F, F.
  3. When N, N.
  4. When P, P.
  5. When T, T.

Census > People > Demographics > Person Information > Gender


identity.gender

Demographics/BirthDate
 (required)

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
 (required)

List of languages an individual uses to communicate.

Census > People > Demographics > Person Information > Home Primary Language, Native Language

Demographics/
LanguageList/Language
 (required)

Container for language elements.


Demographics/LanguageList/
Language/Code
 (required)

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
 
Reports "mis" when no SIF mapping found.

Census > People > Demographics > Person Information > Home Primary Language, Native Language


identity.homePrimaryLanguage


identity.languageAlt

Demographics/LanguageList/
Language/OtherCodeList

List of other codes or strings that crosswalk to or serve as translations of the Code element paired with this common element.


Demographics/LanguageList/
Language/
OtherCodeList/OtherCode/
@Codeset

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.


Demographics/LanguageList/
Language
/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.


Reports the State Code selected in Home Primary Language or Native Language.

Census > People > Demographics > Person Information > Home Primary Language, Native Language


identity.homePrimaryLanguage
 
 identity.languageAlt

Demographics/LanguageList/
Language/LanguageType

An indication of the function and context in which an individual uses a language to communicate.


When Home Primary Language, reports “1037”
 
When Native Language, reports “1038”

Census > People > Demographics > Person Information > Home Primary Language, Native Language


identity.homePrimaryLanguage
 
 identity.languageAlt

Demographics/ DwellingArrangement

Setting/environment in which the person resides.


Demographics/Dwelling
Arrangement/Code
 (required)

Code representing the setting/environment in which the person resides.


Reports “9999”


Demographics/ DwellingArrangement/
OtherCodeList/OtherCode/ @Codeset
 (required)

Student’s ‘Homeless’ status.


Codeset=’StateProvince’


Demographics/ DwellingArrangement/
OtherCodeList/OtherCode
 (required)

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
TimeResidence

AddressList
 (required)

A list of Address elements.


A collection of the addresses that exist for the student.

Orders address by:

1. Non-secondary
 2. Most recent Start Date

Census > People > Households > Address

Address
 (required)

This element contains address data.


AddressList/Type
 (required)

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
 (required)

The street element is a complex element and breaks the street down into several parts.


AddressList/Street/Line1
 (required)

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

address.number
address.prefix
address.street
address.tag
address.dir


AddressList/Street/Line2
 (required if exists)

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
address.state
address.zip

AddressList/Street/
StreetNumber

The address number assigned to the building.

Census > People > Households > Address > Number


address.number

AddressList/Street/
StreetPrefix

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/
ApartmentNumber

Type of apartment, for example, Suite.

Census > People > Households > Address > Apt


address.apt

AddressList/City
 (required)

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
 (required)

The state or province code.

Census > People > Households > Address > State


address.state

AddressList/Country
 (required)

The country code.


Reports "US".


AddressList/PostalCode
 (required)

The ZIP/postal code.

Census > People > Households > Address > Zip


address.zip

PhoneNumberList

The student's phone number(s).


Reports the household phone, and either cell phone or work phone.


PhoneNumber Type="0096" must be reported from the household based on the AddressList reporting criteria, EVEN WHEN the household and/or household's address has an End Date < the current date.

Census > People > Households > Household Info > Phone Number
 
Census > People > Personal Contact Information > Cell Phone, Work Phone


household.phone
contact.cellPhone
contact.workPhone

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:
 
When contact.cellPhone is not null, reports this number first. Otherwise reports contact.workPhone.

Census > People > Households > Household Info > Phone Number
 
Census > People > Personal Contact Information > Cell Phone, Work Phone


household.phone
contact.cellPhone
contact.workPhone

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 "NGA Cohort End Year" field is 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
 
Student Information > General > Graduation > Date First Entered the 9th Grade
 
Student Information > General > Enrollments > Grade


GraduationcohortYearNGA
Graduation.grade9Date
 enrollment.grade

OnTimeGraduationYear

First projected graduation year, usually determined when student is accepted into 9th grade.


Reports the NCLB Cohort End Year.
 
When blank, considers the Date First Entered the Grade 9th Grade field to calculate.

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.
 
 Otherwise, No.

Student Information > Special Ed > General > Documents > Enrollment Status > Special Ed Status
 
Student Information > General > Special Ed Status


planState.specialEdStatus, enrollment.specialEdStatus

Migrant
 (required)

Is this a migrant student?


Reports Yes when:
 1. Start Date <= current date
 2. End Date is null or >= current date
 3. Migrant Indicator is Y
 
 Otherwise, reports No.

Student Information > Program Participation > Migrant


Migrant. lastQualifyingArrivalDate
Migrant. eligibilityExpirationDate
Migrant. migrantCOEStatusIndicator

Title1

Is the student in Title 1 programs?


Reports Yes when:
 1. Start Date <= current date
 2. End Date is null or >= current date
 
 Otherwise, reports No.

Student Information > Program Participation > Title 1


Title1.startDate
Title1.endDate

GiftedTalented
 (required)

Is the student in Gifted/Talented programs?


Reports Yes when:
 1. Start Date <= current date
 2. End Date is null or >= current date
 
 Otherwise, reports No.

Student Information > Program Participation > Gifted


Gifted.startDate
Gifted.endDate

EconomicDisadvantage

Does the student meet the State criteria for classification as having an economic disadvantage?


Reported based on FRAM eligibility: FRAM > Eligibility > Eligibility
  1. Reports F when:
    1. Start Date <= current date
    2. End Date is null or >= current date
    3. Eligibility = Free
  2. Reports R when:
    1. Start Date <= current date
    2. End Date is null or >= current date
    3. Eligibility = Reduced
  3. Otherwise reports blank

FRAM > Eligibility > Eligibility Detail


posEligibility.eligibility

ELL

Is the student an English Language Learner under Title 3?


Reports Yes when:
 Student's EL record with the latest (most recent) Identified Date that is <= the current date has:
 1. Program Exit Date of null or >= current date
 
 Othewise No.

Student Information > Program Participation > English Learners (EL)


lep.identifiedDate

lep.exitDate

Homeless
 (required)

Is the student homeless?


Reports Yes when:
 The student has a Homeless record with Start Date <= current date and End Date of null or >= current date.
 
 When no qualifying Homeless record exists, reports No.

Student Information > General > Program Participation > Homeless > Start Date, End Date


homeless.startDate
homeless.endDate

Section504
 (required)

Is the student a qualified individual under Section 504 of the Rehabilitation Act? (Mututally exclusive with IDEA classification.)


Reports Yes when:
 1. Start Date <= current date
 2. End Date is null or >= current date
 
 Othewise No.

Student Information > Program Participation > Section 504


Section504.startDate
Section504.endDate

VocationalConcentrator

Does the student meet the State criteria for classification as a vocational concentrator?


Reports Yes when:
 1. Start Date <= current date
 2. End Date is null or >= current date
 3. Supplemental Services has Vocational selected
 
 Otherwise, No.

Student Information > Program Participation > Title 1


Title1.startDate
Title1.endDate
Title1. title1Services

Immigrant
 (required)

Does the student meet the State criteria for classification as being an immigrant?


Reports Yes when:
 Immigrant is checked.
 
 Otherwise, No.

Census > People > Person Information > Immigrant


identity.immigrant

NeglectedDelinquent

Is the student participating in programs for neglected, delinquent, or at risk children?


Reports Yes when:
 1. Start Date <= current date
 2. End Date is null or >= current date
 3. Neglected / Delinquent is not null
 
 Otherwise, No.

Student Information > Program Participation > State Programs > Youth In Care


YouthProgram.startDate
YouthProgram.endDate
YouthProgram. neglectedDelinquent

FirstUSEnrollment
 (required if Immigrant is ‘Y’)

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

HighSchlComplStatusHigh 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
LimitedEnglishThis 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:
 1. Program Status is EL or Exited EL.
 2. Program Exit Date is null or >= current date.
 3. Parent Declined Date is null or > current date.
 4. An EL Service record exists in this EL record with:

4a. Service Type not mapped to “ELSS” or “Not a State Reported Type”.

      4b. Start Date <= current date
       4c. 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
ResidentStatusThis 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
MESAProgramIdentifies 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.
 2. Program Exit Date is null or >= current date.
 3. An EL Service record exists in this EL record with:

4a. Start Date <= current date
 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
NCLBSuppServLangIndicates 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
NCLBSuppServMathIndicates 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
CumulativeGPACumulative 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.
SpecialEdExitDateThe 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

MilitaryChildShould 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.
 2. End Date >= the current date or is null

Otherwise, reports blank.		Census > People > Relationships > Guardian
 
Census > People > Military Connections > Military Connections Editor

relatedPair.Guardian
impactAidEmployment.militaryStatus
RefugeeStudentIdentifies 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:

  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 = “ENS”

  4. Student’s assessment Date is in the SIF Zone year

  5. When the "ROGL or ENS Explanation" field is null:

    1. Reports Y when student has a passing score.

    2. Reports N when the student does not have a passing score.

    3. When the above criteria are not met, reports blank.


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:

  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 = “ENS”

  4. Student’s assessment Date is in the SIF Zone year

  5. When the "ROGL or ENS Explanation" field is null:

    1. Reports Y when student has a passing score.

    2. Reports N when the student does not have a passing score.

    3. When the above criteria are not met, reports blank.


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:

  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 = “ENS”

  4. Student’s assessment Date is in the SIF Zone year

  5. When the "ROGL or ENS Explanation" field is null:

    1. Reports Y when student has a passing score.

    2. Reports N when the student does not have a passing score.

    3. When the above criteria are not met, reports blank.


EarlyNumeracyIntervention

Reports the code selected in the "Reading or Numeracy Intervention" field on the Assessment when:

  1. Test Type = State Test

  2. State Code selection has an Attribute/Dictionary Standard Code = "ENS”

  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.


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
ELProficiencyAssessmentPre-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
PassedCivicsExamIndicates 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
Biliteracy1LevelFor 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
Biliteracy1LanguageIf 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
Biliteracy2LevelFor 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
Biliteracy2LanguageIf 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
EarlyNumeracyStatusBOY

EarlyNumeracyStatusMOY

EarlyNumeracyStatusEOY

EarlyNumeracyIntervention

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 TypeRequirement

Add

Adding an enrollment for the student.

Add

Setting “State Exclude” / “No Show” NOT = checked.
 
 Student Information > Genera > Enrollments > State Reporting Fields > State Exclude
 
 Student Information > Genera > Enrollments > General Enrollment Information > No Show

Change

A change is made on the student’s enrollment in the SIF Zone Scope.
 Student Information > General > Enrollments

ChangeA change is made on the student’s enrollment record.
ChangeA change on the following tabs occur: Enrollment, Foster Care, Early Learning
DeleteDeleting a student enrollment.
DeleteSetting “State Exclude” / “No Show” = checked.
  • Student Information > Genera > Enrollments > State Reporting Fields > State Exclude
  • Student Information > Genera > Enrollments > General Enrollment Information > No Show

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:
 System Administration > Calendar > Calendar > Exclude from SIF Exchange

Student has an enrollment in the SIF Zone Year that is not excluded on the SIF Zone Options:

  • Exclude All Secondary Enrollments
  • Exclude No Show Enrollments
  • Exclude All State Exclude Enrollments

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 ElementDescription and Business RulesData Source GUI Path and Database Field

EntryDate
 (required)

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)
 
 Student Information > General > Enrollment > General Enrollment Information > Grade

GradeLevel/OtherIdList/
OtherCode/@Codeset

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.
 
 1ai. When > 1 homeroom section has the same latest End Date, reports from the section with the highest section ID.
 
 When the current date > the homeroom section's term date range, reports from the latest homeroom that the student was last enrolled.

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
 (required when exited)

Day following the last day of school membership.


Reports the enrollment End Date + 1 day when End Date is not null.
 
 Otherwise, reports 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/
OtherCode/@Codeset
 
 

“StateProvince”


Reports “StateProvince”.


ExitType/OtherCodeList/ OtherCode
 (required when exited)

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
 
 System Administration > Enrollment > End Status Type > End Status Type Editor > End Status Type Detail > State End Status Code (Mapping)


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".
 
 Otherwise, "FullTime".

System Administration > Calendar > Grade Levels > Grade Level Editor > Grade Code


FullTime
PartTime

PartTimeHomeSchoolPart-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 Kindergarten Course Type is null from the qualifying course, reports null.		Scheduling > Courses > Course > Course Information > Kindergarten Course Type

course.programType


Title1MathTitle I Targeted Assistance Program - Additional Math services provided.

Reports “Y” when:
  1. Student has a Title 1 record with a Start Date <= enrollment End Date (or last instructional day in calendar when End Date is null) and End Date >= enrollment Start Date.
  2. Supplemental Services has Math selected.
Otherwise, reports null.		Student Information > Program Participation > Title 1 > Supplemental Services

title1.startDate
title1.endDate
title1. title1Services
Title1ELATitle I Targeted Assistance Program - Additional ELA services provided.

Reports “Y” when:
  1. Student has a Title 1 record with a Start Date <= enrollment End Date (or last instructional day in calendar when End Date is null) and End Date >= enrollment Start Date.
  2. Supplemental Services has ELA selected.
Otherwise, reports null.		Student Information > Program Participation > Title 1 > Supplemental Services

title1.startDate
title1.endDate
title1. title1Services
Title1ScienceTitle I Targeted Assistance Program - Additional Science services provided.

Reports “Y” when:
  1. Student has a Title 1 record with a Start Date <= enrollment End Date (or last instructional day in calendar when End Date is null) and End Date >= enrollment Start Date.
  2. Supplemental Services has Science selected.
 Otherwise, reports null.		Student Information > Program Participation > Title 1 > Supplemental Services

title1.startDate
title1.endDate
title1. title1Services
Title1HealthTitle I Targeted Assistance Program - Student received Health/Dental assistance supported by Title I funds.

Reports “Y” when:
  1. Student has a Title 1 record with a Start Date <= enrollment End Date (or last instructional day in calendar when End Date is null) and End Date >= enrollment Start Date.
  2. Supplemental Services has Health selected.
 Otherwise, reports null.		Student Information > Program Participation > Title 1 > Supplemental Services

title1.startDate
title1.endDate
title1. title1Services
Title1AcademicGuidanceTitle I Targeted Assistance Program - Student received Academic guidance assistance supported by Title I funds.

Reports “Y” when:
  1. Student has a Title 1 record with a Start Date <= enrollment End Date (or last instructional day in calendar when End Date is null) and End Date >= enrollment Start Date.
  2. Supplemental Services has Academic Guidance  selected.
 Otherwise, reports null.		Student Information > Program Participation > Title 1 > Supplemental Services

title1.startDate
title1.endDate
title1. title1Services
Title1SocialStudiesTitle I Targeted Assistance Program - Additional Social Studies services provided.

Reports “Y” when:
  1. Student has a Title 1 record with a Start Date <= enrollment End Date (or last instructional day in calendar when End Date is null) and End Date >= enrollment Start Date.
  2. Supplemental Services has Social Studies selected.
 Otherwise, reports null.		Student Information > Program Participation > Title 1 > Supplemental Services

title1.startDate
title1.endDate
title1. title1Services
Title1VocationalTitle I Targeted Assistance Program - Student received vocational/career services supported by Title I funds.

Reports “Y” when:
  1. Student has a Title 1 record with a Start Date <= enrollment End Date (or last instructional day in calendar when End Date is null) and End Date >= enrollment Start Date.
  2. Supplemental Services has Vocational selected.
 Otherwise, reports null.		Student Information > Program Participation > Title 1 > Supplemental Services

title1.startDate
title1.endDate
title1. title1Services
Title1ParaProsStudent received services from SB81 funding of Title I ParaPros.

Reports “Y” when:
  1. Student has a Title 1 record with a Start Date <= enrollment End Date (or last instructional day in calendar when End Date is null) and End Date >= enrollment Start Date.
  2. Supplemental Services has ParaPros selected.
 Otherwise, reports null.		Student Information > Program Participation > Title 1 > Supplemental Services

title1.startDate
title1.endDate
title1. title1Services
Intergenerational PovertyGrantStudent was a direct beneficiary of services supported by Intergenerational Poverty Grant.

Reports “Y” when:
  1. Student has an Other Supplemental Service record with a Start Date <= enrollment End Date (or last instructional day in calendar when End Date is null) and End Date >= enrollment Start Date.
  2. Intergenerational Poverty Grant is checked.
 Otherwise, reports null.		Student Information > Program Participation > State Programs > Other Supplemental Services > Intergenerational Poverty Grant

supplementalServices.startDate
supplementalServices.endDate
supplementalServices.supplementalService1
AfterSchool21CCLCStudent is a participant of Afterschool Program on or off site supported by 21st Century Community Learning Center Grant - 21 CCLC

Reports “Y” when:
  1. Student has an Other Supplemental Service record with a Start Date <= enrollment End Date (or last instructional day in calendar when End Date is null) and End Date >= enrollment Start Date.
  2. After School 21st Century Grant is checked.
 Otherwise, reports null.		Student Information > Program Participation > State Programs > Other Supplemental Services > After School 21st Century Grant

supplementalServices. startDate
supplementalServices. endDate
supplementalServices.supplementalService2

ELStateSoftwareStudent 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:
  1. Start Date <= current date
  2. End Date is null or >= current date.
  3. Service Type is mapped to a State Service Type = ELSS
 AND
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 StateSoftwareStudent 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:
  1. Start Date <= current date
  2. End Date is null or >= current date.
  3. Service Type is mapped to a State Service Type = ELSS
 AND
 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:
  1. When all courses the student has been enrolled during the enrollment have Attendance Type = null, report this element as null: <EnrollmentValidationType/>
  2. When all courses the student has been enrolled during the enrollment have Attendance Type = A: 100% Attendance Validated, OR A and null, report "A".
  3. When all courses the student has been enrolled during the enrollment have Attendance Type = L: 100% Learner Validated, OR L and null, report "L".
  4. When all courses the student has been enrolled during the enrollment have Attendance Type = S: 100% Somewhere Else, OR S and null, report "S".
  5. Otherwise, report "M" (Mixed).

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 TypeRequirement

Add/Delete

Checking/unchecking course.active.

Add/Delete

The course Active checkbox is modified
 Scheduling > Courses > Course > Course Information > Active

Change

Any change made to the roster batch edit for the section.

  • Start Date added/changed/removed
  • End Date added/changed/removed
  • Enrollment status added/changed/removed

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.
 Scheduling > Courses > Course > State Exclude

Student must have an enrollment associated with a calendar that is not excluded:
 System Administration > Calendar > Calendar > Exclude from SIF Exchange

Student must have an enrollment in the Zone Scope that is not excluded on the SIF Zone Options:
 
 System Administration > Data Interchange > Zones > SIF Zone Options
 Exclude All Secondary Enrollments
 Exclude No Show Enrollments
 Exclude All State Exclude Enrollments

Object Data Elements

Data ElementDescription and Business RulesData Source GUI Path and Database Field
/@RefIdThe Id (GUID) that uniquely identifies this StudentSectionEnrollment entity.

This attribute is generated by Infinite Campus.		N/A
/@SectionInfoRefIdThe Id (GUID) of the section in which this student is enrolled.

This attribute is generated by Infinite Campus.		roster.sectionId
/@StudentPersonalRefIdThe Id (GUID) of the student to whom the enrollment information applies.

This attribute is generated by Infinite Campus.		roster.personId
/@SchoolYearSchool 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 > Term
 
When 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
GradeEarnedThe grade earned for the course.
  1. Reports the State Score when not null, from the Grading Task assigned to the student in the section that has “State Reported” and “Final” = checked.
  2. If State Score is null, report Score (Grading & Standards > Score Groups & Rubrics > Score Group List Items Detail > Score), from the Grading Task assigned to the student in the section that has “State Reported” and “Final” = checked.
  3. When > 1 grading tasks for the same term has “State Reported” and "Final" = checked, reports the grade with the highest (latest) ID grading score.
  4. When the qualifying State Score and Score is blank, or there is no qualifying Grading Task, reports this element as blank.
  5. Updated Data Source GUI: Grading & Standards > Score Groups & Rubrics > Score Groups & Rubrics Editor > Score Group List Items Detail > State Score
Grading & Standards > Score Groups & Rubrics > Score Group List Items Detail > Score

gradingScore.score
gradingTask.stateReported
gradingTask.isFinal
CourseMembershipActual Membership (CTE)
  1. Report if If positions 1 and 2 of StateCourseCode >=30


Reports the number of instructional days up to and including the current date in which the student was enrolled on and between the earliest section schedule placement term date and the latest section schedule placement date term. 


Day count is limited by the student’s Roster Batch Edit > Start Date and End Date range when not null.

Scheduling > Courses > Section > Section Editor > Where Taught Campus
 
Scheduling > Courses > Course Information > Where Taught Campus
 
Scheduling > Courses > Section > Section Editor > Section Schedule Placement
 
Scheduling > Courses > Section > Roster Batch Edit > Start Date, End Date

section.distanceCode
course.distanceCode
ConcurrEnrolledStudent 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
CreditsEarnedNumber 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

AddA term is added
ChangeA term is changed
DeleteA 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 ElementDescription and Business RulesGUI Path and Database Field
@RefIdThe Id (GUID) that uniquely identifies this TermInfo entity.Term.termID, District.districtGUID
@SchoolInfoRefIdThe Id (GUID) that identifies the school where the term is used.
@SchoolYearSchool 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).
StartDateStarting date of the term.System Administration > Calendar > Calendar > Term

Term.StartDate
EndDateEnding date of the term (CCYYMMDD).System Administration > Calendar > Calendar > Term

Term.endDate
DescriptionText-based description of the term.System Administration > Calendar > Calendar > Term

Term.name
RelativeDurationPortion 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
TermCodeLocally-defined code.System Administration > Calendar > Calendar > Term

TermSchedule.name
TrackThe 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/CodeCode for session type

Calculated value based upon COUNT(terms)		Calculated value based upon COUNT(terms)
TermSpan/OtherCodeList

TermSpan/OtherCodeList/OtherCodeA 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.
MarkingTermDoes this TermInfo represent a marking period?

Optional do not report
SchedulingTermDoes this TermInfo represent a scheduling term?

Optional do not report
AttendanceTermDoes 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.

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com