Skip to main content

Recalculation of Academic Records Settings

Use these settings to set the frequency of recalculation, to pause or resume the process, or to select a postrecalc stored procedure.

The process is informally called "academic recalc", and it runs only when there's new information, such as when new grades are entered. If no records need updating, the process doesn't run. So you're setting the frequency of checking for the need to run.

  • Recalculation frequency (when new data requires): Enter a number from 1 to 5. This represents minutes between checking for new data to trigger running a recalculation.

  • Last time student records were recalculated (refreshed every 10 seconds): This shows the last time the process finished, but you can use it to prevent the process from running. Enter a future date and/or time. The process won't run again until after that date and time when it is naturally triggered.

    • [If date is in the future]: Academic recalculation is paused and will resume at this date and time. Click the Resume recalculation button to start the recalculation before the displayed time.

  • Number of students currently requiring recalculation (refreshed every 10 seconds): This shows students whose data has changed. Their records will be recalculated in the next run.

  • Postrecalc stored procedure: Select a a stored procedure if you wish. Jenzabar provides CUST_POST_RE_RECALC as an empty procedure. You can put your code in it, or you can create your own stored procedure. The stored procedure is called with the ID_NUM argument after the recalc is run for a given student.

    Warning

    Whenever you change the stored procedure selection, you must do the following before you save:

    1. Stop the Client Application Services (CAS).

    2. Save your changes.

    3. Restart the CAS.

The information is stored on the Configuration Table table.

Table 1. Database Locations for Recalculation of Academic Records

Label

Database Calculation Method

Recalculation frequency (when new data requires)

comes from CONFIGURATION_TABL.config_value where MOD_CDE = 'RE' and FUNCT_CDE = 'AUTO_ACAD_RECAL' and CHAR_CDE = 'INTERVAL_MINUTE'

Last time student records were recalculated (refreshed every 10 seconds)

comes from CONFIGURATION_TABL.config_value where MOD_CDE = 'RE' and FUNCT_CDE = 'AUTO_ACAD_RECAL' and CHAR_CDE = 'LAST_EXECUTED'

Number of students currently requiring recalculation (refreshed every 10 seconds)

comes from SELECT Count(appid) FROM student_master WHERE run_academic_recalc > 0

Postrecalc stored procedure

Options come from Select so.nameFROM sysobjects soWHERE so.type ='P' and so.name like 'CUST_POST_RE_RECALC%'

Data comes from configuration_tabl where funct_cde = 'ACAD_RECALC_CTL' and char_cde = 'post_recalc_sp'



In Desktop, these settings are found on the Registration Configuration window, Registration Configuration tab in the Automated 'Recalcuate Academic Record' Process section.

The permission needed is "Can manage enrollment settings". It's available in the Registration Settings section of the Registration Module Manager role or roles copied from it.

  1. From the Registration Administration hub options, select Settings.

  2. Click Enrollment settings. The Enrollment Settings page opens.

  3. Scroll down, or click the anchor link to the Recalculation of Academic Records section.

  4. To edit, click the Edit this section button.

  5. Make your edits.

  6. If you want to abandon your changes, click the Cancel button. Otherwise, click the Save this section button.

  1. From the Registration Administration hub options, select Settings.

  2. Click Enrollment settings. The Enrollment Settings page opens.

  3. Scroll down, or click the anchor link to the Recalculation of Academic Records section.

  4. Click the Edit this section button.

  5. Under Last time student records were recalculated (refreshed every 10 seconds), enter a future date and time. The regular recalculation process triggers will be reinstated at that date and time.

  6. At any time, you can reinstate the regular process triggers by clicking the Resume recalculation button.

  7. Click the Save this section button.