Search Results uai_logical_delete_dt




Overview
Explore in AI Chat

Overview

The IGS_AS_UNIT_ASSESSMENT_ITEM_V view is a Student System (IGS) reporting object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. As its ETRM description states, the view was created primarily to support the assignment due dates summary report, consolidating assessment item scheduling information so that due dates can be presented in a single, report-ready structure. Rather than forcing report developers to join several normalized Student System tables, the view pre-joins unit offering options, unit classes, assessment items, and assessment types, and exposes both the raw due date and a derived week-ending date. It is a read-only, non-materialized view; its behavior therefore reflects the current state of the underlying transactional tables at query time.

Underlying Base Objects

The view text documents a join across five base objects: IGS_AS_UNITASS_ITEM (aliased UAI), IGS_PS_UNIT_OFR_OPT (UOO), IGS_AS_UNIT_CLASS (UC), IGS_AS_ASSESSMNT_ITM (AI), and IGS_AS_ASSESSMNT_TYP (ATYP). The driving table is IGS_AS_UNITASS_ITEM, which supplies the unit/version/calendar key plus due-date and weight attributes. It is joined to IGS_PS_UNIT_OFR_OPT on UNIT_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER. IGS_AS_UNIT_CLASS is joined on UNIT_CLASS, and IGS_AS_ASSESSMNT_ITM is joined on ASS_ID, with IGS_AS_ASSESSMNT_TYP finally joined on ASSESSMENT_TYPE to retrieve assessment type descriptions and the examinable indicator. One function call, IGS_GE_GEN_001.GENP_CLC_WEEK_END_DT(UAI.DUE_DT), derives the WEEK_ENDING_DT value. Although the ETRM entry lists no separately documented referenced base objects, the view text above is authoritative for the dependency mapping.

Key Columns

Common Use Cases and Queries

Typical use is the assignment due dates summary report, as well as ad-hoc extracts of upcoming assessments. A common query filters out logically deleted rows, the scenario the search term uai_logical_delete_dt points to.

  • List due assessments for a teaching period: SELECT unit_cd, uai_due_dt, week_ending_dt, assessment_type, s_assessment_type FROM igs_as_unit_assessment_item_v WHERE cal_type = :cal_type AND uai_logical_delete_dt IS NULL ORDER BY uai_due_dt;
  • Extract weighted midterm and final items: SELECT ass_id, assessment_type, midterm_weight_qty, final_weight_qty, examinable_ind FROM igs_as_unit_assessment_item_v WHERE examinable_ind = 'Y' AND uai_logical_delete_dt IS NULL;
  • Group due dates by week: SELECT week_ending_dt, COUNT(*) FROM igs_as_unit_assessment_item_v WHERE uai_logical_delete_dt IS NULL GROUP BY week_ending_dt;

Because the view performs inner joins and invokes a PL/SQL function per row, queries restricted to unit, version, and calendar keys will generally benefit from the underlying indexes on IGS_AS_UNITASS_ITEM.