Results for “unit_cd”

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

Overview

IGF_SP_UNIT_V is a form-driven database view within the Oracle E-Business Suite IGF (Financial Aid) product family, documented in ETRM for releases 12.1.1 and 12.2.2. Its purpose is to present "sponsor pays only" unit details for a pays-only program. In this context, a pays-only program is an academic program construct under which a third-party sponsor, rather than the student, is responsible for the assessed unit fees. The view is therefore the underlying data source for an Oracle Forms block or window that allows student financial aid administrators to review, insert, and maintain the fee-class unit records associated with such sponsor-funded programs.

The view is explicitly identified in the metadata as a FORM view, meaning it exists primarily to service the Forms user interface of the IGF module rather than to serve as a general-purpose reporting object. The ETRM record also carries the notation "Not implemented in this database," and is classified as Obsolete under the IGF - Financial Aid module. As a result, it should be treated as a legacy artifact from an earlier Financial Aid implementation and not as a supported integration point in current 12.2.2 environments.

Underlying Base Objects

Per the documented view text, IGF_SP_UNIT_V is defined by joining three objects:

• IGF_SP_UNIT (aliased SFCLU) — the sponsor pays unit detail table that supplies the fee class unit identifier, unit code, version number, and maximum amount.
• IGF_SP_PRG (aliased SFCLP) — the sponsor pays program header, joined on FEE_CLS_PRG_ID.
• IGS_PS_UNIT_VER (aliased UV) — the student system unit version table, joined on UNIT_CD and VERSION_NUMBER to validate that the referenced unit and version exist in the academic structure.

The join predicates are FEE_CLS_PRG_ID equals FEE_CLS_PRG_ID between the two IGF sponsor-pays tables, and UNIT_CD/VERSION_NUMBER equality between IGF_SP_UNIT and IGS_PS_UNIT_VER. Notably, the ETRM metadata states that no base objects are documented as referenced for this view and that it is not implemented in the current database, so the join definition above should be taken as the historical definition recorded in the ETRM documentation rather than as a live dictionary object.

Key Columns

The view exposes the following columns, all projected from IGF_SP_UNIT except where noted:

• ROW_ID — the ROWID of the underlying IGF_SP_UNIT row, used by Oracle Forms for row-level identification and updates.
• FEE_CLS_UNIT_ID — primary key of the sponsor pays unit record.
• FEE_CLS_PRG_ID — foreign key to the sponsor pays program (IGF_SP_PRG) that the unit belongs to.
• UNIT_CD and VERSION_NUMBER — the academic unit and version being sponsored; together they link to IGS_PS_UNIT_VER.
• MAX_AMOUNT — the maximum sponsor-payable amount defined for that unit.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO-audit columns.
• ORG_ID — the multi-org (business unit) identifier, enabling operating unit security on the rows.

Collectively these columns describe which unit, in which version, under which sponsor-pays program, may be paid up to what ceiling.

Common Use Cases and Queries

Typical usage centers on Forms-based maintenance and ad hoc review of sponsor-pays unit ceilings. A basic query lists all sponsor-pays units with their maximum amounts:

• SELECT fee_cls_unit_id, fee_cls_prg_id, unit_cd, version_number, max_amount, org_id FROM igf_sp_unit_v ORDER BY fee_cls_prg_id, unit_cd;

To inspect the units configured for a specific program:

• SELECT unit_cd, version_number, max_amount FROM igf_sp_unit_v WHERE fee_cls_prg_id = :program_id;

Because the view joins to IGS_PS_UNIT_VER, queries can be used to confirm that each sponsored unit resolves to a valid unit version, or to filter by operating unit using ORG_ID. Given the obsolete status and the "not implemented in this database" annotation, any current development should reference IGF_SP_UNIT and IGF_SP_PRG directly rather than relying on this view.