Search Results program_version_number




Overview
Explore in AI Chat

Overview

IGSBV_PROG_HESA_COST_CENTRES is a base business view within the Oracle E-Business Suite Student System (IGS) product family. It exposes Program HESA (Higher Education Statistics Agency) Cost Center detail records, providing a denormalized, read-only projection of the relationship between academic programs and the organizational cost centers to which they are attributed for statutory HESA reporting purposes. The view allows queries on Program HESA Cost Center Details and is documented as a base business view, meaning it is intended to serve as a foundational data source for downstream reporting views, concurrent programs, and extracts rather than as an end-user maintenance screen. In ETRM 12.2.2 documentation, the object is flagged as Obsolete, and the implementation notes state that it is not implemented in the documented database. The view text carries a WITH READ ONLY clause, enforcing that consumers can only query the data and cannot perform DML through the view.

Underlying Base Objects

The view is defined over a single underlying base table, IGS_HE_PROG_OU_CC, aliased as PCC in the view text. No additional referenced base objects are documented for this view in the ETRM metadata. The naming convention of the base table indicates its purpose: IGS (Student System), HE (Higher Education), PROG (Program), OU (Organizational Unit), and CC (Cost Centre). Each row in the base table represents the allocation of a program to one or more organizational units and cost centers, with a proportion indicating the share of the program attributed to each combination. Because the view selects directly from this table without joins, the columns of the view are essentially a renamed and stable interface over the underlying table, insulating dependent objects from physical column names such as COURSE_CD and ORG_UNIT_CD.

Key Columns

The view exposes a set of columns that identify the allocation and its audit attributes. Of particular relevance to the user's search on "program_code" is the COURSE_CD column from the base table, which is surfaced through the view as PROGRAM_CODE. This is the code identifying the academic program (course) to which the HESA cost center allocation applies.

  • HESA_PROG_CC_ID — Surrogate primary key from IGS_HE_PROG_OU_CC uniquely identifying each program, organizational unit, and cost center allocation record.
  • PROGRAM_CODE — The program (course) code, aliased from COURSE_CD, identifying the academic program.
  • PROGRAM_VERSION_NUMBER — Version of the program record, supporting versioned program definitions.
  • ORG_UNIT_CODE — The organizational unit (aliased from ORG_UNIT_CD) associated with the allocation.
  • PROGRAM_COST_CENTRE — The HESA cost center code to which the program is attributed.
  • PROGRAM_SUBJ — The subject classification associated with the program cost center allocation.
  • PROGRAM_COST_CENTRE_PROP — The proportion of the program attributed to this cost center, typically expressed as a fraction or percentage.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns recording row creation and modification.

Common Use Cases and Queries

The principal use case for this view is extracting or reporting program-to-cost-center allocations for HESA statutory returns and internal costing analysis. A reporting user searching by program code would typically filter on PROGRAM_CODE to retrieve all cost center splits for a specific program. A representative query is:

  • SELECT PROGRAM_CODE, PROGRAM_VERSION_NUMBER, ORG_UNIT_CODE, PROGRAM_COST_CENTRE, PROGRAM_SUBJ, PROGRAM_COST_CENTRE_PROP FROM IGSBV_PROG_HESA_COST_CENTRES WHERE PROGRAM_CODE = :program_code; — retrieves the cost center allocation profile for a given program.
  • SELECT PROGRAM_COST_CENTRE, SUM(PROGRAM_COST_CENTRE_PROP) FROM IGSBV_PROG_HESA_COST_CENTRES GROUP BY PROGRAM_COST_CENTRE; — aggregates proportions to validate that allocations across programs reconcile to expected totals.
  • SELECT DISTINCT PROGRAM_CODE FROM IGSBV_PROG_HESA_COST_CENTRES WHERE PROGRAM_COST_CENTRE = :cost_centre; — lists all programs attributed to a particular cost center.

Because the view is read-only and documented as obsolete and not implemented in the reference database, consumers on 12.1.1 or 12.2.2 environments where it is absent should verify availability before depending on it in custom concurrent programs or extracts, and should anticipate that replacement functionality may exist elsewhere in the Student System data model.