Managing Repackaging

This chapter provides an overview and discusses how to:

Run the Need Summary Validation process.
Perform batch repackaging.
Perform online repackaging.
Review a repackaging result.

Understanding Repackaging

Using Repackaging, you can award financial aid for groups of students. An equation, a PS Query, or an external file can identify the group of students for repackaging. You can then associate one or more repackaging plans to that population. You can evaluate your selected population and the repackaging plan associated with each student first. The system selects the optimum repackaging plan for each student based on the combination of your repackaging equations and the processing order of the repackaging plan. Then the system applies the repackaging plan against those selected students, awarding each student based on the defined repackaging plan rules.

Three processes are run as part of Repackaging. The first process selects students for evaluation. The second process assigns repackaging plans to students. The third process reviews the student's eligibility, the program rules, and other eligibility criteria and then decreases, increases, or validates existing awards, or it inserts new awards to students using the assigned repackaging plans. After the first two processes, you can review the students being selected and the assigned repackaging plans. You can also review the order in which the students will be repackaged, again by repackaging plan. You can delete students that should not be repackaged. Finally, you can run the third process in live mode or in simulation mode to review expected repackaging results.

Before repackaging, consider the results you want the system to produce according to your institution's repackaging philosophies. Determine the student attributes to use in the repackaging equations to select the correct students for each repackaging plan. Review the criteria each repackaging plan uses to select students. If some of the selected students cannot be matched to any of your repackaging plans, review the list of these students to determine why the they did not get matched. Adjust your equations to ensure these students are assigned correctly.

Unlike Packaging, during Repackaging, locked awards are always preserved and unchanged, even if the student is in an overaward situation.

During the loading of external awards, an EA lock attribute is set, such that External Awards are treated like locked awards during Repackaging. External awards are always preserved and unchanged, even if the student is in an overaward situation. Once the EA lock is set, you cannot remove it.

Note. Your repackaging plans must be established before you begin repackaging; if you change the selection criteria in either Equations or PS Query, rerun the batch repackaging selection routine. If you make changes to your repackaging plans, rerun the Assign Repackaging plans routine before running the Batch Repackaging process. Changing any repackaging plan selection criteria (tied at the plan level) after students have been assigned to repackaging plans may produce incorrect or undesirable results.

You should run Need Summary Validation before performing any Repackaging activities.

Running the Need Summary Validation Process

This section discusses how to select students for Need Summary Validation.

Page Used to Run the Need Summary Validation Process

Page Name	Object Name	Navigation	Usage
Select Students for Need Summary Validation	SFA_RUN_NEEDUPD	Financial Aid, Awards, Need Summary Validation	Update the needs summary to reflect changes made to COA or Effective Family Contribution (EFC).

Selecting Students for Need Summary Validation

Access the Select Students for Need Summary Validation page.

Population Selection

Population selection is a method for selecting the IDs to process for a specific transaction. Selection tools are available based on the selection tools that your institution selected in the setup of the Population Selection process for the application process and on your user security. Fields in the group box appear based on the selection tool that you select. If your institution uses a specific delivered selection tool (PS Query, Equation Engine equation, or external file) to identify IDs for a specific transaction, you must use it.

See Using the Population Selection Process.

Selection Tool	Select one of these values: Equation Engine, PS Query, or External File. Additional parameters appear for your selected tool.
Query Name	For PS Query, select a population selection query that joins with the bind record SFA_BNSV_BIND, which does not require a career.

Performing Batch Repackaging

This section discusses how to:

Select students for repackaging.
Review students selected for batch repackaging.
Assign repackaging plans to selected students.
Review repackaging plans assigned by query.
Review repackaging plans by student.
Repackage groups of students.
Review batch repackaging summary.
Review eligibility and need after repackaging.
Review batch repackaging details.
Review batch repackaging errors.

Pages Used to Repackage Groups of Students

Page Name	Object Name	Navigation	Usage
Select Students for Repackaging	SFA_RUN_RPKG_SEL	Financial Aid, Awards, Repackaging, Select Students to Repackage	Define the population of students to repackage for award eligibility.
Batch Repackaging Students	SFA_RPKG_STDNTLIST	Financial Aid, Awards, Repackaging, View Selected Students	View a list of students selected for repackaging. Optionally select Valid or Invalid for Process Status.
Assign Repackaging Plan	SFA_RUN_RPKG_ASN	Financial Aid, Awards, Repackaging, Assign Repackaging Plans	For a selected population, assign one or more Repackaging Plans.
Batch Repackaging Plans Assigned	SFA_RPKG_PLAN_INQ	Financial Aid, Awards, Repackaging, View Assigned Plans	View all the students assigned to each Repackaging Plan.
Batch Repackaging Students by Plan	SFA_RPKG_STDNTPLAN	Financial Aid, Awards, Repackaging, View Students by Plan	View individual students and the Repackaging Plan assigned to each, sorted by specified sort field.
Repackage Students in Batch	SFA_RUN_RPKG	Financial Aid, Awards, Repackaging, Process Batch Repackaging	Repackage a select group of students using their assigned repackaging plans.
Batch Repackaging Summary	SFA_BRPKG_SUMM	Financial Aid, Awards, Repackaging, View Batch Repackaging Summary	Display all Repackaging Plans, number of students selected, number repackaged and number not repackaged.
Eligibility and Need	SFA_BRPKG_STUDTL	Financial Aid, Awards, Repackaging, View Batch Repackaging Details, Eligibility and Need	View eligibility and need details for a student after repackaging.
Award Detail	SFA_BRPKG_AWDDTL	Financial Aid, Awards, Repackaging, View Batch Repackaging Details,	View award details for a student after repackaging.
Batch Repackaging Errors	SFA_BRPKG_ERROR	Financial Aid, Awards, Repackaging, View Batch Repackaging Errors	View message number and error detail for each student for whom repackaging failed.

Selecting Students for Repackaging

Access the Select Students for Repackaging page.

Population Selection

See Using the Population Selection Process.

Select the Population Selection check box.

Population Selection

Select this check box to use Population Selection to define the student population.

Selection Tool

Displays if Population Selection check box is selected. Select from: Equation Engine, PS Query, or External File. Additional parameters are displayed for your selected tool.

Query Name

Displays only when PS Query is selected. Select a PS Query that selects a population using one of these bind records

SFA_BRPKGX_BIND, if population selection is not based on career

SFA_BRPKG_BIND, if population selection is based on career

Equation Name

If you select Equation Engine, the Equation Name field appears. Select an equation that is defined with the application prompt Batch Repackaging Selection.

Processing Status Selection

If the Population Selection check box is not selected, the Processing Status Selection is displayed.

Aid Processing Status

Select Repackage or any status that indicates the student has been previously packaged and needs to be re-evaluated. The External Award Load process assigns the Repackage status to any student who has a Loan Certification Request as an external award or if the student’s Aid Processing Status is Complete.

Reviewing Students Selected for Batch Repackaging

Access the Batch Repackaging Students page.

Process Status

Indicates if the student will be processed (Valid) or not processed (Invalid) in the next Repackaging run.

You can delete the student's row or change the Process Status to Invalid to remove a student from this repackaging batch. If students have multiple careers, there is a row for each career for which they will be repackaged.

Assigning Repackaging Plans to Selected Students

Access the Assign Repackaging Plan page.

From the Selection Definition list, select the name of the student group defined on the Select Students for Repackaging page. Then define the Repackaging Plan for this group of students.

Repackaging Plan Parameters

Career	Select the Academic Career that you will be processing during this Repackaging run.
Repackaging Plan	Select from the list of Repackaging Plans for this Aid Year and Career.
Sort Field	Select a field on which to sort students within each plan. Then choose ascending or descending order from the Sort Order field. Sort Field and Sort Order determine the order in which students are repackaged. For example, to repackage students with the lowest Federal EFC first and students with the highest Federal EFC last, select FED_EFC and then a Sort Order of Ascending. Select from: ADJ_PAR_CONTRIB (Adjusted Parent Contribution) AGI_PAR (Parents’ Adjusted Gross Income) AGI_STU (Students’ Adjusted Gross Income) EMPLID (Employee ID) FED_EFC (Federal Effective Family Contribution) FED_NEED (Federal Need) FED_PARENT_CONTRB (Federal Parent Contribution) FED_STDNT_CONTRB (Federal Student Contribution) INST_EFC (Institutional Effective Family Contribution) INST_PARENT_CONTRB (Institutional Parent Contribution) INST_STDNT_CONTRB (Institutional Student Contribution) PRORATED_EFC (Prorated Effective Family Contribution) TRANS_PROCESS_DT (Transaction Process Date)
Sort Order	Based on the selected Sort Field, select Ascending to order students from lowest to highest or Descending to order students from highest to lowest. See Sort Field.

Reviewing Repackaging Plans Assigned by Query

Access the Batch Repackaging Plans Assigned page.

To further identify each repackaging plan, the page lists the student's career, the sort field and order from the Assign Repackaging Plan page, and the plan order from the repackaging plan setup.

In this example, Patrick Quijano (FARPK0045) did not meet any of the Selection Criteria of the Repackaging Plans defined on the Assign Repackaging Plans page. The batch routine did not assign him a Repackaging Plan.

The Sort Field Value (such as FED_EFC) field displays the value of the FED_EFC sort field, which was defined on the Assign Repackaging Plans page.

Reviewing Repackaging Plans by Students

Access the Batch Repackaging Students by Plan page.

For each repackaging plan, the page displays the Repackaging Plan ID, Career, and sort field and sort order from Assign Repackaging Plan page. The Plan Order is the processing order for the repackaging plan from the repackaging plan setup.

For each repackaging plan, the selected students are listed as sorted by the Sort field and Sort order. In this example, the students are listed in ascending FED_EFC order, as defined on the Assign Repackaging Plans page. The Sort Field column, such as FED_EFC, lists the FED_EFC value.

Repackaging Groups of Students

Access the Repackage Students in Batch page.

Selection Definition

From the Selection Definition list, select the name of the student group defined on the Select Students for Repackaging page.

Live

Select this mode to run the process and commit the awards to the database. This includes tables such as student awards, student disbursements, student aggregate history, loan information, fiscal item types, and the award activity log.

Note. It is recommended that you run in Simulation mode at least once before running in Live mode.

Simulation

Select this mode to simulate and view results. You can then refine your repackaging plan rules and re-run Batch Repackaging Simulation to produce the desired award amounts. Once you are satisfied with the Simulation results, re-run Batch Repackaging in Live mode.

Reviewing Batch Repackaging Summary

Access the Batch Repackaging Summary page.

Batch Number

The number assigned to the batch of students when you run Repackaging process.

Batch Date Time

The date and time you ran the Repackaging process for this batch of students.

Live vs. Simulation

Indicates whether you ran the Repackaging process in live or simulation mode.

Live: The Repackaging process updated all award-related tables.

Simulation: You can review the results of the Repackaging process, but award-related tables were not updated.

Repackaging Plan ID

Identifies the repackaging plan used in this Repackaging process.

Total Selected

The total number of students assigned this repackaging plan.

Total Packaged

The total number of students who were successfully repackaged using this repackaging plan.

Total Not Packaged

The total number of students who were assigned this repackaging plan but did not receive any awards because of one or more errors.

Reviewing Eligibility and Need After Repackaging

Access the Eligibility and Need page.

This information is for a single repackaging plan. To view other students, use the Eligibility Summary scroll arrows. To view further information for this student, use the Need Summary by Award Period scroll arrows.

Eligibility Summary

Sequence	The sequence number indicates the order in which students were repackaged during the Repackaging process.
Federal Dependency Status	Indicates whether the student is dependent or independent under federal methodology.
Institutional Dependcy Status (institutional dependency status)	Indicates whether the student is dependent or independent under institutional methodology.
Federal PELL Eligibility	Indicates if the student is eligible to receive a Pell Grant.
Received First Bachelor Degree	Indicates if the student has already received his first bachelor's degree.
Title IV Eligibility	Indicates if the student is eligible to receive federal Title IV aid.

Reviewing Batch Repackaging Details

Access the Award Detail page.

All awards in the repackaging plan are listed as zero or non-zero awards. Non-zero awards display a link to the scheduled disbursements.

Seq (student sequence)	The sequence number indicates the order in which students were repackaged during the Repackaging process.
Nbr (award number)	The sequence number automatically assigned in increments of ten when awards are entered.
Item Type	The financial aid item type of the student's award.
Disb Plan (disbursement plan)	The disbursement plan assigned to the student's award.
Split Code	The split code of the student's award, which indicates how the award is split for disbursement to the student.
Offered	If the offered amount for an award is 0.00, then the student was not eligible for that particular award or it was an unlocked, pre-existing award. The zero awards are not visible after the student's award package is posted.
Disbursement	Click to access the Batch Repackaging Disbursement page and view scheduled disbursement detail for an award.
Message	Click to access the Batch Repackaging Message page and view the reason why the student did not receive this award.

Reviewing Batch Repackaging Errors

Access the Batch Repackaging Errors page.

Only students who had serious errors, such as students who had their Financial Aid Term deleted, are in this list.

Batch #	The batch number identifies the particular Repackaging session.
Batch Date Time	The date and time the Repackaging session was run.
Total Not Packaged	The total number of students who were assigned to the repackaging plan but were not repackaged due to an error.
Error Sequence	Key by which the error data is sorted.
ID	The ID of the student who was not repackaged.
Message Number	Click this link to view the error message.

Repackaging Error Messages

Message Number	Message Text	Explanation
9221	Repackaged award does not exist; Item Type rejected.	This item type has been input into the packaging process during repackaging and is marked as a change or cancel. However, the item type does not exist at this stage in the student's current package. As a result it is being discarded.
9223	Repackaging: Item Type award amount has been decreased.	Item Type is being processed in repackaging for an decrease, and has either been decreased to a lower award amount or set to a 0.00 value and cancelled.
9224	Repackaging: Item Type Increase does not meet increase threshold; rejected.	Item Type is being processed in repackaging for an increase, but the need or cost of attendance threshold for the package has not been met. As a result, the item type is rejected.
9225	Item Type with disbursements canceled.	This disbursed award has been canceled. The item type does not meet disbursement protection rules.
9226	Item Type decrease does not meet decrease threshold; rejected.	Item Type is being processed in repackaging for a decrease, but the need or cost of attendance threshold for the package has not been met. As a result, the item type is rejected.
9506	This student was not assigned to a Packaging, or Repackaging, Plan.	The student did not meet the selection criteria for the Packaging, or Repackaging, Plans defined for the specified Career.
9528	Award was auto-canceled.	The award was canceled by an Auto Cancel Item Type.
9544	Invalid equation data for Selection Criteria at the Packaging, or Repackaging, Plan level.	There is incorrect or inconsistent equation data associated with the Selection Criteria at the Packaging, or Repackaging, Plan level.
9590	Student has no awards for the specified academic career.	The student cannot be repackaged because no awards exist for the specified academic career.
9591	Student does not have a Packaging Plan.	The Repackaging rule is Original Packaging Plan, but Packaging Plan ID is missing from STDNT_AID_ATRBT. Please contact your System Administrator for assistance.
9592	Number of Auto-cancel Item Types exceeds the size of an internal table.	The total number of Auto-cancel Item Types exceeds the size of an internal table. Please contact your System Administrator for assistance.
9593	Unable to sequence new award as desired.	The system was unable to assign a PKG_SEQ_NBR that would sequence the new award as desired. Please contact your System Administrator for assistance.
9594	No awarding from Related Item Type Group.	The system was unable to award any of the Item Types specified for a Related Item Type Group.

Performing Online Repackaging

You should run Need Summary Validation before performing any Repackaging activities.

This section discusses how to repackage individual students.

Pages Used to Repackage Students Online

Page Name	Object Name	Navigation	Usage
Student Aid Package	STDNT_AWARD_ENTRY3	Financial Aid, Awards, Award Processing, Assign Awards to a Student, Student Aid Package	Use this page for manual repackaging, auto select repackaging, or auto repackaging. Auto select repackaging and auto repackaging can be combined with manual repackaging in the same online repackaging session.
Professional Judgement	STDNT_AWARD_ENTRY4	Financial Aid, Awards, Award Processing, Invoke Professional Judgement, Professional Judgement	Use professional judgement to override all federal and aggregate rules except for fiscal limits when repackaging online. Repackage students without a budget. All item types awarded from this component will be set to PJ locked.
Packaging Status Summary	STDNT_AID_PACKAGE	Financial Aid, View Packaging Status Summary	View the Repackaging Plan ID for student who has been repackaged.

Repackaging an Individual Student

Access the Student Aid Package page or the Professional Judgement page.

Common Page Information

Career	The active career for the student to be used for repackaging at this time. If the student only has one career, it is defaulted into the field. If the student has multiple careers, choose from among the active careers for the student, which are defined on the Financial Aid Term record. Once you select a career, do not change this field until after you click the Post button or the Reset button. This prevents you from changing awards for more than one career at a time. Only the repackaging plans and disbursement plans associated with the active career are available during this session. Note. If the student has only one career for the aid year, that career defaults into the Career field and you do not need to select a career.
Repackaging Plan ID	Either select the Repackaging Plan from the list to use Auto Repackaging or leave the Repackaging Plan ID field blank to use Auto-Select Repackaging. For Auto-Select Repackaging, the system selects the Repackaging Plan that has the lowest sequence number of the plans for which the student qualifies. The Repackaging Plan ID field will be populated with the qualified plan.
Repackage	Click this button and the system returns award results and corresponding disbursement plan and split code data. After you post the repackaging results, the Repackaging Plan ID is displayed on the Student Aid Package, Professional Judgement, and on the Packaging Status Summary pages.
Award Period	Provides the Repackaging routine with the intended award period processing mode for the award period that you are currently repackaging. The routine uses this information to determine automatically which existing awards are active or passive. The award period you select functions like the repackaging plan award period attribute on the Repackaging Plan setup in the determination of passive/active mode for existing awards. Both: You are currently repackaging the student for both award periods. This is the default value. The Repackaging routine reevaluates all existing awards, processing all awards as active awards. When you select Both, all awards are available for reevaluation. Academic: You are currently repackaging the student for the academic award period (AAP) only. The Repackaging routine reevaluates only existing awards whose disbursement plan/split code patterns indicate that they are for the AAP or for both award periods. The Repackaging routine processes all other existing awards as passive awards. Non-Std (non standard): You are currently repackaging the student for the non standard award period (NSAP) only. The Repackaging routine reevaluates only existing awards whose disbursement plan/split code patterns indicate that they are for the NSAP or for both award periods. The Repackaging routine processes all other existing awards as passive awards.
Reset	Click this button to clear this instance.
Post	Click this button to save the results to the student award table.

Status tab

Select the Status tab

Lock

Unlike Packaging, during Repackaging, locked awards are always preserved and unchanged. Even if the student is in an overaward situation, Repackaging always retains the locked award in its entirety.

EA

During the loading of external awards, this EA lock attribute is set. External Awards are treated as locked awards during Repackaging. External awards are always preserved and unchanged, even if the student is in an overaward situation. You cannot remove the EA lock.

Review a Repackaging Result

This section discusses:

Repackaging process behavior
Example of a decrease repackaging plan

Repackaging Process Behavior

During the Repackaging process, the system updates the Unmet/Overaward Need and Unmet/Overaward COA totals as each award is adjusted. The system does not wait until all awards have been adjusted to calculate these Need Summary totals. The resulting Unmet/Overaward Need and Unmet/Overaward COA values determine if further reductions or adjustments are necessary.

For the Decrease – Bottom Up Repackaging Rule, the system reduces the student's package from bottom up (highest to lowest sequence), but calculates the Need Summary from top down (lowest to highest sequence). If the student's package contains Special Need/Cost awards and the Repackaging Plan is Decrease – Bottom Up, because the system updates the Need Summary totals top down after each award has been reduced, the characteristics of that Special Need/Cost award can change from completely replacing EFC to partially replacing EFC to completely reducing Unmet Need.

Example of a Decrease Repackaging Plan

The Decrease Repackaging Plan example focuses on the FASS Scholarship, a Special Need/Cost award, to highlight the changing nature of the Meet Need/Cost attribute. This behavior is similar to a Stafford Unsub. With each step in the Repackaging example, the FASS Scholarship amount progresses from completely replacing EFC to completely reducing Unmet Need.

Initially, the student was awarded 740 USD FASS Scholarship. During Repackaging, because the student's EFC is reduced to 560 USD and because this is a Special Need/Cost award, Repackaging reduces the award to match the EFC: The original award of 740 less EFC of 560 equals 180. Therefore, the system will reduce the original award by 180.

Revised award = 560 (740-180 = 560).

Once the system determines that the award is 560 USD, it preserves that award in the student's package. However, because that award is defined as Special/Need Cost, its attribute will change from completely replacing EFC to completely reducing Unmet Need.

Original Package Awards

The Student Aid Package page displays the student's initial set of awards.

This table lists the relevant attributes for the original awards.

Sequence	Award	Meet Need/Cost	Lock
10	Federal Pell Grant	Straight Need/Cost	Unlocked
20	State Scholarship	Straight Need/Cost	Unlocked
30	Honors Scholarship	Special Need/Cost	Unlocked
40	University Grant	Straight Need/Cost	Unlocked
50	Federal SEOG Grant	Straight Need/Cost	Unlocked
60	FASS Grant	Straight Need/Cost	Locked
70	FASS Scholarship	Special Need/Cost	Unlocked
80	Exclude Grant	Straight Need/Cost	Locked

After the original package is made to the student, a change to COA or EFC occurs that forces her into an overaward situation. As a result, the student is overawarded in both Need and COA.

Original Need Summary Totals

The Need Summary page displays the student's need summary totals after Packaging.

The administrator determines that the student needs to be repackaged.

Decrease-Bottom Up Repackaging Plan

The Repackaging Plan page displays the Decrease – Bottom Up plan to be applied.

Step 1

The system first determines that the student is overawarded. It then locates the highest sequenced award, Exclude Grant, and evaluates it. Exclude Grant is a Straight Need/Cost award. Since it is a locked award, the system does not reduce it; it is preserved and remains unchanged. The system then updates the Need Summary totals (top down) for Unmet/Overaward Need and Unmet/Overaward COA.

This the Need Summary result after the system processes the Exclude Grant.