...
Instructions for rolling and configuring various Banner tables:
Use the TEMPLATE - Term-Based Config - Table Roll Checklist document https://tulane.box.com/s/kveaukqq54vszdw9i10112m12j3x3vf3
Since students register for both summer and fall simultaneously, and summer term configuration is particularly onerous:
When performing spring term configurations, roll all tables but SFRRSTS, SFRRFCR, SZVECCP, and SFRCTRL for the whole year (10, 20, 30, and 40 terms)
The above listed tables must be rolled/configured differently, so they should only be rolled for the term(s) being configured during the current configuration processes.
All tables should be checked for errors even if they are not being rolled in the current term(s) configuration.
Tables are rolled from spring-to-spring, fall-to-fall, etc.
For the REG_ROLL_TERM_CONFIG_M process to run properly, the tables for the prior term(s) being copied must exactly match the newly created records.
If new POTs are being created, they must be created in SOATERM for the prior/copied term (with dummy dates) before the roll can occur.
SFAESTS (SFBESTS and SFBRFST tables)
This form defines enrollment statuses.
Use generic/default dates based on what was used in prior semesters
SFAMHRS
This form sets default minimum and maximum enrolled hours based on students' level and college
During priority registration periods for fall and spring, NTC students’ default should be set to 16
This will be raised to 19 after all student registration times have rolled in
- SFRRSTS and SFRRFCR configuration:
.
SFARSTS (SFRRSTS and SFRRFCR tables)
These tables do not roll.
Use the saved table dumps to create new SFRRFCR and SFRRSTS tables for the configuration term(s) based on the completed POT template.
Once changes to the new files have been completed, send the new files back to Joe Van Meter, requesting that he import them into the appropriate Banner tables.
SFAMHRS (SFRMHRS table)
This form sets default minimum and maximum enrolled hours based on students' level and college.
During priority registration periods for fall and spring, NTC students’ default maximum should be set to 16 hours.
This will be raised to 19 after all student registration times have rolled in.
SFAROVR (SFRROVR table)
This form drives registration overrides.
These rules do not change frequently, compare to prior terms' settings.
SFATMST (SFRTMST and SFRTMSL tables)
This form drives students' time statuses based on level, college, and number of registered credits.
These rules do not change frequently, compare to prior terms' settings.
SZAECCP (custom Page Builder form)
Roll for current configuration term(s) only.
Most schools follow POT 1 confirmation dates.
Update dates per responses from Colette, SoPA, and Med School.
Most follow POTs follow POT 1 confirmation dates.
Only configure fall and spring terms, no confirmation in summer or year-long terms.
When updating on the Banner front end, be sure to select SZAECCP – Enrollment Confirmation Period option. This will open up a Page Builder form that will allow you to edit the table. The other option, Enrollment Confirmation Period Form (SZAECCP), is an obsolete custom form.
Also see Term Config Bible - Chapter 5 - Enrollment Confirmation.pdf. https://tulane.box.com/s/qphr24rxlx2rty43hrdn2y0npg9s77uj
SFRCTRL configuration:
This table does not roll.
Use the saved table dump to create new SFRCTRL table for the configuration term(s) based on the completed POT template.
Once changes to the new file has been completed, send the new file back to Joe Van Meter, requesting that he import it.