Search Results reference_code_description




Overview
Explore in AI Chat

Overview

The view IGSBV_USEC_OCCUR_REFERENCES is a base database view owned by the APPS schema within the Oracle E-Business Suite Student System product (IGS). Its documented role is to expose the reference information associated with unit section occurrences — the discrete scheduled or deliverable instances of a unit section in an academic term. The view is defined as a read-only projection over a single underlying table and does not perform joins, aggregation, or transformation beyond column aliasing.

Because it is a business view ("BV") prefixed object, it is intended as a stable, presentation-layer interface for reporting, concurrent programs, and integration extracts that must retrieve occurrence reference codes and their descriptions without querying the base transactional table directly. In Oracle EBS 12.1.1 and 12.2.2 the object remains VALID and is shipped as part of the APPS edition of the IGS schema.

Underlying Base Objects

The view is defined over a single table, IGS_PS_USEC_OCUR_REF, aliased as UOR in the view text. The documented DDL is a straight column mapping with a WITH READ ONLY clause, which prevents DML through the view and enforces its use strictly for query access. No other base tables, synonyms, or views are referenced in the documented definition.

Each row of the base table represents one reference attached to one unit section occurrence, joined logically by the UNIT_SECTION_OCCURRENCE_ID foreign key to the unit section occurrence entity. The ETRM metadata for 12.2.2 documents no additional referenced base objects, so the relationship between the view and the underlying data model is one-to-one at the row level.

Key Columns

  • REFERENCE_CODE_TYPE — Classifies the nature of the reference, allowing multiple reference categories to coexist for the same occurrence.
  • REFERENCE_CODE — The coded value of the reference, typically resolving to a lookup or reference-code definition elsewhere in the Student System.
  • REFERENCE_CODE_DESCRIPTION — The descriptive text for the reference code. This is the column most often targeted by users searching for "reference_code_description", and it is exposed under exactly that name in the view even though the base column is REFERENCE_CODE_DESC.
  • UNIT_SEC_OCCUR_REFERENCE_ID — Primary identifier for the occurrence reference record.
  • UNIT_SECTION_OCCURRENCE_ID — Foreign key linking the reference to its parent unit section occurrence.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard Oracle EBS audit columns capturing who created and last modified the row and when.

Common Use Cases and Queries

Typical uses include extracting all references for a given occurrence, validating that required reference types exist before a scheduling process runs, and producing descriptive reports that translate coded references for academic administrators.

Retrieve all references for a specific occurrence:

SELECT reference_code_type, reference_code, reference_code_description
FROM apps.igsbv_usec_occur_references
WHERE unit_section_occurrence_id = :occurrence_id;

List distinct reference descriptions by type for a term:

SELECT DISTINCT reference_code_type, reference_code_description
FROM apps.igsbv_usec_occur_references
ORDER BY reference_code_type, reference_code_description;

Audit recently changed reference data:

SELECT unit_sec_occur_reference_id, reference_code_description,
last_updated_by, last_update_date
FROM apps.igsbv_usec_occur_references
WHERE last_update_date >= SYSDATE - 30;

Because the view is read-only and single-table, these queries are inexpensive and safe for ad hoc reporting and integration extracts against both 12.1.1 and 12.2.2 environments.