Results for “reference_type_description”

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

Overview

The view IGSFV_USEC_OCCUR_REFERENCES belongs to the IGS – Student System product family within Oracle E-Business Suite. It is documented in the ETRM as a "Full View for Unit Section Occurrence Reference" and is flagged as part of an obsolete module. The view exposes descriptive reference data that is attached to a unit section occurrence — that is, the specific scheduling instance of a unit (course) section delivered in a given teaching period. Its role is to present a denormalized, read-only projection that joins reference-code detail records to their associated unit section occurrence references, so that downstream reporting, inquiry forms, and integration extracts can retrieve reference codes together with their human-readable descriptions and reference-type descriptions in a single query.

The view is defined WITH READ ONLY, meaning it is intended purely for query and reporting purposes and cannot be the target of DML. It is documented as not implemented in the current database instance, so in the environments described by this metadata the view exists as a definition only. The user search term unit_section_occurrence_id corresponds directly to a column exposed by this view, confirming that the view is the appropriate object for resolving references tied to a specific unit section occurrence.

Underlying Base Objects

The view text is defined over exactly two base objects:

• IGS_PS_USEC_OCUR_REF (aliased UOR) — the primary table storing unit section occurrence reference records, including the foreign key to the unit section occurrence.
• IGS_GE_REF_CD_TYPE_ALL (aliased RCT) — the reference-code type lookup, providing the descriptive text for the reference code type.

The two objects are joined on the condition UOR.REFERENCE_CODE_TYPE = RCT.REFERENCE_CD_TYPE. This inner join means only occurrence references whose reference code type resolves to a valid entry in the reference-code type table will be returned. The documented metadata lists no referenced base objects and no owner, which is consistent with the object being recorded as obsolete and not implemented in the database.

Key Columns

• UNIT_SEC_OCCUR_REFERENCE_ID — unique identifier (primary key) for the occurrence reference row.
• UNIT_SECTION_OCCURRENCE_ID — foreign key to the unit section occurrence to which the reference is attached; the column corresponding to the user's search term.
• REFERENCE_CODE_TYPE — the reference code type identifier, joining to the reference-code type lookup.
• REFERENCE_CODE — the actual reference code value assigned.
• REFERENCE_CODE_DESCRIPTION — descriptive text for the reference code, sourced from UOR.REFERENCE_CODE_DESC.
• REFERENCE_TYPE_DESCRIPTION — the description of the reference code type, sourced from RCT.DESCRIPTION.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard Oracle EBS audit columns recording who created and last modified the row and when.

Common Use Cases and Queries

The principal use case is retrieving all references recorded against a particular unit section occurrence for display or reporting. A typical query filters on the occurrence identifier returned by the user's search term:

• List references for one occurrence: SELECT reference_code_type, reference_code, reference_code_description, reference_type_description FROM igsfv_usec_occur_references WHERE unit_section_occurrence_id = :occurrence_id;
• Retrieve references by code type: SELECT unit_section_occurrence_id, reference_code FROM igsfv_usec_occur_references WHERE reference_code_type = :ref_type;
• Reporting extract joining reference detail to occurrence scheduling data via unit_section_occurrence_id.
• Audit review of creation and last-update activity using the standard audit columns.

Because the view is read-only and flagged obsolete, it should be treated as a legacy reporting surface; new development should confirm whether a supported replacement object exists in the target release (12.1.1 or 12.2.2).