Results for “igs_as_assessmnt_itm”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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

• ROW_ID — The physical row identifier of the underlying row, exposed as ROWID.
• ASS_ID — The primary identifier for the assessment item record.
• ASSESSMENT_TYPE — Classifies the assessment instrument, for example examination or paper.
• DESCRIPTION and COMMENTS — Free-text descriptive attributes.
• EXAM_SHORT_PAPER_NAME, EXAM_PAPER_NAME — Names used to identify the examination paper in short and full form.
• EXAM_WORKING_TIME, EXAM_PERUSAL_TIME — Durations allocated for working and perusal during the examination.
• EXAM_SCHEDULED_IND — Indicates whether the examination is scheduled.
• EXAM_SUPERVISOR_INSTRCTN, EXAM_ANNOUNCEMENTS, EXAM_ALLOWABLE_INSTRCTN, EXAM_NON_ALLOWED_INSTRCTN, EXAM_SUPPLIED_INSTRCTN, EXAM_CONSTRAINTS — Instructional and constraint text presented to supervisors and candidates.
• QUESTION_OR_TITLE — The question text or title associated with the item.
• ASS_LENGTH_OR_DURATION — The length or duration of the assessment.
• CLOSED_IND — Indicates whether the assessment item is closed.
• ORG_ID and the Multi-Org filter — Restricts rows to the current operating unit.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — The standard twenty flexible descriptive attributes.

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.