Overview

There was a desire to have student transcripts reflect a student's Home Reporting School rather than the Virtual school where the sections were actually provided. This change necessitated not only having the Section School recorded on the transcript (HIS) records, but also a change to the CALPADS Extracts to use that new field when reporting the teachers, sections and student sections for Fall 2 and EOY.  That frees up the School Taken field to be used to control only what prints on the transcript itself to allow for this option. 


A new option has been added when copying grades into Transcripts to allow for the Home Reporting School, when populated, to be copied into the School Taken field of the Transcripts, rather than the school where the section is. 


Copy Grades to Transcripts

Navigate to Grade Reporting > Functions > Copy Grades to Transcripts or Grade Reporting > Grade Reporting Process Dashboard > F. Transcripts > Copy Grades to Transcripts.


Click on the Copy Grades to Transcripts link. The following selection will display.


Copy Grades to Transcript-CA


Copy Grades to Transcript-TX


If the School Taken should be populated with the Student's Reporting Home School instead of the LOC school, check the Populate School Taken with Home School box. This will only affect students who have a value greater than 0 in their Home School field. All other students will have the LOC school populated as the School Taken.  


If the School Taken should be populated with the Student's Campus of Accountability instead of the LOC school, check the Populate School Taken with Campus of Accountability box. This will only affect students who have a value greater than 0 in their Campus of Accountability field. All other students will have the LOC school populated as the School Taken .


Sample Queries

If this solution comes after grades have already been copied to the Transcript table (HIS), the following change queries can be used (with proper permissions) to first view the records to be changed, and then to actually change them. 


  • Query to list all HIS records for the current year and term where the student has a Home Reporting school populated and that home reporting school does not match the HIS.ST field, but DOES match the HIS.SSE taken field

LIST STU HIS STU.ID STU.SC STU.HS HIS.YR HIS.TE HIS.ST HIS.SE HIS.SSC IF HIS.YR = 21 AND HIS.TE = 3 AND STU.HS > 0 AND HIS.ST = STU.SC AND HIS.ST # STU.HS  


  • Review the data presented to make sure these are the records you wish to replace the value in the transcript School Taken field (HIS.ST) with the contents of the student Home School field (STU.HS).  

CHANGE STU HIS HIS.ST TO STU.HS IF HIS.YR = 21 AND HIS.TE = 3 AND STU.HS > 0 AND HIS.ST # STU.HS


  • This Query will let you look at the students who have a Reporting Home School value filled in.

LIST STU HIS STU.ID STU.SC STU.HS HIS.YR HIS.TE HIS.ST HIS.SE HIS.SSC IF HIS.YR = 21 AND HIS.TE = 3 AND STU.HS > 0