Results for “igf_sp_std_prg_all”

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

Overview

The IGF_SP_STD_PRG_ALL table is a transaction and setup table within the IGF (Financial Aid) product module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It holds student pays only program details for a pays only tuition fee class. In practice, this table stores the program-level configuration that determines how a "student pays only" fee class is applied, including the fee percentage and any maximum amount that governs the amount assessed against the student for a given course and version.

Because the table carries descriptive attributes (FEE_PERCENT, MAX_AMOUNT) attached by way of a foreign key to a parent entity (IGF_SP_STD_FC_ALL via FEE_CLS_ID), the heuristic Data Vault classification is satellite-leaning. From a modeling perspective, it is best understood as a satellite describing the business key defined by the fee class and course combination, rather than as a hub or a pure link.

Key Information Stored

The documented physical schema contains 12 columns. The most significant are the following:

• FEE_CLS_PRG_ID — the surrogate primary key of the table, enforced by the constraint IGF_SP_STD_PRG_ALL_PK and backed by the unique index IGF_SP_STD_PRG_ALL_U1. This is the value referenced by dependent child tables.
• FEE_CLS_ID — the foreign key to IGF_SP_STD_FC_ALL, identifying the parent "student pays only" fee class to which this program record belongs.
• COURSE_CD — the course code associated with the pays only program detail.
• VERSION_NUMBER — the version of the course/program combination, allowing multiple valid versions to coexist.
• FEE_PERCENT — the percentage of the fee that the student is assessed for this pays only program line.
• MAX_AMOUNT — the ceiling amount applied when the calculated percentage would otherwise exceed the configured limit.
• ORG_ID — the operating unit identifier supporting multi-org security and reporting.

The business key (alternate unique key) is defined by the index IGF_SP_STD_PRG_ALL_U2 on the combination of FEE_CLS_ID, COURSE_CD, and VERSION_NUMBER, which guarantees that no duplicate program line exists for the same fee class, course, and version. The remaining audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) capture standard row-level auditing.

Common Use Cases and Queries

This table is typically queried when reporting or validating how much a student is expected to pay for a pays only tuition fee class, or when resolving the FEE_CLS_PRG_ID required by downstream unit-level records. A frequent pattern joins the table back to its parent fee class:

• Retrieving all program lines for a fee class: SELECT fee_cls_prg_id, course_cd, version_number, fee_percent, max_amount FROM igf.igf_sp_std_prg_all WHERE fee_cls_id = :p_fee_cls_id;
• Resolving the surrogate key for a child insert into IGF_SP_STD_UNIT_ALL: query by the business key (FEE_CLS_ID, COURSE_CD, VERSION_NUMBER) to obtain FEE_CLS_PRG_ID.
• Reporting assessed amounts across operating units: filter on ORG_ID and apply FEE_PERCENT/MAX_AMOUNT logic in the report layer.
• Data validation and reconciliation: detect rows where the percentage-derived amount breaches MAX_AMOUNT, or where the unique business key has conflicting versions.

Related Objects

The following objects have the most significant documented relationships to this table:

• IGF_SP_STD_FC_ALL — the parent fee class table; joined on IGF_SP_STD_PRG_ALL.FEE_CLS_ID = IGF_SP_STD_FC_ALL.FEE_CLS_ID.
• IGF_SP_STD_UNIT_ALL — the child unit table; it references this table through IGF_SP_STD_UNIT_ALL.FEE_CLS_PRG_ID = IGF_SP_STD_PRG_ALL.FEE_CLS_PRG_ID.
• IGF_SP_STD_PRG_ALL_PK and IGF_SP_STD_PRG_ALL_U1 / IGF_SP_STD_PRG_ALL_U2 — the primary key constraint and unique indexes that enforce integrity and the business key.

Together these objects form the fee class hierarchy: the fee class (IGF_SP_STD_FC_ALL) is the parent, IGF_SP_STD_PRG_ALL provides program-level detail, and IGF_SP_STD_UNIT_ALL holds the unit-level breakdown beneath each program line.