Return to Navigation

Performing Batch Repackaging

This section discusses how to:

Page Name

Definition Name

Navigation

Usage

Select Students for Repackaging

SFA_RUN_RPKG_SEL

select Financial Aid, then select Awards, then select Repackaging, then select Select Students to Repackage, then select Select Students for Repackaging

Define the population of students to repackage for award eligibility.

Batch Repackaging Students

SFA_RPKG_STDNTLIST

select Financial Aid, then select Awards, then select Repackaging, then select View Selected Students, then select Batch Repackaging Students

View a list of students selected for repackaging. Optionally, select Valid or Invalid for Process Status.

Assign Repackaging Plan

SFA_RUN_RPKG_ASN

select Financial Aid, then select Awards, then select Repackaging, then select Assign Repackaging Plans, then select Assign Repackaging Plan

For a selected population, assign one or more repackaging plans.

Batch Repackaging Plans Assigned

SFA_RPKG_PLAN_INQ

select Financial Aid, then select Awards, then select Repackaging, then select View Assigned Plans, then select Batch Repackaging Plans Assigned

View all the students assigned to each repackaging plan.

Batch Repackaging Students by Plan

SFA_RPKG_STDNTPLAN

select Financial Aid, then select Awards, then select Repackaging, then select View Students by Plan, then select Batch Repackaging 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

select Financial Aid, then select Awards, then select Repackaging, then select Process Batch Repackaging, then select Repackage Students in Batch

Repackage a select group of students using their assigned repackaging plans.

Batch Repackaging Summary

SFA_BRPKG_SUMM

select Financial Aid, then select Awards, then select Repackaging, then select View Batch Repackaging Summary, then select Batch Repackaging Summary

Display all repackaging plans, number of students selected, number repackaged, and number not repackaged.

Eligibility and Need

SFA_BRPKG_STUDTL

select Financial Aid, then select Awards, then select Repackaging, then select View Batch Repackaging Details, then select Eligibility and Need

View eligibility and need details for a student after repackaging.

Award Detail

SFA_BRPKG_AWDDTL

select Financial Aid, then select Awards, then select Repackaging, then select View Batch Repackaging Details, then select Award Detail

View award details for a student after repackaging.

Batch Repackaging Errors

SFA_BRPKG_ERROR

select Financial Aid, then select Awards, then select Repackaging, then select View Batch Repackaging Errors, then select Batch Repackaging Errors

View message number and error detail for each student for whom repackaging failed.

Access the Select Students for Repackaging page select (Financial Aid, then select Awards, then select Repackaging, then select Select Students to Repackage, then select Select Students for Repackaging).

Image: Select Students for Repackaging page

This example illustrates the fields and controls on the Select Students for Repackaging page. You can find definitions for the fields and controls later on this page.

Select Students for Repackaging 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.

Select the Population Selection check box.

Image: Select Students for Repackaging: Population Selection check box

This example illustrates the fields and controls on the Select Students for Repackaging: Population Selection check box. You can find definitions for the fields and controls later on this page.

Select Students for Repackaging: Population Selection check box

Field or Control

Definition

Population Selection

Select to use Population Selection to define the student population.

Selection Tool

Appears 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

Appears 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 appears.

Field or Control

Definition

Aid Processing Status

Select Repackage or any status that indicates that the student has been previously packaged and needs to be reevaluated. 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.

Access the Batch Repackaging Students page (select Financial Aid, then select Awards, then select Repackaging, then select View Selected Students, then select Batch Repackaging Students).

Image: Batch Repackaging Students page

This example illustrates the fields and controls on the Batch Repackaging Students page. You can find definitions for the fields and controls later on this page.

Batch Repackaging Students page

Field or Control

Definition

Process Status

Indicates whether the student is 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, a row exists for each career for which they can be repackaged.

Access the Assign Repackaging Plan page (select Financial Aid, then select Awards, then select Repackaging, then select Assign Repackaging Plans, then select Assign Repackaging Plan).

Image: Assign Repackaging Plan page

This example illustrates the fields and controls on the Assign Repackaging Plan page. You can find definitions for the fields and controls later on this page.

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

Field or Control

Definition

Career

Select the academic career to process 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 select 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)

Note: Do not use FED_EFC for repackaging plans that have a non-standard award period. FED_EFC represents the PRIMARY_EFC, which is the 9–month EFC that is synonymous with the academic award period. Therefore, all non-standard award period FED_EFC values equal 0.00. If you sort by FED_EFC for non-standard plans, the system defaults the sort order to EMPLID.

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.

Access the Batch Repackaging Plans Assigned page (select Financial Aid, then select Awards, then select Repackaging, then select View Assigned Plans, then select Batch Repackaging Plans Assigned).

Image: Batch Repackaging Plans Assigned page

This example illustrates the fields and controls on the Batch Repackaging Plans Assigned page. You can find definitions for the fields and controls later on this page.

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 field displays the value of the FED_EFC sort field, which was defined on the Assign Repackaging Plans page.

Access the Batch Repackaging Students by Plan page (select (Financial Aid, then select Awards, then select Repackaging, then select View Students by Plan, then select Batch Repackaging Students by Plan ).

Image: Batch Repackaging Students by Plan page

This example illustrates the fields and controls on the Batch Repackaging Students by Plan page. You can find definitions for the fields and controls later on this page.

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.

Access the Repackage Students in Batch page (select Financial Aid, then select Awards, then select Repackaging, then select Process Batch Repackaging, then select Repackage Students in Batch).

Image: Repackage Students in Batch page

This example illustrates the fields and controls on the Repackage Students in Batch page. You can find definitions for the fields and controls later on this page.

Repackage Students in Batch page

Field or Control

Definition

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: Oracle recommends 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 rerun Batch Repackaging Simulation to produce the desired award amounts. When you are satisfied with the Simulation results, rerun Batch Repackaging in Live mode.

Access the Batch Repackaging Summary page (select Financial Aid, then select Awards, then select Repackaging, then select View Batch Repackaging Summary, then select Batch Repackaging Summary).

Image: Batch Repackaging Summary page (1 of 2)

This example illustrates the fields and controls on the Batch Repackaging Summary page (1 of 2). You can find definitions for the fields and controls later on this page.

Batch Repackaging Summary page (1 of 2)

Image: Batch Repackaging Summary page (2 of 2)

This example illustrates the fields and controls on the Batch Repackaging Summary page (2 of 2). You can find definitions for the fields and controls later on this page.

Batch Repackaging Summary page (2 of 2)

Field or Control

Definition

Batch Number

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

Batch Date Time

The date and time that 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. Values are:

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 to 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.

Access the Eligibility and Need page (select Financial Aid, then select Awards, then select Repackaging, then select View Batch Repackaging Details, then select Eligibility and Need).

Image: Eligibility and Need page

This example illustrates the fields and controls on the Eligibility and Need page. You can find definitions for the fields and controls later on this page.

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

Field or Control

Definition

Sequence

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 whether the student is eligible to receive a Pell Grant.

Received First Bachelor Degree

Indicates whether the student has already received his or her first bachelor's degree.

Title IV Eligibility

Indicates whether the student is eligible to receive federal Title IV aid.

Access the Award Detail page (select Financial Aid, then select Awards, then select Repackaging, then select View Batch Repackaging Details, then select Award Detail).

Image: Award Detail page

This example illustrates the fields and controls on the Award Detail page. You can find definitions for the fields and controls later on this page.

Award Detail page

All awards in the repackaging plan are listed as zero or nonzero awards. Nonzero awards display a link to the scheduled disbursements.

Field or Control

Definition

Seq (student sequence)

Indicates the order in which students were repackaged during the Repackaging process.

Nbr (award number)

The sequence number is 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 that is 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 that the student did not receive this award.

Access the Batch Repackaging Errors page (select Financial Aid, then select Awards, then select Repackaging, then select View Batch Repackaging Errors, then select Batch Repackaging Errors).

Image: Batch Repackaging Errors page

This example illustrates the fields and controls on the Batch Repackaging Errors page. You can find definitions for the fields and controls later on this page.

Batch Repackaging Errors page

Only students who had serious errors, such as students who had their financial aid term deleted, are in this list.

Field or Control

Definition

Batch #

The batch number identifies the particular Repackaging session.

Batch Date Time

The date and time that 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

The key by which the error data is sorted.

ID

The ID of the student who was not repackaged.

Message Number

Click 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 was entered 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.

This item type is being processed in Repackaging for a decrease, and has either been decreased to a lower award amount or set to a 0.00 value and canceled.

9224

Repackaging: Item Type Increase does not meet increase threshold; rejected.

This 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.

This 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.

Incorrect or inconsistent equation data is 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 the 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.