Results for “question_or_title”

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

Overview

The IGSBV_AS_ASSESSMENT_ITEMS view is a read-only database object owned by the APPS schema within the Oracle EBS 12.1.1 / 12.2.2 Student System (IGS) module. It exposes descriptive and instructional attributes for assessment items — the individual components (exams, papers, questions, or titled deliverables) against which a student may be assessed. In EBS reporting and integration contexts, this view serves as a flattened, presentation-oriented access point for assessment item metadata, eliminating the need for reporting tools, Oracle Reports/BI Publisher templates, or inbound/outbound interface programs to reconstruct the underlying column semantics or resolve lookup values independently.

The view is defined with the WITH READ ONLY clause, confirming it is intended strictly for query and extraction workloads rather than DML. Its role is therefore confined to read paths: concurrent program extracts, OBIEE/BI Publisher datasets, custom SQL reports, and third-party integration feeds that consume assessment item definitions for scheduling, examination logistics, or student communication.

Underlying Base Objects

The view is defined over a single base object, IGS_AS_ASSESSMNT_ITM_ALL, which is the translatable, multi-organization "ALL" table storing assessment item records. Although the ETRM documentation records "none documented" for referenced base objects, the view text explicitly identifies IGS_AS_ASSESSMNT_ITM_ALL as the sole source table, joined implicitly by direct column projection. No joins, unions, or analytical operations are applied; every column is a one-to-one projection of a corresponding base table column, with the exception of the two lookup-resolving expressions and the column aliasing that renames several base columns to more descriptive view names.

Because the base table carries the _ALL suffix, it supports both base-language records and translations via the standard EBS MLD (Multi-Lingual Data) pattern. The view itself does not expose a LANGUAGE column, so consumers querying translated assessment descriptions must be aware that the translation view (IGS_AS_ASSESSMNT_ITM_TL) is not referenced here; the view projects only the base-table columns.

Key Columns

• ASSESSMENT_ITEM_DESCRIPTION — The free-text narrative describing the assessment item. This is the column most directly associated with the search term "assessment_item_description" and is the primary human-readable field in the view.
• ASSESSMENT_TYPE — Classifies the assessment item (for example, examination, assignment, or continuous assessment).
• QUESTION_OR_TITLE — Supplies the question text or the title of the assessed item.
• ASSESSMENT_LENGTH_OR_DURATION — The expected length or duration of the assessment.
• EXAM_PAPER_NAME / EXAM_SHORT_PAPER_NAME — Long and abbreviated examination paper titles.
• EXAM_WORKING_TIME / EXAM_PERUSAL_TIME — Allocated working and reading (perusal) times for examinations.
• EXAM_SUPERVISOR_INSTRUCTIONS, EXAM_ANNOUNCEMENTS, EXAM_ALLOWABLE_INSTRUCTIONS, EXAM_NON_ALLOWED_INSTRUCTIONS, EXAM_SUPPLIED_INSTRUCTIONS, EXAM_CONSTRAINTS — Instructional fields capturing invigilation guidance, permitted and prohibited materials, supplied resources, and examination constraints.
• "_LA:EXAM_SCHEDULED_INDICATOR" and "_LA:CLOSED_INDICATOR" — Lookup-resolving pseudo-columns generated via the IGS_LOOKUP_VALUES mechanism against the YES_NO lookup type, returning the descriptive MEANING rather than the raw code.
• ASSESSMENT_ID — The primary key of the underlying assessment item record, used for joining to related IGS assessment tables.
• COMMENTS — Supplementary free-text notes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns.

Common Use Cases and Queries

The view is typically queried to produce assessment item listings for examination scheduling, student handbooks, and paper-setting workflows. A representative query retrieving the description alongside its type is shown below.

• Listing assessment items and their descriptions for a reporting extract:
  SELECT assessment_id, assessment_item_description, assessment_type FROM apps.igsbv_as_assessment_items;
• Building an examination logistics report:
  SELECT exam_paper_name, exam_working_time, exam_perusal_time, "_LA:EXAM_SCHEDULED_INDICATOR" FROM apps.igsbv_as_assessment_items WHERE assessment_type = 'EXAM';
• Extracting invigilation instructions and constraints for a given assessment:
  SELECT assessment_item_description, exam_supervisor_instructions, exam_constraints FROM apps.igsbv_as_assessment_items WHERE assessment_id = :p_assessment_id;

Because the view is read-only and projects a single base table, it performs efficiently in ad-hoc queries and can be safely granted to read-only reporting responsibilities. Consumers requiring translated descriptions must query the underlying translatable tables directly, as this view does not expose translation attributes.