Search Results anon_grading_ind

Overview

IGS_AS_ASSESSMENT_ITM_V is a supplementary view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as IGS.IGS_AS_ASSESSMENT_ITM_V. It serves the Oracle Student System (formerly Oracle Student Administration) assessment functionality and is classified as a "supplementary view used to simplify forms coding." It is therefore not intended as a general-purpose reporting object. Oracle explicitly warns that this view should not be queried or altered directly for data manipulation, since its definition may change dramatically in subsequent minor or major releases. In EBS 12.1.1 and 12.2.2 the object remains VALID and is preserved for backward compatibility with the forms and concurrent programs that depend on it.

The view presents a denormalized, presentation-ready projection of assessment item data, combining plain assessment attributes with examination-specific details. It exposes the assessment identifier (ASS_ID), the assessment type, descriptive fields, exam scheduling and instruction text, and several display-oriented indicator columns such as DSP_DESCRIPTION, DSP_EXAMINABLE_IND, DSP_CLOSED_IND, and ANON_GRADING_IND. This design allows a form block or report to render assessment items without joining the underlying normalized tables itself.

Underlying Base Objects

The ETRM metadata does not document any referenced base objects for this view, so no authoritative dependency list can be quoted. Based on the naming convention and the IGS_AS module prefix, the view is expected to be defined over the assessment item base table, conventionally IGS_AS_ASSESSMENT_ITM, and is likely joined to related assessment type, examination, and lookup tables to resolve the descriptive and display columns. Because the documentation exposes no join definitions, integrators should treat the view as an opaque projection and rely on Oracle's own concurrent programs and forms rather than reverse-engineering it. Any custom object that depends on this view inherits the risk that the underlying definition is rebuilt during patching or an upgrade.

Key Columns

• ROW_ID – ROWID of the underlying assessment item row, used by Oracle Forms for row identification and locking.
• ASS_ID – Unique numeric identifier of the assessment item; the principal key for joining to assessment and grading data.
• ASSESSMENT_TYPE – Type classification of the assessment (for example, examination or assignment).
• DESCRIPTION and QUESTION_OR_TITLE – Long descriptive text and the question or title associated with the item.
• EXAM_* columns – Examination-specific attributes including short and full paper names, working and perusal times, scheduled indicator, and several 2000-character instruction blocks (supervisor instructions, announcements, allowable and non-allowed materials, supplied instructions, and constraints).
• ASS_LENGTH_OR_DURATION – Length or duration of the assessment, held as character data.
• ANON_GRADING_IND – Indicator controlling whether the assessment item is graded anonymously. This is the column referenced by the search term.
• DSP_DESCRIPTION, DSP_EXAMINABLE_IND, DSP_CLOSED_IND – Display helper columns used to render descriptive text and derivable indicators within forms.
• CLOSED_IND – Indicates whether the assessment item is closed.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–20 – Standard Oracle EBS descriptive flexfield columns for customer-defined attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns.
• COMMENTS – Free-text comments on the assessment item.

Common Use Cases and Queries

The principal use case is form and report support within the Student System assessment module, particularly where anonymous grading behavior must be surfaced. A typical read-only diagnostic query might be:

SELECT ass_id, assessment_type, description, anon_grading_ind, closed_ind, dsp_examinable_ind FROM apps.igs_as_assessment_itm_v WHERE anon_grading_ind = 'Y';

This identifies assessment items flagged for anonymous grading, useful when validating grading configuration before an examination cycle. A second common pattern lists examination scheduling details for examination-type items:

SELECT ass_id, exam_short_paper_name, exam_working_time, exam_scheduled_ind FROM apps.igs_as_assessment_itm_v WHERE assessment_type = 'EXAM' AND closed_ind = 'N';

Because Oracle discourages direct querying, integration and reporting developers should prefer the documented base tables or published APIs where available, and restrict use of this view to diagnostic or investigative purposes. Any dependency on ANON_GRADING_IND or the exam columns must be reviewed against ETRM after each upgrade, since the view definition is not guaranteed to remain stable between minor or major releases.