Search Results grading_schema_desc




Overview
Explore in AI Chat

Overview

IGS_AS_UAI_FIND_V is a Student Systems (IGS) view in the Oracle E-Business Suite Applications schema (APPS), belonging to the Student Records / Assessment module. The name suggests it is a "find" (search/lookup) view for Unit Assessment Items (UAI), designed to expose assessment item records together with their assessment type and grading schema information for inquiry, reporting, and integration purposes. It is a denormalized read-only construct: rather than requiring callers to join four separate tables, the view already resolves the relationships between unit assessment items, assessment items, assessment types, and grading schemas.

Because the view exposes human-readable derived values — most notably grading_schema_desc, which is resolved from the grading schema table — it is well suited for LOV queries, descriptive reports, and UI-driven searches where users look up assessments by their grading schema. It carries no DML capability and is intended purely for retrieval.

Underlying Base Objects

The view is defined over four base tables joined on their primary/foreign key relationships:

Note that the grading schema join is two-column (code + version), reflecting versioned grading schemas. No base objects were documented in the ETRM metadata excerpt, but the view SQL explicitly references these four tables.

Key Columns

Common Use Cases and Queries

Typical uses include locating unit assessment items by grading schema, listing examinable items for a unit, and reporting assessment weightings. Sample query filtered by grading schema description:

SELECT unit_cd, version_number, ass_id, grading_schema_cd, grading_schema_desc, assessment_type, description
FROM apps.igs_as_uai_find_v
WHERE grading_schema_desc LIKE '%EXAM%' AND logical_delete_dt IS NULL;

A second pattern lists examinable items for a unit with weightings:

SELECT ass_id, exam_paper_name, midterm_weight_qty, final_weight_qty
FROM apps.igs_as_uai_find_v
WHERE unit_cd = :p_unit AND examinable_ind = 'Y';

Always filter on LOGICAL_DELETE_DT IS NULL to exclude soft-deleted rows, and be aware the two plain NULL literals and other NULL placeholders in the view text yield empty columns.