Search Results anon_grading_ind

Overview

The view IGS_AS_ASSESSMENT_ITM_V is an Oracle E-Business Suite (EBS) database object belonging to the IGS — Student System product family, which is marked as obsolete in later releases. It was delivered within the legacy Oracle Student System (OSS) module, a component historically integrated with the Oracle EBS 11i/12.1.1 and 12.2.2 technology stacks where student, assessment, and grading data were managed. The view is designed to present assessment items — the discrete units of work for which a student can be assessed, such as examinations, assignments, papers, or coursework components.

Functionally, the view denormalises assessment item records by joining each item to its parent assessment type. This join resolves assessment-type-level attributes (such as whether the assessment is examinable, closed, or anonymously graded) alongside the item-level descriptive and instructional data. The result is a single reporting surface that exposes both granular item detail and the governing characteristics of the assessment type. Because the underlying product is obsolete and the object is reported as "Not implemented in this database" in the ETRM reference, the view is primarily of interest for historical reporting, migration analysis, or upgrade reconciliation rather than for new development.

Underlying Base Objects

The view text is defined over two base tables:

• IGS_AS_ASSESSMNT_ITM (aliased AI) — the primary source, supplying the assessment item identifier (ASS_ID), assessment type code, descriptive fields, examination metadata, audit columns, and the twenty descriptive flexfield ATTRIBUTE columns.
• IGS_AS_ASSESSMNT_TYP (aliased AST) — the assessment type reference, joined on AST.ASSESSMENT_TYPE = AI.ASSESSMENT_TYPE, contributing the type-level description, EXAMINABLE_IND, CLOSED_IND, and the ANON_GRADING_IND flag that matches the search term.

The join is an equi-join on the assessment type code, meaning every assessment item is enriched with exactly one set of type attributes. No outer join is used, so items whose assessment type code does not exist in the type table are excluded from the result set. The documented metadata lists no additional referenced base objects.

Key Columns

• ROW_ID / ASS_ID — unique identifiers for the assessment item record.
• ASSESSMENT_TYPE — the code linking the item to its governing type.
• DESCRIPTION — item description (note the type description surfaces as DSP_DESCRIPTION).
• EXAM_SHORT_PAPER_NAME / EXAM_PAPER_NAME — examination paper naming attributes.
• EXAM_WORKING_TIME / EXAM_PERUSAL_TIME — timing allowances for the exam.
• EXAM_SCHEDULED_IND — indicates whether the examination is formally scheduled.
• EXAM_SUPERVISOR_INSTRCTN, EXAM_ANNOUNCEMENTS, EXAM_ALLOWABLE_INSTRCTN, EXAM_NON_ALLOWED_INSTRCTN, EXAM_SUPPLIED_INSTRCTN, EXAM_CONSTRAINTS — instructional and constraint text associated with the exam.
• QUESTION_OR_TITLE, ASS_LENGTH_OR_DURATION, COMMENTS — general descriptive content.
• DSP_EXAMINABLE_IND, DSP_CLOSED_IND — assessment-type-level flags for examinability and closure.
• ANON_GRADING_IND — the anonymous grading flag inherited from the assessment type, indicating whether marking is performed without identifying the student.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — the descriptive flexfield segments for both item and inherited context.

Common Use Cases and Queries

The view is typically queried to list assessment items, filter by grading or examinability characteristics, or feed downstream reports. A representative query filtering on the anonymous grading flag is:

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

Another common pattern selects exam scheduling details for examinable, open items:

SELECT assessment_type,
       exam_paper_name,
       exam_working_time,
       exam_scheduled_ind
FROM   igs_as_assessment_itm_v
WHERE  dsp_examinable_ind = 'Y'
AND    dsp_closed_ind = 'N';

Because the product is obsolete, these queries are best regarded as reference or migration aids when reconciling legacy Student System data during an upgrade to a supported assessment platform.