Search Results oss_costcn




Overview
Explore in AI Chat

Overview

The view APPS.IGS_HE_EN_SUSA_CC_V is a reporting and integration object within the Oracle E-Business Suite student system, specifically the Higher Education (HE) module of Oracle Student System (OSS). It presents cost centre allocation records associated with student unit set attempts (SUSA), linking student enrolment data to institutional cost centre definitions. The view is defined over the base table IGS_HE_EN_SUSA_CC and enriches each row with descriptive values resolved from two additional lookup sources, IGS_HE_CODE_VALUES and IGS_PS_FLD_OF_STUDY_ALL.

Its primary role is to expose denormalised, human-readable data for reporting. Rather than requiring report authors to join to code lookup tables themselves, the view resolves the cost centre description and the field-of-study (subject) description inline. The column OSS_COSTCN is the code type used to look up cost centre descriptions in IGS_HE_CODE_VALUES, which corresponds directly to the user search term "oss_costcn". This makes the view a convenient source for costing, funding, and statutory return reporting.

Underlying Base Objects

The documented view definition references the following objects:

  • IGS_HE_EN_SUSA_CC — the primary driving table, aliased as A. This holds the HE student unit set attempt cost centre allocation records, including the cost centre, subject, proportion, and audit columns.
  • IGS_HE_CODE_VALUES — referenced in a scalar subquery to resolve COST_CENTRE_DESC using CODE_TYPE = 'OSS_COSTCN' and matching VALUE = A.COST_CENTRE. This provides the descriptive text for each cost centre code.
  • IGS_PS_FLD_OF_STUDY_ALL — referenced in a scalar subquery to resolve SUBJECT_DESC by matching FIELD_OF_STUDY = A.SUBJECT. This supplies the descriptive name of the field of study associated with the subject code.

The view does not persist data; it derives its content at query time from these base objects. The two descriptive columns are resolved via correlated scalar subqueries, so their values reflect the current state of the underlying lookup tables.

Key Columns

  • ROW_ID — the ROWID of the base table row, allowing unique identification.
  • HE_SUSA_CC_ID — the primary identifier of the cost centre allocation record.
  • PERSON_ID — the student (person) identifier to whom the allocation relates.
  • COURSE_CD — the course code associated with the enrolment.
  • UNIT_SET_CD — the unit set (programme/module grouping) code.
  • SEQUENCE_NUMBER — a sequencing value for multiple allocation rows.
  • COST_CENTRE — the raw cost centre code stored on the base record.
  • COST_CENTRE_DESC — the resolved description from IGS_HE_CODE_VALUES (code type OSS_COSTCN).
  • SUBJECT — the field-of-study code.
  • SUBJECT_DESC — the resolved field-of-study description.
  • PROPORTION — the proportion of the allocation attributed to this cost centre/subject combination.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

The view is typically used for costing and funding reporting, verifying that cost centre allocations are correctly resolved to descriptions, and feeding downstream extracts. A representative query retrieves allocations for a student with their descriptive values:

  • SELECT person_id, course_cd, cost_centre, cost_centre_desc, subject_desc, proportion FROM apps.igs_he_en_susa_cc_v WHERE person_id = :p_person_id;
  • Reporting by cost centre: SELECT cost_centre, cost_centre_desc, COUNT(*) FROM apps.igs_he_en_susa_cc_v GROUP BY cost_centre, cost_centre_desc;
  • Filtering invalid codes: rows where COST_CENTRE_DESC IS NULL indicate a cost centre code that has no matching OSS_COSTCN entry in IGS_HE_CODE_VALUES, which is a useful data-quality check.

Because the descriptive columns are scalar subqueries, large extracts may benefit from a direct join to the lookup tables for performance. The view remains the authoritative, documented interface for this cost centre allocation data.