Results for “igf_sp_std_unit_all”

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

Overview

The IGF_SP_STD_UNIT_ALL table resides in the IGF schema and belongs to the Oracle E-Business Suite IGF – Financial Aid product. In the 12.1.1 and 12.2.2 releases it stores student "pays only unit" detail for a pays only program, meaning it captures the individual academic units (courses or instructional units) against which a student is expected to pay, rather than units that attract financial aid disbursement.

The object is a standard EBS intersection-style table: it holds a surrogate primary key, references a parent program row, and carries descriptive and transactional attributes together with the standard WHO audit columns and a multi-organization ORG_ID discriminator. Under a heuristic Data Vault classification derived from the foreign key topology, this table models as a satellite. The reasoning is that it hangs off a single parent (IGF_SP_STD_PRG_ALL) through FEE_CLS_PRG_ID and stores descriptive attributes about that program's units, which is characteristic satellite behaviour rather than the many-to-many pattern of a link table. This classification should be treated as a modeling suggestion only; operational confirmation against installation-specific data is advisable.

Key Information Stored

The physical schema documents eleven columns. The most significant are listed below; the remainder are the standard audit and multi-org columns.

• FEE_CLS_UNIT_ID – the surrogate primary key, enforced by IGF_SP_STD_UNIT_ALL_PK and also carried in unique index IGF_SP_STD_UNIT_ALL_U1. This is the system-generated identifier for each unit row.
• FEE_CLS_PRG_ID – the foreign key to IGF_SP_STD_PRG_ALL, tying the unit to its owning pays only program.
• UNIT_CD – the business-facing unit code identifying the academic or instructional unit.
• VERSION_NUMBER – the version of the unit record, supporting date-effective or versioned maintenance of program unit definitions.
• MAX_AMOUNT – the maximum amount associated with the unit, used in pays only fee or charge calculation.
• ORG_ID – the operating unit discriminator enabling multi-organization security and partitioning of the data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – the standard WHO audit columns recording row provenance and change history.

The business key is captured by the composite unique index IGF_SP_STD_UNIT_ALL_U2 over (FEE_CLS_PRG_ID, UNIT_CD, VERSION_NUMBER), which guarantees that a given program cannot repeat the same unit code and version combination.

Common Use Cases and Queries

Typical usage centres on identifying which units drive pays only charges for a student's program and on reporting the maximum chargeable amount per unit. A common query retrieves all units for a given program:

• Joining IGF_SP_STD_UNIT_ALL to IGF_SP_STD_PRG_ALL on FEE_CLS_PRG_ID to resolve program context for each unit.
• Filtering by UNIT_CD and VERSION_NUMBER to retrieve the currently effective version of a unit definition.
• Aggregating or reporting MAX_AMOUNT by program and operating unit (ORG_ID) for fee exposure analysis.
• Auditing historical changes through the WHO columns to track when unit amounts or definitions were altered.

A representative pattern is a three-way selection of unit, program name, and amount constrained by ORG_ID and ordered by UNIT_CD.

Related Objects

• IGF_SP_STD_PRG_ALL – the parent table; joined via IGF_SP_STD_UNIT_ALL.FEE_CLS_PRG_ID = IGF_SP_STD_PRG_ALL.FEE_CLS_PRG_ID. This is the only documented foreign key relationship.
• The primary key index IGF_SP_STD_UNIT_ALL_PK and unique indexes IGF_SP_STD_UNIT_ALL_U1 and IGF_SP_STD_UNIT_ALL_U2, which enforce identity and business-key uniqueness.
• Other IGF_SP_STD_* tables in the same pays only program family, which share the FEE_CLS_PRG_ID linkage and are commonly queried alongside this table.