Search Results unit_section_reference_title

Overview

IGSFV_USEC_REFERENCES is a read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGS (Student System) product family. The view provides a denormalized presentation of the relationship between unit section references and reference codes. In the Oracle EBS 12.1.1 and 12.2.2 data models, reference codes are the configurable lookup values that classify and categorize student-system entities; the present view joins those codes to the unit section reference records (USEC) that consume them, exposing both the code values and the descriptive text of the underlying reference type. Because the object is defined as a view over three base tables and is created WITH READ ONLY, it is intended for query and reporting purposes only. Report authors, integration developers, and functional analysts use it wherever unit section reference data must be rendered with human-readable code descriptions rather than raw identifiers — for example in admissions, enrollment, and curriculum reporting extracts.

Underlying Base Objects

The view is defined over three IGS base tables, combined through an inner join:

• IGS_PS_USEC_REF_CD (aliased US) — the driving table, holding the unit section reference code rows that carry the reference code type, code, and code description.
• IGS_GE_REF_CD_TYPE (aliased RE) — the reference code type definition table, joined on US.REFERENCE_CODE_TYPE = RE.REFERENCE_CD_TYPE, supplying the descriptive name of the code type.
• IGS_PS_USEC_REF (aliased USR) — the unit section reference header, joined on US.UNIT_SECTION_REFERENCE_ID = USR.UNIT_SECTION_REFERENCE_ID, supplying the unit section reference title.

The documented ETRM metadata lists no referenced base objects beyond those implied by the view text. The join structure is strictly equi-join based, so a row is returned only when matching records exist in all three tables; unit section reference code rows lacking a valid reference code type or header record are excluded.

Key Columns

• REFERENCE_CODE_TYPE — identifier of the reference code type assigned to the unit section reference code row.
• REFERENCE_CODE — the reference code value itself.
• REFERENCE_CODE_DESC — description of the reference code.
• USEC_REFERENCE_CODE_ID — the unit section reference code identifier, aliased from UNIT_SECTION_REFERENCE_CD_ID.
• REFERENCE_CODE_ID — exposed as a NULL literal in this view; retained for union compatibility with related views.
• UNIT_SECTION_REFERENCE_ID — the unit section reference identifier linking the code back to its header record.
• REFERENCE_CODE_TYPE_DESC — descriptive name of the reference code type, sourced from IGS_GE_REF_CD_TYPE.
• REFERENCE_DESCRIPTION — exposed as a NULL literal.
• UNIT_SECTION_REFERENCE_TITLE — title of the unit section reference, sourced from IGS_PS_USEC_REF.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard Oracle EBS audit columns inherited from the driving table.

Common Use Cases and Queries

The view supports reporting on how unit section references are categorized by reference code, and on the code types in use across a student system implementation. A typical query returns all codes for a given reference type:

• SELECT unit_section_reference_title, reference_code_type, reference_code, reference_code_desc FROM igsfv_usec_references WHERE reference_code_type = :p_code_type;
• SELECT usec_reference_code_id, unit_section_reference_id, reference_code, reference_code_type_desc FROM igsfv_usec_references ORDER BY unit_section_reference_title;
• SELECT reference_code_type, COUNT(*) FROM igsfv_usec_references GROUP BY reference_code_type;

Because the view is read-only, it must not be used as a DML target; maintenance of unit section reference codes is performed against the base tables through the Student System application. When writing queries, note that REFERENCE_CODE_ID and REFERENCE_DESCRIPTION always return NULL and should not be used as filter or join criteria.