Maintenance of Stackable Financial Aid Awards

Summary

This article explains when a financial aid award is considered "stackable", and how the codes for these awards are managed.

Body

A "stackable" financial aid award is an award that can be provided for students concurrently with certain other awards, as determined by leadership at the University.  If an award is not stackable, the dollar amount overlap between that award and certain other awards is not provided twice (i.e. multiple times) for the student.  The list of currently stackable financial aid award codes can vary from academic year to academic year, and the list(s) will change on occasion, most often due to the addition of new stackable award codes.  For any particular academic / financial aid year, the list of stackable awards is maintained in an Envision subroutine in the ST.INSERTS directory.  Instances of these subroutines include the following:

S.FA.PKG.AMT.G15 (starting for new freshmen in academic year 2015-16)
S.FA.PKG.AMT.G16 (starting for new freshmen in academic year 2016-17)
S.FA.PKG.AMT.G17 (starting for new freshmen in academic year 2017-18; also coded for use in academic year 2018-19)
S.FA.PKG.AMT.G19 (starting for new freshmen in academic year 2019-20, and all academic years following)

S.FA.PKG.AMT.GT13 (starting for new transfer students in academic year 2013-14)
S.FA.PKG.AMT.GT14 (starting for new transfer students in academic year 2014-15, and all academic years following)

At some point when time permits, it is desired to add a proper "stackable" field (or fields) to the AWARDS file, so that the status of the awards can be more automatically maintained for any particular academic year.  Currently, there are only two I-descriptors available in the AWARDS file, which include the most current stackable awards list (i.e. the stackable awards list for the most current financial aid year that is available).  These two I-descriptors are C26AW.CURRENT.STACK.CODES, which mirrors the list in the most current subroutine, and an I-descriptor used to find if any certain award in that list is currently stackable, called C26AW.IS.CURR.STACKABLE.  The I-descriptor C26AW.CURRENT.STACK.CODES must be updated whenever there have been changes in the corresponding Envision subroutine.

We often provide an up-to-date listing of stackable codes to staff in the Financial Aid Office when changes have occurred in the list.  There is an Informer report available for this purpose, named "Financial Aid Stackable Award Codes".  It has been scheduled to run on a monthly basis as an up-to-date reference, and should also be run on an ad hoc basis when changes to the stackable award list have been introduced.

Alternate/previous method: This can be done by first copying the list of current stackable codes into a saved list (a tool like Notepad++ is very helpful in doing this, in conjunction with the Colleague SLED form), and then by running a statement, shown below, at the Redwood command prompt.  The output of this query can be copied into a text file and/or an Excel file as needed.  Command prompt statement: SORT AWARDS AW.DESCRIPTION FMT '45L' AW.CATEGORY COL.HDG 'Award}Category' AW.TYPE COL.HDG 'Award}Type' C26AW.AWARD.GROUP NOPAGE HDR.SUP COL.HDR.SUPP

Details

Details

Article ID: 66830
Created
Wed 11/7/18 6:28 PM
Modified
Wed 11/17/21 2:06 PM