Search Results assp_get_uapi_ap

Overview

IGS_AS_SUAAI_V is a PL/SQL-based view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It is available in both release 12.1.1 and 12.2.2. The view presents assessment outcome data for students — specifically records originating from the Student Unit Attempt Assessment Item (SUAAI) entity — enriched with assessment type descriptions, due dates, references, and validation results derived through calls to the IGS_AS_GEN_001, IGS_AS_GEN_003, and IGS_GE_GEN_004 packages. Because the view resolves display descriptions and computes validation results on the fly, it serves as a consolidated read model for marks and grades reporting rather than as a transactional object.

The view is referenced when users search on the package name igs_as_gen_001, since that package supplies the ASSP_CLC_SUAAI_VALID function whose truncated output appears as a column in the view's projection.

Underlying Base Objects

The ETRM metadata documents the view text but does not enumerate a formal list of referenced base objects. The SELECT statement identifies the following sources and supporting objects:

• IGS_AS_SUAAI (aliased SUAAI) — the primary base table supplying person, course, unit, assessment, mark, grade, and attribute columns. A ROWID column is exposed directly.
• ASI — an assessment-type source supplying ASSESSMENT_TYPE and fallback DESCRIPTION.
• IGS_AS_UNITASS_ITEM_ALL — correlated lookup for unit assessment item descriptions where UNIT_SECTION_ASS_ITEM_ID is null.
• IGS_PS_UNITASS_ITEM — correlated lookup for section-level assessment item descriptions.
• IGS_GE_GEN_004 — provides GENP_GET_LOOKUP for outcome comment meanings.
• IGS_AS_GEN_003 — provides ASSP_GET_UAI_DUE_DT and ASSP_GET_UAI_REF.
• IGS_AS_GEN_001 — provides ASSP_CLC_SUAAI_VALID, whose first seven characters form a validation indicator column.

Key Columns

The view exposes the full identifier key of a student's assessment attempt: PERSON_ID, COURSE_CD, UNIT_CD, CAL_TYPE, CI_SEQUENCE_NUMBER, ASS_ID, UOO_ID, ATTEMPT_NUMBER, and UNIT_ASS_ITEM_ID. Outcome data includes MARK, GRADE, PERFORMANCE, OUTCOME_DT, and OVERRIDE_DUE_DT. Derived columns include DSP_ASSESSMENT_TYPE, DSP_DESCRIPTION (resolved via DECODE/NVL logic across assessment item tables), OUTCOME_COMMENT_MEANING (translated through IGS_GE_GEN_004), and the function-driven due date, reference, and validity columns. Attribute columns ATTRIBUTE1 through ATTRIBUTE11 and ATTRIBUTE_CATEGORY support descriptive flexfield data.

Common Use Cases and Queries

Typical uses include building marks-and-grades reports, validating assessment attempts before grade roll-up, and extracting due-date or reference detail for a student's unit attempt.

A sample extraction of current outcomes:

SELECT person_id, course_cd, unit_cd, ass_id,
       dsp_description, mark, grade, outcome_dt
FROM   apps.igs_as_suaai_v
WHERE  logical_delete_dt IS NULL
AND    person_id = :p_person_id;

To surface records flagged or validated by the IGS_AS_GEN_001 routine, applications filter on the validation column produced by ASSP_CLC_SUAAI_VALID. Queries should always constrain by person, course, or calendar to avoid full scans, since the view invokes PL/SQL functions per row and correlated subqueries against the assessment item tables.