Setup Semester for Registration
Problem Description :
Steps to setup Banner and Scripts for Registration
Information needed before beginning.
From Registrar - Registration Start and End Date
ReAdmit Term(s)
From Bursar - for Web Payment Script - Hold to Date and Graduation Date
Before Starting
Be sure that Athletic Director has entered Athletes in Banner - SGASPRT
Be sure that Registrar has built time tickets in Banner
Early Registration Tasks
Setup Action Items - Financial Agreement in Banner General INB for new term. Get Registration Start and End date from registrar.
Registration Group Scripts Run Twice when setting up Summer and Fall
-- DO THIS STEP FIRST
-- N:\csd\TRACY\SQL\Registrar's SQLS\Registration Scripts\CreateRegistrationTimeTickets.sql (used to be the .old file)
-- SET TERM to Current Term and then work backwards. i.e run the top parts for each term i.e 202008, then 202005, 202002, 201908 for one year back (don't run the bottom insert into SFBWCTL until the end) and then run the SFBWCTL insert, and then the select query below it to pull the groups.
-- Set reg_term to upcoming registration terms. Will need to run twice for summer & fall registrations.
-- Bottom of script creates a summary grid, the numbers will change when the special population time tickets are assigned in Step #2
Commit after each term set up
Run special population time ticket script (Military, ADA, Honors, Athletes, MOWR). Run twice when setting up Summer and Fall (by updating the terms)
--N:\csd\TRACY\SQL\Registrar's SQLS\Registration Scripts\special_time_tickets.sql
-- Set "term" to current term
-- Set reg_term to upcoming registration terms. Will need to run twice for summer & fall registrations.
--Set athl_term to last term that was populated with athletes. Check with Kristi and {{Athletic Director}}
-- Run select code at bottom of script, export to HTML Table (or spreadsheet) and email to registrar (Kristi H)
Lock/Unlock terms in Banner Web in toad open packages and edit html_faculty, html_student, html_regis set term1, term2 and termtext (saved the 3 packages at N:\csd\BANNER\Banner Hosting documents\custom packages\)
-- For Fall/Summer set term1 to fall code and term2 to summer code
-- For Spring set term1 to spring code and term2 to null
--Make changes in Package and email to ITS via the ticket created
-- Send Ticket to ITS to update package in TEST - Have Registrar test it once done...
Magic words:
"
These are the packages that we update every semester for registration. I have added the txt extension so that I could upload them here. We want it done in PROD on Thursday after 5pm. This covers the Banner Web Student package.
"
--Send Ticket to ITS to update package in PROD
Term Code in webpmt.sql on Heron(term is in many places...do a search/replace) - Be sure Bursar is ready for you to change. Also need to change Hold to Date and Graduation date by 1 year.
R11 group for readmits - SAVE SCRIPT IT RUNS DAILY ON HERON
-- N:\csd\TRACY\SQL\Registrar's SQLS\Registration Scripts\create_reg_groups_readmits.sql (see comments on how to handle 1 term vs 2 term registrations)
-- Have to uncomment code for summer/fall and comment when setting up spring.
--BE SURE STEP ONE IS COMPLETE BEFORE CHANGING THIS
Update term and aid year for medical history and finaid requirements for housing move in
NEW webserver:
\\buzzard\d$\inetpub\wwwroot\SAMovein\idvalidate.asp
8) Lock Students
:\csd\Kirsten\Sqls\Alt Pin - Update terms and runs sqls in TOAD
--curr_stud_altpin_fall.sql
--curr_stud_altpin_spring.sql
--curr_stud_altpin_summer.sql
--prospective_stud_altpin.sql
--prospective_stud_altpin_fall.sql
--prospective_stud_altpin_spring.sql
Late Registration Tasks
1) Bookstore interface term code - Wait for Ticket from the Bookstore
2) At end of term reset Papercuts
----3/31/2020----
Had an issue with the button for advisers to unlock students. This is from Sam on the issue and what had to be fixed on the ITS side:
the unlock function has an & init, and toad identifies that as a variable, it was deleting the second parameter on the unlock function because when she was compiling it she was marking it as a variable when it should have been a litteral
Revision Date : 10/19/2020
Keywords : banner