Search Results exam_cal_inst_sequence_number




Overview
Explore in AI Chat

Overview

The view APPS.IGSBV_AS_UNIT_ASSESSMENT_ITEMS belongs to the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to describe assessment items that have been allocated to a unit version within a nominated teaching calendar instance. In practical terms, the view consolidates the assessment structure of a taught unit — the individual assessment items, their weights, mandatory flags, grading schema, due and release dates, and examination scheduling attributes — alongside the teaching calendar instance under which that unit version is delivered.

The view is defined as a read-only projection (declared WITH READ ONLY) over a single base table, and it resolves several coded columns into their display meanings by referencing IGS_LOOKUP_VALUES. This makes it well suited to reporting and integration workloads where consumers require human-readable assessment metadata without joining to lookup tables themselves. Because it is a reporting-oriented view rather than a transaction entity, it exposes no DML surface; inserts and updates must be performed against the underlying base table.

Underlying Base Objects

The documented view text shows a single referenced base object: IGS_AS_UNITASS_ITEM_ALL, aliased as UAI. The ETRM metadata notes that no base objects are separately documented, so IGS_AS_UNITASS_ITEM_ALL is the authoritative source from the view definition itself. The view selects the assessment item attributes directly from this table and applies inline lookup resolution against IGS_LOOKUP_VALUES for three coded columns:

The view therefore sits directly on the unit assessment item table, with no intermediate joins documented, and inherits the multi-org (_ALL) nature of its base table. Because the base is a _ALL table, row visibility is governed by the standard IGS/HR security and operating unit context of the calling session.

Key Columns

The view exposes columns that describe both the assessment item and its teaching calendar context. Notable columns include:

Common Use Cases and Queries

A frequent requirement is to list assessment items for a unit version within a specific teaching calendar instance. Filtering on CALENDAR_START_DATE is the typical entry point when a user searches by teaching period start:

  • Assessment item listings for a unit version in a nominated calendar instance.
  • Weight and mandatory-type reporting for midterm and final components.
  • Examination scheduling extracts using the exam calendar columns.
  • Due-date and release-date monitoring for assessment items.

Representative query:

SELECT unit_code, version_number, reference, description, calendar_start_date, calendar_end_date, midterm_weight_quantity, final_weight_quantity, due_date FROM apps.igsbv_as_unit_assessment_items WHERE unit_code = :unit_code AND calendar_type = :cal_type AND calendar_start_date >= :calendar_start_date AND logical_delete_date IS NULL ORDER BY unit_code, version_number, sequence_number;

Because the view performs the lookup resolution internally, users obtain mandatory-type and default-item meanings without additional joins, simplifying report and interface development against the IGS assessment structures.