Spreadsheet: 00653de1-c041-4ac1-b254-c0c9fee16b14
Sheet: Sheet1

Element Name | Id Num. | Status | Description | Notes | Outbound PESC XML Mapping
Distrct / School Summary - This is data concerning the transcripting district/school.  One summary per transcript.
District Name | UT.008 | R | The name of the school district or charter school that is submitting the transcript. |  | TransmissionData.Source.Organization.LocalOrganizationName
School Code (CEEB) | UT.003 | O | The school CEEB code, maintained by the College Board |  | TransmissionData.Source.Organization.CEEBACT
State School ID | UT.003 | R | State assigned school code |  | TransmissionData.Source.Organization.LocalOrganizationID.LocalOrganizationIDCode *** ALSO REQUIRES *** TransmissionData.Source.Organization.LocalOrganizationID.LocalOrganizationIDQualifier
School Name | UT.194 | R | The name of the school that is generating the transcript |  | TransmissionData.Source.Organization.OrganizationName
School Address Line One | UT.195 | R | The school address |  | TransmissionData.Source.Organization.Contacts.Address.AddressLine
School Address City | [NAME] | R | The school city |  | TransmissionData.Source.Organization.Contacts.Address.City
School Address State Code | UT.197 | R | The school state code |  | TransmissionData.Source.Organization.Contacts.Address.StateProvinceCode
School Address Zip | UT.198 | R | The school zip code |  | TransmissionData.Source.Organization.Contacts.Address.PostalCode
School Phone | UT.199 | R | The school phone number |  | TransmissionData.Source.Organization.Contacts.Phone.PhoneNumber
General Transcript Information - One per transcript
Transcript Generation Date | n/a | R | The date the transcript was generated | Calculated | TransmissionData.CreatedDateTime
Accredited by: | n/a | R | Description of the school's accreditations |  | TransmissionData.Source.Organization.Accreditation.AccreditingBodyName
[NAME] | n/a | C | Non-traditional grade scale used by the district or school | Required if non-traditional grade scale is used
Student Demographic Information - Student data. One per transcript.
Student Parent/Guardian First Name | UT.204 | O | The first name of the student's parent or guardian |  | Student.Person.[NAME].FirstName
Student Parent/Guardian Last Name | UT.205 | O | The last name of the student's parent or guardian |  | Student.Person.ParentGuardianName.LastName
Student First Name | UT.012 | R | The student's first name |  | Student.Person.Name.FirstName
Student Last Name | UT.011 | R | The student's last name |  | Student.Person.Name.LastName
Student Middle Name | UT.013 | O | The student's middle name |  | Student.Person.Name.MiddleName
Student Address Line One | UT.180 | R | The student's address |  | Student.Person.Contacts.Address.AddressLine
Student Address Line Two | UT.181 | O | The student's apartment or building number |  | Student.Person.Contacts.Address.AddressLine
Student Address City | UT.182 | R | The student's city |  | Student.Person.Contacts.Address.City
Student Address State Code | UT.183 | R | The student's state code |  | Student.Person.Contacts.Address.StateProvinceCode
Student Address Zip Code | UT.044 | R | The student's zip code |  | Student.Person.Contacts.Address.PostalCode
Student Phone | UT.036 | R | The student's phone number |  | Student.Person.Contacts.Phone.PhoneNumber
Student Birth Date | UT.014 | R | The student's date of birth |  | Student.Person.Birth.BirthDate
Student Grade Level | UT.022 | R | The student's current grade level |  | Student.AcademicRecord.StudentLevel.StudentLevelCode
Student Gender | UT.015 | R | The student's gender/sex |  | Student.Person.[NAME].GenderCode
Student Entry Date | UT.157 | O | The student's entry date into high school |  | Student.AcademicRecord.AcademicSummary.NoteMessage
Student Exit Date | UT.026 | R | The student's exit date from high school |  | Student.AcademicRecord.AcademicSummary.ExitDate
Student Graduation Date | UT.158 | C | The student's graduation date | Required only if student has graduated | Student.AcademicRecord.AcademicAward.AcademicAwardDate *** WHEN *** Student.AcademicRecord.AcademicAward.AcademicCompletionIndicator="true"
Student Expected Graduation Date | UT.187 | C | The student's expected graduation date | Required only if student has not yet graduated | Student.AcademicRecord.AcademicAward.AcademicAwardDate *** WHEN ***  Student.AcademicRecord.AcademicAward.AcademicCompletionIndicator="false"
Completion Status | UT.027 | R | The student's completion status |  | Student.AcademicRecord.AcademicAward.NoteMessage
Student Local ID Number | UT.009 | O | The student's local LEA ID number |  | Student.Person.SchoolAssignedPersonID
Student SSID Number | UT.051 | R | The student's state issued ID number |  | Student.Person.AgencyAssignedID
Student Social Security Number | UT.010 | O | The student's social security number |  | Student.Person.SSN
Student Academic Summary - A summary of academic data for the student. One summary per transcript
Student Cumulative Credits | UT.159 | R | The total number of credits or credit hours that the student has earned during their entire academic experience |  | Student.AcademicRecord.AcademicSummary.GPA.CreditHoursEarned *** AND *** Student.AcademicRecord.AcademicSummary.AcademicSummaryType="All"
Cumulative GPA Earned Credits | UT.160 | R | The number of credits or credit hours used to calculate the GPA that the student has earned to the point in time the transcript was generated |  | Student.AcademicRecord.AcademicSummary.GPA.CreditHoursEarned *** AND *** Student.AcademicRecord.AcademicSummary.AcademicSummaryType="Cumulative"
Student Credits Attempted | UT.161 | R | The number of credits that the student has attempted to date |  | Student.AcademicRecord.AcademicSummary.GPA.CreditHoursAttempted *** AND *** Student.AcademicRecord.AcademicSummary.AcademicSummaryType="All"
Diploma Type | UT.206 | C | The type of diploma that the student has earned | Required if graduated. Basic, GED, [NAME], or Certificate of Completion | Student.AcademicRecord.AcademicAward.AcademicAwardTitle
Student Unweighted Cumulative GPA | UT.202 | R | The unweighted grade point average the student has earned up to the time the transcript was generated |  | Student.AcademicRecord.AcademicSummary.GPA.GradePointAverage *** AND *** Student.AcademicRecord.AcademicSummary.AcademicSummaryType="Unweighted"
Student Weighted Cumulative GPA | UT.203 | O | The weighted grade point average the student has earned up to the time the transcript was generated |  | Student.AcademicRecord.AcademicSummary.GPA.GradePointAverage *** AND *** Student.AcademicRecord.AcademicSummary.AcademicSummaryType="Weighted"
Student Class Rank | UT.165 | R | The rank order number of the student compared to other students in the same grade level based on GPA |  | Student.AcademicRecord.AcademicSummary.ClassRank *** AND *** Student.AcademicRecord.AcademicSummary.AcademicSummaryType="All"
Student Class Size | UT.166 | R | The total number of students in the same grade level as the student |  | Student.AcademicRecord.AcademicSummary.ClassSize *** AND *** Student.AcademicRecord.AcademicSummary.AcademicSummaryType="All"
Student Percentile | UT.167 | O | Ther percentile that the student is based upon the class rank and the class size |  | Student.AcademicRecord.AcademicSummary.UserDefinedExtensions.UTCustom.StudentPercentile *** AND *** Student.AcademicRecord.AcademicSummary.AcademicSummaryType="All"
Student Academic Session - An academic session represents the combination of a school of enrollment and an academic year. It is repeated for each combination of a school and and a academic year.
School Year | UT.009 | R | The calendar year of enrollment | ccyy-ccyy | Student.AcademicRecord.AcademicSession.AcademicSessionDetail.SessionSchoolYear
Grade Level | UT.193 | R | The grade level of the student during this school year |  | Student.AcademicRecord.AcademicSession.AcademicSessionDetail.StudentLevel.StudentLevelCode
School Name | UT.139 | R | The name of the school attended |  | Student.AcademicRecord.AcademicSession.School.OrganizationName
School Code/Site Number | UT.140 | O | The school's state code (district and state code) |  | Student.AcademicRecord.AcademicSession.School.CCD
Session Credits Earned | UT.168 UT.171 UT.174 UT.177 | R | The number of credits or credit hours the student earned during this session | Calculated in the manifest by totaling all courses for this session | Student.AcademicRecord.AcademicSession.AcademicSummary.AcademicSummary.GPA.CreditHoursEarned *** AND *** Student.AcademicRecord.AcademicSession.AcademicSummary.AcademicSummaryType="All"
Session GPA | UT.169 UT.172 UT.175 UT.178 | R | The grade point average the student earned during this session |  | Student.AcademicRecord.AcademicSession.AcademicSummary.AcademicSummary.GPA.GradePointAverage *** AND *** Student.AcademicRecord.AcademicSession.AcademicSummary.AcademicSummaryType="All"
Student Course Details - Course details are reported within a Student Academic Session.
Local Course Code/ID | UT.132 | O | The school's/district course code |  | Student.AcademicRecord.AcademicSession.Course.CourseNumber
Course Name/Title | UT.133 | R | The school's/district course name |  | Student.AcademicRecord.AcademicSession.Course.CourseTitle
State Course Code/ID | UT.134 | R | The USOE course code |  | Student.AcademicRecord.AcademicSession.Course.AgencyCourseID
Course Credit Earned | UT.135 | R | The course credit hours earned |  | Student.AcademicRecord.AcademicSession.Course.CourseCreditEarned
Course Letter Grade-Term 1 | UT.145 | C | The letter grade earned for this course | At least ONE Course Letter Grade must be reported for every course | Student.AcademicRecord.AcademicSession.Course.CourseAcademicGrade
Course Letter Grade-Term 2 | UT.145 | C | The letter grade earned for this course | At least ONE Course Letter Grade must be reported for every course | Student.AcademicRecord.AcademicSession.Course.UserDefinedExtensions.UTCustom.CourseGrades.CourseGrade Type="2"
Course Letter Grade-Term 3 | UT.145 | C | The letter grade earned for this course | At least ONE Course Letter Grade must be reported for every course | Student.AcademicRecord.AcademicSession.Course.UserDefinedExtensions.UTCustom.CourseGrades.CourseGrade Type="3"
Course Letter Grade-Term 4 | UT.145 | C | The letter grade earned for this course | At least ONE Course Letter Grade must be reported for every course | Student.AcademicRecord.AcademicSession.Course.UserDefinedExtensions.UTCustom.CourseGrades.CourseGrade Type="4"
Course Letter Grade-Term 5 | UT.145 | C | The letter grade earned for this course | At least ONE Course Letter Grade must be reported for every course | Student.AcademicRecord.AcademicSession.Course.UserDefinedExtensions.UTCustom.CourseGrades.[NAME] Type="5"
Course Letter Grade-Term 6 | UT.145 | C | The letter grade earned for this course | At least ONE Course Letter Grade must be reported for every course | Student.AcademicRecord.AcademicSession.Course.UserDefinedExtensions.UTCustom.CourseGrades.[NAME] Type="6"
Course Letter Grade-Term Other | UT.145 | C | The letter grade earned for this course | At least ONE Course Letter Grade must be reported for every course | Student.AcademicRecord.AcademicSession.Course.UserDefinedExtensions.UTCustom.CourseGrades.CourseGrade Type="7"
Student Assessments - Details of assessments recorded for the student. Multiple occurences of the same assessment can be reported.
Test Name | UT.148 | O | The name of the assessment | ACT, AP or SAT only | Student.Tests.TestName *** ALSO REQUIRES *** Student.Tests.TestCode (this value must meet PESC Spec)
Subtest | UT.153 | O | The subtest or subject category of the assessment. | ACT - (Composite, English, Math, Reading, Science) SAT - (Writing, Math, Critical Reading, Science)  AP - (Any) | Student.Tests.Subtest.SubtestName *** ALSO REQUIRES *** Student.Tests.Subtest.SubtestCode (this value must meet PESC Spec)
Test Date | UT.149 | O | Date the assessment was administered | [NAME]/dd/ccyy | Student.Tests.TestDate
Test Score | UT.155 | O | Test score recorded |  | Student.Tests.Subtest.TestScores.ScoreValue