Data Field Specifications

R2T4 Wizard Grid

R2T4 Worksheet Controls

R2T4 Worksheet Header

Step 1: Student's Title IV Aid Information

If a campus-based fund was awarded, or Loans were originated after the Date of Withdrawal, the amounts will display as zero/blank in the R2T4 template/worksheet.  If the awards originated after the DOD/WDDD (per configuration), then those funds are not pulled into the R2T4 and display as blank amounts.

R2T4s completed by the Automated Process will have this entire section, except for the "Override Recalculated Pell Amount" field, filled out before auto-finalizing.

Dollar amounts in this section can be overridden.  See Processing an R2T4 in Regent Award for more information on overrides.

Note: When the originated loan amount as of the R2T4 Processing Date (amount calculation date) is different than the originated loan amount as of the R2T4 Date of Withdrawal, the Step 1 Amount used is determined by R2T4 configuration options in Institution, Campus, and Program Setup in Regent Award. Users can select to use either the 'Amount as of R2T4 Date of Withdrawal' (default) or the 'Amount as of R2T4 Processing Date' for the ‘Originated Loan Amount to Use If Amount on R2T4 Processing Date is Lower Than Amount on R2T4 Date of Withdrawal' field. Users can select to use either the 'Amount as of R2T4 Date of Withdrawal' (default) or the 'Lower of the Highest Amount Originated prior to R2T4 Date of Withdrawal and Amount Originated as of R2T4 Processing Date' for the ‘Originated Loan Amount to Use If Amount on R2T4 Processing Date is Higher Than Amount on R2T4 Date of Withdrawal’ field.

Step 2: Percentage of Title IV Aid Earned 

There are two different display options for Step 2, one for a student in a credit hour program, and one for a student enrolled in a clock hour program.  The default display is the "credit hour" display.  However, if the Academic Unit Type (from Program Setup) for the student's current active program is "Clock Hour," then the Clock Hour version of Step 2 should be presented to the user.  If the Program Start Date of the student's current active program is after the R2T4 Period End date, then Regent Award will look at the student's prior program (this would be the program the student was enrolled in during the R2T4 period), not the current program, in order to determine if the program is clock hour based.

Dates and the number of break dates in this section can be overridden.  See Processing an R2T4 in Regent Award for more information on overrides.

Student Course Information

Displays the courses for the Academic Year containing the R2T4 period.  This is necessary to make adjustments to the date ranges based on course failures, course withdrawal dates vs institutional withdrawal dates, etc.

Step 3: Amount of Title IV Aid Earned by the Student

Multiply the percentage of Title IV Aid Earned (Box H) by the Total Title IV Aid Disbursed and that Could Have Been Disbursed for the period (Box G).

R2T4s completed by the Automated Process will have this entire section filled out before auto-finalizing.

Step 4: Title IV Aid to be Disbursed or Returned

• If the amount in Box I is greater than the amount in Box E, go to Item J (Post-Withdrawal Disbursement).
• If the amount in Box I is less than the amount in Box E, go to Title IV Aid to be Returned (Item K).
• If the amounts in Box I and Box E are equal, STOP. No further action is necessary.

R2T4s completed by the Automated Process will have this entire section filled out before auto-finalizing.

Step 5: Amount of Unearned Title IV Aid Due from the School

Step 6: Return of Funds by the School

The school must return the unearned aid for which the school is responsible (Box O) by repaying funds to the following sources, in order, up to the total net amount disbursed from each source.

R2T4s completed by the Automated Process will have this entire section filled out before auto-finalizing.

NOTE: The funds and the refund order below apply to R2T4s for students with withdrawal dates on or after 7/1/21, per regulatory guidelines. 

Step 7: Initial Amount of Unearned Title IV Aid Due from the Student

From the Amount Of Title IV Aid to be Returned (Box K), subtract the Amount for the School to Return (Box O).

R2T4s completed by the Automated Process will have this entire section filled out before auto-finalizing.

Step 8: Repayment of Student's Loans

From the Net Loans Disbursed To The Student (Box B), subtract the Total the School Must Return (Box P) to find the amount of Title IV loans the student is still responsible for repaying (Box R).

These loans consist of loans the student has earned or unearned loan funds the school is not responsible for repaying. They are repaid to the loan holders according to the terms of the borrower's promissory note.

R2T4s completed by the Automated Process will have this entire section filled out before auto-finalizing.

Step 9: Grant Funds to be Returned

R2T4s completed by the Automated Process will have this entire section filled out before auto-finalizing.

Step 10: Return of Grant Funds by the Student

When the configuration option to "Automatically Return Grant Amounts in Step 10" at the Institution, Campus, and Program levels is turned on, Regent Award will automatically return the amounts greater than $50 on fund amounts determined to be due from the student to their fund source once the R2T4 is finalized. These refunds are in addition to any Pell returned due to the Pell recalculation and/or any Pell/SEOG/TEACH identified for a refund by the R2T4 calculation. Regent will itemize the amount as an "overpayment" being returned on behalf of the student as a new line item under Step 6.

Except as noted below, the student must Return the Unearned Grant Funds for which he or she is responsible (Box U). The grant funds returned by the student are applied in order as indicated, up to the amount disbursed from that grant program minus any grant funds the school is responsible for returning to that program in Step 6 and the amount of grant protection. Note that the student is not responsible for returning funds to any program in which the student owes $50.00 or less.

R2T4s completed by the Automated Process will have this entire section filled out before auto-finalizing.