Results for “org_unit_desc”

7 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_OU_CC_V is a reporting and integration object delivered within the Oracle E-Business Suite Student System (product code IGS). It is designed to expose HESA (Higher Education Statistics Agency) cost centre, subject, and proportion data that has been defined against an organizational unit. The view is documented as a "new view" whose purpose is to consolidate cost centre assignments for organizational units in a form suitable for statutory HESA returns and related institutional reporting. Its status is VALID, and it is owned by the APPS schema, meaning it is intended for use by application users, concurrent programs, and reporting tools rather than being maintained directly by end users.

Because the view resolves several foreign-key relationships inline through scalar subqueries, it presents fully described, human-readable output without requiring the consumer to join to lookup or reference tables. This makes it particularly convenient for ad hoc queries and for extracting data into external reporting systems. The object was identified in a search for the term "cost_centre", which is consistent with the view's central purpose: surfacing the cost centre code and its associated description.

Underlying Base Objects

The view text documents a single primary base table, IGS_HE_OU_CC (aliased as OUCC), which stores the HESA organizational-unit cost centre records. The view itself does not persist data; it is a stored SELECT statement evaluated against that base table at runtime.

In addition to the base table, the view definition embeds several correlated scalar subqueries that read from supporting reference objects:

The documented ETRM metadata lists no formally declared referenced base objects beyond the primary table; the dependent lookups are visible only through the view text. Each lookup is evaluated per row, so performance on the view reflects the cost of these correlated subqueries.

Key Columns

The view exposes the following columns:

  • ROW_ID — the ROWID of the underlying IGS_HE_OU_CC row, useful for identifying the base record.
  • HESA_OU_CC_ID — the primary identifier of the HESA organizational-unit cost centre record.
  • ORG_UNIT_CD — the organizational unit code to which the cost centre allocation applies.
  • ORG_UNIT_DESC — the resolved party name of the organizational unit.
  • COST_CENTRE — the HESA cost centre code (the value the user searched for).
  • COST_CENTRE_DESC — the description of that cost centre from IGS_HE_CODE_VALUES where CODE_TYPE = 'OSS_COSTCN'.
  • SUBJECT and SUBJECT_DESC — the subject code and its description from the field-of-study reference.
  • PROPORTION — the proportion of the organizational unit's activity attributed to that cost centre and subject combination.
  • Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include HESA statutory reporting, reconciliation of cost centre splits by organizational unit, and validation that proportions sum correctly. A representative query retrieving all cost centre allocations for a given organizational unit is:

SELECT org_unit_cd, org_unit_desc, cost_centre, cost_centre_desc, subject, subject_desc, proportion FROM apps.igs_he_ou_cc_v WHERE org_unit_cd = :p_org_unit ORDER BY cost_centre, subject;

For a completeness check ensuring proportions total to 1 per unit:

SELECT org_unit_cd, SUM(proportion) FROM apps.igs_he_ou_cc_v GROUP BY org_unit_cd HAVING SUM(proportion) <> 1;

A lookup by the searched term confirms which units carry a specific cost centre:

SELECT org_unit_desc, subject_desc, proportion FROM apps.igs_he_ou_cc_v WHERE cost_centre = :p_cost_centre;

Because these queries execute the view's correlated subqueries, they are best restricted by ORG_UNIT_CD or COST_CENTRE where possible.