Batch updating students' maximum registered credits in a term - REG_MAX_HRS_C
This job will adjust students’ maximum hours on SFAREGS. Prior to fall and spring registration periods, all continuing UG NTC students (not FTFs or Spring Scholars) will have their max credits lowered to 17. This is done by lowering max hours in SFAMHRS. At the end of the registration period, max hours will be reset in SFAMHRS to 19. This Appworx job will allow us to set max hours for students who are exceptions to the SFAMHRS rule, like FTFs and Spring Scholars.
Prepare Student List
Create csv file with the following format:
TUID
NO HEADER RECORD
Upload the csv file into Banner
Banner form: GUAUPLP
Process name: Reg MAX HRS
APPWORX request:
REG_MAX_HRS_C
Parameters:
Term Code - required
enter the term for which students' max hours will be increased
Max Hrs - required
enter the maximum enrolled hours to be set
Run Mode - required
Run in Audit (A) mode to check output
Compare output to file uploaded into GUAUPLP
Run in Update (U) mode to update student records
Verify
This process can be verified in two ways:
Check individual students on SFAREGS
Run a Max HRs Report:
APPWORX Request:
REG_MIN_MAX_HRS_REPORT_C
Parameter: Term
NOTE:
This report will only return a value for a student if their individual MAX HRS have been updated for that term.
Any student with a blank MHRS_OVR value (column O) will default to the SFAMHRS value for their level and college (column S).
Students updated by the REG_MAX_HRS_C process will have values in MHRS_OVR and the USER_ID (column Q) will be APPWORX.
The Appworx time ticket report (Running an Appworx time ticket report - REG_TIME_TKT_REPORT_C) also shows students' MAX HRS.