PESC Transcript Stylesheet

This document outlines the stylesheet that presents the PESC Transcript XML in a human readable form as delivered by the Ministry of Education, Government of Alberta.

The implementation of the stylesheet supports the following requirement:

  • To allow consumers of the PESC HighSchoolTranscript messages to be able to render the xml into a human readable html page.
  • Conceptually align with the printed version of the high school transcript, already implemented within PASIprep.

Some of the Post-Secondary Institutions (PSI) that integrate to PASI through APAS consume transcripts directly using a human readable version. Some of the PSIs have internal systems that consume the content of the XML directly as well as produce a PDF of the html produced by the styled xml.

This stylesheet will be for the HighSchoolTranscript PESC XML messages that are retrieved using the Retrieve Transcript service on the PESCService201604 endpoint.

Note: Each section will have the same name and subtitle text as what appears on the printed transcript.

Name and Location of Stylesheet

The stylesheet is located in a location on the web that has public access and does not require any authentication to be able to access the stylesheet. Most likely the stylesheet will be in the same locations as the legacy stylesheet in each environment.

The name of the stylesheet will be “transcriptstylesheet_201704.xsl”.

The name is deliberately different that the stylesheet that is used with the legacy HighSchoolTranscript PESC XML messages. Going forward, will need to be able to introduce new versions of the stylesheet without “breaking” the older versions.

transcriptstylesheet_201704

The following is the SharePoint location of the mockup that was made using excel:

The numbering of the data elements in each of the following sections are based on the mockup.

The page header appears at the top of the html page.

Pos Source in PESC HighSchoolTranscript XML Notes
/Student/Person/Name/LastName
/Student/Person/Name/FirstName
/Student/Person/Name/MiddleName
First and middle name is separated by a space if the middle name element exists.
/Student/Person/AgencyIdentifier/AgencyAssignedID Formatted as xxxx-xxxx-x
/Student/Person/Birth/BirthDate
/Student/AcademicRecord/Course/CourseCreditEarned
/Student/AcademicRecord/AcademicSession/Course/CourseCreditEarned
A calculation that sums the values in the listed locations.
/Student/AcademicRecord/AcademicAward/AcademicAwardTitle There can be multiple <AcademicAward> segments.
Use the one that has a value in the <AcademicAwaredLevel> tag. If no value found, then show “None”.
/Student/AcademicRecord/AcademicAward/AcademicAwardDate There can be multiple <AcademicAward> segments.
Use the one that has a value in the <AcademicAwaredLevel> tag.
Use the year only from the date.
/TransmissionData/Destination/ Organization/OrganizationName

Coursework in Alberta Accredited Schools

This section only appears if there is a least one <AcademicSession> in the PESC HighSchoolTranscript XML.

Output a row for every course that is defined directly in each <AcademicSession>.

Pos Source in PESC HighSchoolTranscript XML Notes
/Student/AcademicRecord/AcademicSession/Course/AgencyCourseID
/Student/AcademicRecord/AcademicSession/Course/CourseTitle
/Student/AcademicRecord/AcademicSession/AcademicSessionDetail/SessionSchoolYear
/Student/AcademicRecord/AcademicSession/AcademicSessionDetail/SessionType
/Student/AcademicRecord/AcademicSession/Course/CourseOverrideSchool/LocalOrganizationID/LocalOrganizationIDCode
/Student/AcademicRecord/AcademicSession/Course/LanguageOfInstruction/LanguageCode Where the <InstructionUsage> has a value of “Instruction”.
/Student/AcademicRecord/AcademicSession/Course/CourseSupplementalAcademicGrade/ CourseSupplementalGrade/ CourseAcademicSupplementalGrade Where the <SupplementalGradeCode> has a value of “InstructorAssignedGrade”.
/Student/AcademicRecord/AcademicSession/Course/LanguageOfInstruction/LanguageCode Where the <InstructionUsage> has a value of “Examination”.
/Student/AcademicRecord/AcademicSession/Course/CourseSupplementalAcademicGrade/CourseSupplementalGrade/CourseAcademicSupplementalGrade Where the <SupplementalGradeCode> has a value of “ExamGrade”.
/Student/AcademicRecord/AcademicSession/Course/CourseCreditEarned
/Student/AcademicRecord/AcademicSession/Course/CourseAcademicGrade
/Student/AcademicRecord/AcademicSession/Course/UserDefinedExtensions/Extensions/EndNote/EndNoteDescription For each end note on the course, add a new line and display in italics “Note: “ followed by the <EndNoteDescription>.

Legend

This section only appears if there is a least one <AcademicSession> in the PESC HighSchoolTranscript XML.

Alberta Accredited School

Output a row on the Alberta Accredited School table for every unique school that is defined in the AcademicSession/Course/CourseOverrideSchool.

Pos Source in PESC HighSchoolTranscript XML Notes
/ Student/AcademicRecord/AcademicSession/Course/CourseOverrideSchool/LocalOrganizationID/LocalOrganizationIDCode
/ Student/AcademicRecord/AcademicSession/Course/CourseOverrideSchool/OrganizationName

Mark Legend

Only output the “Mark Legend” and table if there is at least one course that has a mark value that is a letter of A, B, C, D, F or P. Do not output that table if there is not a course with a letter mark value.

Other Credits

This section only appears if there is at least one course that is defined directly in any <AcademicRecord> where there is no Course/CourseSupplementalAcademicGrade segment in the PESC HighSchoolTranscript XML.

Output a row on the table for every course that is defined directly in each <AcademicRecord> where there is no Course/CourseSupplementalAcademicGrade segment.

Pos Source in PESC HighSchoolTranscript XML Notes
/Student/AcademicRecord/Course/AgencyCourseID
/Student/AcademicRecord/Course/CourseTitle
/Student/AcademicRecord/Course/CourseCreditEarned

Private Music Evaluations

This section only appears if there is at least one course that is defined directly in any <AcademicRecord> where there is a Course/CourseSupplementalAcademicGrade segment in the PESC HighSchoolTranscript XML.

Output a row on the table for every course that is defined directly in each <AcademicRecord> where there is a Course/CourseSupplementalAcademicGrade segment.

Pos Source in PESC HighSchoolTranscript XML Notes
/Student/AcademicRecord/Course/AgencyCourseID
/Student/AcademicRecord/Course/CourseTitle
/Student/AcademicRecord/Course/CourseCreditEarned
/Student/AcademicRecord/Course/CourseSupplementalAcademicGrade/CourseSupplementalGrade/CourseAcademicSupplementalGrade Where the <SupplementalGradeCode> has a value of “InstructorAssignedGrade”.

Completed Career and Technology Studies Credentialed Pathways

This section only appears if there is a <CareerAndTechnologyStudiesCredentialedPathways> segment in the SC HighSchoolTranscript XM.

Output a row on the table for every <CareerAndTechnologyStudiesCredentialedPathway> in the <CareerAndTechnologyStudiesCredentialedPathways> segment.

Pos Source in PESC HighSchoolTranscript XML Notes
AcademicRecord/UserDefinedExtensions/Extensions/CareerAndTechnologyStudiesCredentialedPathways/CareerAndTechnologyStudiesCredentialedPathway/PathwayName
AcademicRecord/UserDefinedExtensions/Extensions/CareerAndTechnologyStudiesCredentialedPathways/CareerAndTechnologyStudiesCredentialedPathway/CompletedSchoolYear
AcademicRecord/UserDefinedExtensions/Extensions/CareerAndTechnologyStudiesCredentialedPathways/CareerAndTechnologyStudiesCredentialedPathway/ContributingCourses

External Credentials

This section only appears if there is at least one <AcademicAward> where there is no <AcademicAwaredLevel> segment in the PESC HighSchoolTranscript XML.

Output a row on the table for every <AcademicAward> where there is no <AcademicAwaredLevel> segment.

Pos Source in PESC HighSchoolTranscript XML Notes
/Student/AcademicRecord/AcademicAward/AcademicAwardTitle
/Student/AcademicRecord/AcademicAward/AcademicAwardDate
/Student/AcademicRecord/School/OrganizationName

General Information

This section always appears as the last section just before the page footer and consists of static text. The mockup has the full detail.

The page footer appears at the bottom of the html page. There is no section title nor subtitle.

Pos Source in PESC HighSchoolTranscript XML Notes
/TransmissionData/CreatedDateTime Only display the date portion of this value.
/TransmissionData/RequestTrackingID
/TransmissionData/Destination/Organization/OrganizationName
A hyper link pointing to a page exported from the wiki on DevNet that provides details on how to read the styled transcript. The value of the link will come from a configuration preferences.
The link will point to the How to Read the Styled Electronic Transcript page on DevNet. The DevNet link is: https://extranet.education.alberta.ca/PASI.devnet/PASI%20Documents/ CurrentRelease/Business/userdocs/how_to_read_styled_electronic_transcript.html