Search Results igs_ps_unitass_item_v




Overview
Explore in AI Chat

Overview

The IGS_PS_UNITASS_ITEM_V view is a reporting and integration object within the Oracle E-Business Suite Student System (IGS) product family. It resides in the APPS schema and presents a denormalized, presentation-ready projection of the assessment item definitions that are attached to unit (course) offerings. In the IGS data model, a unit assessment item associates a specific assessment (identified by ASS_ID) with a unit offering option (UOO_ID) and, where applicable, with an exam calendar instance. This view surfaces those associations together with contextual descriptive attributes such as assessment descriptions, grading schema descriptions, and exam calendar descriptions, eliminating the need for downstream consumers to perform the multi-table joins themselves.

Because the view is owned by APPS and is marked VALID, it can be queried directly by reporting tools, concurrent program logic, and integration extracts. It exposes the audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the concurrent manager columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE), which makes it suitable for incremental or change-data-capture style extraction.

Underlying Base Objects

The view text defines four source objects joined together:

The joins to GRD and AST are inner joins (equality only), while the join to CI is an outer join, expressed in Oracle syntax with the (+) operator on the CI columns. Consequently, rows that have no matching calendar instance are still returned.

Key Columns

The view exposes the primary key column UNIT_SECTION_ASS_ITEM_ID, along with the foreign key columns UOO_ID and ASS_ID. SEQUENCE_NUMBER, CI_START_DT, and CI_END_DT provide ordering and effective-dating semantics. DUE_DT, REFERENCE, and DFLT_ITEM_IND describe the due date, free-text reference, and default item indicator for the assessment item. LOGICAL_DELETE_DT and ACTION_DT support logical deletion and action tracking.

The searched column, US_ASS_ITEM_GROUP_ID, is exposed directly from IGS_PS_UNITASS_ITEM and identifies the assessment item group to which the item belongs — a grouping construct used to organize items within a unit's assessment structure. The columns GRADING_SCHEMA_CD, GS_VERSION_NUMBER, GRADING_SCHEMA_DESC, RELEASE_DATE, EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER, and EXAM_CAL_DESCRIPTION provide grading and scheduling context. The columns MIDTERM_MANDATORY_TYPE_CODE, MIDTERM_WEIGHT_QTY, FINAL_MANDATORY_TYPE_CODE, and FINAL_WEIGHT_QTY carry midterm and final examination weighting and mandatory-type attributes. The DESCRIPTION column is the coalesced value NVL(UAI.DESCRIPTION, AST.DESCRIPTION).

Common Use Cases and Queries

Typical use cases include listing all assessment items for a unit offering, grouping items by assessment item group, reporting grading schema usage, and extracting assessment data for student records or LMS integration.

To retrieve all items for a specific assessment item group:

  • SELECT unit_section_ass_item_id, uoo_id, ass_id, sequence_number, us_ass_item_group_id, description FROM igs_ps_unitass_item_v WHERE us_ass_item_group_id = :p_group_id;

To list items for a unit offering option with grading and exam context:

  • SELECT uoo_id, ass_id, due_dt, grading_schema_cd, grading_schema_desc, exam_cal_type, exam_cal_description, midterm_weight_qty, final_weight_qty FROM igs_ps_unitass_item_v WHERE uoo_id = :p_uoo_id AND logical_delete_dt IS NULL ORDER BY sequence_number;

Because the view does not filter logically deleted rows, queries should generally include a predicate such as LOGICAL_DELETE_DT IS NULL unless historical data is explicitly required. Note that UNIT_CLASS, UNIT_MODE, and LOCATION_CD are projected as NULL constants, so they carry no data and should not be relied upon.