Results for “igf_sp_unit_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGF_SP_UNIT_ALL table resides in the IGF schema (Oracle Financial Aid) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores pays-only unit details for a pays-only program, forming part of the fee classification and program configuration infrastructure used by financial aid and student billing processes. In practice, a "pays-only" program describes an offering where the institution disburses funds to a recipient without generating a corresponding chargeable enrollment line; the unit records in this table define the qualifying units (by unit code and version) that belong to such a program.

From a modeling perspective, the ETRM metadata classifies this table heuristically as satellite-leaning. This is a suggested classification: the table behaves like a dependent detail or descriptive satellite attached to a parent program (IGF_SP_PRG_ALL) rather than an independent hub of business identity. Its foreign key relationship to the program table, combined with its own surrogate and business keys, reinforces this descriptive, program-scoped role.

Key Information Stored

The table carries 11 documented columns. The most significant are summarized below, distinguishing the surrogate primary key from documented business-key candidates.

• FEE_CLS_UNIT_ID — the surrogate primary key (defined by index IGF_SP_UNIT_ALL_PK and also the unique index IGF_SP_UNIT_ALL_U1). A system-generated identifier uniquely representing each unit record.
• FEE_CLS_PRG_ID — the foreign key linking each unit record to its owning pays-only program in IGF_SP_PRG_ALL.
• UNIT_CD — the code identifying the unit (for example, a course, credit, or instructional unit) associated with the pays-only program.
• VERSION_NUMBER — the effective version of the unit definition, enabling multiple revisions of the same unit code to coexist.
• MAX_AMOUNT — the maximum payable amount applicable to the unit within the pays-only context, used in award or disbursement calculation.
• ORG_ID — the operating unit (multi-org) discriminator, supporting organizational data partitioning across legal entities and business groups.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns capturing who created or last modified each row, when, and through which login session.

The unique index IGF_SP_UNIT_ALL_U2 on (FEE_CLS_PRG_ID, UNIT_CD, VERSION_NUMBER) represents the primary business-key candidate, ensuring that a given unit code and version is defined only once per program.

Common Use Cases and Queries

Typical scenarios include listing all units configured for a given pays-only program, checking the maximum amount applicable to a specific unit, and resolving a unit code to its internal record identifier during import or integration work.

Example: all pays-only units for a program.

SELECT u.fee_cls_unit_id,
       u.unit_cd,
       u.version_number,
       u.max_amount
  FROM igf.igf_sp_unit_all u
 WHERE u.fee_cls_prg_id = :p_fee_cls_prg_id
   AND u.org_id = :p_org_id
 ORDER BY u.unit_cd, u.version_number;

Example: join units to their parent program for reporting.

SELECT p.fee_cls_prg_id,
       u.unit_cd,
       u.version_number,
       u.max_amount
  FROM igf.igf_sp_prg_all  p,
       igf.igf_sp_unit_all u
 WHERE p.fee_cls_prg_id = u.fee_cls_prg_id
   AND u.org_id = :p_org_id;

Reporting uses include reconciliation of configured units against awarded amounts, auditing changes to configured maximum amounts via the audit columns, and validating version-controlled unit definitions during data migration.

Related Objects

The following objects are most significant to IGF_SP_UNIT_ALL, drawn from its documented foreign key and key relationships:

• IGF_SP_PRG_ALL — the parent pays-only program table; joined on IGF_SP_UNIT_ALL.FEE_CLS_PRG_ID = IGF_SP_PRG_ALL.FEE_CLS_PRG_ID. This is the primary referential relationship.
• IGF_SP_UNIT_ALL_PK — the primary key constraint/index on FEE_CLS_UNIT_ID.
• IGF_SP_UNIT_ALL_U1 — unique index on FEE_CLS_UNIT_ID.
• IGF_SP_UNIT_ALL_U2 — unique business-key index on (FEE_CLS_PRG_ID, UNIT_CD, VERSION_NUMBER).
• IGF_SP_PRG_ALL (reverse direction) — referenced via the FEE_CLS_PRG_ID foreign key; any downstream fee, award, or disbursement configuration that resolves a program will typically traverse this unit table.

No additional downstream tables or APIs are documented in the available ETRM metadata; integration points should be confirmed against the specific 12.1.1 or 12.2.2 patch level in use, as the IGF financial aid module is delivered through Oracle Student Financial Planning integration conventions.