The Copy Grades to Transcripts function was ran using an incorrect Year.  This can be fixed via a CHANGE query.  

A backup of the HIS table prior to the Query change is highly recommended. This is done through SQL.


Step 1: Confirm that the records in question have the wrong year.

  • Go to a student's Transcript page. Note the Year, Term, and the School Taken, for a record that needs correcting.

Step 2: Run a List query to determine the number of records that need updating:

  • Go to Query and run a query to LIST the records that need updating. For example:

LIST HIS ST SN YR TE IF YR = ## AND ST = ### 

(Replace the ## with the incorrect year, and the ### with the School Taken)


Step 3: Run a Change query to fix the year:

  • CHANGE HIS YR TO ##@ IF YR = ## AND ST = ### AND TE = #

(Replace ##@ with the year records should be changed to. Replace ## with the original incorrect year. Replace the ### with the School Taken. Replace # with the Term of the HIS records showing in Step 2)

  • Be sure that the number of records to be changed matches the List query in Step 2, before proceeding to click on OK.