28 Nov 2013
4 MINS READ
Recently, we faced a situation where we had to provide an automated Scholarship calculation tool for a leading university. None of the vanilla processes and functionalities met the unique challenges of the customer and we finally decided to develop our own Scholarship calculation engine in our labs to kill the haunting ghost which had been a mystery for many Higher Education customers in this region.
While Campus Solutions do provide scholarship calculation functionality through Financial Aid, there are unique, region specific scenarios where we normally lean towards extensive customization. As a renowned PeopleSoft Shop in association with the product for more than 2 decades, we are well aware of the factors involved in supporting a large custom solution and the challenges involved during upgrades.
So, what did we finally do?
We developed a BOLT-On solution by adopting best practices from other Universities and keeping in mind that solutions should be useful and reusable for other customers too in a plug and play mode.
In this blog, I’m going to discuss how we actually developed the Bolt-On solution for Scholarship Calculation and how you can use this article for any similar requirement in Campus Solutions.
Consider a scenario where you have to develop a Scholarship Calculator based on the following criteria:
Now, the very next thing you can do is to break up the above mentioned requirements into smaller pieces and then take a look at them again individually.
So first we break the lengthy pieces of the requirements mentioned in BIG REQUIREMENT DOCUMENTS into smaller one line statements in the form of questions and answers and then we look carefully at each statement at a time.
For example, the requirement is that certain programs under different colleges affiliated with the University are eligible for Scholarship; we should first focus on figuring out the colleges which are eligible and those that are not for scholarship.
Then we create a SET UP page mentioning the colleges eligible for Scholarship. You can do the reverse for colleges that are not eligible as well. A A similar case would apply if the requirement is as follows:
Students from certain foreign nations getting admitted should get a scholarship only for the Specific semester and should not get any financial assistance for other semesters. Also, the amount of scholarship varies based on the Science, Literature and Commerce programs. Any of the Students performing better in academics will get additional financial assistance based on their programs.
Look at the screen below. We have broken up the above particular statement into set up screens.
We have tried breaking up the requirements into small configurable pieces and every piece works as a condition (when put in a program) for eligibility or non-eligibility of the scholarship. While deciding on these pieces, look around into your Campus Solution system and check if any of the delivered pieces or set-ups can work for you or not. In future, if there is a requirement change, accordingly you can manage your screens and introduce new ones or discard some of the existing ones. This way, your program is always configurable in real sense like any other standard delivered program or process.
Once we are done with the design, let’s see (in the diagram below) how it will actually work once developed into a program.
Once you have your requirements clearly, you need to decide upon the approach, the way your program should work on the database (specifically Student details) and produce results based on the conditions (criteria broken up into smaller pieces).
Now you need to decide upon the tool for writing the calculation engine. The choice is yours, whether you want to write an SQR program or create an Application engine or use any other tool.(Do compare available tools in terms of their advantages before the giant leap)
We actually wrote one application engine program which goes through all the conditions step by step and provides the desired result.
Coming to an important point from Customer’s perspective; how is your customer benefitted from all the hard work you put into this?
Through this kind of solution, your customer, first and foremost, sees all the key business processes getting implemented without any hassle and doesn’t have to depend only on the out of the box solution provided by PeopleSoft (or any other ERP) to meet their unique needs. You don’t have to sound skeptical in front of the customer.
Also, keeping in mind that scholarship criteria does change often based on the geography, economic conditions and with time, such kind of solutions provide better returns, on the investment done while implementing Campus Solutions and creating Bolt-On, in the longer run.
Once the system is ready and in place, you can actually scale up by providing more options or let’s say NICE to HAVE Wish list from the Client.
For example, you can add a feature of “Student Loan Processing” to this by again adding new setup pages and adding few more sections to the program.
You can also produce various reports based on several criteria with the help of this kind of customized solution.
Now, if you can scale this solution to suit requirements for customers from different regions and create a reusable component, this might be very helpful on your next visit to a University looking forward to such solutions. Also, this kind of solution can be handy with some extra customizations for Campus Retail industry.
Question for you? What if your client doesn’t permit a Bolt-On solution and instead asks you to make use of existing HRMS system for scholarships? Think.
We will discuss this in our next blog post.
About the Author
Manufacturing and Consumer
14 Apr 2020
27 Sep 2018
14 Mar 2018
07 Oct 2015
18 Jul 2014
15 Jul 2014
30 Jun 2014
26 Jun 2014
Enterprise Solutions, Manufacturing and Consumer
31 Jan 2014
03 Jan 2014
BI & Analytics
19 Mar 2009
26 Nov 2010
Digital Assurance
02 Jan 2012
17 Feb 2012
Infrastructure Mgmt. Services
02 Mar 2012
03 Jan 2013
04 Feb 2013
06 Feb 2013
Digital Assurance, Enterprise Solutions
14 Feb 2013
18 Feb 2013
21 Feb 2013
27 Feb 2013
Others
01 Mar 2013
04 Mar 2013
Enterprise Solutions
05 Mar 2013
18 Mar 2013
Digital Assurance, Enterprise Solutions, Others
22 Mar 2013
12 Apr 2013
26 Apr 2013
29 Apr 2013
13 May 2013
11 Jun 2013
17 Jun 2013
25 Jun 2013
19 Aug 2013
26 Aug 2013
27 Aug 2013
03 Sep 2013
10 Sep 2013
19 Sep 2013
24 Sep 2013
26 Sep 2013
30 Sep 2013
01 Oct 2013
03 Oct 2013
01 Nov 2013
19 Nov 2013
03 Dec 2013
20 Dec 2013
22 Jan 2014
27 Jan 2014
12 Feb 2014
13 Feb 2014
20 Mar 2014
24 Mar 2014
17 Apr 2014
11 Jun 2014
10 Jul 2014
16 Jul 2014
28 Oct 2014
13 Jul 2015
06 Aug 2015
26 Aug 2015
28 Sep 2015
26 Oct 2015
07 Mar 2016
22 Mar 2016
13 May 2016
23 May 2016
Application Transformation Mgmt.
11 Jul 2016
25 Aug 2016
03 Sep 2016
14 Sep 2016
15 Nov 2016
22 Nov 2016
25 Nov 2016
Business Process Services
25 Apr 2017
Banking and Financial Services
18 May 2017
30 May 2017
23 Jun 2017
27 Jun 2017
18 Jul 2017
26 Oct 2017
Healthcare, Insurance
28 Nov 2017
11 Dec 2017
25 Jan 2018
21 Feb 2018
( Mandatory field * )
The information you provide will be used in accordance with our terms ofPrivacy Policy
Please Check on "I Agree" to register for the blog.