Search Results franchise_out_arrangmnts_code

Overview

APPS.IGSBV_PROGRAM_UK_STATISTICS is a read-only reporting view within the Oracle E-Business Suite (EBS) Student Systems / Higher Education (HE) module, part of the IGS (Student Information) schema family. Its purpose is to expose UK-specific statutory program statistics data — that is, the attributes that UK higher education institutions must return to HESA (Higher Education Statistics Agency) and to funding bodies such as HEFCE. The view presents program-level data drawn from the underlying IGS_HE_ST_PROG_ALL table and re-labels the physical columns with their external reporting names, so that reporting extracts, legislative returns, and integration routines can address the attributes by their published UK statistics terminology rather than by internal column names.

The object is a simple projection: there is no aggregation, no join, and no filter logic beyond the view definition itself. It is declared WITH READ ONLY, so it cannot be used as a DML target. Its principal value is as a stable, semantically-named interface to UK statutory program data, insulated from any internal column naming conventions in the base table.

Underlying Base Objects

The view is defined over a single documented base object: IGS_HE_ST_PROG_ALL. The SQL selects from this table with the alias PRG and maps each column to an alias that matches the published UK statistics term. Because EBS's documented metadata for this view lists no additional referenced objects, all columns exposed by the view originate directly from IGS_HE_ST_PROG_ALL, and no dependent lookups or descriptive flexfields are resolved by the view itself.

As with most ETRM-referenced views, the object resides in the APPS schema, while the underlying table is owned by the IGS product schema. This schema separation is standard in EBS 12.1.1 and 12.2.2; the APPS synonym/grants layer permits reporting users to query the view without direct privileges on the base table.

Key Columns

The view exposes a comprehensive set of UK statutory program attributes. The most commonly referenced columns include:

• HESA_STATS_PROGRAM_ID (from HESA_ST_PROG_ID) — the primary identifier for the statistics program record.
• PROGRAM_CODE (COURSE_CD) and PROGRAM_VERSION_NUMBER (VERSION_NUMBER) — the program's course code and version.
• FEE_BAND (FEE_BAND) — the fee band classification, which is the column most directly relevant to the search term fee_band. It records the fee band applied to the program for statutory reporting.
• FUNDABILITY_CODE (FUNDABILITY) and LEVEL_APP_TO_FUNDING_COUNCIL (LEVEL_APPLICABLE_TO_FUNDING) — funding eligibility and council-level funding attributes.
• CREDIT_TRANSFER_SCHEME, LOCATION_OF_STUDY, and HESA_RETURN_TYPE — reporting classification attributes.
• FTE_INTENSITY, TEACHING_PERIOD_START_DATE, and TEACHING_PERIOD_END_DATE — teaching load and period parameters.
• IMPLIED_FUNDING_RATE, GOVERNMENT_INITIATIVES_CODE, and UNITS_TO_ACHIEVE_QUALIFICATION — funding calculation and qualification attributes.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include preparing HESA returns, validating fee band assignments, and reconciling program funding classifications. Because the view is read-only and non-aggregated, queries are straightforward. A common query to inspect fee band values for programs would be:

• SELECT PROGRAM_CODE, PROGRAM_VERSION_NUMBER, FEE_BAND, FUNDABILITY_CODE FROM APPS.IGSBV_PROGRAM_UK_STATISTICS WHERE FEE_BAND IS NOT NULL;
• SELECT HESA_STATS_PROGRAM_ID, PROGRAM_CODE, LOCATION_OF_STUDY, HESA_RETURN_TYPE FROM APPS.IGSBV_PROGRAM_UK_STATISTICS WHERE HESA_RETURN_TYPE = :return_type;
• SELECT FEE_BAND, COUNT(*) FROM APPS.IGSBV_PROGRAM_UK_STATISTICS GROUP BY FEE_BAND;

When additional descriptive data is required (for example, program titles or department attribution), the view must be joined back to other IGS program tables using HESA_STATS_PROGRAM_ID or PROGRAM_CODE. All access should be read-only, and any extracts intended for legislative submission should be validated against the current HESA specification for the applicable reporting year.