Search Results exam_short_paper_name




Overview
Explore in AI Chat

Overview

The view IGS_AS_ASSESSMNT_ITM belongs to the IGS — Student System product family within Oracle E-Business Suite. This module, which encompasses the Oracle Student System and its associated assessment-processing functionality, is documented as obsolete in ETRM 12.1.1 and 12.2.2. The view exposes assessment item records, presenting attributes that describe individual assessment components such as examinations, papers, and other graded instruments together with their scheduling, instructional, and descriptive characteristics.

In the context of Oracle EBS reporting and integration, IGS_AS_ASSESSMNT_ITM serves as a reporting-friendly projection of the underlying assessment item data. Views of this type are typically used to shield external reports, extracts, and interfaces from the physical structure of the base table while enforcing Multi-Org security through the operating unit context. The view definition embeds an ORG_ID predicate that resolves the current operating unit from the CLIENT_INFO session setting, ensuring that only rows belonging to the caller's organization are returned.

Underlying Base Objects

The view is defined over a single base object, IGS_AS_ASSESSMNT_ITM_ALL, as shown in the view text. No additional base tables or join objects are documented in the ETRM metadata; the ETRM entry lists no referenced base objects beyond this foundation table. The _ALL suffix indicates that the underlying table stores records across all operating units, and the view applies the Multi-Org filter to partition that data by ORG_ID.

The documented implementation status is notable: ETRM records the object as Not implemented in this database. This means that while the view definition and column metadata are catalogued, the object may not be physically present in a given environment, and it should be treated as obsolete for new development. The view text relies on USERENV('CLIENT_INFO') to derive the organization identifier, consistent with the Multi-Org model used throughout the Student System schema.

Key Columns

Common Use Cases and Queries

Because the object is obsolete and may not be implemented, its primary practical relevance is historical reporting, data migration analysis, and auditing of legacy Oracle Student System installations. A typical query retrieves open assessment items for the current operating unit:

  • SELECT ASS_ID, ASSESSMENT_TYPE, EXAM_PAPER_NAME, EXAM_WORKING_TIME, EXAM_PERUSAL_TIME, EXAM_SCHEDULED_IND, CLOSED_IND FROM IGS_AS_ASSESSMNT_ITM WHERE CLOSED_IND = 'N' ORDER BY ASS_ID;
  • SELECT ASS_ID, DESCRIPTION, QUESTION_OR_TITLE, ASS_LENGTH_OR_DURATION FROM IGS_AS_ASSESSMNT_ITM WHERE ASSESSMENT_TYPE = :p_type;
  • SELECT ASS_ID, EXAM_SUPERVISOR_INSTRCTN, EXAM_ANNOUNCEMENTS, EXAM_ALLOWABLE_INSTRCTN, EXAM_NON_ALLOWED_INSTRCTN, EXAM_CONSTRAINTS FROM IGS_AS_ASSESSMNT_ITM WHERE ASS_ID = :p_ass_id;

Each query is automatically scoped by the embedded Multi-Org predicate, so callers must ensure the correct operating unit context is initialized in CLIENT_INFO before execution.