Search Results group_cd

Overview

The table IGF_AW_TARGET_GRP_ALL is a core data structure within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It serves as a master repository for defining and storing target groups, which are sets of upper-level constraints or rules applied to the distribution of financial aid grants. These constraints govern how award amounts are calculated and allocated to students, ensuring compliance with institutional, state, or federal aid policies. The table's role is critical in the award packaging process, as it links high-level grouping logic to specific award distribution formulas and plans. Its "ALL" suffix indicates it is a multi-organization table, storing data partitioned by the operating unit (ORG_ID).

Key Information Stored

The table's primary purpose is to uniquely define a target group within a specific academic calendar and operating unit. The key columns, as defined by its primary and unique keys, establish this identity and its relationships. The primary identifier is the surrogate key TGRP_ID. The business key is a composite of GROUP_CD, ORG_ID, CAL_TYPE, SEQUENCE_NUMBER, and ADPLANS_ID, ensuring a unique group definition per award distribution plan and calendar instance. Another unique key on GROUP_CD, RULE_ORDER, and ORG_ID controls the sequence in which group rules are evaluated. Therefore, the GROUP_CD column, central to the user's search, holds the code that identifies the logical grouping of award constraints. Other significant columns include ADPLANS_ID, which links to the specific award distribution plan, and CAL_TYPE/SEQUENCE_NUMBER, which link to the academic calendar period.

Common Use Cases and Queries

This table is primarily accessed during the setup and execution of financial aid packaging. Administrators define target groups to segment students (e.g., by residency, program, or need level) for different award calculations. A common reporting use case is to list all target groups defined for a specific award distribution plan within an operating unit. For troubleshooting, one might query for groups related to a specific GROUP_CD to understand all its associated constraints and calendar contexts. A sample SQL pattern to retrieve basic group information would be:

• SELECT group_cd, cal_type, sequence_number, rule_order FROM igf_aw_target_grp_all WHERE org_id = :p_org_id AND adplans_id = :p_plan_id ORDER BY group_cd, rule_order;

Another critical use case involves joining this table to award formula details to validate the complete rule hierarchy before running a packaging process.

Related Objects

IGF_AW_TARGET_GRP_ALL maintains documented foreign key relationships with several other core Financial Aid tables, forming a key part of the award packaging data model.

• IGF_AW_AWD_DIST_PLANS: Linked via ADPLANS_ID. This is the parent Award Distribution Plans table.
• IGS_CA_INST_ALL: Linked via the composite foreign key (CAL_TYPE, SEQUENCE_NUMBER). This is the Calendar Instances table from the Student System, anchoring the target group to a specific academic period.
• IGF_AW_AWD_FRML_ALL: Linked via the composite foreign key (GROUP_CD, ORG_ID). This is the Award Formula table, where the detailed calculation rules for each target group are stored.

These relationships illustrate that a target group is defined for a specific distribution plan (IGF_AW_AWD_DIST_PLANS), within a specific calendar (IGS_CA_INST_ALL), and its detailed constraints are stored in the formula table (IGF_AW_AWD_FRML_ALL).