Spreadsheet: 23dce0d7-7820-4aae-8818-8ee00ea09b7f
Sheet: SIF Profile

This USOE SIF Profile is based upon the SIF Specification 2.4 and IS NOT inclusive of all the data elements that are required according to this specification.  Other data elements that are required by the SIF Specification will also need to be provided with an appropriate mapping or default value.
ID Num. | Record Type | Element Name | Description | SIF Xpath Mapping | Notes and References | ExtendedElement | SIF Object
 | AC | ** METADATA **  EXCLUDE FROM STATE REPORTING | Flag that record should be excluded from State Reporting | SchoolCourseInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SchoolCourseInfoExtensions/ExcludeFromStateReporting  SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SectionInfoExtensions/ExcludeFromStateReporting | Used only for records to be excluded.  Will also exclude associated AM records.  * PREFERRED METHOD *  Agent doesn't publish records flagged for exclusion from state reporting.
UT.082 | AC | CIP CODE NUMBER | Where the concurrent enrollment course is taught | SchoolCourseInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SchoolCourseInfoExtensions/CIPCodeNumber
UT.088 | AC | COLLEGE GRANTING CR | The two character “district” number of the college granting the college credit portion of the concurrent enrollment course | SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SectionInfoExtensions/CollegeGranting
UT.085 | AC | CORE CODE | This is the 11 digit CORE CODE used in CACTUS | SchoolCourseInfo/StateCourseCode
UT.077 | AC | COURSE & SECTION | This is the unique alphanumeric course + section number that you are using to identify a class within the school | SchoolCourseInfo/CourseCode AND SectionInfo/CourseSectionCode  ** ALTERNATE MAPPING **  Agent provides combined value in either: SectionInfo/SectionCode  or SchoolCourseInfo/CourseCode (SectionInfo/CourseSectionCode must be blank). | Manifest will create a unique ID using these two fields, or will use agent-provided combined value if alternative mapping used.
UT.084 | AC | COURSE TITLE | This is the alpha-numeric course title that your school uses to describe the course | SchoolCourseInfo/CourseTitle
UT.092 | AC | CYCLE | A cycle is defined as a day or days that repeat the same school schedule | SectionInfo/ScheduleInfoList/ScheduleInfo/MeetingTimeList/MeetingTime/TimetableDay
UT.090 | AC | INSTRUCT SETTING | The primary setting or medium of delivery for the course | SectionInfo/MediumOfInstruction/OtherCodeList[@CodeSet='StateProvince']
UT.001 | AC | [NAME] | State-assigned LEA number.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.078 | AC | PERIOD | This is a two digit field indicating which period the class is being taught | SectionInfo/ScheduleInfoList/ScheduleInfo/MeetingTimeList/MeetingTime/TimetablePeriod
UT.003 | AC | SCHOOL NUMBER | Submitting school state-assigned number.  Must match School Number in SC records. | SchoolInfo/StateProvinceId | StudentSchoolEnrollment[@SchoolInfoRefId]
UT.083 | AC | SEMESTER LENGTH | 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 | TermInfo/TermSpan TermInfo/EndDate  *** ALTERNATIVE MAPPING ***  SchoolCourseInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/SchoolCourseInfoExtensions/SemesterLength | ScheduleInfoList/ScheduleInfo[@TermInfoRefId], TermInfo/TermSpan/Code Calculate USOE code using TermSpan Code and EndDate
UT.081 | AC | TEACHER 1 ID | Renamed 'TEACHER 1' to 'TEACHER 1 ID' for consistency with other Teacher Id fields.  This is the CACTUS ID of the TEACHER OF RECORD assigned to the class | StaffPersonal/StateProvinceId  *** ALTERNATIVE MAPPING ***  SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SectionInfoExtensions/Teacher1ID | SectionInfo/ScheduleInfoList/ScheduleInfo/TeacherList[1][@StaffPersonalRefId]  If StaffPersonal used, set VRF environment variableVrf.Target.usesStaffPersonal = true.
UT.086 | AC | TEACHER 2 ID | The CACTUS ID of a second teacher assigned to this course master record | StaffPersonal/StateProvinceId  *** ALTERNATIVE MAPPING ***  SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SectionInfoExtensions/Teacher2ID | SectionInfo/ScheduleInfoList/ScheduleInfo/TeacherList/@StaffPersonalRefId  If StaffPersonal used, set VRF environment variable Vrf.Target.usesStaffPersonal = true.
UT.087 | AC | TEACHER 3 ID | The CACTUS ID of a third teacher assigned to this course master record | StaffPersonal/StateProvinceId  *** ALTERNATIVE MAPPING ***  SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SectionInfoExtensions/Teacher3ID | SectionInfo/ScheduleInfoList/ScheduleInfo/TeacherList/@StaffPersonalRefId  If StaffPersonal used, set VRF environment variable Vrf.Target.usesStaffPersonal = true.
UT.091 | AC | TERM | This is the term the class is taught | TermInfo/TermCode  *** ALTERNATIVE MAPPING ***  SchoolCourseInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/SchoolCourseInfoExtensions/TermCode | ScheduleInfoList/ScheduleInfo[@TermInfoRefId]. Use translation to normalize to state codes
UT.089 | AC | WHERE TAUGHT CAMPUS | Where the concurrent enrollment course is taught | SectionInfo/LocationOfInstruction/Code | LocationOfInstruction/Code (NCES 0171). Use code 0342 for College, code 0340 or 0341 for High School, translate to Utah codes in Manifest.
UT.079 | AC | WHERE TAUGHT DIST | This field is to designate the LEA where the class is taught used in conjunction with WHERE TAUGHT SCHL | SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SectionInfoExtensions/WhereTaughtDist  ** ALTERNATIVE MAPPING **  SchoolCourseInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SchoolCourseInfoExtensions/WhereTaughtDist | If blank the submitting district is assumed
[NAME] | AC | WHERE TAUGHT SCHL | This field is to be used only if the class is taught at some other school | SectionInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SectionInfoExtensions/WhereTaughtSchl  ** ALTERNATIVE MAPPING **  SchoolCourseInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SchoolCourseInfoExtensions/WhereTaughtSchl | If blank, the submitting school is assumed
UT.097 | AM | ACTUAL MEMBERSHIP | Actual course membership, only required for CTE courses. | StudentSectionEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentSectionEnrollmentExtensions/CourseMembership
UT.098 | AM | CONCURR ENROLLED | Indicates whether or not the student is taking this class (deemed to be a concurrent enrollment class in the AC record) as a concurrent enrollment class for college credit or taking the class for just high school credit | StudentSectionEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentSectionEnrollmentExtensions/ConcurrEnrolled
UT.093 | AM | COURSE ENTRY DATE | This is the date the student first began instruction in the course | StudentSectionEnrollment/EntryDate
UT.094 | AM | COURSE EXIT DATE | This is the day following the last day of instruction in the course | StudentSectionEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentSectionEnrollmentExtensions/ReportedExitDate  *** ALTERNATE MAPPING ***  StudentSectionEnrollment/ExitDate | ExtendedElement value is day after last day of instruction.  Agent should write extended element if published ExitDate is last day of instruction.
UT.077 | AM | COURSE NUMBER | This is an eight digit numeric course + section number, must match COURSE SECTION on Course Master . | SchoolCourseInfo/CourseCode AND SectionInfo/CourseSectionCode  ** ALTERNATE MAPPING **  Agent provides combined value in either: SectionInfo/SectionCode  or SchoolCourseInfo/CourseCode (SectionInfo/CourseSectionCode must be blank). | Manifest will create a unique ID using these two fields, or will use agent-provided combined value if alternative mapping used.
UT.095 | AM | CREDITS ATTEMPTED | The amount of credit attempted for the period of time the “AM=” record represents | StudentSectionEnrollment/CreditsAttempted
UT.099 | AM | CREDITS EARNED | The amount of credit earned for the period of time the “AM” record represents | StudentGrade/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/StudentGradeExtensions/CreditsEarned  *** ALTERNATIVE MAPPING  ***  StudentSectionEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/StudentSectionEnrollmentExtensions/CreditsEarned | If [NAME] used, set VRF Environment Variable Vrf.Target.usesStudentGrade = 'true'
UT.096 | AM | GRADE EARNED | The grade the student earned for the period of time the “AM=” record represents | StudentGrade/Grade/Letter, StudentGrade/Grade/Percentage, StudentGrade/Grade/Numeric  *** ALTERNATIVE MAPPING ***  StudentSectionEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/StudentSectionEnrollmentExtensions/GradeEarned | If [NAME] used, set VRF Environment Variable Vrf.Target.usesStudentGrade = 'true'.  All three grade elements listed used to calculate reported value.  'F' in P/F context indicated by Percentage = 0 or blank.
UT.001 | AM | [NAME] | State-assigned LEA number.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.078 | AM | PERIOD | This is a two digit field indicating which period the class is being taught | SectionInfo/ScheduleInfoList/ScheduleInfo/MeetingTimeList/MeetingTime/TimetablePeriod
UT.003 | AM | SCHOOL NUMBER | Submitting school state-assigned number.  Must match School Number in SC records. | SchoolInfo/StateProvinceId | StudentSchoolEnrollment[@SchoolInfoRefId]
UT.009 | AM | STUDENT NUMBER | The LEA assigned student number | StudentPersonal/LocalId
UT.001 | DI | [NAME] | This can ONLY be a State assigned and approved LEA number | LEAInfo/StateProvinceId
UT.014 | ES | BIRTH DATE | Student’s birth date | StudentPersonal/Demographics/Birthdate
UT.012 | ES | FIRST NAME | Student’s first name | StudentPersonal/Name/FirstName
UT.015 | ES | GENDER | Student’s gender code | StudentPersonal/Demographics/Gender
UT.011 | ES | LAST NAME | Student’s last name | StudentPersonal/Name/LastName
UT.001 | ES | [NAME] | State-assigned LEA number.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.051 | ES | STATEWIDE STUDENT ID | The number assigned to the student using the Statewide Student Identifier | StudentPersonal/StateProvinceId
UT.009 | ES | STUDENT NUMBER | The LEA assigned student number | StudentPersonal/LocalId
UT.101 | I1 | GANG RELATED | Indicate if incident is gang related | DisciplineIncident/RelatedToList/RelatedTo | 3068=GangRelated (NCES 1048)
UT.102 | I1 | INCIDENT DATE | This is the date the incident occurred | DisciplineIncident/IncidentDate
UT.103 | I1 | INCIDENT DESCRIPTION | This is a description of the incident | DisciplineIncident/IncidentDescription
UT.100 | I1 | INCIDENT ID | Numeric value from 1 to 99999 inclusive and each incident record for a school must have a unique value here | DisciplineIncident/IncidentNumber
UT.001 | I1 | [NAME] | State-assigned LEA number.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.003 | I1 | SCHOOL NUMBER | Submitting school state-assigned number.  Must match School Number in SC records. | SchoolInfo/StateProvinceId | StudentSchoolEnrollment[@SchoolInfoRefId]
UT.114 | I2 | ALTERNATIVE PLACEMENT | Indicate if alternative placement was provided/administered to the student for this incident | DisciplineIncident/OffenderList/Offender/ActionList/Action/Code or DisciplineIncident/OffenderList/Offender/ActionList/Action/AlternativeEducation | If value = 3072-3075 (NCES 1054) or AlternativeEducation = 'Yes' then 'Y', otherwise 'N'
UT.104 | I2 | CAUSED INCIDENT | Indicate if this student was determined to have caused the incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/CausedIncident
UT.107 | I2 | DISCIPLINE METHOD | Indicate if this student was suspended or expelled | DisciplineIncident/OffenderList/Offender/ActionList/Action/Code | If value is 3086 or 3087 then 'E'; if 3099-3102 then 'S'; otherwise blank (NCES 1054)
UT.106 | I2 | GANG PREV PROG | Indicate if this student was part of a gang prevention program at the time of the incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/GangPrevProg
UT.115 | I2 | HEARING OFFICER REMOVAL | Indicate if removal of the student was done by a hearing officer | DisciplineIncident/OffenderList/Offender/ActionList/Action/Code | If value is 3158 then 'Y', otherwise 'N' (NCES 1054)
UT.109 | I2 | IN SCHOOL | Indicate if the DISCIPLINE METHOD was in school or out of school | DisciplineIncident/OffenderList/Offender/ActionList/Action/Code | If value is 3099 or 3100 then 'Y', otherwise 'N' (NCES 1054)
UT.100 | I2 | INCIDENT ID | Numeric value from 1 to 99999 inclusive and each incident association record must have a matching ‘I1’ record preceding it | DisciplineIncident/IncidentNumber
UT.105 | I2 | INJURED | Indicate if this student was injured in the incident | DisciplineIncident/OffenderList/Offender/Injury  or DisciplineIncident/VictimList/Victim/Injury | If value=3063, 3064, 3579, then 'Y'; if 3065 or null, then 'N' (NCES 1046); Serious Bodily Injury (3579) will be flagged accordingly
UT.001 | I2 | [NAME] | State-assigned LEA number.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.108 | I2 | NUMBER OF DAYS | The number of days the DISCIPLINE METHOD was in effect | DisciplineIncident/OffenderList/Offender/ActionList/Action/Duration
UT.116 | I2 | PI INFRACTION TYPE | The primary infraction type (or incident type) of the student in this incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/InfractionType and IncidentInvolvementList/IncidentInvolvement/InvolvementType | Where sibling element /IncidentInvolvement/InvolvementType = 'Primary'
UT.118 | I2 | PI ROLE | The primary role of the student in this incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/Role | Where sibling element /IncidentInvolvement/InvolvementType = 'Primary'
UT.117 | I2 | PI WEAPON | The primary weapon used in the incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/WeaponType | Where sibling element /IncidentInvolvement/InvolvementType = 'Primary'
UT.112 | I2 | REFERRED TO COURT | Indicate if the incident was referred to court | DisciplineIncident/OffenderList/Offender/ActionList/Action/Code | If value is 3088 or 3089 then 'Y', otherwise 'N' (NCES 1054)
UT.111 | I2 | REFERRED TO POLICE | Indicate if the incident was referred to police | DisciplineIncident/OffenderList/Offender/ActionList/Action/PoliceNotification
UT.113 | I2 | REFERRED TO PROGRAM | Indicate if the incident was referred to a program | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ReferredToProgram
UT.003 | I2 | SCHOOL NUMBER | Submitting school state-assigned number.  Must match School Number in SC records. | SchoolInfo/StateProvinceId | StudentSchoolEnrollment[@SchoolInfoRefId]
UT.110 | I2 | SERVICES OFFERED | Indicate if services were offered to the student | DisciplineIncident/OffenderList/Offender/ActionList/Action/Code | If value is 3086 or 3101 then 'Y' otherwise 'N' (NECS 1054).
UT.119 | I2 | SI1 INFRACTION TYPE | Indicate a secondary infraction type (or incident type) of the student in this incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/InfractionType | First record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary1'
UT.121 | I2 | SI1 ROLE | Indicate a secondary role of the student in this incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/Role | First record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary1'
UT.120 | I2 | SI1 WEAPON | Indicate a secondary weapon used in the incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/WeaponType | First record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary1'
UT.122 | I2 | SI2 INFRACTION TYPE | Indicate another secondary infraction type (or incident type) of the student in this incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/InfractionType | Second record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary2'
UT.124 | I2 | SI2 ROLE | Indicate another secondary role of the student in this incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/Role | Second record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary2'
UT.123 | I2 | [NAME] | Indicate another secondary weapon used in the incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/WeaponType | Second record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary2'
UT.125 | I2 | SI3 INFRACTION TYPE | Indicate another secondary infraction type (or incident type) of the student in this incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/InfractionType | Third record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary3'
UT.127 | I2 | SI3 ROLE | Indicate another secondary role of the student in this incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/Role | Third record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary3'
UT.126 | I2 | SI3 WEAPON | Indicate another secondary weapon used in the incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/WeaponType | Third record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary3'
UT.128 | I2 | SI4 INFRACTION TYPE | Indicate another secondary infraction type (or incident type) of the student in this incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/InfractionType | Fourth record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary4'
UT.130 | I2 | SI4 ROLE | Indicate another secondary role of the student in this incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/Role | Fourth record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary4'
UT.129 | I2 | SI4 WEAPON | Indicate another secondary weapon used in the incident | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/ IncidentInvolvementList/IncidentInvolvement/WeaponType | Fourth record where sibling element /IncidentInvolvement/InvolvementType = 'Secondary4'
UT.009 | I2 | STUDENT NUMBER | The LEA assigned student number | StudentPersonal/LocalId where StudentPersonalRefId = DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/StudentPersonalRefId | DisciplineIncident/OffenderList/Offender[@SIF_RefId], [@SIF_RefObject='StudentPersonal'] ** Note…Will match either DisciplineIncident/OffenderList/Offender[@SIF_RefId] or DisciplineIncident/VictimList/Victim[@SIF_RefId], [@SIF_RefObject='StudentPersonal'] **
UT.211 | I2 | CAUSED SERIOUS BODILY INJURY | Indicate if this student was determined to have caused serious bodily injury | DisciplineIncident/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ DisciplineIncidentExtensions/StudentParticipantList/StudentParticipant/CausedSeriousBodilyInjury
N/A | S1 | ** METADATA **  EXCLUDE FROM STATE REPORTING | Flag that record should be excluded from State Reporting | SchoolInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SchoolInfoExtensions/ExcludeFromStateReporting  StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/ExcludeFromStateReporting  StudentSchoolEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentSchoolEnrollmentExtensions/ExcludeFromStateReporting | Used only for records to be excluded.  Will also exclude associated records. SchoolInfo: SC, S1, AC, AM StudentPersonal: S1, S2, S3, AM StudentSchoolEnrollment:  AM  * PREFERRED METHOD *  Agent doesn't publish records flagged for exclusion from state reporting.
UT.048 | S1 | 504 SERVICES | The student received services under Section 504 of the Rehabilitation Act of 1973 | StudentPersonal/Section504
UT.061 | S1 | ACCOMPANIED STUDENT | Indicate if the student was accompanied by a parent/guardian for selecting the HOME STATUS field value. | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/AccompaniedStudent
UT.017 | S1 | AMER INDIAN/ALASKAN NATIVE | Is this student a person having origins in any of the original peoples of North and South America | StudentPersonal/Demographics/RaceList
UT.018 | S1 | ASIAN | Is this student a person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent | StudentPersonal/Demographics/RaceList
UT.014 | S1 | BIRTH DATE | Student’s birth date | StudentPersonal/Demographics/Birthdate
[NAME] | S1 | BLACK OR AFRICAN AMER | Is this student a person having origins in any of the black racial groups of Africa | StudentPersonal/Demographics/RaceList
UT.029 | S1 | CONCENTRATOR | Concentrator Code. This is a six digit numeric field requested for students in Career and Technical Education (CTE) programs | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/CTEProgramArea | Used for manifest validations only
UT.052 | S1 | CUMULATIVE GPA | Cumulative GPA to three decimal places as you would provide it to a college when a student requests that a transcript be sent to an admissions office | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/CumulativeGPA
UT.188 | S1 | DAYS ATTENDED | This represents the sum of days attended by the student in both regular (S1) and self-contained special education and youth-in-custody  (some S2 & S3) settings and should be reported in 180 day equivalent days. | StudentAttendanceSummary/DaysAttended  If StudentAttendanceSummary record is associated with a specific StudentSchoolEnrollment, then StudentAttendanceSummary/StudentSchoolEnrollmentRefId must be populated.  *** ALTERNATIVE MAPPING ***  StudentSchoolEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions]/StudentSchoolEnrollmentExtensions/DaysAttended | Value is Equivalent Days prorated for FTE.  See VRF Environment Variable Notes on SIF Objects List tab: Vrf.Property.ProrateMembershipDays
UT.046 | S1 | DISTRICT OF RESIDENCE | Intended use is for LEAs with numbers other than 01-40, 42, such as charter schools.  This is the REGULAR district number (01-40, 42) of the district in which the PERMANENT address of the student is located. | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/DistrictOfResidence
UT.034 | S1 | ECONOMIC DISADV | This code identifies the status of students with respect to “economic disadvantage” | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/MealStatus (preferred)  *** Alternate Mapping***  StudentPersonal/EconomicDisadvantage | Alternate mapping provides only Yes/No, translated to 'Y' or blank.  Extended element required for full 'F', 'R', 'Y' code set.
UT.049 | S1 | ELL INSTRUCTION TYPE | The type of ELL instruction the student receives | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/ELLInstructionType
UT.043 | S1 | ELL MONITORED ENTRY DATE | The date the ELL student was advanced to LIMITED ENGLISH code ‘F’ (Former ELL student – exited an ELL program and entered monitoring) | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/ELLMonitoredDate
UT.041 | S1 | [NAME] | Native or first language of student | StudentPersonal/Demographics/LanguageList/Language/LanguageType AND StudentPersonal/Demographics/LanguageList/Language/OtherCodeList[@CodeSet='StateProvince']        ** or (alternate) ** StudentPersonal/Demographics/LanguageList/Language/Code | Uses Language/Code WHERE Language/LanguageType=1038.  OtherCode preferred.
UT.042 | S1 | ELL PARENT LANGUAGE | Language which parent(s) of student prefer in communication with the school | StudentPersonal/Demographics/LanguageList/Language/LanguageType AND StudentPersonal/Demographics/LanguageList/Language/OtherCodeList[@CodeSet='StateProvince']        ** or (alternate) ** StudentPersonal/Demographics/LanguageList/Language/Code | Uses Language/Code WHERE Language/LanguageType=1037  OtherCode preferred.
UT.023 | S1 | ENTRY DATE | Date the student entered school | StudentSchoolEnrollment/EntryDate
UT.016 | S1 | ETHNICITY | Is this student a person of Cuban, Mexican, Puerto Rican, South or Central America, or other Spanish culture or origin | StudentPersonal/Demographics/HispanicLatino
UT.025 | S1 | EXIT CODE | This code identifies the reason for the above exit date | StudentSchoolEnrollment/ExitType/OtherCodeList/OtherCode[@Codeset='StateProvince']
UT.024 | S1 | EXIT DATE | Day following the last day of school attendance. | StudentSchoolEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentSchoolEnrollmentExtensions/ReportedExitDate  *** ALTERNATE MAPPING ***  StudentSchoolEnrollment/ExitDate | ExtendedElement value is day after last day of attendance.  Agent should write extended element if published ExitDate is last day of attendance.
UT.040 | S1 | FIRST ENROLL IN US | If the student was born outside of the United States, enter the date of the student’s first enrollment in a school in the United States | StudentPersonal/FirstUSEnrollment
UT.012 | S1 | FIRST NAME | Student’s first name as it appears on his/her birth certificate | StudentPersonal/Name/FirstName
UT.015 | S1 | GENDER | Student’s gender code | StudentPersonal/Demographics/Gender
UT.047 | S1 | GIFTED | Indicates if the student was identified by the local education agency as being eligible for participation in a program for the gifted and talented | StudentPersonal/GiftedTalented
UT.022 | S1 | GRADE LEVEL | Student’s current grade level | StudentSchoolEnrollment/GradeLevel (preferred mapping)   *** ALTERNATIVE MAPPING *** StudentPersonal/MostRecent/GradeLevel | Alternative usually OK, but does not report multiple grade levels in the school year.
UT.020 | S1 | HAWAIIAN / PACIFIC ISL | Is this student a person having origins in any of the original peoples of Hawaii, Guam, Samoa, Tonga, or other Pacific Island | StudentPersonal/Demographics/RaceList
UT.027 | S1 | HIGH SCHL COMPL STATUS | All students who are seniors (GRADE LEVEL = 12), the school submitted under is his/her school of record, and is NOT exited must have one of the following codes indicating the final outcome of their schooling as of July 15 | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/HighSchlComplStatus | GR, G1, G2, G3, GM, GC, GG, CT, RT, GP, AO, DO (see lookup values sheet)
UT.039 | S1 | HOMELESS | Student’s homeless status | StudentPersonal/Demographics/DwellingArrangement/OtherCodeList[@CodeSet='StateProvince']
UT.057 | S1 | IMMIGRANT | Indicate the student is an immigrant if the student meets all three of the following conditions: Age is 3-21, Not born in any State, Has not attended one or more schools in any State for more than 3 full academic years | StudentPersonal/Immigrant
UT.054 | S1 | KINDERGARTEN TYPE | Identifies if [NAME] students participated in an extended [NAME] program (regardless of funding source), and which type of program | StudentSchoolEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentSchoolEnrollmentExtensions/KindergartenType
UT.011 | S1 | LAST NAME | Student’s last name as it appears on his/her birth certificate | StudentPersonal/Name/LastName
UT.001 | S1 | [NAME] | State-assigned LEA number.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.033 | S1 | LIMITED ENGLISH | This code identifies the student’s English Language Learner (ELL) status | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/LimitedEnglish
UT.045 | S1 | MESA PROGRAM | Identifies the degree of student involvement in the MESA (Math, Engineering, Science Achievement) program during the year | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/MESAProgram
UT.013 | S1 | MIDDLE NAME | Student’s middle name or initial as it appears on his/her birth certificate | StudentPersonal/Name/MiddleName
UT.037 | S1 | MIGRANT | A migrant student is a student who enrolled during the year AND has a Certificate of Eligibility (COE) form on file in the LEA | StudentPersonal/Migrant
UT.055 | S1 | MILITARY CHILD | “Military child” means a child enrolled in kindergarten through grade 12 who is legally residing in the household of an active duty service member or whose parent or legal guardian is an active duty service member. | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/MilitaryChild
[NAME] | S1 | NCLB SCHOOL CHOICE | Indicates whether the student is enrolled in this school, outside of their assigned attendance area, by choice under the provisions of NCLB Title I Part A | StudentSchoolEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentSchoolEnrollmentExtensions/NCLBSchoolChoice
UT.185 | S1 | NCLB SUPP SERV LANG | Indicates whether the student received supplemental services in Language Arts, funded out of the LEA's NCLB Title I Part A allocation, by identifying the approved provider of that service | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/NCLBSuppServLang
UT.186 | S1 | NCLB SUPP SERV MATH | Indicates whether the student received supplemental services in Mathematics, funded out of the LEA's NCLB Title I Part A allocation, by identifying the approved provider of that service | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/NCLSSuppServMath
UT.028 | S1 | PART-TIME HOME SCHOOL | This is for indicating the status of a student who is enrolled for only part of the school day | StudentSchoolEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentSchoolEnrollmentExtensions/PartTimeHomeSchool
UT.036 | S1 | PHONE NUMBER | This is the 3 digit area code plus the 7 digit student home phone number | StudentPersonal/PhoneNumberList/PhoneNumber
UT.060 | S1 | RACE OBSERVER ID | Indicate if the student’s RACE was determined by observer identification | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/RaceObserved
UT.058 | S1 | READ GRADE LEVEL | For grades 1-3 indicate if the student is reading on grade level | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/ReadGradeLevel
UT.059 | S1 | READING INTERVENTION | Indicate if the student is receiving or has received reading intervention | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/ReadingIntervention
UT.056 | S1 | REFUGEE STUDENT | Identifies the student as having refugee status | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/RefugeeStudent
UT.035 | S1 | RESIDENT STATUS | This code identifies the resident status of all students | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/ResidentStatus
UT.189 | S1 | SCHOOL MEMBERSHIP | Regular student aggregated school membership, using 180-equivalent days. | StudentAttendanceSummary/DaysInMembership  If StudentAttendanceSummary record is associated with a specific StudentSchoolEnrollment, then StudentAttendanceSummary/StudentSchoolEnrollmentRefId must be populated.  *** ALTERNATIVE MAPPING ***  StudentSchoolEnrollment/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions]/StudentSchoolEnrollmentExtensions/DaysInMembership | Value is Equivalent Days prorated for FTE.  See VRF Environment Variable Notes on SIF Objects List tab: Vrf.Property.ProrateMembershipDays, Vrf.Property.SubtractSIFProgramDays.
UT.003 | S1 | SCHOOL NUMBER | The “SC” record this “S1” follows is the ONE school to which data should be attributed for the student | SchoolInfo/StateProvinceId | StudentSchoolEnrollment[@SchoolInfoRefId]
UT.192 | S1 | SCHOOL OF RECORD | The “SC” record this “S1” follows is the ONE school to which data should be attributed for the student | StudentSchoolEnrollment[@MembershipType] | Blank when MembershipType='Home', otherwise 'N'
UT.010 | S1 | SOC. SEC. NUMBER | This is the student’s 9 digit Social Security Number | StudentPersonal/OtherIdList/OtherId[@Type='0004']
UT.053 | S1 | SPECIAL ED EXIT DATE | The date the student in special education has completely exited from all special education services | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/SpecialEdExitDate
UT.051 | S1 | STATEWIDE STUDENT ID | The number assigned to the student using the Statewide Student Identifier | StudentPersonal/StateProvinceId
UT.009 | S1 | STUDENT NUMBER | The school assigned student number | StudentPersonal/LocalId
UT.044 | S1 | STUDENT ZIP CODE | First 5 digits of the zip code of the address at which the student resides | StudentPersonal/AddressList/Address[@Type='0765']/PostalCode
UT.032 | S1 | [NAME] | This code indicates the Indian tribal affiliation of students | StudentPersonal/Demographics/RaceList/Race/OtherCodeList[@CodeSet='StateProvince']
UT.030 | S1 | VOC-ACADEM DISADV | Used to identify Vocational Academically Disadvantaged students | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/CumulativeGPA | Use CumulativeGPA value to determine
UT.021 | S1 | WHITE | Is this student a person having origins in any of the original peoples of the Europe, the Middle East, or North Africa | StudentPersonal/Demographics/RaceList
UT.210 | S1 | EARLY GRADUATE | Indicates that the student intends to graduate early in accordance with their SEOP | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/EarlyGrad |  | 1
UT.208 | S1 | READ GRADE LEVEL FALL | For grades 1-3 indicate if the student is reading on grade level | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/ReadGradeLevelFall
UT.209 | S1 | READ GRADE LEVEL SPRING | For grades 1-3 indicate if the student is reading on grade level | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/ReadGradeLevelSpring
UT.062 | S2 | DISABILITY TYPE | Identifies the type of disability for which the student is receiving Special education services | StudentParticipation/ExceptionalityCategories/ExceptionalityCategory/Code
UT.069 | S2 | ENVIRONMENT | Identifies the type of educational setting in which the student receives special education services | StudentParticipation/LeastRestrictiveEnvironment/OtherCodeList[@CodeSet='StateProvince']
UT.001 | S2 | [NAME] | State-assigned LEA number.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.068 | S2 | REGULAR PERCENT | Summarizes the amount of time the student is in a regular education class | StudentParticipation/StudentSpecialEducationFTE
UT.003 | S2 | SCHOOL NUMBER | Submitting school state-assigned number.  Must match School Number in SC records. | SchoolInfo/StateProvinceId | StudentParticipation/ ManagingSchool (preferred) or StudentSchoolEnrollment [@SchoolInfoRefId]
UT.064 | S2 | SCRAM ENTRY DATE | This is the date the student first began receiving Special education related services | StudentParticipation/ProgramPlacementDate
UT.065 | S2 | SCRAM EXIT DATE | This is the day following the last day the student received special education related services for a particular handicapping condition | StudentParticipation/ProgramExitDate
UT.066 | S2 | SCRAM EXIT REASON | This code identifies the reason this student exited special education related services | StudentParticipation/ProgramExitReason/OtherCodeList[@CodeSet='StateProvince']
UT.190 | S2 | SCRAM MEMBERSHIP | SCRAM aggregated membership, equivalent days. | StudentParticipation/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentParticipationExtensions/DaysInMembership | ExtendedElement value is Equivalent Days, prorated for FTE.  If self-contained program membership days are included in School Membership, set VRF environment variable Vrf.Property.SubtractSIFProgramDays = true.
UT.063 | S2 | SCRAM TIME | TIME' field renamed to 'SCRAM TIME'.  Summarizes the amount of time the student is served | StudentParticipation/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentParticipationExtensions/TimeCode
UT.009 | S2 | STUDENT NUMBER | The LEA assigned student number | StudentPersonal/LocalId
UT.070 | S3 | CUSTODY TYPE | Identifies the type of custody under which the student is receiving services | StudentParticipation/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentParticipationExtensions/CustodyType
UT.072 | S3 | ENVIRONMENT | Identifies the type of educational setting in which the student receives youth in custody related services | StudentParticipation/LeastRestrictiveEnvironment/OtherCodeList[@CodeSet='StateProvince']
UT.001 | S3 | [NAME] | State-assigned LEA number.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.003 | S3 | SCHOOL NUMBER | Submitting school state-assigned number.  Must match School Number in SC records. | SchoolInfo/StateProvinceId | StudentParticipation/ ManagingSchool (preferred) or StudentSchoolEnrollment [@SchoolInfoRefId]
UT.009 | S3 | STUDENT NUMBER | The LEA assigned student number | StudentPersonal/LocalId
UT.073 | S3 | YIC ENTRY DATE | This is the date the student first began receiving YIC related services for this CUSTODY TYPE and TIME | StudentParticipation/ProgramPlacementDate
UT.074 | S3 | YIC EXIT DATE | This is the day following the last day the student received YIC related services for a particular CUSTODY TYPE and TIME | StudentParticipation/ProgramExitDate
UT.075 | S3 | YIC EXIT REASON | This code identifies the reason this student exited YIC related services | StudentParticipation/ProgramExitReason/OtherCodeList[@CodeSet='StateProvince']
UT.191 | S3 | YIC MEMBERSHIP | YIC aggregated membership, equivalent days. | StudentParticipation/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentParticipationExtensions/DaysInMembership | ExtendedElement value is Equivalent Days, prorated for FTE.  If self-contained program membership days are included in School Membership, set VRF environment variable Vrf.Property.SubtractSIFProgramDays = true.
UT.071 | S3 | YIC TIME | TIME' field renamed to 'YIC TIME'.  Summarizes the amount of time the student is served | StudentParticipation/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentParticipationExtensions/TimeCode
N/A | SC | ** METADATA **  EXCLUDE FROM STATE REPORTING | Flag that record should be excluded from State Reporting | SchoolInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SchoolInfoExtensions/ExcludeFromStateReporting | Used only for records to be excluded.  Will also exclude associated S1, AC, and AM records.  * PREFERRED METHOD *  Agent doesn't publish records flagged for exclusion from state reporting.
UT.004 | SC | DAYS IN SCHOOL YEAR | The total number of days the school was in session with classroom instruction being conducted. | CalendarSummary/DaysInSession
UT.005 | SC | LAST DAY OF SCHOOL | The last day the school is in session (current school year) | CalendarSummary/LastInstructionDate
UT.007 | SC | SCHEDULE DAY TYPE | The type of daily schedule | SchoolInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ SchoolInfoExtensions/ScheduleDayType
UT.006 | SC | SCHEDULE YEAR TYPE | The type of yearly schedule | SchoolInfo/SessionType
UT.003 | SC | SCHOOL NUMBER | This can ONLY be a State assigned and approved school number. | SchoolInfo/StateProvinceId | StudentSchoolEnrollment[@SchoolInfoRefId]
UT.014 | SLF | BIRTH DATE | Students birth date | StudentPersonal/Demographics/Birthdate
UT.015 | SLF | GENDER | Student Gender M/F | StudentPersonal/Demographics/Gender
UT.001 | SLF | [NAME] | State-assigned LEA number. | LEAInfo/StateProvinceId
UT.003 | SLF | [NAME] NUMBER | Requesting schools state-assigned school number | SchoolInfo/StateProvinceId
UT.009 | SLF | [NAME] NUMBER | Students [NAME] assigned student number | StudentPersonal/LocalId
UT.012 | SLF | LEGAL FIRST NAME | Student First Name | StudentPersonal/Name/FirstName
UT.011 | SLF | LEGAL LAST NAME | Student’s last name as it appears on his/her birth certificate | StudentPersonal/Name/LastName
UT.013 | SLF | LEGAL MIDDLE NAME | Student Middle Name | StudentPersonal/Name/MiddleName
UT.002 | SLF | SCHOOL YEAR | School year for which this enrollment is applicable. Expressed as the four-digit-year in which the school year ends (e.g. 2011 for the 2010-11 school year | StudentSchoolEnrollment[@SchoolYear]
UT.051 | SLF | SSID | The number assigned to the student using the Statewide Student Identifier | StudentPersonal/StateProvinceId
N/A | ST, TA, TC, TG | *** METADATA NOTE *** |  |  | If SIF agent supports SIF_Query grade level constraint on SRE objects, set VRF Environment Variables Vrf.Target.usesSREGradeLevelSIFQuery = 'true' and Vrf.Target.skipsSREGradeLevelSIFQuery = 'false'.
UT.182 | ST | ADDRESS CITY | City of Student's permanent address | StudentPersonal/AddressList/Address[@Type='0765']/City
UT.184 | ST | ADDRESS COUNTRY | Country code of Student's permanent address if not US | StudentPersonal/AddressList/Address[@Type='0765']/Country
UT.180 | ST | ADDRESS LINE 1 | First 32 characters of Student's permanent address line 1 | StudentPersonal/AddressList/Address[@Type='0765']/Street/Line1
UT.181 | ST | ADDRESS LINE 2 | First 32 characters of Student's permanent address line 2 | StudentPersonal/AddressList/Address[@Type='0765']/Street/Line2
UT.183 | ST | ADDRESS STATE CODE | State/Province code of Student's permanent address if not Utah | StudentPersonal/AddressList/Address[@Type='0765']/StateProvince
UT.165 | ST | CLASS RANK | The rank order number of the student compared to other students in the grade level based on GPA. | StudentAcademicRecord/AcademicPerformanceSummary/ClassRank
UT.166 | ST | COHORT SIZE | The total number of students in the grade level to compare students against. | StudentAcademicRecord/AcademicPerformanceSummary/ClassTotalNumber
UT.159 | ST | CUMULATIVE CREDITS | The number of credits or credit hours that the student has earned to the present time. | StudentAcademicRecord/AcademicPerformanceSummary/TotalCreditsEarned | Manifest will calculate by summing all Credit Earned for all Courses if this data is not published by the SIS
UT.160 | ST | CUMULATIVE GPA CREDITS | The number of credits or credit hours used to calculate the GPA that the student has earned to the present time. | StudentAcademicRecord/AcademicPerformanceSummary/CumulativeGPACreditsEarned
UT.206 | ST | DIPLOMA TYPE | The type of diploma the student earned | StudentAcademicRecod/AcademicPerformanceSummary/GraduationDiplomaType | Required if graduated. Basic, GED, [NAME], or Certificate of Completion
UT.187 | ST | EXPECTED GRADUATION DATE | If the student has graduated, the graduation date; if the student is yet to graduate, the expected graduation date. | StudentAcademicRecord/AcademicPerformanceSummary/ProjectedGraduationDate
UT.171 | ST | GRADE 10 CREDITS EARNED | The number of credits the student earned during the 10th grade. | StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/CreditsEarned | Where : StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/GradeLevelWhenTaken = "10"  Manifest will calculate by summing all CourseCredits earned by SchoolYear if this data is not published by the SIS
UT.172 | ST | GRADE 10 GPA | The average of the grade points the student earned during the 10th grade. | StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/GPA
UT.174 | ST | GRADE 11 CREDITS EARNED | The number of credits the student earned during the 11th grade. | StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/CreditsEarned | Where : StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/GradeLevelWhenTaken = "11"  Manifest will calculate by summing all CourseCredits earned by SchoolYear if this data is not published by the SIS
UT.175 | ST | GRADE 11 GPA | The average of the grade points the student earned during the 11th grade. | StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/GPA
UT.177 | ST | GRADE 12 CREDITS EARNED | The number of credits the student earned during the 12th grade. | StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/CreditsEarned | Where : StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/GradeLevelWhenTaken = "12"  Manifest will calculate by summing all CourseCredits earned by SchoolYear if this data is not published by the SIS
UT.178 | ST | GRADE 12 GPA | The average of the grade points the student earned during the 12th grade. | StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/GPA
UT.168 | ST | GRADE 9 CREDITS EARNED | The number of credits the student earned during the 9th grade. | StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/CreditsEarned | Where : StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/GradeLevelWhenTaken = "9"  Manifest will calculate by summing all CourseCredits earned by SchoolYear if this data is not published by the SIS
UT.169 | ST | GRADE 9 GPA | The average of the grade points the student earned during the 9th grade. | StudentAcademicRecord/AcademicPerformanceHistory/TermPerformance/GPA
UT.158 | ST | GRADUATION DATE | The student's graduation date, month and year only.  Blank if not yet graduated. | StudentAcademicRecord/AcademicPerformanceSummary/GraduationDate
UT.027 | ST | HIGH SCHL COMPL STATUS | All students who are seniors (GRADE LEVEL = 12), the school submitted under is his/her school of record, and is NOT exited must have one of the following codes indicating the final outcome of their schooling as of July 15 | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/HighSchlComplStatus
UT.008 | ST | [NAME] | The name of the District or Charter School that is generating the transcript. | LEAInfo/LEAName
UT.001 | ST | [NAME] | State-assigned LEA number for submitting school.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.167 | ST | PERCENTILE RANK | The student's percentile based upon student class rank and the number of students. | StudentAcademicRecord/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentAcademicRecordExtensions/PercentileRank | Optional. Manifest will calculate if not provided
UT.195 | ST | SCHOOL ADDRESS | The address of the transcripting school | SchoolInfo/AddressList/Address[@Type='0765]/Street/Line1
[NAME] | ST | SCHOOL CITY | The city of the transcripting school | SchoolInfo/AddressList/Address[@Type='0765]/City
UT.207 | ST | SCHOOL CODE (CEEB) | The school CEEBACT code, maintained by the College Board | SchoolInfo/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/SchoolInfoExtensions/CEEBCode | Optional
UT.194 | ST | SCHOOL NAME | The name of the school that is generating the transcript (transcripting school) | SchoolInfo/SchoolName
UT.003 | ST | SCHOOL NUMBER | State-assigned number for school submitting record.  Must match School Number on S1 record where school is student's school of record. | SchoolInfo/StateProvinceId | StudentSchoolEnrollment[@SchoolInfoRefId]
UT.199 | ST | SCHOOL PHONE | The phone number of the transcripting school | SchoolInfo/PhoneNumberList/PhoneNumber[@Type='0096']/Number
UT.197 | ST | SCHOOL STATE | The state of the transcripting school | SchoolInfo/AddressList/Address[@Type='0765]/StateProvince
UT.198 | ST | SCHOOL ZIP | The zip code of the transcripting school | SchoolInfo/AddressList/Address[@Type='0765]/PostalCode
UT.157 | ST | STUDENT ENTRY DATE | The student's entry date into high school. | StudentAcademicRecord/EnrollmentHistory/StudentSchoolEnrollmentData/EntryDate | Optional Element. Where : StudentAcademicRecord/EnrollmentHistory/StudentSchoolEnrollmentData/GradeLevel = "9"
UT.026 | ST | STUDENT EXIT DATE | The students exit date from high school | StudentPersonal/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentPersonalExtensions/HighSchoolExitDate | Optional Element
UT.009 | ST | STUDENT NUMBER | Student's locally-assigned unique ID.  Must match [NAME] record, follow same formatting rules. | StudentPersonal/LocalId | Optional Element
UT.204 | ST | STUDENT PARENT/GUARDIAN FIRST NAME | The first name of the student's parent or guardian | StudentDemographicRecord/StudentContactSummary/ParentGuardian1/Name[@Type='04']/FirstName
UT.205 | ST | STUDENT PARENT/GUARDIAN LAST NAME | The last name of the student's parent or guardian | StudentDemographicRecord/StudentContactSummary/ParentGuardian1/Name[@Type='04']/LastName
UT.202 | ST | STUDENT UN-WEIGHTED GPA | The un-weighted grade point average the student has earned up to the time the transcript was generated | StudentAcademicRecord/AcademicPerformanceSummary/CumulativeGPA
UT.203 | ST | STUDENT WEIGHTED GPA | The weighted grade point average the student has earned up to the time the transcript was generated | StudentAcademicRecord/SIF_ExtendedElements/SIF_ExtendedElement[@Name='UTExtensions']/ StudentAcademicRecordExtensions/WeightedGPA | Optional Element
UT.161 | ST | TOTAL CREDITS ATTEMPTED | The number of credits that the student has attempted to take. | StudentAcademicRecord/AcademicPerformanceSummary/TotalCreditsAttempted | Manifest will calculate by summing all Credits Attempted for all Courses if this data is not published by the SIS
UT.164 | ST | TOTAL GPA POINTS | The weighted average total of the student's credits multiplied by the student's decimal grade equivalent values. | StudentAcademicRecord/AcademicPerformanceSummary/CumulativeGradePoints
UT.149 | TA | DATE | Date the assessment was administered | StudentAcademicRecord/AssessmentPerformanceHistory/Assessment/AdministrationDate
UT.150 | TA | FORM | Form, version, or edition of the test (if applicable) | StudentAcademicRecord/AssessmentPerformanceHistory/Assessment/Form
UT.152 | TA | GRADE LEVEL | Student's grade level when assessed | StudentAcademicRecord/AssessmentPerformanceHistory/Assessment/StudentGradeLevelWhenAssessed
UT.001 | TA | [NAME] | State-assigned LEA number for submitting school.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.151 | TA | LEVEL | Level of the test (if applicable) | StudentAcademicRecord/AssessmentPerformanceHistory/Assessment/Level
UT.003 | TA | SCHOOL NUMBER | State-assigned number for school submitting record.  Must match School Number on S1 record where school is student's school of record. | SchoolInfo/StateProvinceId | StudentSchoolEnrollment[@SchoolInfoRefId]
UT.155 | TA | SCORE | Test score reported | StudentAcademicRecord/AssessmentPerformanceHistory/Assessment/TestScore
UT.154 | TA | SCORE TYPE | Type of score, using NCES 0056 values | StudentAcademicRecord/AssessmentPerformanceHistory/Assessment/TestScoreType
UT.009 | TA | STUDENT NUMBER | Student's locally-assigned unique ID.  Must match [NAME] record, follow same formatting rules. | StudentPersonal/LocalId
UT.153 | TA | SUBTEST | The subtest or subject category of the assessment, e.g. 'English' or 'Composite' | StudentAcademicRecord/AssessmentPerformanceHistory/Assessment/SubTestCategory | ACT - (Composite, English, Math, Reading, Science) SAT - (Writing, Math, Critical Reading, Science)  AP - (Any)
UT.148 | TA | TEST NAME | Assessment name, e.g. 'American College Test' as recorded in the SIS | StudentAcademicRecord/AssessmentPerformanceHistory/Assessment/Name | Manifest will only report ACT, SAT, and AP tests
UT.134 | TC | CORE CODE | State Core code for Utah public school courses or if one assigned for transfer courses, otherwise blank.  This is the same type of code as the Core Code in AC records. | StudentAcademicRecord/CourseHistory/Term/Courses/Course/SchoolCourseInfoData/StateCourseCode
UT.132 | TC | COURSE NUMBER | Local course number if available.  Corresponds to first part of COURSE NUMBER in AM record. | StudentAcademicRecord/CourseHistory/Term/Courses/Course/SchoolCourseInfoData/CourseCode | Optional element
UT.141 | TC | COURSE SCHOOL CITY | Name of city that school was in where course was taken. | StudentAcademicRecord/SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/AddressList/Address/City
UT.139 | TC | COURSE SCHOOL NAME | School name where course was taken | StudentAcademicRecord/SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/SchoolName
UT.140 | TC | COURSE SCHOOL NCES ID | School NCES Id where course was taken | StudentAcademicRecord/SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/SchoolNCESId
UT.142 | TC | COURSE SCHOOL STATE | Code for state or province that school was in where course was taken | StudentAcademicRecord/SchoolAttendanceHistory/SchoolAttended/SchoolInfoData/AddressList/Address/State
UT.133 | TC | COURSE TITLE | Title of course, up to 20 characters.  Use course title as found in SIS. | StudentAcademicRecord/CourseHistory/Term/Courses/Course/SchoolCourseInfoData/CourseTitle
UT.136 | TC | CREDITS ATTEMPTED | Credits attempted by the student (potential credits) | StudentAcademicRecord/CourseHistory/Term/Courses/Course/MarkingPeriods/MarkingPeriod/CourseCreditsAttempted
UT.135 | TC | CREDITS EARNED | Credits actually earned for the course. | StudentAcademicRecord/CourseHistory/Term/Courses/Course/MarkingPeriods/MarkingPeriod/CourseCreditsEarned | This value is calculated in the manifest by totaling credits received from all marking periods for a specific course
UT.193 | TC | GRADE LEVEL | Student grade level when course was taken | StudentAcademicRecord/CourseHistory/Term/Courses/Course/MarkingPeriods/MarkingPeriod/GradeLevelWhenTaken
UT.001 | TC | [NAME] | State-assigned LEA number.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.003 | TC | SCHOOL NUMBER | State-assigned number for school submitting record.  Must match School Number on S1 record where school is student's school of record. | SchoolInfo/StateProvinceId | StudentSchoolEnrollment[@SchoolInfoRefId]
UT.137 | TC | SCHOOL YEAR | School year course was taken, designated by ending year (e.g. '2011' for the 2010-2011 school year). | StudentAcademicRecord/CourseHistory/Term/TermInfoData/SchoolYear
UT.009 | TC | STUDENT NUMBER | Student's locally-assigned unique ID.  Must match [NAME] record, follow same formatting rules. | StudentPersonal/LocalId
UT.144 | TG | CREDIT EARNED | Course credit value associated with this grade.  As recorded in SIS or portion of total course credit. | StudentAcademicRecord/CourseHistory/Term/Courses/Course/MarkingPeriods/MarkingPeriod/CourseCreditsEarned | Only the credit earned for this marking period for a specific course. This allows multiple marking periods to be reported for a single course
UT.143 | TG | GRADING TERM | Grading term as recorded in SIS (e.g. Storecode in PowerSchool).  Does not need to match term [NAME], grades will be listed by ordinal position. | StudentAcademicRecord/CourseHistory/Term/Courses/Course/MarkingPeriods/MarkingPeriod/TermInfoData/TermCode
UT.001 | TG | [NAME] | State-assigned LEA number.  Must match [NAME] record. | LEAInfo/StateProvinceId
UT.145 | TG | LETTER GRADE | As recorded in SIS, typically A, B, C…  Any value up to 5 characters is accepted if found in standard or submitted gradescale. | StudentAcademicRecord/CourseHistory/Term/Courses/Course/MarkingPeriods/MarkingPeriod/MarkData/Letter
UT.003 | TG | SCHOOL NUMBER | State-assigned number for school submitting record.  Must match School Number on S1 record where school is student's school of record. | SchoolInfo/StateProvinceId | StudentSchoolEnrollment[@SchoolInfoRefId]
UT.009 | TG | STUDENT NUMBER | Student's locally-assigned unique ID.  Must match [NAME] record, follow same formatting rules. | StudentPersonal/LocalId
KEY:
AC | Course Master Record
AM | Course Membership Record
DI | District Record
ES | Exit Status Update Record
I1 | Incident Record
I2 | Incident Association Record
S1 | Student Record
S2 | SCRAM Record
S3 | [NAME] Record
SC | School Record
ST | Student Transcript Record
TA | Transcript Assessment Record
TC | [NAME] Record
TG | Transcript Grade Record
SLF | StudentLocatorFramework (SLF)