Results for “igf_sp_std_fc”

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

Overview

IGF_SP_STD_FC is a Multi-Org (MO) view owned by the APPS schema within the IGF — Financial Aid product of Oracle E-Business Suite. The view is valid across EBS 12.1.1 and 12.2.2 and serves as an org-secured access layer over the sponsor student fee configuration data held in the IGF_SP_STD_FC_ALL table. Its principal role is to enforce row-level organizational security so that each operating unit (ORG_ID) sees only its own sponsor-to-student fee records, while presenting a stable, report-friendly structure for inquiries, reports, concurrent programs, and integrations that must respect Multi-Org access rules.

The view name carries the "FC" suffix, indicating it exposes sponsor student fee class data — the percentage and maximum amount rules associated with fee classes for sponsored students. Because it is an MO view rather than a base table, developers and report authors should query it rather than the underlying _ALL table to avoid bypassing the org security predicate.

Underlying Base Objects

The view is defined over a single base object: IGF_SP_STD_FC_ALL, aliased STDFC in the view text. No other base tables or views are referenced in the documented definition, and the ETRM metadata records no additional referenced base objects. The view is intentionally thin — it selects the full business column set from the base table plus the ROWID pseudocolumn and applies only a WHERE clause for Multi-Org security. There are no joins, aggregations, or derived expressions other than the org predicate, so the view's behavior is a direct projection of the base table filtered by the current session's organization context.

Because the view inherits the DML-transparency and org filtering of the underlying _ALL table, it can be used both for query and, where privileges permit, for controlled updates subject to the org security predicate.

Key Columns

• ROWID — Pseudocolumn exposed for direct row addressing; useful in update or delete operations surfaced through the view.
• FEE_CLS_ID — Primary identifier for the sponsor student fee class record.
• SPNSR_STDNT_ID — Identifier of the sponsored student to which the fee configuration applies.
• FEE_CLASS — The fee class code or category being associated with the sponsored student.
• FEE_PERCENT — Percentage of the fee class covered by the sponsorship.
• MAX_AMOUNT — Maximum monetary amount payable or covered for the fee class.
• ORG_ID — Operating unit identifier that drives Multi-Org security filtering.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns recording who created and last modified the record and when.

The org security predicate compares ORG_ID against the value derived from USERENV('CLIENT_INFO'), defaulting to −99 when no org context is set. Sessions without a valid org context therefore see no rows unless the default matches.

Common Use Cases and Queries

The view is typically used in financial aid reporting and validation logic that must respect operating unit boundaries. Typical scenarios include listing all sponsor student fee classes for the current org, verifying percentage and cap amounts during sponsorship allocation, and joining to sponsor student master data for downstream reporting.

Sample query listing fee classes for the current organization:

• SELECT FEE_CLS_ID, SPNSR_STDNT_ID, FEE_CLASS, FEE_PERCENT, MAX_AMOUNT FROM APPS.IGF_SP_STD_FC WHERE SPNSR_STDNT_ID = :spnsr_stdnt_id;

Sample query auditing recent changes:

• SELECT FEE_CLS_ID, FEE_CLASS, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM APPS.IGF_SP_STD_FC WHERE LAST_UPDATE_DATE >= :from_date ORDER BY LAST_UPDATE_DATE DESC;

Because org filtering is applied automatically, these queries return only records belonging to the caller's active operating unit, making the view the preferred access point for org-sensitive financial aid programs and integrations.