Search Results oss_fund_code




Overview
Explore in AI Chat

Overview

The view APPS.IGS_HE_ST_PRG_DTLS_V is a reporting and integration object within the Oracle E-Business Suite Student System (IGS) product family. It exposes Higher Education Statistics Agency (HESA) program-level detail, presenting the attributes that institutions must report for statutory returns covering teaching programmes, funding characteristics, and programme-level descriptors. The view carries a status of VALID and is owned by the APPS schema, which confirms it is a supported, compiled database object available for querying by reporting tools, concurrent programs, and external integration layers.

Rather than storing data itself, the view projects a denormalized, human-readable representation of program records. Each coded attribute from the underlying detail table is paired with its corresponding descriptive text sourced from Oracle lookups or related tables. This design makes the view particularly suitable for extract generation, BI Publisher reports, and downstream feeds that require descriptive values rather than raw codes.

Underlying Base Objects

The documented metadata lists no explicitly declared base objects and the ETRM entry records "none documented" for referenced base objects. However, the view text itself reveals the composition of the object. The driving table is aliased as A, and is joined to a series of lookup or value tables aliased C through W, each supplying a VALUE_DESCRIPTION for a corresponding coded column. Examples include Q.VALUE_DESCRIPTION FEE_BAND_DESC, R.VALUE_DESCRIPTION FUNDABILITY_DESC, and M.VALUE_DESCRIPTION CREDIT_TRANSFER_SCHEME_DESC. A separate join against alias B provides SHORT_TITLE, while aliases K and L resolve other institution provider teaching names via a NAME column.

The view also exposes A.ROWID ROW_ID, which preserves a row identifier for the base record. Administrators should verify the exact underlying table — most likely a HESA student program detail table — against the database dictionary, since the ETRM metadata does not enumerate it.

Key Columns

Common Use Cases and Queries

The view is typically queried to produce HESA returns, funding reconciliations, and programme catalogues. A common requirement is resolving fee band descriptions for a programme:

SELECT hesast_prog_id,
       course_cd,
       short_title,
       fee_band,
       fee_band_desc
  FROM apps.igs_he_st_prg_dtls_v
 WHERE fee_band IS NOT NULL;

Institutions may also extract all descriptive funding fields for a reporting period:

SELECT course_cd,
       fundability_desc,
       level_appl_to_funding_desc,
       gov_initiatives_desc,
       disadv_uplift_elig_desc
  FROM apps.igs_he_st_prg_dtls_v;

Because the view resolves codes to descriptions, it eliminates the need for downstream joins to lookup tables, making it well suited to BI Publisher templates, concurrent extracts, and integration interfaces that feed HESA submission processes.