PESC XML Output for eTranscripts

All generated eTranscripts output in PESC (Post-secondary Electronic Standards Council) XML format. The following information describes the exact format generated within each XML transcript file.

This layout details the PESC version 1.3 standards.

See the PESC website for more information. 

eTranscript Workflow

Generating the eTranscript Report and downloading the results are Steps 11 and 12 in the workflow.

Click here to expand...

The following workflow provides information on using eTranscripts.

StepCampus Location
1.System Administration > User Security > Tool Rights
2.Verify the school's CEEB number is entered.System Administration > Resources > School
3.Establish Code Defining values for diploma type.System Administration > Data Defining Tools > Code Defining
4.Configure a server connection to your eTranscript vendor's API for electronic release functionality.System Administration > Preferences > eTranscripts > Electronic Release Setup
5.Select eTranscript report type and customize eTranscript report preferences.System Administration > Preferences > Reports > eTranscripts
6.

Verify PESC Test and PESC Sub-test options are entered on tests for assessments that are chosen on preferences. For example, if the student's ACT score should be included in the eTranscript, verify these fields are populated for the ACT test.


In order for tests to report, at least one date and one score must be present in a Campus Test Family (Parent Test or Child Test).


The Display in Transcripts checkbox must be marked to select these options.

Assessment > Test Setup
7.Verify PESC grade levels are assigned to grade levels.System Administration > Resources > Grade Level Definitions
8.

If the Credit Group does not have a PESC Name assigned, it will not be reported in the PESC output on the eTranscript.

Grading and Standards > Credit Groups > PESC Name
9.

Verify the Diploma Type, Diploma Date and NGA Cohort Year are populated on the student's Graduation record, as well as the State Seal (if applicable).

Student Information > General > Graduation
10.

Confirm the student has transcript records.

Student Information > Counseling > General > Transcripts


Student Information > General > Transcripts

11.Grading and Standards > Reports > eTranscript Batch
12.Download (save) and send eTranscript files to third party eTranscript vendors.N/A


Only students with primary enrollments (Enrollment Service Type is P: Primary) are included in eTranscripts.

eTranscript XML Output

Layout Key

  • Items that must be included in the layout are marked with Required in the Data Element column.
  • Items that report based on an eTranscript Report Preference are indicated with a green checkmark(tick)
  • Items that require additional setup to display are marked with a green plus sign (plus)

A message in a gray bar (see image below) may display at the top of the XML layout. An XML file is designed to not be read by users. This message is NOT an error.

Screenshot showing the message in the gray bar that displays at the top of the XML layout.XML Output Header Message  

Transmission Data

This section includes routing and header information.

Header Information

Click here to expand...

This section provides basic information related to when the eTranscript was generated.

Data ElementDescription and FormatXML LocationCampus Location

Document ID

Required


Reports the date and time the eTranscript was generated, plus a value of DocumentID.

Date/Time field (CCYY-MM-DD + timestamp + DocumentID)

TransmissionData.DocumentIDN/A

Created Date Time

Required


Reports the date and time the eTranscript was generated.

Date/Time field (CCYY-MM-DD + timestamp)

TransmissionData.CreatedDateTimeN/A

Document Type Code

Required


Reports a value of Institution Request.

Alphabetic
TransmissionData.DocumentTypeCodeN/A

Transmission Type

Required


Reports a value of Original.

Alphabetic
TransmissionData.TransmissionTypeN/A

Screenshot of the PESC XML eTranscript where the Header Information is highlighted.PESC XML eTranscript Header Information  

Source

Click here to expand...

This section is required and indicates where the eTranscript originated. It is often the sending school where the student is enrolled.

Data ElementDescription and FormatXML LocationCampus Location
Organization

CEEBACT (tick)

The unique identifier assigned by the College Entrance Examining Board and ACT for each K-12 data exchange partner.


Numeric, 6 digits

TransmissionData.Source. Organization.CEEBACTSystem Administration > Resources > School > CEEB Number

School.satNumber
Local Organization ID

Local Organization ID Code

Required


The code assigned for the sending school by the state defined agency specified in the LocalIDQualifier that follows.


Reports School.DistrictID and School.number as one number. When the district number is 1234 and the school number is 567, the reported value is 1234567.


Numeric, 35 digits

TransmissionData.Source. Organization.LocalOrganizationID. LocalOrganizationIDCode

System Administration > Resources > District Information > State District Number


District.number


System Administration > Resources > School > State School Number


School.number

Local Organization ID Qualifier

Required


Reports the state-defined agency that assigned the Local ID Code above.


Reports the two-character State abbreviation from the State field on the School record.


Alphanumeric, 2 characters

TransmissionData.Source. Organization.LocalOrganizationID. LocalOrganizationIDQualifierSystem Administration > Resources > School > State

School.state
Organization NameReports the name of the school.

Alphanumeric, 60 characters
TransmissionData.Source. Organization.OrganizationNameSystem Administration > Resources > School  > Name

School.name
Contacts
Address

Address Line

Required


Local delivery information such as street, building number, PO box portion of a postal address of a Contact at the Sending (Source) High School.


Reports the building number, street name, and street tag.


Alphanumeric, 40 characters

TransmissionData.Source. Organization.Contacts.
Address.AddressLine
System Administration > Resources > School > Address

School.address

City

Required


The city portion of the address of a contact at the sending (source) high school.

Alphanumeric, 30 characters
TransmissionData.Source. Organization.Contacts. Address.CitySystem Administration > Resources > School > City

School.city

State Province Code

Required

Code for US states, etc., and Canadian provinces.


Reports the two-character state abbreviation from the school's address.


Alphabetic, 2 characters

TransmissionData.Source. Organization.Contacts. Address.StateProvinceCodeSystem Administration > Resources > School > State

School.state

Postal Code

Required


The postal code portion of the Address.


Reports the Zip Code from the school's address.


Numeric, 17 digits (NNNN-NNN or NNNNN)

TransmissionData.Source. Organization.Contacts.AddressSystem Administration > Resources > School > Zip

School.zip

Attention Line (tick)


When the preference to report the student's counselor is marked, reports the first and last name of said counselor.

Alphanumeric, 45 characters
TransmissionData.Source. Organization.Contacts.
AttentionLine
Census > People > Identities > First Name, Last Name

Identity.firstName

Identity.lastName


Phone
Phone NumberReports the school telephone number, including area code.

Numeric, 10 digits

NNNNNNNNNN

TransmissionData.Source. Organization.Contacts.
Phone.PhoneNumber
System Administration > Resources > School > Phone

School.phone
Fax Phone
FaxReports the school's fax number when populated.

Numeric, 10 digits

NNNNNNNNNN

TransmissionData.Source. Organization.Contacts. FaxPhone.PhoneNumberSystem Administration > Resources > School > Fax

School.fax

Screenshot of the PESC XML eTranscript where the Source Information is highlighted.PESC XML eTranscript Source Information 

Destination

Click here to expand...

This section indicates the recipient and destination of the eTranscript, or where the eTranscript is being sent.

Data ElementDescription and FormatXML LocationCampus Location
Organization
ATPTYPThe unique identifier for the Admissions Testing Program assigned by the College Board for each data exchange partner.

Numeric, 6 digits
TransmissionData. Destination. Organization.ATPN/A
Organization NameReports the non-person entity, such as Organization, Institution, Agency or Business.

Alphanumeric, 6 characters
TransmissionData. Destination. OrganizationSystem Administration > Resources > School > Name

School.name
Contacts
Adress

Address Line

Required


Reports the local delivery information such as street, building number, PO box portion of a postal address of a Contact at the receiving institution.


Alphanumeric, 40 characters

TransmissionData.Destination. Organization.Contacts. Address.AddressLineSystem Administration > Resources > School > Physical Address

School.address

City

Required


Reports the city portion of the Address of a Contact of the receiving institution.

Alphanumeric, 30 characters
TransmissionData.Destination. Organization.Contacts. Address.CitySystem Administration > Resources > School > Physical City

School.city

State Province Code

Required

Reports the two-character state abbreviation of the receiving institution.


Alphanumeric, 2 characters

TransmissionData.Destination. Organization.Contacts. Address.StateProvinceCodeSystem Administration > Resources > School > Physical State

School. state

Postal Code

Required


The postal code portion of the Address of the receiving institution.


Numeric, 17 digits (NNNN-NNN or NNNNN)

TransmissionData.Destination. Organization.Contacts. Address.PostalCodeSystem Administration > Resources > School > Physical Zip

School.zip

Screenshot of the PESC XML eTranscript where the Destination Information is highlighted.PESC XML eTranscript - Destination Information 

Student

This section reports student information that is sent with the eTranscript.

When the Report Comments preference is marked on the eTranscript Report Preferences, students who have active Report Comments associated with their Transcript report in a NoteMessage after the Student section. When the Report Comment is longer than 80 characters, multiple NoteMessages report.

Person

Click here to expand...

This section reports student identifying information (name, birth date, school of enrollment, etc.).

Data ElementDescription and FormatXML LocationCampus Location
School Assigned Person ID

Reports the student's school-assigned identification number.


This only reports when the student's Student State ID field (reported below) is not populated.


Numeric, 20 characters

Student.Person.
SchoolAssignedPersonID
Census > People > Demographics > Person Identifiers > Local Student Number

Person.studentNumber
Agency Identifier
Agency Assigned IDReports the student's state ID number.

Numeric, 10 characters
Student.Person.AgencyIdentifier. AgencyAssignedIDCensus > People > Demographics > Person Identifiers > Student State ID

Person.stateID
Agency CodeReports a value of State.

Alphabetic, 5 characters
Student.Person.AgencyIdentifier. AgencyCodeN/A
State Province CodeReports the state in which the student resides.

Alphabetic, 2 characters
Student.Person.AgencyIdentifier. StateProvinceCodeSystem Administration > Resources > School > State

School.state
SSN

Social Security Number (tick)


Reports the student's Social Security number when this option is selected on the eTranscript Report Preferences.

  • When Full is selected on the Report Preferences, this field reports the student's 9-digit Social Security number.
  • When Partial is selected on the Report Preferences, this field reports the last four digits of the student's Social Security number.
  • When the preference to report SSN is not selected or the student does not have the SSN field populated on the Identities record, this field does not report.

Numeric, 9 digits (full) or 4 digits (partial) (NNNNNNNNNNNNN)

Student.Person.SSNCensus > People > Identities > Identity Information > Soc Sec Number

Identity.ssn
Birth
Birth DateReports the student's birth date.

Date field, 10 characters

(CCYY-MM-DD)

Student.Person.Birth.BirthDateCensus > People > Identities > Identity Information > Birth Date

Identity.birthdate

Name

In order to report the student's legal name information entered in the Protected Identity Information fields, those fields must be populated and the user generating the eTranscript must be assigned R rights to Legal Name and Gender. Otherwise, the name reports from the general name fields.

First Name (tick)


Reports the student's first name.

 

When the Legal Name preference is selected on the eTranscript Report Preferences, the first name reports from the Legal First Name field. 


When that field is not populated or when that option is not selected, the first name reports from the First Name field.


Alphanumeric, 35 characters

Student.Person.Name.FirstName

Census > People > Identities > Identity Information > First Name


Identity.firstName


Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name


Identity.legalFirstName

Middle Name (tick)


Reports the student's middle name.


When the Legal Name preference is selected on the eTranscript Report Preferences, the middle name reports from the Legal Middle Name field. 


When that field is not populated or when that option is not selected, the middle name reports from the Middle Name field.


Alphanumeric, 35 characters

Student.Person.Name. MiddleName

Census > People > Identities > Identity Information > Middle Name


Identity.middleName


Census > People > Identities > Identity Information > Protected Identity Information > Legal Middle Name


Identity.legalMiddleName


Last Name(tick)


Reports the student's last name.


When the Legal Name preference is selected on the eTranscript Report Preferences the last name reports from the Legal Last  Name field. 


When that field is not populated or when that option is not selected, the last name reports from the Last Name field.


Alphanumeric, 35 characters

Student.Person.Name.LastName

Census > People > Identities > Identity Information > Last Name


Identity.lastName


Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name


Identity.legalLastName

Suffix (tick)


Reports the student's generational identifier (Jr., III, etc.).


When the Legal Name preference is selected on the eTranscript Report Preferences, the suffix reports from the Legal Suffix field. 


When that field is not populated or when that option is not selected, the suffix reports from the suffix field.


Alphabetic, 4 characters

Student.Person. Name.Suffix

Census > People > Identities > Identity Information > Suffix


Identity. suffix


Census > People > Identities > Identity Information > Protected Identity Information > Legal Suffix


Identity.legalSuffix


Contacts

This section displays for each primary household address where the student is a member and where a guardian of that student resides and is marked for mailing. When there is more than one primary household for the student, information for all primary households is sent.


Households and addresses marked as Secondary are not sent.

Address

Address Line

Required


Local delivery information such as street, building number, PO box, or apartment portion of a postal address of a Contact at the Sending (Source) High School.


Alphanumeric, 40 characters

Student.Person.Contacts. Address.AddressLineCensus >  Households > Address Info > Number, Street Tag

Address.number

Address.street

Address.tag

City

Required


Reports the name of the city from the student's address.

Alphanumeric, 30 characters
Student.Person.Contacts. Address.CityCensus > Households > Address Info > City

Address.city

State Province Code

Required


Reports the two-character state abbreviation from the student's address.

Alphabetic, 2 characters
Student.Person.Contacts. Address.StateProvinceCodeCensus > Households > Address Info > State

Address.state

Postal Code

Required


Reports the Zip Code from the student's address.

Numeric, 17 characters
Student.Person.Contacts. Address.PostalCodeCensus > Households > Address Info > Zip

Address.zip
Phone
Phone NumberReports the phone number associated with the household.

Numeric, 10 digits
Student.Person.Contacts.PhoneCensus > Households > Household Info > Phone Number

Household.phone
Email

Email Address(tick)


Reports the student's email address when populated.

Alphanumeric, 128 characters
Student.Person.Contacts.
Email.EmailAddress
Census > People > Demographics > Personal Contact Information > Email

Contact.email

Gender

In order to report the student's legal gender information entered in the Protected Identity Information fields, that field must be populated and the user generating the eTranscript must be assigned R rights to Legal Name and Gender. Otherwise, the gender reports from the general gender fields.

Gender Code (tick)

Required



Reports a student as being identified as male (M) or female (F).


When the Legal Gender preference is selected on the eTranscript Report Preferences, the gender reports from the Legal Gender field. 


When that field is not populated or when that option is not selected, the gender reports from the gender field.


Alphabetic, 1 character

Student.Person.Gender. GenderCode

Census > People > Identities > Gender


Identity.gender


Census > People > Identities > Protected Identity Information > Legal Gender


Identity.legalGender


Ethnicity Race (tick)
Ethnicity CodeReports a student as being Hispanic or Non-Hispanic.

Alphabetic, 11 characters
Student.Person.EthnicityRace. EthnicityCodeCensus > People > Identities > Race/Ethnicity > Is the individual Hispanic/Latino?

Identity.hispanicEthnicity
Race Code

Reports the student’s ethnicity and race code(s) as recorded in the sending school’s records.


This element reports multiple time is there are multiple race/ethnicities selected for the student.


Alphanumeric, 15 characters

Student.Person.EthnicityRaceCensus > People > Identities > Race/Ethnicity > Is the individual from one or more of these races?

Identity.raceEthnicity

Screenshot of the PESC XML eTranscript where the Student Information is highlighted.PESC XML eTranscript - Student Information 

Academic Record

Click here to expand...

This section reports the student's overall grade history for courses posted to the transcript.

Data ElementDescription and FormatXML LocationCampus Location
Student Level
Student Level Code

Reports the student's grade level, using the PESC Grade mapped value.


Grade levels report the mapped state grade level.


Alphanumeric

Student.AcademicRecord. AcademicSession.StudentLevel. StudentLevelCodeSystem Administration > Resources > Grade Level Definitions

TranscriptCourse.grade

Cohort Graduation Year (tick)

Reports the school year in which the student entered the baseline group used for computing completion rates.

Numeric, 4 digits (CCYY)

Student.AcademicRecord. CohortGraduationYearStudent Information > General
> Graduation > NGA Cohort End Year

Graduation.cohortYearNGA

Academic Award

This section reports data only when the student has graduated high school and diploma fields are available to report.

Academic Award Level (tick)


The level of the degree, certificate, or award granted for the successful completion of requirements of an academic program. 


This is the PESC Code for the Diploma.


When not selected, or not populated for the student, or when Diploma Types are not PESC-mapped, this does not report.


Alphanumeric, 20 characters

Student. AcademicRecord.
AcademicAward. Academic AwardLevel

System Administration > Data Defining Tools > Code Defining 

> Diploma Type


Student Information > General 

> Graduation > Diploma Type


Graduation.diplomaType


Academic Award Date (tick)

Reports the date the student received the diploma.


The date reports when selected even when the Diploma Type is not selected.


Date field, 10 characters

(CCYY-MM-DD)

Student. AcademicRecord.
AcademicAward. Acadmic AwardDate
Student Information > General
> Graduation > Diploma Date

Graduation.diplomaDate

Academic Award Title (tick)


Reports the descriptive title for the academic award, and is the district's Name for the diploma.


This reports when the Diploma Type or Date is not selected.


Alphanumeric, 400 characters

Student. AcademicRecord. AcademicAward. Academic AwardTitleStudent Information > General
> Graduation > Diploma Type

Graduation.diplomaType
Academic Honors
Honors Title (tick)

Reports the State Seal Information when the State Seal preference is marked on the eTranscript Report Preferences. 


When the Report Preference is marked, State Seal information reports even when there is no Diploma Date or Diploma Type available for the student. 


When the Report Preference is not marked, State Seal information does NOT report, even when there is a Diploma Date or Diploma Type available for the student.


This item can report multiple times when there are multiple state seals assigned to the student.


Alphanumeric, 30 characters

Student. AcademicRecord.
AcademicAward. AcademicHonors. HonorsTitle
Student Information > General
> Graduation > State Seal Information

GraduationSeal.stateSeal
Academic Completion DateReports the State Seal Date Earned.

Date field, 10 characters
(CCYY-MM-DD)
Student. AcademicRecord. AcademicAward. Academic CompletionDateStudent Information > General
> Graduation > State Seal Information > Date Earned

GraduationSeal.earnedDate
Note MessageReports additional information on the State Seal (Language/Method).

When a Graduation Seal has both Language and Method populated, two separate Note Messages report.

Alphanumeric, 80 characters
Student. AcademicRecord.
AcademicAward. AcademicHonors.
NoteMessage
Student Information > General
> Graduation > State Seal Information

GraduationSeal.language
Student Information > General
> Graduation > State Seal Information > Name

GraduationSeal.method

Academic Summary (tick)

This section reports for each type of GPA selected on the report preferences. 

Academic Summary Type

Reports Nonweighted when Unweighted GPA or Unweighted GPA with bonus points is selected on the report preferences.


Reports Weighted when GPA or GPA with bonus points is selected on the report preferences.


Reports UserDefined when a Custom GPA is selected. A <NoteMessage> reports when a Custom GPA is selected.


Alphanumeric, 12 characters

Student. AcademicRecord. AcademicSummary. AcademicSummary TypeN/A
GPA
Credit Hours EarnedReports the total value of credit hours successfully completed or earned.

Numeric, 4 digits (NN.NN)

Student. AcademicRecord. AcademicSession. AcademicSummary.GPA. CreditHoursEarnedStudent Information > General
> Transcript > Credits Earned

TranscriptCourse.
creditsEarned
Grade Point AverageReports the calculated GPA value for the selected GPA Type.

Numeric, 7 characters

N.NNNNNN


Student. AcademicRecord. AcademicSession. AcademicSummary.GPA. GradePointAverageN/A

Class Rank (tick)

Reports based on the calculated GPA value for the selected GPA type when the preference to report Class Rank is selected.

Numeric, 4 digits
Student. AcademicRecord. AcademicSummary. ClassRankN/A

Class Size (tick)


Reports based on the calculated GPA value for the selected GPA type when the preference to report Class Rank is selected.

Numeric, 4 digits
Student. AcademicRecord. AcademicSummary. ClassSizeN/A
Entry DateLists the date the student first entered the 9th grade, as entered on the student's Graduation record.

Date field, 10 characters (YYYY-MM-DD)

Student. AcademicRecord. AcademicSummary. EntryDateStudent Information > General
> Graduation > Date Entered
Ninth Grade

Graduation.grade9Date
Exit DateLists the date the student received their diploma.

Date field, 10 characters (YYYY-MM-DD)
Student. AcademicRecord. AcademicSummary. ExitDateStudent Information > General
> Graduation > Diploma Date

Graduation.diplomaDate

Academic Summary 

This section reports the Credit Summary information when preference is selected on the Report Preference.

Academic Summary Type

This section lists all courses taken by the student up to and including the current session.

Reports Cumulative.


Alphabetic, 10 characters


Student. AcademicRecord.
AcademicSummary. Academic SummaryType
N/A
High School Credit Summary
High School Subject Area
High School Subject Area Code

Reports the PESC-mapped credit name, as follows:

  • AcademicElective
  • Arts
  • English
  • ForeignLanguage
  • HistorySocialScience
  • LabScience
  • Math
  • Other
  • Science

This reports when the NCES/SCED Code (CourseFiveDigitSCEDCode) preference is NOT marked.


Alphabetic, 30 characters

Student. AcademicRecord.
AcademicSummary. HighSchoolCreditSummary. HighSchoolSubjectArea. HighSchool SubjectAreaCode
Student Information > General
> Transcript > Transcript Credit > Credit Name

PescCurriculumStandard. courseSubjectAreaCode
High School Subject Area Name

Reports the PESC-mapped credit name, as follows:

  • AcademicElective
  • Arts
  • English
  • ForeignLanguage
  • HistorySocialScience
  • LabScience
  • Math
  • Other
  • Science

This reports when the NCES/SCED Code (CourseFiveDigitSCEDCode) preference is NOT marked.


Alphabetic, 30 characters

Student.AcademicRecord.
AcademicSummary.
HighSchoolCreditSummary.
HighSchoolSubjectArea.
HighSchoolSubjectAreaName
Student Information > General
> Transcript > Transcript Credit > Credit Name

PescCurriculumStandard. courseSubjectAreaCode

Course Credit Units(tick)


When Credit Summary is selected, and a Credit Type is selected, that value reports.


Reports the name of the unit, as follows:

  • Quarter
  • Semester
  • Units
  • Clock
  • Hours
  • Carnegie Units
  • Continuing-Education Units
  • Unreported
  • Other

Alphabetic, 20 characters

Student. AcademicRecord.
AcademicSummary. HighSchoolCreditSummary.
HighSchoolSubjectArea.
CourseCreditUnits
N/A
Credit Hours EarnedIndicates the number of credits a student earned by the successful completion of a course.

Numeric, 5 digits (XX.XXX)

Student.AcademicRecord. AcademicSession.Course. CourseCreditEarnedStudent Information > General
> Transcripts > Transcript Credit > Earned

PescCurriculumStandard. TranscriptCourse.
creditsEarned
Credit Hours AttemptedReports the total sum of credits the student attempted from all courses within the same Credit Type when the preference is selected.

Numeric, 5 digits (XX.XXX)
Student. AcademicRecord. AcademicSession. Course. CourseCreditAttemptedStudent Information > General
> Transcripts > Transcript Credit
> Attempted

TranscriptCourse.credits Attempted
Academic Session
Academic Session Detail

Session Designator

Required


Reports the year and month of the term being reported in CCYY-MM fomat.

  • When the TranscriptCourse record is associated with a real Term object, and the start date of that object is not null, that day reports.
  • When the Term Start Date field field is populated on the student Transcript, that day reports.
  • When the start date and real term object's start date is null and the Term Start Date on the student Transcript is null, a value of 01 reports for the month (e.g., 2017-01).

Date field, 7 characters

(CCYY-MM)

Student.AcademicRecord. AcademicSession. AcademicSessionDetail. SessionDesignatorStudent Information > General > Transcript > Actual Term
Session Name

Reports Term and the value from the TranscriptCourse.actualTerm.


When there is no Actual Term, Term 0 reports.


Alphanumeric, 30 characters

Student.AcademicRecord. AcademicSession. AcademicSessionDetail. SessionNameStudent Information > General > Transcript > Actual Term

TranscriptCourse.actualTerm
Session School Year

Reports the school year in which the course was taken. A course taken in the 2016-17 school year reports as 2016-2017.


Date field, 9 characters

(CCYY-CCYY)

Student.AcademicRecord. AcademicSession. AcademicSessionDetail. SessionSchoolYearStudent Information > General > Transcript > School Year

TranscriptCourse.startYear 

TranscriptCourse.endYear


Session Begin DateReports the earliest Term Start Date from the transcript course records in this group.

When it is not populated, this field does not report.

Date field, 10 characters

(CCYY-MM-DD)

Student.AcademicRecord. AcademicSession.
AcademicSessionDetail. SessionBeginDate



Student Information > General > Transcript > Term Start Date

TranscriptCourse.termStartDate
Session End DateReports the latest Term End Date from the transcript course records in this group.

When it is not populated, this field does not report.

Date field, 10 characters

(CCYY-MM-DD)

Student.AcademicRecord. AcademicSession.
AcademicSessionDetail. SessionEndDate
Student Information > General > Transcript > Term End Date

TranscriptCourse.termEndDate
School
Organization Name

Reports the name of the school where the courses were taken in the term.


Alphanumeric, 60 characters

Student.AcademicRecord. AcademicSession.
School.OrganizationName
Student Information > General > Transcript > School Name

TranscriptCourse.school Name

Attendance Count

Attendance is the sum of all enrolled calendar days within an academic session. 

Days Absent

Reports the student's total days of absence for the school year. 


Numeric, 5 digits (XX.XXX)

Student.AcademicRecord. AcademicSession. AttendanceCount.DaysAbsentStudent Information > General > Attendance
Days PresentReports the student's total days present for the school year.

Numeric, 5 digits (XX.XXX)
Student.AcademicRecord. AcademicSession. AttendanceCount.DaysPresentStudent Information > General > Attendance

Local Organization ID

Reports only when TranscriptCourse.schoolNumber is populated. 

Local Organization ID Code

Required


Reports a concantenation of the district number and school number when populated.

Alphanumeric, 35 characters
Student.AcademicRecord. AcademicSession.
School.LocalOrganizationID. LocalOrganizationIDCode

Student Information > General > Transcript > District Number, School Number


TranscriptCourse.districtNumber


TranscriptCourse.schoolNumber

Local Organization ID Qualifier

Required


Reports the 2-character abbreviation for the state.

Alphabetic, 2 characters
Student.AcademicRecord. AcademicSession.
School.LocalOrganizationID.
LocalOrganizationIDQualifier
System Administration > Resources > District Information > State

District.state
Student Level

Student Level Code

Required


Reports the student's grade level from the current enrollment or the most current enrollment when the student is not currently enrolled. 


Only records from the primary school of record are sent.

Reports the PESC Grade mapped in the Grade Level Definitions tool.


Alphanumeric, 13 characters

Student.AcademicRecord. StudentLevel.
StudentLevelCode

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

System Administration > Resources > Grade Level Definitions


TranscriptCourse.grade


Course
Course Credit Basis

Indicates the type of enrollment associated with the credit hours for the course.


Reports a value of Regular.


Alphabetic

Student.AcademicRecord. AcademicSession.Course. CourseCreditBasisN/A
Course Credit ValueIndicates the number of credit hours that may be earned in a course.

Numeric, 4 digits (X.XXX)

Student.AcademicRecord. AcademicSession.Course. CourseCreditValueStudent Information > General > Transcripts > Transcript Credit > Attempted

TranscriptCredit.credits Attempted
Course Credit EarnedIndicates the number of credits a student earned by the successful completion of a course.

Numeric, 4 digits (X.XXX)
Student.AcademicRecord. AcademicSession.Course. CourseCreditEarnedStudent Information > General > Transcripts > Transcript Credit > Earned

TranscriptCredit.creditsEarned
Course Academic GradeReports the final score the student was awarded for participation in the course.

Alphanumeric, 10 characters
Student.AcademicRecord. AcademicSession.Course. CourseAcademicGradeStudent Information > General > Transcript > Mark, Current Score

TranscriptCourse.score
Course Academic Grade Status Code

Reports the student's courses for the current school year as InProgress for  courses the student is taking in the current term and NotYetReported for courses the student has scheduled in future terms in the current school year.  as part of the current school year Session.

These courses display near the end of the Academic Session section of the eTranscript.


Alphanumeric, 10 characters


Student.AcademicRecord. AcademicSession.Course. CourseAcademicGrade StatusCode

Student Information > General > Schedule


Course Repeat Code(tick)


Indicates that an academic course has been repeated by a student and how that repeat computes in the student’s academic grade average.

Reports a value of RepeatCounted.


Alphabetic, 20 characters

Student.AcademicRecord. AcademicSession. Course.CourseRepeatCode

Student Information > General > Schedule

Student Information > General > Transcript > Repeat Course

TranscriptCourse.repeatCourse

Course Five Digit SCED Code

(tick)


Reports the first five digits from the SCED Code assigned to the course (SCED Subject Area, SCED Course ID).


This only reports when the SCED fields are populated and when the NCES/SCED Code option is marked on the eTranscript Report Preferences.


Numeric, 5 digits

Student.AcademicRecord.
AcademicSession.Course.
CourseFiveDigitSCEDCode

Student Information > General > Transcript > SCED Subject Area


TranscriptCourse.scedSubjectArea


Scheduling > Courses > Course > NCES Data > SCED Course Identifier


TranscriptCourse.scedCourseId


Course Subject Area Code

Reports the PESC name to which the course credit is mapped. 


Course credit MUST be mapped through Grading & Standards > Credit Groups and be given a PESC name. Otherwise, the credit information on the course does not appear on the XML.


Alphabetic, 30 characters


Student.AcademicRecord. AcademicSession.Course. CourseSubjectAreaCodeGrading and Standards > Credit Groups > Credit Group Detail > PESC Name, Subject Area

TranscriptCredit.creditCode

Course Level (tick)


Indicates the level of work demonstrated by successful completion of the course, as follows:

  • Accelerated
  • AdultBasic
  • AdvancedPlacement
  • Basic
  • InternationalBaccalaureate
  • CollegeLevel
  • CollegePreparatory
  • GiftedTalented
  • Honors
  • NonAcademic
  • Regents
  • Remedial
  • SpecialEducation
  • TechnicalPreparatory
  • Vocational

Alphabetic, 20 characters

Student.AcademicRecord. AcademicSession.Course. CourseLevelStudent Information > General > Transcript > Course Level

TranscriptCourse.honorsCode

Course Number(tick)


Reports the official reference number portion of a course identifier. This number frequently designates the level of the course as well as the level of the student expected to enroll in the course.


When the preference to report the State Code is selected, that number reports.


Numeric, 15 digits

Student.AcademicRecord. AcademicSession.Course. CourseNumber

Student Information > General > Transcripts > Course Number, State Code


TranscriptCourse.courseNumber


TranscriptCourse.stateCode


Course TitleReports the name or title of the course taken by a student at an academic institution.

Alphanumeric, 60 characters
Student.AcademicRecord. AcademicSession.Course. CourseTitle

Student Information > General > Transcripts > Course Name


TranscriptCourse.courseName


Note MessageReports the GPA Weight of the course.

Alphanumeric, 80 characters
Student.AcademicRecord. AcademicSession.Course.
NoteMessage
Scheduling > Courses > Course > GPA Weight

TranscriptCourse.gpaWeight

Screenshot of the PESC XML eTranscript where the Academic Record Information is highlighted.PESC XML eTranscript - Academic Record Information 

Health

Click here to expand...

This section reports the student's vaccines, as entered on the student Immunizations record. An entry reports for each shot for each vaccine.

Data ElementDescription and FormatXML LocationCampus Location
Immunizations
Immunization DateReports the date the student received a shot for the immunization.

Date field, 10 characters

(CCYY-MM-DD)

Student.Health.Immunizations. ImmunizationDateStudent Information > Health > Immunizations

VaccineShot.date
Immunization Code

Reports the name of vaccine.


When the vaccine is marked as hidden in the Attribute/Dictionary, the vaccine does not report.


Alpahnumeric, 20 characters

Student.Health.Immunizations. ImmunizationCodeStudent Information > Health > Immunizations

Vaccine.code

Screenshot of the PESC XML eTranscript where the Student Immunization Information is highlighted.PESC XML eTranscript - Student Immunization Information 

Tests

Click here to expand...

This section reports the assessments the student has taken. These are created in the Assessment Test Setup tool and scores for those tests display on the student's Assessments record.

When there are multiple records for the same test and all are appropriately PESC mapped, each record reports, unless the preference to display best score is checked. When Display Best Score Only is marked on the eTranscript Report Preferences, and there are multiple assessment records for the same test, only the assessment with the highest score reports. When the test has multiple test score methods, only one is used to determine the best score. The priority for comparison is: (1) Scale Score, (2) Raw Score, (3) Percent, (4) Normal Curve Equivalent, (5) Percentile, (6) Stanine, (7) Graded.

  • A test must have a date in TestScore.date in order to report. However, in the case of parent/child tests, When there is a date in the Parent Test, there does not need to be a date in the Child Test.
  • Tests must have a value in Test.PESCTestCode and Test.PESCSubTestCode to report. Test.PESCTestCode and Test.PESCSubTestCode store the Test Code. For example, ACT: The ACT, "ACT" is the Test Code and "The ACT" is the Test Name. These report separately in the XML.

A District test has Test.stateCode = NULL and Test.nationalCode = NULL. A State test has Test.stateCode not NULL. A National test has Test.nationalCode not NULL.

When an assessment is marked as Other Test or Other Sub Test, a note message appears with the actual name of the test.

Data ElementDescription and FormatXML LocationCampus Location

Education Test Code

Required


Identifies the test.

Numeric, 5 digits
Student.Tests. EducationTestCodeAssessment > Test Setup > Test Detail > PESC Test (eTranscript)

Test.PESCTestCode
Test Name

Reports the name of the test associated with the code.


This is the parent test name when assessments are set up in Parent Test/Child Test format.


The hierarchy of the test displays also. For example, when the student has an ACT score for all of the ACT subtests, that parent/child test displays (e.g., ACT - ACT English, ACT - ACT Science, etc.).


Alphanumeric, 20 characters

Student.Tests.TestNameAssessment > Test Setup > Test Detail > PESC Test (eTranscript)

Test Year Month (tick)

Required



Reports the date the student took the tests.


Date field, 7 characters

(CCYY-MM)


Student.Tests. TestYearMonthStudent Information > General > Assessment > Test Scores > Test Score Detail > Date

TestScore.date
Subtest

Education Subtest Code

Required


Identifies the subtest.

Numeric, 5 digits
Student.Tests.Subtest. EducationSubtestCodeAssessment > Test Setup > Test Detail > PESC Sub-Test (eTranscript)

Test.PESCSubTestCode
Subtest Name

Reports the name of the test associated with the code. 


This is the child test name when assessments are set up in Parent Test/Child Test format.


Alphanumeric, 20 characters

Student.Tests. Subtest.SubtestNameAssessment > Test Setup > Test Detail > PESC Sub-Test (eTranscript)

Test.PESCSubTestCode
Test Scores (tick)

Score Value

Required


Reports the score value of the tests.

Numeric, 80 digits
Student.Tests.Subtest. TestScores.ScoreValueN/A
Test Score Method

Reports the score type based on the score attribute, as follows:

  • Scaled
  • Graded
  • Percent
  • Percentile
  • Normal Curve
  • Raw
  • Grades
  • Stanine (when TestScore.stanine= 0 or NULL, does not report)

Alphanumeric, 20 characters

Student.Tests.Subtest. TestScores.TestScoreMethodAssessment > Test Setup > Test Detail > Score Fields

TestScore.scaleScore

TestScore.percent

TestScore.percentile

TestScore.normalCurve Equivalent

TestScore.rawScore 

TestScore.gradeEquivalent

TestScore.stanine


Screenshot of the PESC XML eTranscript where the Student Assessment Information is highlighted.PESC XML eTranscript - Student Assessment Information