financial aid award letters on the web by indiana university of pennsylvania carrie lamont
TRANSCRIPT
![Page 1: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/1.jpg)
Financial Aid Award Letters on the Web
By
Indiana University of Pennsylvania
Carrie Lamont
![Page 2: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/2.jpg)
Presentation Goal Discuss Benefits, Setup, and
Customizations of: AES Award Notification Letter Banner Self-Service Award Letter
![Page 3: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/3.jpg)
About IUP 14,000 students; 1,800 employees Largest Member, SSHE 3 campuses; 1 center; 1 academy Doctoral I Clock-hour programs
![Page 4: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/4.jpg)
Banner at IUP Implemented five baseline modules and
three “Web For” products 1998-2000 Banner 5.x (soon to be Banner 6) Oracle 9I OAS (soon to be Oracle 9IAS) Sun Solaris
![Page 5: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/5.jpg)
Post Implementation SSD, FAMIS, Workflow, TouchNet,
Resource25, IDWorks, CSI Web For Admissions and Web For Alumni Quest Central For Oracle Dozens of custom-written programs and
web applications Large data warehousing initiative
![Page 6: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/6.jpg)
New Additions Looming Banner 6 Oracle 9IAS, J-Developer, Forms 9i,
Oracle Portal Pipeline/Luminus XTender Solutions Messaging Integrator
![Page 7: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/7.jpg)
Banner IT Support at IUP Application Development Group
1 Coordinator 1 Senior Systems Analyst/DBA 2 Senior DBAs 7 Developers
Miscellaneous Entities User Services, Tech. Services, Acad. Support
Reps., Power Users
![Page 8: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/8.jpg)
The Challenge Improve the level of service to IUP
students while reducing costs and resources simultaneously
![Page 9: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/9.jpg)
Solution Building Blocks Available Options:
Custom Letters, AES Award Notification
Letters to be supplied: Initial vs. Adjusted
How to handle Freshman: Web generated letter vs. Hard copy letter
Getting the message to students
![Page 10: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/10.jpg)
Past Award Notification Process Popsels, variables, etc created in Banner
by App Dev. Maintained once an aid year by Fin Aid. Letter Generation run once a week. Students stuff and mail letters every week
for hours.
![Page 11: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/11.jpg)
AES Award Notification Process
![Page 12: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/12.jpg)
AES Award Notification Project Accessed via AES Student Portal Customize Setup Maintain Profiles Regularly upload flat files of award data Generate Reports https://hydra.pheaa.org/awards/index.htm
![Page 13: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/13.jpg)
Benefits of AES letters Custom profiles for schools Provides initial and adjusted letters Ability to accept/decline awards Email notification options Report capability
![Page 14: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/14.jpg)
Customized Banner Self-Service Award
Letters
![Page 15: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/15.jpg)
Banner Self-Service Project Created a DB procedure Compiled in the DB Set up in Web Tailor to integrate with
Banner Accessed via Financial Aid Menu in Banner
Self Service
![Page 16: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/16.jpg)
Benefits of Letters via Banner Web
Economic Advantage Maintenance free Dynamic Data Single point of access Easily Accessible
Additional Resources Multiple Award Letters Awards by term AES not available (winter 2003)
![Page 17: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/17.jpg)
Cons of Letter on the Web
Retraining currently enrolled students Parents feel isolated Keeping up with accuracy of URLs
![Page 18: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/18.jpg)
Banner Self Service Customizations
Aid Year Packaging Dates Aid Period Award Type
Financial Aid is able to control access to data on many levels:
![Page 19: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/19.jpg)
Display Multiple Aid Years
Financial Aid can display multiple award letters for their students based on Aid
Year.
![Page 20: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/20.jpg)
Display Multiple Aid Years Access to information is controlled by Information Access
Indicators.
![Page 21: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/21.jpg)
Display Multiple Aid Years If ROBINST_INFO_ACCESS_IND = 'Y' and
ROBINST_AIDY_START_DATE <= ‘SYSDATE’: Display Aid Year
![Page 22: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/22.jpg)
Control by Packaging Date
If Packaging has not been run yet for the aid year in question, then award letters
should not be displayed!
![Page 23: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/23.jpg)
Control by Packaging Date cont
A user-defined field was set up on RTVUSER to store a generic packaging date
![Page 24: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/24.jpg)
Control by Packaging Date cont
If Current Date < RTVUSER_DESC_10 date:
'PACKAGING HAS NOT BEEN PERFORMED YET FOR THIS AID YEAR’
![Page 25: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/25.jpg)
Packaging Date Restrictions cont
Not all students get packaged at the same time.
If the students packaging complete date is not populated, then award letters should
not be displayed!
![Page 26: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/26.jpg)
Packaging Date Restrictions cont
If RORSTAT_PCKG_COMP_DATE is null:'NO PACKAGING DATE FOR STUDENT'
![Page 27: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/27.jpg)
Aid Period Considerations
A student’s aid period code determines what terms are displayed on the award
letter.
![Page 28: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/28.jpg)
Aid Period Considerations cont
If RORSTAT_APRD_CODE = ‘FA/SPR’: Fall and Spring aid is displayed. If RORSTAT_APRD_CODE = ‘SP/S/F’: Spring, Summer, and Fall aid is
displayed.
![Page 29: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/29.jpg)
Fund Codes displayed on Letter
Financial Aid can control what Fund Codes are displayed on the Award Letter.
![Page 30: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/30.jpg)
Fund Codes displayed on Letter cont
If RFRBASE_VR_MSG_NO is null:
Fund Code will not display on the award letter.
![Page 31: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/31.jpg)
![Page 32: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/32.jpg)
Delivering Financial Aid is Information and Customer Communications Intensive
Integrate Award Letter and Resources!!
![Page 33: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/33.jpg)
Integrate Award Letter and Resources Provide:
explanations of useful information downloadable forms active financial aid messages outstanding requirements
![Page 34: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/34.jpg)
Increase service level for students Reduce number of student calls/inquiries Less demand for Financial Aid counselors
on the counter
Integrate Award Letter and Resources
![Page 35: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/35.jpg)
Additional Links on Award Letter Download scholarship form Review explanation of aid programs Review explanation of IUP charges
![Page 36: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/36.jpg)
Additional Buttons View Active Messages on ROAMESG
If ‘SYSDATE’ < RORMESG_EXPIRATION_DATE: Display Message
![Page 37: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/37.jpg)
Additional Buttons cont
View Outstanding Requirements on RRAAREQ If RRRAREQ_TRST_CODE = ‘E’ or ‘I’: Display Requirement Click hyperlinked requirements to download necessary forms
![Page 38: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/38.jpg)
Demonstration
https://wwwdev.banner.iup.edu/
![Page 39: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/39.jpg)
Visible Improvements Pre-Banner: ~75,000 letters/yr
Initial and Adjusted for all students Banner Let Gen: ~9,500/yr
Initial and Adjusted for all students Now: ~4,500 letters/yr
Initial for Freshman Only
![Page 40: Financial Aid Award Letters on the Web By Indiana University of Pennsylvania Carrie Lamont](https://reader036.vdocuments.us/reader036/viewer/2022062404/5514ff03550346b0338b656a/html5/thumbnails/40.jpg)
Conclusion Current award letters are available via
Banner Self-Service for all students Initial/Current award letters will be
available via AES for all students Freshman will receive a hard-copy letter,
as well.