Search Results fe_program_marker

Overview

The database object IGSBV_PROGRAM_UK_STATISTICS is a base view belonging to the Oracle E-Business Suite (EBS) Student System product family, identified by the product code IGS. In ETRM documentation the product line carries the designation "IGS - Student System (Obsolete)," indicating that the underlying functionality is legacy and is not implemented in current 12.1.1 or 12.2.2 environments. The view is described as the "Base View for UK Statistics Program Details," which defines its role: it exposes program-level attributes that feed United Kingdom statutory statistical returns, principally the Higher Education Statistics Agency (HESA) and related funding council submissions.

Within the EBS reporting and integration architecture, base views such as this one act as a normalized, read-only projection over transactional tables. The view is declared with the WITH READ ONLY clause, so it can be queried for reporting and extract purposes but cannot be used as a DML target. Its practical value lies in presenting a stable column interface — a set of HESA-oriented column aliases — so that downstream extracts and integration programs do not need to reference the physical tables directly.

Underlying Base Objects

According to the documented view text, the definition selects exclusively from a single underlying table: IGS_HE_ST_PROG_ALL (aliased as PRG). This table stores higher education statistics program records. The documented ETRM metadata lists no additional referenced base objects, and there are no joins, unions, or subqueries in the view text. The relationship is therefore a straightforward one-to-one projection: each row in the view corresponds to a row in IGS_HE_ST_PROG_ALL, with columns renamed to their statistical-reporting identities.

Because the product is marked obsolete, the ETRM implementation data records "Not implemented in this database," meaning the view may not exist in a given instance and its defining table may be absent. Any reliance on this object should be validated against the target application schema before use.

Key Columns

The view exposes a wide set of program attributes relevant to UK statistical and funding returns. Notable columns include:

• HESA_STATS_PROGRAM_ID (from HESA_ST_PROG_ID) — the primary statistical program identifier.
• PROGRAM_CODE and PROGRAM_VERSION_NUMBER — the course code and version of the program record.
• SOURCE_OF_DEPT_HEALTH_FUNDING (from NHS_FUNDING_SOURCE) — the source of Department of Health (NHS) funding; this is the column associated with the user search term source_of_dept_health_funding.
• FUNDABILITY_CODE, FEE_BAND, and LEVEL_APP_TO_FUNDING_COUNCIL — funding council categorizations.
• FTE_INTENSITY, TEACHING_PERIOD_START_DATE, and TEACHING_PERIOD_END_DATE — load and delivery timing attributes.
• FRANCHISING_ACTIVITY, FRANCHISE_PARTNER_CODE, and FRANCHISE_OUT_ARRANGMNTS_CODE — franchising and collaborative provision details.
• ITT_PHASE_SCOPE, TEACHER_TRAINING_PROGRAM_ID, and teaching qualification subject columns — initial teacher training attributes.
• Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE).

Common Use Cases and Queries

Typical uses include generating HESA program-level extracts, reconciling NHS/Department of Health funding sources, and auditing franchising or teacher-training classifications. A representative query filtering on the health funding attribute is shown below.

SELECT HESA_STATS_PROGRAM_ID, PROGRAM_CODE, SOURCE_OF_DEPT_HEALTH_FUNDING, FUNDABILITY_CODE, FEE_BAND FROM IGSBV_PROGRAM_UK_STATISTICS WHERE SOURCE_OF_DEPT_HEALTH_FUNDING IS NOT NULL ORDER BY PROGRAM_CODE;

Because the view is read-only and sourced from a single table, queries against it are inexpensive subject only to indexing on the base table. Given the obsolete status, consumers should confirm object availability and consider that no equivalent view is documented as implemented in supported 12.1.1 or 12.2.2 configurations.