Results for “igs_as_unitass_item”

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

Overview

IGS_AS_UNITASS_ITEM is a multi-organization secured view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It presents the assessment items that have been allocated to a specific unit version within a nominated teaching calendar instance, such as a unit offering pattern. In the ETRM data model, a single unit version may be assigned many assessment items, and each assessment item in turn may be linked to additional assessment structures through the ASS_ID reference. The view therefore acts as the primary read-only access path for reporting and integration components that need to retrieve the assessment scheme defined for a unit offering.

Because the view is defined with an ORG_ID predicate derived from USERENV('CLIENT_INFO'), it enforces Oracle's multi-org security model at the row level. Only records belonging to the organization currently set in the user's operating unit context are returned. This makes the view suitable for concurrent programs, OAF pages, and BI Publisher reports that must respect organization-level data segregation without adding explicit ORG_ID filters.

Underlying Base Objects

The view is defined over a single base object, IGS_AS_UNITASS_ITEM_ALL, which is the multi-org table storing all assessment item assignments. The view projects a curated column list from that table and applies the organization security predicate. The ROWID of the base row is aliased as ROW_ID to preserve row identity for update-capable consumers. No other documented base objects are referenced in the metadata, and the ETRM 12.2.2 entry does not expose additional join targets; related information such as grading schema, assessment identifiers, and calendar instance details are denormalized into this single source table.

Key Columns

• UNIT_ASS_ITEM_ID — Primary key of the assessment item assignment, and the column most commonly referenced by downstream transactions.
• ORG_ID — Operating unit that owns the record; drives the multi-org security predicate.
• UNIT_CD, VERSION_NUMBER — Identify the unit version to which the assessment item belongs.
• CAL_TYPE, CI_SEQUENCE_NUMBER, CI_START_DT, CI_END_DT — Define the teaching calendar instance (offering pattern) under which the unit is taught.
• ASS_ID, SEQUENCE_NUMBER — Reference the assessment and its ordering within the unit.
• DUE_DT, REFERENCE — Due date and free-text reference for the item.
• DFLT_ITEM_IND — Indicates whether the item is a default assessment component.
• LOGICAL_DELETE_DT, ACTION_DT — Soft-delete and action timestamps for lifecycle tracking.
• EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER — Examination calendar instance linkage.
• GRADING_SCHEMA_CD, GS_VERSION_NUMBER — Grading schema applied to the item.
• UNIT_ASS_ITEM_GROUP_ID — Grouping identifier for related assessment items.
• MIDTERM_MANDATORY_TYPE_CODE, MIDTERM_WEIGHT_QTY, FINAL_MANDATORY_TYPE_CODE, FINAL_WEIGHT_QTY — Midterm and final weighting and mandatory-type attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_ID — Standard WHO audit and concurrent program context columns.

Common Use Cases and Queries

Typical consumers retrieve the assessment scheme for a unit offering to drive student assessment pages, gradebook population, and transcript-adjacent reporting. The following query lists active assessment items for a unit version in the current operating unit:

SELECT unit_ass_item_id, unit_cd, version_number,
       cal_type, ci_sequence_number, ass_id,
       due_dt, dflt_item_ind, grading_schema_cd
FROM   apps.igs_as_unitass_item
WHERE  unit_cd = :p_unit_cd
AND    version_number = :p_version
AND    cal_type = :p_cal_type
AND    logical_delete_dt IS NULL
ORDER BY sequence_number;

A second common pattern joins the view to unit and assessment reference views to produce a fully described listing, filtering on DFLT_ITEM_IND = 'Y' where only default components are required. Because the view resolves ORG_ID automatically, callers generally omit that predicate and rely on the session's operating unit context, which is the recommended practice for all IGS assessment reporting.