...
(PORTAL/WEB APPS/BANNER SCREENS)
(v. 2) March 3, 2016
Table of Contents
...
LDAP Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Portal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Maintaining the Need to Know Section on the commencement page . . . . . 9
Apply for Graduation Web App . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Administrative functions of Graduation Web App . . . . . . . . . . . . . . . . . . . . 16
Manually adding/maintaining Graduation Applications . . . . . . . . . . . . . . 19
Terms available for graduation applications (Banner screen WERG004) . . 21
Scholarships and Fellowships Web App. . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
Graduation CheckOut . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
Completion of CheckOut Process by the Office of Student Records . . . . . 26
Manually allowing students to see the portal page and apply . . . . . . . . . . . 32
Tracking Undergraduate and Graduate Students Eligible for Graduation. . 33
Ldap Groups
p_greligible: Students registered this academic year with a classification of
2J,1U,2U
p_gr_greligible: Students registered this academic year with a classification of
G1, G2, G3, G4, G5 (passing in their current curriculum level and this term as parameters
p_gr_holds: Students (UG and GR) with a graduation hold that is not an A4 hold code
p_gr_faholds: Students (UG and GR) with an A4 hold
p_uggr_apply: Students (UG) who can apply to graduate. (They are in the p_greligible
...
for a term in the wreg162 table)
p_grgr_apply: Students (GR) who can apply to graduate. (They are in the p_greligible
...
for a term in the wreg162 table)
p_uggr_applied: Students (UG) who have applied to graduate. (They are in the p_greligible
...
for a term in the wreg162 table with chk_ind = ‘Y’)
p_grgr_applied: Students (GR) who have applied to graduate. (They are in the p_greligible
...
for a term in the wreg162 table with chk_ind = ‘Y’)
p_uggr_checkout UG Students who have applied and are now eligible for checking out for a term
identified in wreg162 with chk_ind = ‘Y’
p_grgr_checkout GR Students who have applied and are now eligible for checking out for a term
identified in wreg162 with chk_ind = ‘Y’ and have not applied for a CERT program.
p_uggr_checkedout p_greligible + p_grelib_ovr UG students that do not have any graduation holds that have
...
than or equal to today.
p_grgr_checkedout p_greligible GR students that do not have any graduation holds that have
...
than or equal to today.
P_reg_admin Deborah & Connie P.
p_gen_ceremony Those attending the general ceremony
...
Accessed from the Student Home page’s Need to Know section by the p_greligible or p_gr_greligible ldap groups. (that includes all students registered this academic year and have a classification of '2J', '1U', '2U', 'G1','G2','G3','G4' or 'G5')
The following message is displayed for undergrads
...
Portal Commencement Page Content:
Message: Apply to Graduate
...
Population: All UG students who will be graduating this year (p_greligible + p_grelig_ovr who have not previously applied)
Message: Apply to Graduate
...
Population: All GR students who will be graduating this year (p_gr_greligible ) who have not previously applied)
Message: Thank you for your application
...
(not necessarily p_greligible)
Message: Thank you for your application
...
(not necessarily p_gr_greligible)
Message: Scholarship/Fellowship
...
Start Date: Always available
End Date:
Message: Check Out For Graduation
...
(not necessarily p_greligible)
Message: Check Out For Graduation
...
(not necessarily p_greligible)
Message: Account Holds
...
are not A4 holds (not necessarily p_greligible or p_gr_greligible).
Message: Ceremony Instructions
...
necessarily p_gr_eligible)
Message: Ceremony Instructions
...
necessarily p_gr_eligible)
Maintaining the Need to Know Section on the commencement page.
Click on the Edit Web Content button in the lower left corner of the portlet.
This will open the Web Content Editor (shown below). In this section you define each of the messages to be displayed on the screen, the location of the message on the screen, who sees the messages, the dates the message is available, and any appropriate links.
Adding and Editing the web content:
Once all changes have been made, click the Save and Continue button above. The following message will be displayed in the green bar at the top of the screen.
Click Return to Full Page in the upper right corner to exit this process.
Some subtle things to note:
It is not necessary to delete a message if you do not wish it to appear for anyone. Just set the dates to past values and no one will see the message. This is useful if your message should only appear for a short period of time each year or each term. It will save you from having to recreate the template row each time.
Remember that the top portion uses ldap group and date for displaying a message. If you enter a valid start date but set the end date for 20991231, the message will always be viewed….but only by those individuals in the specific ldap group. If for example: you want the Account Holds information to always remain on the screen visible for anyone who has holds, set the begin date to today and the end date for 20991231 with a p_gr_holds ldap group.
The system is design to use a link to a web page but if you want to do something a little more unusual such as “Click here to send an email”, contact ITS. It may be possible but will likely require some extra coding in the message section.
Apply for Graduation Web App
...
01/06/2015 Dart, Pam Revised to be used by both undergrads and graduates.
Brief Description
This web application allows the undergraduate and graduate students to apply for graduation.
Link: access is through myCanisius portal from the commencement page.
Authentication
The p_greligible and p_grelig_ovr ldap members should be authorized for this application. P_greligible includes all students registered this academic year and have a classification of '2J', '1U', '2U', 'G2','G3','G4' or 'G5'
Each candidate may apply for graduation one time per year (year value from wreg162 table). Duplicates are not allowed.
When they logon, they see the following screen:
...
If the student is an undergrad, the Undergraduate button is available to click. If the student is a graduate student, the Graduate button is available. Both of the screens that follow are very similar except that the graduate one requires the selection of the degree and the undergraduate application will default it.
All majors and all concentrations will be listed in the top portion. This information is based on the sovlcur and sovlfos data. The student’s name defaults into the diploma name value. This is stored in WREG161 and written to the SHADIPL rows. The system updates SHBDIPL as appropriate with this value regardless of there being data already in the name field. We assume this is the most recent and correct data to be kept. The application will also update the sought row for the student on SHADEGR with data pulled from the WREG004 screen as described below. We assume the sought row exists at this point.
The office of the student records controls which terms are displayed that a student can select (via banner screen WREG004).
If a student selects a non-Spring term in a term beyond the term of the next ceremony (“40” term from wreg161) and they are not applying for a certification, they are prompted to answer an additional question:
When a student applies to graduate, updates are made other database tables as follows:
Wreg153 (tables supporting the wreg002 screen for graduation tracking) –
...
Walker row entered for the next spring term if they answer Yes to the attending question above.
Wreg161 (tables supporting the wreg007 screen for application maintenance)
Row inserted for the term in which they are completing their degree requirements. Duplicates are not allowed within the same WREG004 Year value.
SHBDEGR (table supporting SHADEGR screen)
The row representing the student “SO”ught record updated with the Graduation Term, Deg Code, Status, Year and Graduation Date from WREG004 screen for the term the student is completing their degree requirements.
SHBDIPL (table supporting SHADIPL screen)
The student’s row is either updated or inserted (based on the SHBDEGR_DEGREE_SEQ_NO from SHBDEGR above) with the name entered on this web application.
Also note that the wreg002 screen has been altered so that upon “reload” of the term’s graduation data, any “walker_flag” or “applied_flag” rows with values are not deleted. This will guarantee that if a student has applied before the Registrar’s office loads the whole term’s data, their application information will not be deleted.
When the student successfully submits their application, the following message will be displayed.
If a student attempts to submit an application more than once, they receive the following:
...
A duplicate is determined based on the year values entered on wreg004. A student cannot submit more than one application within the Year value on WREG004.
On rare occasions it is possible for a student to have applied for graduation in one term (say fall) and indicate that they are attending the spring ceremony. If they then apply for the spring term for a different sequence number, they could have 2 applications for the same term in wreg161 (with different sequence numbers). If this occurs, they will get a message indicating that they must contact the office of student records to have their checkout completed manually. They can no checkout via the web application.
Administrative functions of Graduation Web App
...
Limited individuals have access to the administrative functionality of this application. Those individuals will have an additional link at the top of the screen called Admin..
When you click on that link the following screen will appear:
...
In the search field, enter the last name of a student to reduce the list. Click on the name of the person you would like to impersonate You will be taken to the main screen as that person. However, be patient, response is a little slow on this screen due to the number of students being displayed.
The terms that are displayed on the application screen are controlled by data entered on Banner screen WERG004.
Adding and deleting terms on this screen will control the terms display on the web application line shown below:
The values entered on this screen will control the values entered into the degree pending SHADEGR row updated by the web application.
...
All students who have applied for graduation for that term will be displayed with their answers from the web app.
To add a student to the list for a particular term:
...
top portion of the screen.
To add a student to the list for a particular term:
...
Only those in the Office of Student Records should add people to this list. There are other pieces of information in Banner that must be updated along with this screen in order to manually set someone up for graduation processing.
Click on any row in the table, the Insert button will become undithered, allowing for inserting of a row.
...
Either you will receive a successful message or a failure message in the upper right corner of the screen.
To Delete a Student from the list:
...
Click on the row in the table you wish to delete. Click the delete button in the upper right hand corner of the screen. Note, this delete happens immediately, you do not have to click save for the delete to occur. When you delete a row from this table, it does not reset any values in any of the Banner proper screens such as SHADEGR. Resetting of any of those values must be done manually on those specific screens.
Managing the flags:
To turn a flag on, simply click in the field under the column and enter Y. A blank value represents N. Click Save to save your changes. You can not revise the Applied field. This is set only when a student applies using the web application.
Please note the student will be added to the temporary tables but no processing will be completed for their SGADEGR, WREG002, SHADIPL, ETC. data. That must be managed manually.
Adding and deleting terms on WREG004 will control the terms display on the web application line shown below:
...
The values entered on this screen will control the values entered into the degree pending SHADEGR row updated by the web application. Additionally, the Term Available for Checkout field feeds the process that identifies the terms in which students have applied that allow them to be put into the p_uggr_checkout group. This group controls who can get to the checkout application.
Scholarships and Fellowships Web App
...
08/01/12 Dart, Pam Original
Brief Description
This web application allows the undergraduate students to notify the Office of Student Records of received scholarships, fellowships or assistantships for graduate study work for recognition in the commencement program.
Link: access is through myCanisius portal from the commencement page viewable by p_seniors and is available based on the dates entered in the Need To Know template for this application.
Authentication
The p_seniors ldap members are authorized for this application.
When they logon, they see the following screen:
To add an award, click Add. A blank line will be displayed for the user to enter as shown below:
...
The name of the awarding institution and the type of award are required. Click Save to save the data to the database. A message will be displayed if the data was successfully saved and the entry is added to the students list of awards.
The student can then edit the awards listed, add additional awards or delete awards.
Graduation CheckOut:
Modification Log:
...
03/04/16 Dart, Pamela Removed alternative tickets, added additional tickets for Undergrads
Brief Description
This web application allows the undergraduate and graduate students to checkout for graduation once they have applied and have no holds on their account. The Banner screen for the registrar’s office allows everyone in the registrar’s office to dispense graduation tickets and print the form for the bookstore so that students can get their cap and gown. (For graduate students, no tickets are currently dispensed for their ceremony. Because the students do not have to come to the registrar’s office to collect tickets, their cap and gown form is available to print directly from the web application)
Link: access is through myCanisius portal from the commencement page viewable to p_uggr_checkout and p_grgr_checkout
Authentication
The p_uggr_checkout and p_grgr_checkout LDAP members are authorized for this application.
Each candidate may check out for graduation one time per spring graduation ceremony. Duplicates are not allowed.
When the logon, if they have no graduation holds and have not already checked out for this spring term, they see the following screen: (If they do have graduation holds, they are not allowed to continue. They are given a message indicating that the holds need to be cleared before they can continue.)
All majors and all concentrations will be listed in the top portion. This information is based on the sovlcur and sovlfos data. The student’s name defaults into the diploma name value.
When a student checks out to graduate, a record is written to wreg164. To accommodate multiple ceremonies, the students are all asked if they are attending the general ceremony. However, depending upon their degree, they will either be asked if they are attending the ceremony for the School of Arts and Sciences or The School of Education and School of Business Ceremony. Below is a screen sample for a student in the School of Business.
The wreg164 table tracks each value entered. Updates to SHBDIPL and SHBCATT with UGYES/UGNO as well as termcode (Spring) are based on their answer to the school specific ceremony. If they are not attending, the UGNO value is entered in SHBDIPL and SHBCATT. If they are attending SHBDIPL and SHBCATT will have a UGYES in the appropriate fields.
The graduate version of the above screen lists only the graduate ceremony.
When the undergraduate student successfully submits their information, the following message will be displayed.
When a graduate student successfully submits their information, the following message will be displayed:
...
Graduate students should print their Cap and Gown Authorization form from the button available above.
If a student attempts to submit an application more than once, they receive the following:
If a student has more than one in the table, a message appears telling the student to go to the office of student records to checkout manually.
...
Manually authorizing students to access the graduation portal page and apply:
Call the help desk. Identify the student and tell them to:
“Add the p_grelig_ovr reporting group resource for the student and then reprovision them”.
The help desk can do this and the programming staff can do this.
What will this do:
1) The graduation information section of the Student’s Need to Know section will be displayed allow the student to see the link to the Commencement Community Page.
Once on the Commencement Community Page they will be allowed access to
1) All unsecured announcements available to allUsers.
...
7) The detailed commencement directions once they have checked out (that process will make them part of the p_uggr_checkedout ldap group)
If the student does not have access to the portal anymore because their account has expired (ie: they haven’t been registered in a year) then you can ask the help desk to add the p_student reporting group resource for that student as well. This will give them student access.