Search Results implied_fund_rate




Overview
Explore in AI Chat

Overview

IGS_HE_ST_PROG is a read-only view owned by the APPS schema in Oracle E-Business Suite. It belongs to the IGS (Student System / Higher Education) product family and carries FND Design Data registration IGS.IGS_HE_ST_PROG, which distinguishes it from customer-defined objects. The view presents HESA (Higher Education Statistics Agency) program-level records used for statutory returns and related regulatory reporting in the UK higher education sector.

The object is implemented as a multi-org view. In Oracle EBS, a multi-org view restricts the rows returned to those associated with the operating unit in the current session, ignoring data belonging to other operating units. This behavior is enforced through the standard _ALL / _ORG_ID partitioning pattern: the view typically selects from a base table with an ORG_ID predicate bound to the client's operating unit context via CLIENT_INFO / FND_CLIENT_INFO.

The metadata records the object as VALID in the 12.1.1 / 12.2.2 releases. The described functionality is unchanged across these releases from a reporting standpoint. The DEFAULT_AWARD column that prompted the search is a VARCHAR2(30) attribute intended to hold the default award to which a student is expected to progress on the given program/teaching combination.

Underlying Base Objects

The ETRM documentation for this version does not enumerate the referenced base tables (documented base objects: none). It is nonetheless evident from the column list that the view projects from a single HESA program staging/detail table in the IGS schema, most likely named IGS_HE_ST_PROG_ALL or similar, carrying the ORG_ID column required for the multi-org behavior. Because the view is flagged as multi-org, all query results are automatically scoped to the current operating unit; a query run without a properly initialized session may return no rows.

In higher education implementations the base table is populated from the Student System course/teaching-program setup and then extracted for HESA returns. Verify the exact base object by querying USER_VIEWS / DBA_VIEWS for the view text on the target instance before relying on the projection.

Key Columns

Common Use Cases and Queries

The view is typically queried for HESA program returns, default-award analysis, and integration feeds exposing program attributes. Because it is multi-org, set the operating unit context before querying.

SELECT h.HESA_ST_PROG_ID, h.COURSE_CD, h.VERSION_NUMBER,
       h.DEFAULT_AWARD, h.FEE_BAND, h.FUNDABILITY
FROM   APPS.IGS_HE_ST_PROG h
WHERE  h.EXCLUDE_FLAG IS NULL
AND    h.COURSE_CD = :p_course_cd;

To inspect default-award distribution for a reporting period:

SELECT h.DEFAULT_AWARD, COUNT(*)
FROM   APPS.IGS_HE_ST_PROG h
WHERE  h.TEACH_PERIOD_START_DT >= :p_start
AND    h.EXCLUDE_FLAG IS NULL
GROUP  BY h.DEFAULT_AWARD
ORDER  BY 2 DESC;

Typical scenarios include reconciling published default awards against course setup, auditing fundability and fee-band assignments, and building teacher-training (ITT) extracts. Always confirm the base table projection and the ORG-scoping behavior directly against DBA_VIEWS on the release in use, as the ETRM metadata for this version documents columns thoroughly but not the underlying SQL.