Search Results unit_set_short_title




Overview
Explore in AI Chat

Overview

The APPS.IGSFV_PRG_OFR_OPT_COST_CENTRES view is a reporting and inquiry object within the Oracle E-Business Suite Student System (IGS) module. It presents a consolidated, denormalized result set covering the cost center details associated with Program Offering Option Unit Sets, specifically those carrying HESA (Higher Education Statistics Agency) reporting attributes. In the context of Oracle EBS 12.1.1 and 12.2.2, this object is registered in the ETRM as a VALID view owned by the APPS schema with the description "Full View for Program Offering Option Unit Set HESA Details - Cost Center Details."

The view exposes linked attributes from program versions, calendar types, unit sets, and HESA cost center reference data in a single flat structure, which simplifies downstream reporting and statutory returns. Because the view is defined WITH READ ONLY, it is intended purely for query and extraction purposes and cannot be used for DML operations.

Underlying Base Objects

The view is defined over four primary base tables joined on their descriptive keys:

  • IGS_HE_POOUS_CC_ALL (aliased POC) — the driving table holding the Program Offering Option Unit Set cost center records, keyed by HESA_POOUS_CC_ID.
  • IGS_PS_VER_ALL (aliased PS) — the program version table, supplying program titles, short titles, and the ABBREVIATION attribute.
  • IGS_EN_UNIT_SET_ALL (aliased EN) — the unit set table, matched on unit set code and version number.
  • IGS_CA_TYPE (aliased CA) — the calendar type reference table, matched on CAL_TYPE.

The join conditions tie COURSE_CD and CRV_VERSION_NUMBER to the program version, UNIT_SET_CD and US_VERSION_NUMBER to the unit set, and CAL_TYPE to the calendar type. Several correlated subqueries also reference IGS_AD_LOCATION_ALL, IGS_EN_ATD_MODE_ALL, IGS_EN_ATD_TYPE_ALL, IGS_HE_CODE_VALUES, and IGS_PS_FLD_OF_STUDY_ALL to resolve descriptions for location, attendance mode, attendance type, cost centre, and subject.

Key Columns

Common Use Cases and Queries

Typical usage centers on HESA statutory returns, cost center reconciliation, and program offering analysis. Because the view flattens multiple parents, a single query returns program, calendar, unit set, and cost center context without additional joins.

  • Locating a program by its abbreviation: SELECT PROGRAM_CODE, PROGRAM_TITLE, PROGRAM_COST_CENTRE_DESC FROM IGSFV_PRG_OFR_OPT_COST_CENTRES WHERE PROGRAM_ABBREVIATION = :p_abbrev;
  • Extracting cost center allocations per program version: SELECT PROGRAM_CODE, PROGRAM_VERSION_NUMBER, UNIT_SET_CODE, PROGRAM_COST_CENTRE, PROGRAM_COST_CENTRE_SUBJ_PROP FROM IGSFV_PRG_OFR_OPT_COST_CENTRES ORDER BY PROGRAM_CODE;
  • Filtering by calendar and location for delivery reporting: SELECT PROGRAM_TITLE, CALENDAR_ABBREVIATION, LOCATION_DESC, ATTENDANCE_MODE_DESC FROM IGSFV_PRG_OFR_OPT_COST_CENTRES WHERE CALENDAR_TYPE = :cal;

As the view is read-only, all access should be confined to SELECT statements, typically surfaced through Oracle Reports, BI Publisher, or ad hoc SQL for institutional and statutory reporting.