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:
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.
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.
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 |
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> . |
This section only appears if there is a least one <AcademicSession>
in the PESC HighSchoolTranscript XML.
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 |
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.
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 |
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”. |
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 |
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 |
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 |