Search Results prop_of_teaching_in_welsh

Overview

The IGS_HE_ST_UNT_VS view is a reporting construct within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its name and description identify it as the "HESA Unit Details" view — that is, a presentation-layer object designed to expose unit (module) level data required for Higher Education Statistics Agency (HESA) statutory returns. In the context of Oracle EBS 12.1.1 and 12.2.2, this view is owned by the APPS schema, holds a VALID status, and is registered in the ETRM (E-Business Suite Technical Reference Manual) as a documented, supported object.

Its principal role is to provide a clean, ORG_ID-secured projection over the underlying HESA student unit staging table. The view presents a curated set of columns — unit code, version, teaching-in-Welsh proportion, credit transfer scheme, module length, FTE proportion, location, and auditing fields — so that institutional reporting teams, HESA extraction routines, and integration programs can query a stable, security-filtered interface rather than the base table directly.

Underlying Base Objects

The view text unambiguously defines its source as IGS_HE_ST_UNT_VS_ALL. The naming convention (the _ALL suffix) indicates that the base table is a Multi-Org (Operating Unit) enabled table containing records for all operating units. The view filters this table by the ORG_ID column to expose only rows belonging to the current operating unit context.

The filter is implemented using the standard Multi-Org security predicate, which reads the CLIENT_INFO session value via USERENV and extracts the leading operating unit identifier. The NVL and DECODE construct applies a default of -99 when no context is set. Notably, the ETRM metadata records no explicitly documented base objects; however, the view definition itself clearly references IGS_HE_ST_UNT_VS_ALL, and the two objects should be treated as a related pair. The view carries no stored data of its own — it is a pure runtime projection — so changes to the base table are reflected immediately.

Key Columns

• ROW_ID — the ROWID of the underlying base-table row, exposed for addressed/row-level access.
• HESA_ST_UNT_VS_ID — the primary identifier for the HESA student unit record; this is the column referenced in the user search string ("hesa_st_unt_vs_id").
• UNIT_CD — the code identifying the unit or module being reported.
• VERSION_NUMBER — the version of the unit definition, supporting HESA's version tracking requirements.
• PROP_OF_TEACHING_IN_WELSH — the proportion of teaching delivered through the medium of Welsh, a Welsh-language reporting measure.
• CREDIT_TRANSFER_SCHEME — indicates the credit accumulation and transfer scheme applicable to the unit.
• MODULE_LENGTH — the length or duration attribute of the module.
• PROPORTION_OF_FTE — the full-time-equivalent proportion associated with the unit.
• LOCATION_CD — the location/study-site code for the unit delivery.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns.
• EXCLUDE_FLAG — a control flag used to mark records that should be excluded from reporting output.

Common Use Cases and Queries

The view is typically consumed by HESA return extraction scripts, Student System reporting, and reconciliation queries that must respect operating unit security. Because the Multi-Org predicate is embedded, no additional ORG_ID filter is required in most cases. A typical query selects unit detail for the current operating unit context:

• SELECT hesa_st_unt_vs_id, unit_cd, version_number, proportion_of_fte FROM igs_he_st_unt_vs WHERE exclude_flag = 'N';
• Joining to unit master data to validate that reported UNIT_CD values exist for the institution's return period.
• Auditing recently created or changed unit records using CREATION_DATE and LAST_UPDATE_DATE range filters.
• Reconciling the view against IGS_HE_ST_UNT_VS_ALL to confirm ORG_ID partitioning and record completeness.

Because the security predicate depends on the CLIENT_INFO session value, querying this view outside a properly initialized EBS session (for example, from SQL*Plus without the Multi-Org context) will return only records matching the default or unset operating unit. Report developers should account for this behavior when scheduling concurrent programs.