Search Results reference_code_description




Overview
Explore in AI Chat

Overview

APPS.IGSBV_USEC_OCCUR_REFERENCES is a read-only database view in the Oracle E-Business Suite (EBS) covering releases 12.1.1 and 12.2.2. It belongs to the Student Systems product family, whose objects carry the IGS prefix and are typically deployed in higher-education and institutional implementations. The view presents reference-code information attached to unit section occurrences — that is, records that classify or annotate a specific occurrence of a unit section within the institution's academic structure.

Functionally, the view serves as a reporting and integration facade over its single underlying base table, IGS_PS_USEC_OCUR_REF. By exposing a stable, aliased column set, it decouples downstream consumers — concurrent programs, OBIEE or XML Publisher reports, interfaces, and custom extensions — from the physical column names of the base table. The presence of the "BV" naming convention (as in IGSBV) signals a business view whose primary consumers include ETRM (Enterprise Transaction Reference Model) and reporting layers rather than only transactional entry screens. Because the definition includes the WITH READ ONLY clause, the view cannot be used for DML; all maintenance of reference-code assignments must be performed against the base table through the standard product forms or APIs.

Underlying Base Objects

The view is defined over exactly one object: the base table IGS_PS_USEC_OCUR_REF, aliased as uor in the view text. The join is implicit — there is no union, aggregation, or multi-table join in the definition. Each row in IGS_PS_USEC_OCUR_REF therefore appears once in the view, with no cardinality change or filtering applied. The ETRM metadata for this object does not document additional referenced objects, so the relationship between view and base table is strictly one-to-one as documented.

Key Columns

  • REFERENCE_CODE_TYPE — the category or classification under which the reference code is grouped. It distinguishes the nature of the reference attached to the occurrence.
  • REFERENCE_CODE — the code value itself, which the user searched for in relation to its description.
  • REFERENCE_CODE_DESCRIPTION — the descriptive text associated with the reference code. In the view text this column is aliased from the base column REFERENCE_CODE_DESC, so consumers querying for "reference_code_description" should reference this alias when selecting from the view.
  • UNIT_SEC_OCCUR_REFERENCE_ID — the unique primary identifier for each reference record.
  • UNIT_SECTION_OCCURRENCE_ID — the foreign key linking the reference to the parent unit section occurrence, enabling correlation back to the occurrence and thus to the academic unit/section structure.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns identifying who created and last modified each row and when.

Common Use Cases and Queries

Typical scenarios include listing the reference codes and descriptions attached to a given unit section occurrence, producing validation or lookup reports for reference-code types, and feeding reference data into integrations. A representative query to retrieve the description for a code is:

  • SELECT reference_code_type, reference_code, reference_code_description FROM apps.igsbv_usec_occur_references WHERE reference_code = :code;
  • SELECT reference_code, reference_code_description FROM apps.igsbv_usec_occur_references WHERE unit_section_occurrence_id = :occurrence_id;
  • SELECT DISTINCT reference_code_type FROM apps.igsbv_usec_occur_references ORDER BY reference_code_type;

Because the view is read-only and unfiltered, no DML is permitted, and all listed columns reflect the underlying base-table values unchanged.