Overview

The Parent Plus Refund process using Banner Population Selection combined with the Banner Auto Refunding of Credit Balance Amounts process (TSRRFND) to identify and process parent plus refunds.  TSRRFND is a two fold process. In step one, accounts with a credit balance are identified, flagged, and  reported. Account detail is listed for the specified term or for any detail code with a non-zero balance, and accounts are grouped by the specified category hierarchy. The control report lists totals for all accounts selected. In step two, after a manual review of the accounts, those flagged are updated with a refund detail code for the amount of the credit balance, and are listed on the report. The refund transactions generated are listed with an address. Any flagged accounts that do not meet the parameter criteria for refunding have their flags reset.

Parent Plus Refund

If a refund due to the student is the result of a PLUS loan payment, and the parent did not indicate that the funds may go directly to the student, the refund is processed as an automatic check payable to the PLUS borrower instead of the student. Refunds are based on the balance for each PLUS Loan that has not been applied to charges to the student's account.

PLUS refunding is enabled if an active detail code exists on Detail Code Control Form (TSADETC) with the Refund Code set to P. If a student has Title IV credits, the system determines if the detail code is a Parent PLUS loan that is refundable to the parent and has been disbursed through Banner Financial Aid. If so, the system creates a refund transaction for the amount with the term of the credit. The parent name and address from the Loan Application (RPRLAPP) are included on the report and in the Account Detail Text table (TBRACDT).

Next, the system sets the transaction number of the fund paid to the transaction number of the PLUS credit being refunded.

Each PLUS credit is handled independently. If there is more than one credit (due to multiple borrowers or multiple disbursements of a loan received together), multiple refund transactions will be created. Any credit balance remaining after all PLUS loans have been considered (including PLUS loans refundable to the student and non-Title IV credits) will generate one refund to the student. 

The process is controlled by:
  • Detail Code A4PP has been setup with a refund code of P ( Parent Plus). 
  • The standard Order of Processing logic in the Application of Payment program (TGRAPPL)
  • Population Extract Process (GLBDATA)
  • Population Selection Data Extract data review (GLAEXTR)
  • Parent Plus Refund Process (TSRRFND) FLAG Mode
  • Refund Review Form (TSARFND)
  • Parent Plus Refund Process (TSRRFND) RFND Mode
  • Execute the Accounting Feed Process(TGRFEED)
  • Execute the Refund Interface(FURAPAY)
  • Generate checks and distribute to the proper recipients. 

Population Extract Processing

To run Auto Refund Credit Amt-Student (TSRRFND) with a population selection we must first run the population selection and review the data making any desired changes. A population selection has been created to query the Accounts Receivable Detail table (TBRACCD) with a detail code of A4PP, a balance less then 0 and parameters for to and from dates. The process of creating and the reviewing of the population selection is to first run Population Extract Process (GLBDATA) using the parameters listed below and entering in your to and from dates (note you will be prompted for the dates one you click on submit and save in the form). After running Population Selection Extract (GLBDATA) you can review the data using Population Selection Extract Data (GLAEXTR) with the parameter set shown below. This is will allow you to make any changes to the data that are needed. After reviewing the data you can proceed to Auto Refund Credit Amt-Student (TSRRFND) and use the population selection you have created. 

  1. Run Population Selection Extract Process (GLBDATA)
    1. Parameter 01 Selection Identifier: BS_PARENT_PLUS_REFUND
    2. Parameter 06 Application Code: ACCOUNTS_RECEIVABLE
    3. Parameter 07 Creator ID of Selection ID: GENERAL
  2. Review Population Extract Data (GLAEXTR). This will allow for review of population selection to be used along with the functionality of adding or removing entries from the population selection. 
    1. Application: ACCOUNTS_RECEIVABLE
    2. Selection ID: BS_PARENT_PLUS_REFUND
    3. Creator ID: GENERAL
  3. TSRRFND Parameters to be used for population created. 
    1. Selection Identifier Enter the code that identifies the population with which you wish to work.
      •  BS_PARENT_PLUS_REFUND should be entered in this field. 
    2. Application Code Enter the code that identifies the general area for which the selection identifier was defined. 
      • ACCOUNTS_RECEIVABLE should be entered in this field. 
    3. Creator ID Enter the user ID of the person creating the sub-population rules.
      • GENERAL should be entered in this field. 
    4. User ID The user ID of the person running the sub-population rules. 
      • Enter your User Name in this field  

Parent Plus Refund Processing

The steps required for Parent Plus refund Processing (TSRRFND) are: 

  1. Run Parent Plus Refund Processing (TSRRFND) in FLAG Mode to create a list of refunds to be processed. 
  2. Review refunds in Refund Review Form (TSARFND) making any corrections that are needed. 
  3. Run Parent Plus Refund Processing (TSRRFND) in RFND Mode to create the refund. 

Parent Plus Refund Parameters

Flag/Refund Mode. (Required) FLAG Mode will identify accounts and update the refund indicator. RFND mode will refund the accounts. 

  • FLAG Identify and update refund indicator on accounts (default).
  • RFND Refund accounts. 

Audit/Update Mode (Required) Audit Mode will produce a report but will not update the database. Update mode will produce a report and update the database. 

  • A Audit
  • U Update (default)

Refund A(LL) or T(IV) (Required) Indicates whether you want to refund all credits or only Title IV credits. 

  • T Banner will refund only the Title IV credits, even if there are other credits on the account. 
  • A Banner will refund the student's total credit balance, but the refund will not be less than the sum total of Title IV credits (default). 

Minimum Credit Balance (Required) Minimum amount the account balance must equal to be considered for this run. 

Address Selection Date (Required) Which address, effective to this date, do you want to retrieve for the account. Enter the date in DD-MON-YYYY format.

 Address Type Hierarchy (Required) Enter the address type to be printed on the report. Multiple requests are permitted and must be entered in priority sequence. For example 1MA 2PR will print mailing address, and if none is found, it will print the permanent address. 

Refund Detail Code (Required for RFND mode, Optional for FLAG) For the RFND mode, the detail code for the refund transaction. Valid values are derived from the Detail Code Control Form (TSADETC).

Cashier User ID (Required for RFND mode, Optional for FLAG) For the RFND mode, the cashier of the session to be created for the refund transactions. 

Process Term (Required for RFND mode, Optional for FLAG) for the RFND mode, the term of the refund transactions. 

  • Term Code (STVTERM)

Entity Type (Optional) For the FLAG mode, specify which accounts to include. 

  • P Person 
  • C Non-Person
  • % Both (Default)

Detail Category Hierarchy (Optional) For the FLAG mode, enter the category code to group the accounts by on the report. Multiple requests are permitted and must be entered in priority sequence. For Example 1FAD. A grouping OTHERS is always made for the those accounts that do not qualify for any group.

  • Detail Category Code (TTVDCAT)

Include/Exclude (Optional) For the FLAG mode, include mode groups accounts by category. Exclude mode forces those accounts that qualify for any of the entered categories to not be processed. The OTHERS group will be the only one listed. 

  • I Include accounts (default)
  • E Exclude accounts

Selection Term (Optional) For the FLAG mode, term code used to determine if an account has any of the entered categories. When running FLAG mode and using a Detail Category hierarchy, the Selection Term must be valued. The term entered will cause only accounts which have detail items for the specified term and category to be included or excluded. When the Selection Term is entered and an account is processed, all detail items for the selected term will be printed. When not using a Detail Category hierarchy, the Selection Term may be left blank. When blank, only detail items with a refundable balance will be printed. 

  • Term code (STVTERM)

Print Account Detail (Optional) For the FLAG mode, Y will print account detail transactions and balances. N will print only the account balances. 

  • Y
  • N

Except Term (Optional) For the FLAG and RFND modes, specify which terms' detail code transactions (charges and payments) should be excluded when calculating account and refundable balances. Transactions with this term will not appear on this report. This option is typically used for calculating refunds when a student is eligible for a refund for the current term, and is also enrolled in a future term for which charges are assessed but not currently due. 

Selection Identifier Enter the code that identifies the population with which you wish to work.

  •  BS_PARENT_PLUS_REFUND should be entered in this field. 

Application Code Enter the code that identifies the general area for which the selection identifier was defined. 

  • ACCOUNTS_RECEIVABLE should be entered in this field. 

Creator ID Enter the user ID of the person creating the sub-population rules.

  • GENERAL should be entered in this field. 

User ID The user ID of the person running the sub-population rules. 

  • Enter your User Name in this field.