420 likes | 600 Views
June 15, 2012 | www.sungardhe.com. 2. . Banner 8.4 Financial Aid Enhancements. Financial Aid Archive and Data PurgeApplicant Purge Process (RORAPRG)removes prior year applicant dataArchive/Purge Applicant Process (RORARCH)removes records for the applicant for an aid yearRules Purge Process (ROR
E N D
1. June 16, 2012 Banner Enhancements8.4 to 8.5 New Mexico Student Loan Conference
Fall 2009
2. June 16, 2012 | www.sungardhe.com 2 Banner 8.4 Financial Aid Enhancements Financial Aid Archive and Data Purge
Applicant Purge Process (RORAPRG)
removes prior year applicant data
Archive/Purge Applicant Process (RORARCH)
removes records for the applicant for an aid year
Rules Purge Process (RORRPRG)
removes records for the aid year
3. Applicant Purge Process (RORAPRG) Purge applicant data for those who have not completed the financial aid process for an aid year
No ability to restore data once purged, may need to restrict access
To be included applicant must not have:
an award record
a resource entered on the Resource Maintenance Form
excluding VA benefits loaded from ISIR
a loan record for the aid year
an entry on the Student Registration Table (SFBETRM) for any term within their aid period June 16, 2012 | www.sungardhe.com 3
4. Applicant Purge Process (RORAPRG) continued Records that will be retained:
Once only requirements where no future requirement exists
a record will be inserted into the Applicants Saved Requirements (RORSREQ) Table
Holds not associated with an aid year or term and not expired
Most recent SAP status code for a term June 16, 2012 | www.sungardhe.com 4
5. Applicant Purge Process (RORAPRG) continued Parameter options
Audit Mode
Report is generated for all student that would NOT have been purged
Optional report for all students that would have been purged
Archive/Purge Logging Records option
Set to A, the logging entries are archived then deleted
Set to P, the logging entries are deleted
Set to N, no processing on the logging entries takes place June 16, 2012 | www.sungardhe.com 5
6. Archive/Purge Applicant Process (RORARCH) allows you to purge applicant data for an aid year where the record retention date has passed
June 16, 2012 | www.sungardhe.com 6
7. Global Institution Financial Aid Options (ROAINST) Retention Expired
check this field to allow archiving
Expiration Date
date Retention Expired was checked
Archive Date
date the archive process was run June 16, 2012 | www.sungardhe.com 7
8. Archive/Purge Applicant Process option to archive summary, award, disbursement, and loan data in a XML document
active Perkins MPN where no future requirement exists, and/or;
Once only requirements where no future requirement exists
a record will be inserted into the Applicants Saved Requirements (RORSREQ) Table
Holds not associated with an aid year or term and not expired
Most recent SAP status code for a term
June 16, 2012 | www.sungardhe.com 8
9. Rules Purge Process (RORRPRG) purge rules for an aid year after the applicant data has been archived/purged
no records in the following tables for the aid year:
Applicant Status Table (RORSTAT)
Applicant Award Table (RPRAWRD) - where the system indicator is not equal to P (Pre-Banner) or A (Archived)
Applicant Resource Table (RPRARSC)
Loan Application Table (RPRLAPP) June 16, 2012 | www.sungardhe.com 9
10. June 16, 2012 | www.sungardhe.com 10 Banner 8.4.1 Financial Aid Enhancements Database Cleanup Enhancement
allows you to truncate and obsolete table structures that have not been utilized for many years
option to export tables prior to truncating
OPTIONAL release
may be applied on any release after Banner Financial Aid 8.4
no other functionality, updates, or defect resolutions included in this release
complete list of tables in the release guide
11. June 16, 2012 | www.sungardhe.com 11 Banner 8.4.2 Financial Aid Enhancements Award Locks Enhancement
allow the update of an award status on locked funds
allow an award with a lock to be accepted in Self-Service
12. Award Locks Enhancement ROAINST
Allow Award Status Updates When Locked added
if set to Y
allow the status of an award to be updated if an award or term lock exists for a fund
both Banner and Self-Service
cannot update any of the other fields when the award is locked June 16, 2012 | www.sungardhe.com 12
13. June 16, 2012 | www.sungardhe.com 13 Banner 8.5 Financial Aid Enhancements Requirements by Term Codes
Tracking Satisfy All/Once Enhancement
Perkins MPN Link Correction
Elimination of Transaction Complete Message on RRAAREQ
More Functionality for SBGI Codes on RRAAREQ
Voice Response Message Number on RTVTREQ
Fund Requirement Removal
Information Access Flag for RTVTRST
Batch Posting Enhancement
14. Banner 8.5 Financial Aid Enhancements - continued Promissory Note Satisfied Indicator/Info Access Indicator Updates
Hyperlink and Instructions Added for Promissory Notes
Link Modification Capability Provided Through Web Tailor
RRRAREQ Report – Print if Null Tracking Group
Problem with SQL Query Defined on RORWVAR Corrected
Perkins MPN Detail Not Available on ROASMRY
Sort Order for Self-Service Requirement Messages
Display Promissory Notes in Self-Service June 16, 2012 | www.sungardhe.com 14
15. Banner 8.5 Financial Aid Enhancements - continued Additional Functionality for the Display of Direct Loan Loan Information
Loan Application History Link Display for DL and CommonLine
Financial Aid Requirements Channel Corrected
New Letter Generation Variables
Manual Loan Application Creation Corrected June 16, 2012 | www.sungardhe.com 15
16. Requirements by Term Codes move functionality from processing by aid year to term/enrollment period
concept of an enrollment period in subsequent phases of this project
combining of multiple terms into one period of enrollment for financial aid purposes
includes providing the ability for a summer enrollment period to be treated either as a trailer or a header
June 16, 2012 | www.sungardhe.com 16
17. Requirements by Term Codes Term code added to RRAAREQ
Term Eligible field was added to the Requirements Tracking Validation (RTVTREQ)
Can be only used for disbursement and memos at this time
June 16, 2012 | www.sungardhe.com 17
18. Tracking Satisfy All/Once Enhancement allow requirements with like federal fund IDs to be satisfied during satisfy all processing
Match Federal Fund ID field was added to the Requirements Tracking Validation (RTVTREQ) Form
If checked for entrance interviews…
entrance interviews for any fund with a federal fund ID of STFD will be satisfied even though the fund codes are different June 16, 2012 | www.sungardhe.com 18
19. Perkins MPN Link Correction RRAAREQ previously, only access if cursor was on requirement
can now access the Perkins MPN Detail Tab of the Applicant Requirements Form (RRAAREQ) anytime a Perkins MPN tracking requirement exists for the applicant
Perkins MPN Tab was modified to display multiple Perkins MPNs and to allow updates to the MPNs June 16, 2012 | www.sungardhe.com 19
20. Elimination of Transaction Complete Message on RRAAREQ Form no longer displays dialog box when saving record
message only displays on the status bar June 16, 2012 | www.sungardhe.com 20
21. More Functionality for SBGI Codes on RRAAREQ previously used for college codes (financial aid transcripts)
a SBGI Type field on the Applicant Requirements Form (RRAAREQ) was added
allows requirements with a SBGI code to be validated against the other types of SBGI codes June 16, 2012 | www.sungardhe.com 21
22. VR Message Number Was Still Required for Tracking Messages VR Mesg number from the Requirement Tracking Validation (RTVTREQ) Form is no longer used for the display of tracking requirements June 16, 2012 | www.sungardhe.com 22
23. Fund Requirement Removal Fund Requirement is now removed from RRAAREQ when the Requirement no longer exists on RFRMGMT and the award is refreshed June 16, 2012 | www.sungardhe.com 23
24. Information Access Flag for RTVTRST Info Access indicator added to RTVTRST
control which requirements are displayed in self-service based on requirement status June 16, 2012 | www.sungardhe.com 24
25. Batch Posting Enhancement RORPOST/RORBPST New Batch Posting Types for Term Requirements
RT Term Specific Requirements
RFT Fund Term Specific Requirements
Only post if existing requirement does not exist
Existing R and RF Batch Posting Code Purpose Has Been Re-Defined
Only post if existing requirement does not exist June 16, 2012 | www.sungardhe.com 25
26. Batch Posting Enhancement - continued New Batch Posting Codes to Update Existing Requirements
RS Requirement Status
RFS Fund Requirement Status
RFTS Fund Term Requirement Status
RTS Term Requirement Status
will update the status for both satisfied and unsatisfied requirements
able to post a status code of unsatisfied to requirements previously satisfied
June 16, 2012 | www.sungardhe.com 26
27. Batch Posting Enhancement - continued allow batch posting to check or uncheck Info Access indicator for tracking requirements
RA Requirement/Access Ind
RFA Fund Requirement/Access Ind
RFTA Fund Term Requirement/Access Ind
RTA Term Requirement/Access Ind
provide the ability to post fund requirements when a fund does not exist
the following types will not check that the fund exists in the applicant’s package
R Requirement
RF Fund Specific Requirement
RFT Fund Term Specific Req
RT Term Specific Requirement June 16, 2012 | www.sungardhe.com 27
28. Batch Posting Enhancement - continued New Batch Posting Type for Info Access indicator for Promissory Note for a fund and term
PNA Fund Term Prom Note/Access Indicator
updates non-Direct Loan Promissory Note June 16, 2012 | www.sungardhe.com 28
29. Promissory Note Satisfied Indicator and Info AccessIndicator Updates forms modified to allow the Satisfied indicator for non-Direct Loan funds to be updated to satisfied or unsatisfied
Promissory Note Form (RPAPROM)
Promissory Note block on the Additional Requirements Tab on the Applicant Requirements Form (RRAAREQ)
Promissory Note block of the Applicant Summary Form (ROASMRY)
Info Access indicator has been added which is updateable for non-Direct Loan funds June 16, 2012 | www.sungardhe.com 29
30. Hyperlink and Instructions Added for Promissory Notes Promissory note Description, URL, and Instructions fields have been added to the RFRMGMT and ROAMGMT
enter your own description for the promissory note to associate with the fund
create a hyperlink
to provide the ability to include instructions June 16, 2012 | www.sungardhe.com 30
31. Link Modification Capability Provided Through Web Tailor Requirement Messages link can be added to the bottom of the page through the "Reorder or Customize Menu Items" in WebTailor June 16, 2012 | www.sungardhe.com 31
32. RRRAREQ Report – Print if Null Tracking Group includes applicants who have not been assigned a tracking group June 16, 2012 | www.sungardhe.com 32
33. Problem with SQL Query Defined on RORWVAR Corrected remove the 50-character limitation on the RORWVAR SQL query result
Increased the size of the web variables and the web text that is displayed
do not impact any of the tables within the database June 16, 2012 | www.sungardhe.com 33
34. Perkins MPN Detail Not Available on ROASMRY Perkins MPN Detail Window available on the Applicant Summary (ROASMRY) Form if the Access Ind field is checked June 16, 2012 | www.sungardhe.com 34
35. Sort Order for Self-Service Requirement Messages sort order of requirement messages was changed to:
RRRAREQ_TREQ_CODE
RRRTMSG_MESG_CODE June 16, 2012 | www.sungardhe.com 35
36. Additional Functionality for the Display of Direct LoanLoan Information Info Access indicator has been added to the Loan Status Validation Form (RTVLNST)
allow you to determine if loan information should display in Self-Service based on the Loan Status for a loan
additional check based on the loan status to determine if the requirement for a Promissory Note should display
will also control if loan information is available from the Loan Application History Link June 16, 2012 | www.sungardhe.com 36
37. Financial Aid Requirements Channel Corrected channel logic updated to use Info Access field on the RRAAREQ Form June 16, 2012 | www.sungardhe.com 37
38. New Letter Generation Variables Two new variables to support term requirements logic
*AWARD_REQ_DESC_NULL_TERM
selects the unsatisfied requirement descriptions where the term code is null
*AWARD_REQ_DESC_WITH_TERM
selects the unsatisfied requirement descriptions where the term code is not null and include the term June 16, 2012 | www.sungardhe.com 38
39. Manual Loan Application Creation Corrected Create Application When Requirement Accepted
cannot be checked if DL or FFELP June 16, 2012 | www.sungardhe.com 39
40. Applicant Requirements Inquiry (RRIAREQ) June 16, 2012 | www.sungardhe.com
41. June 16, 2012 | www.sungardhe.com 41
42. June 16, 2012 | www.sungardhe.com 42