Results for “cost_centre_desc”

35 results




Overview
Explore in AI Chat

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

Overview

The view APPS.IGS_HE_POUS_CC_DTL_V is a reporting and integration object delivered within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to present Program Offering Cost Center Details. In the context of Oracle EBS 12.1.1 and 12.2.2, the view consolidates program offering cost centre allocation data with descriptive lookup information, providing a denormalised, read-only projection suitable for external reporting, extracts, and statutory returns — particularly those associated with HESA (Higher Education Statistics Agency) reporting, as indicated by the HESA_ prefix on the primary key column.

The object is owned by the APPS schema and carries a status of VALID. Because it is a view rather than a base table, it holds no data of its own; it materialises its rows at runtime from its referenced base objects and is intended strictly for query access.

Underlying Base Objects

The view text defines its dependencies explicitly. Although formal ETRM base-object documentation in the 12.2.2 metadata is sparse, the view definition reveals three referenced objects:

Both descriptive joins are outer joins, so cost centre allocations are retained even where a matching code value or field of study description is absent. This is significant because cost centre codes and subject codes may be introduced, retired, or re-mapped over time, and the view is designed not to lose allocation rows on account of missing reference data.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_HE_POOUS_CC record, enabling unambiguous identification of the source row.
  • HESA_POOUS_CC_ID — the surrogate primary key linking this detail to the parent program offering unit set cost centre entity.
  • COURSE_CD, CRV_VERSION_NUMBER — the course code and course version, identifying the program of study.
  • CAL_TYPE — the calendar type under which the offering is delivered.
  • LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE — delivery attributes describing where and how the program is offered.
  • UNIT_SET_CD, US_VERSION_NUMBER — the unit set code and version to which the cost centre allocation applies.
  • COST_CENTRE — the cost centre code, resolved via the OSS_COSTCN code type; this is the value most commonly referenced in cost allocation reporting.
  • COST_CENTRE_DESC — the human-readable description of the cost centre obtained from IGS_HE_CODE_VALUES.
  • SUBJECT, SUBJECT_DESC — the subject/field of study code and its description from IGS_PS_FLD_OF_STUDY.
  • PROPORTION — the fractional split applied to the allocation, used where a single offering is distributed across multiple cost centres.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

The view is predominantly used to report program offering cost centre allocations alongside their descriptions. A typical query retrieves allocations for a given course and calendar type:

  • Reporting cost centre distributions per course, unit set, or location for finance and planning.
  • Producing HESA and internal returns requiring cost centre and subject breakdowns.
  • Extracting allocation data into data warehouses or downstream cost-allocation engines.

A representative query is:

  • SELECT COURSE_CD, UNIT_SET_CD, COST_CENTRE, COST_CENTRE_DESC, SUBJECT_DESC, PROPORTION
  • FROM APPS.IGS_HE_POUS_CC_DTL_V
  • WHERE CAL_TYPE = :p_cal_type
  • ORDER BY COURSE_CD, UNIT_SET_CD, COST_CENTRE;

Where the lookup description is absent, COST_CENTRE_DESC returns null owing to the outer join, so reporting logic should coalesce to the raw COST_CENTRE code where a display value is mandatory.