Search Results final_result_ind




Overview
Explore in AI Chat

Overview

IGS_RE_THESIS_RESULT_V is a reporting view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It exposes the set of valid thesis result codes used within the Oracle Student System, joining the base thesis result definition table to the shared lookup view so that each coded value is accompanied by its user-facing meaning and a flag indicating whether the result represents a final outcome. The view carries a VALID status in the ETRM reference for releases 12.1.1 and 12.2.2, meaning it is a supported, compiled object available for query and integration.

The view serves a dual purpose. First, it provides a denormalized, read-only presentation of thesis result configuration data, allowing report developers and integrators to retrieve both the internal code and its display meaning in a single query rather than joining the base table to the lookup infrastructure manually. Second, it surfaces the FINAL_RESULT_IND attribute, which classifies each thesis result code as final or non-final. This classification is significant in academic processing because progression, completion, and award logic frequently depend on distinguishing a terminal thesis outcome from intermediate or provisional results.

Underlying Base Objects

The view text is defined over two objects:

  • IGS_RE_THESIS_RESULT — the primary base table holding thesis result code definitions, aliased as RES. It supplies the row identifier, the result code, description, the system code, the closed indicator, comments, and standard WHO audit columns.
  • IGS_LOOKUPS_VIEW — the lookup presentation object, aliased as LKUP, which supplies the lookup MEANING and the FINAL_RESULT_IND attribute.

The two objects are joined on the condition LKUP.LOOKUP_TYPE = 'THESIS_RESULT' and LKUP.LOOKUP_CODE = RES.S_THESIS_RESULT_CD. This means the view returns only those thesis result records whose system code resolves to a defined lookup entry of type THESIS_RESULT; orphaned or inactive codes that lack a matching lookup row are excluded from the result set. Although ETRM documentation does not enumerate the underlying physical lookup table, IGS_LOOKUPS_VIEW conventionally resolves lookups maintained in the FND_LOOKUP_VALUES / FND_LOOKUPS infrastructure.

Key Columns

  • ROW_ID — the ROWID of the base base-table record, useful for direct row addressing.
  • THESIS_RESULT_CD — the primary business key identifying the thesis result.
  • DESCRIPTION — descriptive text for the result code.
  • S_THESIS_RESULT_CD — the system-level code used to link to the lookup definition.
  • CLOSED_IND — indicates whether the result code is closed to new use.
  • MEANING — the display label resolved from the lookup.
  • FINAL_RESULT_IND — the lookup-controlled flag identifying whether the result counts as a final thesis outcome; this is the attribute referenced in the user's search for "final_result_ind".
  • COMMENTS and the WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — free-text annotation and standard audit tracking.

Common Use Cases and Queries

Typical uses include populating LOVs for thesis result entry, filtering final results for completion reporting, and integrating result definitions with external academic records systems.

To list all active thesis results with their meanings:

SELECT thesis_result_cd, meaning, final_result_ind
FROM   igs_re_thesis_result_v
WHERE  closed_ind = 'N';

To retrieve only final thesis outcomes:

SELECT thesis_result_cd, meaning
FROM   igs_re_thesis_result_v
WHERE  final_result_ind = 'Y';

Valid values for FINAL_RESULT_IND are governed by the THESIS_RESULT lookup configuration; querying the view directly is the recommended way to confirm which codes are currently flagged as final.