Results for “igs_he_poous_cc”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_HE_POOUS_CC view is a multilanguage (ML/"_TL"-style, identified by the "_CC" suffix) reporting object in the Oracle E-Business Suite Student System (IGS) product family. Its documented description is Program Offering Option Cost Center Details, and it is owned by the APPS schema with a status of VALID across EBS 12.1.1 and 12.2.2. The view exposes cost centre attribution data associated with HESA (Higher Education Statistics Agency) program offering option unit-set records, allowing cost centre percentages to be reported against individual course, version, calendar type, location, attendance mode, attendance type and unit-set combinations.

In the EBS reporting and integration layer, IGS_HE_POOUS_CC functions as a secure, filtered presentation layer over the underlying HESA POOUS cost centre table. It is primarily consumed by seeded reports, concurrent programs, extracts and third-party integration interfaces (such as HESA statutory returns and cost-allocation analyses) that must present cost centre data without exposing raw column names or bypassing Multi-Org / row-level security.

Underlying Base Objects

The view is defined over a single documented base object, IGS_HE_POOUS_CC_ALL, which is the multi-organization (ALL) table holding the HESA_POOUS_CC_ID-keyed rows. The view text confirms this with a straight projection: every column A.x from IGS_HE_POOUS_CC_ALL is echoed into the view, prefixed only by the synthetic ROWID column aliased as ROW_ID.

No other base objects are documented (referenced base objects: none beyond the _ALL table). The critical structural relationship is the WHERE-clause filter that restricts the _ALL rows to the current operating unit, using ORG_ID and the session-level USERENV('CLIENT_INFO') accessor. The predicate compares the row's ORG_ID to the numeric value decoded from the first 10 characters of CLIENT_INFO, defaulting to the sentinel value -99 when the client info is blank or unset. This is the classic Oracle Multi-Org (MO) VPD-style filter that allows multiple operating units to share the same physical _ALL table while each session sees only its own org's rows.

Key Columns

• ROW_ID — Pseudo-column; the ROWID of the underlying _ALL row, providing a unique physical locator.
• HESA_POOUS_CC_ID — Primary/unique identifier for the cost centre association record.
• COURSE_CD, CRV_VERSION_NUMBER — Course code and course version number identifying the program offering.
• CAL_TYPE, LOCATION_CD — Calendar type and location code of the offering.
• ATTENDANCE_MODE, ATTENDANCE_TYPE — Attendance attributes that further qualify the offering.
• UNIT_SET_CD, US_VERSION_NUMBER — Unit-set code and version, linking the cost centre to a specific program unit set.
• COST_CENTRE — The cost centre code being attributed.
• SUBJECT — Subject classification associated with the cost centre split.
• PROPORTION — The proportion (typically a percentage or fractional weight) of the offering allocated to this cost centre.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns inherited from the base table.

Common Use Cases and Queries

Typical usage centres on cost-centre apportionment reporting for HESA returns and internal cost analysis. A straightforward query listing cost centre splits for a course version is:

• SELECT course_cd, crv_version_number, unit_set_cd, cost_centre, proportion FROM apps.igs_he_poous_cc WHERE course_cd = :p_course AND crv_version_number = :p_version ORDER BY unit_set_cd, cost_centre;

Aggregating allocation weights per offering option verifies that proportions reconcile:

• SELECT course_cd, crv_version_number, location_cd, attendance_mode, SUM(proportion) total_proportion FROM apps.igs_he_poous_cc GROUP BY course_cd, crv_version_number, location_cd, attendance_mode HAVING SUM(proportion) <> 100;

Integration extracts frequently join the view to other IGS_HESA or unit-set objects via HESA_POOUS_CC_ID, while security-sensitive reports rely on the ORG_ID filter so that only the session's operating unit rows are returned. Queries that omit the ORG context (blank CLIENT_INFO) will resolve against the -99 sentinel and return no rows, which is expected behaviour for the multi-org filter.