Results for “dsp_assessment_type”

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

Overview

The view IGS_AS_UNITASS_ITEM_V belongs to the Oracle E-Business Suite IGS – Student System product family, which is documented as obsolete in release 12.1.1 and 12.2.2. The view presents the assessment item configuration attached to a unit offering — that is, the individual pieces of assessment (such as an examination, assignment, or test) that make up a student's assessment for a given unit, calendar type, and calendar instance. It is a reporting and integration construct rather than a transactional entity, and it exists to give developers and report authors a denormalised, join-ready projection of assessment item data.

Because the view explicitly exposes the column alias DSP_ASSESSMENT_TYPE, it is of particular interest to users searching that term. The alias reflects the assessment type description derived from the assessment item master, and the DSP_ prefix indicates it is intended for display purposes in forms, reports, or self-service pages.

Underlying Base Objects

The view is defined over four base tables joined in a single SELECT statement:

• IGS_AS_UNITASS_ITEM_ALL (aliased UAI) — the driving table, holding the association between a unit offering and an assessment item.
• IGS_AS_ASSESSMNT_ITM_ALL (aliased AI) — the assessment item master, joined on ASS_ID.
• IGS_AS_GRD_SCHEMA (aliased GRD) — the grading schema, joined on both GRADING_SCHEMA_CD and VERSION_NUMBER.
• IGS_CA_INST (aliased CI) — the calendar instance, outer-joined (denoted by the (+) operator) on EXAM_CAL_TYPE and EXAM_CI_SEQUENCE_NUMBER.

The outer join to IGS_CA_INST means the row for an assessment item is still returned when no examination calendar instance has been defined. Note that the reference metadata states the view is "Not implemented in this database," so it may not exist in every ETRM 12.2.2 environment. Its implementation is delivered through Oracle Forms and APPS-level views rather than as a database object in all cases.

Key Columns

• ROW_ID — the row identifier of the underlying IGS_AS_UNITASS_ITEM_ALL record.
• ORG_ID — the operating unit (multi-org) context for the record.
• UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER — the unit offering and calendar instance context.
• ASS_ID, DSP_ASSESSMENT_TYPE, ASS_ID_DESC — the assessment item identifier, its display assessment type, and description. The description uses NVL(UAI.DESCRIPTION, AI.DESCRIPTION) so an override at unit level takes priority.
• CI_START_DT, CI_END_DT, DUE_DT, RELEASE_DATE — scheduling and due-date information.
• GRADING_SCHEMA_CD, GS_VERSION_NUMBER, DSP_GRD_SCHEMA_DESC — grading schema applied to the assessment item.
• MIDTERM_WEIGHT_QTY, FINAL_WEIGHT_QTY, MIDTERM_MANDATORY_TYPE_CODE, FINAL_MANDATORY_TYPE_CODE — weighting and mandatory rules for midterm and final components.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and the concurrent program columns REQUEST_ID, PROGRAM_ID.

Common Use Cases and Queries

Typical usage is reporting assessment structures for a unit offering, or exposing the assessment type in a custom form or OAF page. The DSP_ASSESSMENT_TYPE alias is commonly referenced when building list-of-values or descriptive flexfield-style displays.

To retrieve assessment items for a specific unit and calendar instance:

SELECT unit_cd, cal_type, ci_sequence_number,
       ass_id, dsp_assessment_type, ass_id_desc,
       grading_schema_cd, dsp_grd_schema_desc,
       due_dt, midterm_weight_qty, final_weight_qty
FROM   igs_as_unitass_item_v
WHERE  unit_cd = :p_unit_cd
AND    cal_type = :p_cal_type
AND    ci_sequence_number = :p_seq;

To list all assessment types in use for a unit:

SELECT DISTINCT dsp_assessment_type, ass_id
FROM   igs_as_unitass_item_v
WHERE  unit_cd = :p_unit_cd
AND    logical_delete_dt IS NULL
ORDER BY dsp_assessment_type;

Because LOGICAL_DELETE_DT is exposed, queries should filter on LOGICAL_DELETE_DT IS NULL to exclude soft-deleted assessment items. Given the obsolete status of the IGS module, new development should target supported student system alternatives where available.