Search Results incomp_version_number




Overview
Explore in AI Chat

Overview

IGS_AS_UG_ADI_V is a view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product. Its documented description is “Assessment Unit Grading WebADI View.” The view is registered as VALID in ETRM for both the 12.1.1 and 12.2.2 releases. It is designed to supply the flat, denormalised result set consumed by the Assessment Unit Grading WebADI (Web Applications Desktop Integrator) spreadsheet interface, through which grading staff upload, review, and validate assessment unit outcomes in bulk.

The view joins student assessment data with person, outcome, and grading schema information, and it directly invokes several PL/SQL functions and a package. In particular, the anonymous grading package IGS_AS_ANON_GRD_PKG is used to mask personally identifying information when an assessment unit offering has been flagged for anonymous grading, and the grade derivation package IGS_AS_DERIVE_GRADE is used to recompute grades and marks. This makes the view a reporting and integration surface rather than a purely static data source.

Underlying Base Objects

ETRM documents no referenced base objects for this view in 12.2.2, and the view text revealed in the documentation excerpt is complete enough to identify its principal dependencies by alias. The core source is the student unit attempt table, aliased SUA (IGS_AS_STUDENT_UNIT_ATT), which supplies person, course, unit, version, calendar, and offering identifiers. It is joined to the outcome table, aliased SUAO (the assessment unit outcome table carrying grade, mark, grading period, comments, release date, and override flags), and to a person/party source aliased P that provides PARTY_NUMBER, PERSON_LAST_NAME, PERSON_FIRST_NAME, and PERSON_MIDDLE_NAME.

Additional lookups include EC, an element/configuration source supplying KEY_DERIVE_UNIT_GRADE_FLAG, which controls whether stored grades are passed through unchanged or recomputed through IGS_AS_DERIVE_GRADE. A correlated scalar subquery references IGS_AS_GAA_SUB_HIST to retrieve the most recent grade submission date. Because these source objects are not formally registered as base objects in the ETRM record, dependency analysis should be confirmed against the live data dictionary on the target instance.

Key Columns

Common Use Cases and Queries

Primary usage is populating the WebADI grading spreadsheet and validating uploads before they are written back to the outcome table. The ANONYMOUS_ID column is typically inspected by administrators auditing anonymous grading assignments, or by integration code that must map an anonymous marker back to an assessment unit offering.

  • Extracting gradable outcomes for a unit offering prior to WebADI upload.
  • Auditing anonymously graded offerings and their generated identifiers.
  • Reporting finalised versus un-finalised outcomes by grading period.
  • Reconciling derived grades against stored grades.

A representative query selecting the anonymous grading attributes is:

SELECT uoo_id, course_cd, unit_cd, sua_version_number,
       grading_period_cd, anonymous_id, person_number, grade, mark
FROM   apps.igs_as_ug_adi_v
WHERE  uoo_id = :p_uoo_id
  AND  grading_period_cd = :p_grading_period;

Because the view calls IGS_AS_ANON_GRD_PKG and IGS_AS_DERIVE_GRADE per row, large-scale extracts should be restricted by UOO_ID, ORG_ID, or GRADING_PERIOD_CD to avoid performance degradation.