Search Results igf_sp_std_unit_all_u1

Overview

The IGF_SP_STD_UNIT_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Student Financials module, specifically for the Institutional Grants and Funds (IGF) product. Its primary function is to store detailed unit-level information for "pays only" programs. A pays only program is a type of financial aid or fee classification where the institution directly pays a specified maximum amount for particular units or courses on behalf of the student, rather than disbursing funds directly to the student. This table is a multi-org enabled object, indicated by the ORG_ID column, allowing it to store data partitioned by operating unit in a shared installation. It is critical for defining and managing the specific academic units (courses) that are covered under a given pays only program, along with their associated financial limits.

Key Information Stored

The table's structure is designed to link unit details to a parent program and track versioned data. The key columns include:

• FEE_CLS_UNIT_ID: The primary key, a unique sequence-generated identifier sourced from the IGF_SP_STD_UNIT_S sequence.
• FEE_CLS_PRG_ID: A foreign key linking the unit record to its parent pays only program. This is the column referenced in the user's search, and it is part of a unique constraint (IGF_SP_STD_UNIT_ALL_U2) in combination with UNIT_CD and VERSION_NUMBER.
• UNIT_CD: The code identifying the specific academic unit or course covered by the program.
• VERSION_NUMBER: Allows for version control of the unit definition within a program, enabling historical tracking of changes.
• MAX_AMOUNT: The critical financial data point specifying the maximum sponsor amount the program will pay for this specific unit.
• ORG_ID: The multi-org identifier for the operating unit.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): For auditing and tracking record creation and modifications.

Common Use Cases and Queries

This table is central to operations involving the setup, inquiry, and reporting of pays only program coverage. A common use case is determining all units and their associated maximum payable amounts for a specific program, which is essential for validating charges and ensuring sponsor billing accuracy. For reporting, one might join this table to the parent program table (likely keyed on FEE_CLS_PRG_ID) to produce summaries of program coverage. A fundamental query pattern involves filtering by the FEE_CLS_PRG_ID, as initially sought by the user:

SELECT UNIT_CD, VERSION_NUMBER, MAX_AMOUNT
FROM apps.IGF_SP_STD_UNIT_ALL
WHERE FEE_CLS_PRG_ID = :program_id
AND ORG_ID = :org_id
ORDER BY UNIT_CD;

Another critical operational query would validate the uniqueness of a unit definition within a program version, leveraging the unique constraint, before inserting new records. Integration points and data feeds from student information systems would populate this table to define the scope of a new pays only program.

Related Objects

Based on the provided metadata, the primary relationship is implied through the FEE_CLS_PRG_ID column, which is a foreign key to a parent table defining the pays only program header information, such as IGF_SP_STD_PRGM_ALL or a similarly named table. The table itself is referenced by the APPS synonym IGF_SP_STD_UNIT_ALL, which is the standard access point for all EBS application code and custom integrations. The unique index IGF_SP_STD_UNIT_ALL_U1 on FEE_CLS_UNIT_ID enforces the primary key, while index IGF_SP_STD_UNIT_ALL_U2 enforces business rule integrity for the combination of program, unit code, and version. The sequence IGF_SP_STD_UNIT_S is a direct dependency for generating primary key values.