Search Results credit_transfer_scheme_desc




Overview
Explore in AI Chat

Overview

IGSFV_UNIT_UK_STATISTICS is a read-only view in the Oracle E-Business Suite IGS (Student System) product family, catalogued under the obsolete Student System module set. It is described in the ETRM metadata as the "Full View for UK Statistics Unit Details," indicating its purpose is to expose the unit-level attributes required for United Kingdom statutory higher-education returns, principally those submitted to HESA (Higher Education Statistics Agency). The view consolidates identifying, descriptive, location, credit-transfer, and teaching-proportion information for student units into a single flattened reporting structure, removing the need for downstream reports and interfaces to reassemble these attributes from multiple transactional tables.

The specific search term associated with this object, "credit_transfer_scheme_desc," corresponds to the CREDIT_TRANSFER_SCHEME_DESC column, a derived attribute that resolves a coded credit transfer scheme value into its human-readable description. Because the view is documented as "Not implemented in this database," the metadata record is retained for reference and historical comparison rather than active runtime use. In practice, IGSFV_UNIT_UK_STATISTICS serves as a reporting and integration convenience object for UK regulatory extracts rather than as a transactional entity.

Underlying Base Objects

The documented view text identifies two primary base tables, joined on unit code and version number:

  • IGS_HE_ST_UNT_VS_ALL — the HESA statistics unit version detail table, aliased UNT. This is the driving table supplying the statistics-unit identifier, unit code, version number, teaching-in-Welsh proportion, location code, credit transfer scheme, FTE proportion, module length, exclusion flag, and audit columns.
  • IGS_PS_UNIT_VER_ALL — the unit version table, aliased UV. This supplies the unit title, short title, and abbreviation, joined to the statistics table on both UNIT_CD and VERSION_NUMBER.

Two correlated scalar subqueries further resolve descriptive values: IGS_AD_LOCATION_ALL supplies LOCATION_DESC from the unit location code, and IGS_HE_CODE_VALUES supplies CREDIT_TRANSFER_SCHEME_DESC where CODE_TYPE equals 'OSS_CRDTSCM' and VALUE matches CREDIT_TRANSFER_SCHEME. The ETRM metadata records no separately documented referenced base objects, and the view is declared WITH READ ONLY, confirming it is non-updatable and intended strictly for query access.

Key Columns

Common Use Cases and Queries

The principal use case is generating UK HESA unit statistics extracts, where the description of each credit transfer scheme must be reported alongside its code. Typical patterns include filtering by exclusion flag, aggregating FTE proportions, and reporting teaching-in-Welsh proportions by location.

  • Listing all units with a decoded credit transfer scheme for a submission: SELECT unit_code, unit_version_number, credit_transfer_scheme, credit_transfer_scheme_desc FROM igsfv_unit_uk_statistics;
  • Excluding flagged units: SELECT unit_code, unit_title, prop_of_fte FROM igsfv_unit_uk_statistics WHERE exclude_flag IS NULL;
  • Grouping by location: SELECT location_desc, COUNT(*) FROM igsfv_unit_uk_statistics GROUP BY location_desc;

Because the view is obsolete and reported as not implemented, queries should be validated against the current database before being embedded in production extracts.