Search Results uai_unit_class

Overview

IGS_AS_UAI_SUA_V is a seeded Oracle E-Business Suite view owned by the APPS schema within the IGS (Student System) product family. It presents, in a single flattened result set, the assessment items that are allocated to a unit version within a nominated teaching calendar instance for a specific student. In functional terms, the view joins a student's unit attempt record to the assessment item definitions attached to that unit version and calendar instance, so that each row represents one assessment item an individual student is expected to complete for a given unit offering.

The object carries a VALID status in both the 12.1.1 and 12.2.2 releases and is exposed as a standard read-only reporting view. It is typically referenced by institution-specific inquiries, self-service pages, and third-party reporting extracts that need to resolve assessment item details (reference, due date, weighting, grading schema) against a student's enrolment rather than against a generic unit offering. Because the view enforces a business rule through a database function call, only assessment items that are genuinely applicable to the student are returned, which makes it suitable for direct use in transactional reporting without further filtering.

Underlying Base Objects

The view text defines the object over three base tables and one governing database function:

• IGS_EN_SU_ATTEMPT (alias SUA) — the student unit attempt, supplying person, course, unit, calendar type, calendar instance sequence, degree audit detail, and unit offering option identifiers.
• IGS_AS_UNITASS_ITEM_ALL (alias UAI) — the unit assessment item allocation, supplying the assessment item identifier, sequence, reference, due date, default item indicator, grading schema, weighting, and mandatory type attributes.
• IGS_AS_ASSESSMENT_ITM_ALL (alias AST) — the assessment item master, joined on ASS_ID and used as a fallback source for the item description.
• IGS_AS_VAL_UAI.ASSP_VAL_SUA_AI_ACOT — a validation function invoked in the WHERE clause that confirms the assessment item is applicable to the student's attempt; rows are returned only when the function evaluates to 'TRUE'.

The join is keyed on UNIT_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER across the student attempt and unit assessment item allocation, with ASS_ID linking the allocation to the assessment item master. No additional base objects are documented for this view in the ETRM metadata for 12.2.2.

Key Columns

• PERSON_ID, COURSE_CD, UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER — identify the student, course, unit version, and teaching calendar instance. CAL_TYPE and CI_SEQUENCE_NUMBER together locate the specific calendar instance.
• ASS_ID, SEQUENCE_NUMBER, UNIT_ASS_ITEM_ID — identify the assessment item and its allocation record.
• UAI_REFERENCE — the assessment item reference, the column most commonly used when a report must display a human-readable item identifier and the attribute typically sought by users searching on "uai_reference".
• UAI_DUE_DT, UAI_DFLT_ITEM_IND, UAI_LOGICAL_DELETE_DT, UAI_ACTION_DT — due date, default item flag, logical deletion date, and action date for the allocation.
• DESCRIPTION — resolved as NVL(UAI.DESCRIPTION, AST.DESCRIPTION), giving precedence to the allocation-level description.
• GRADING_SCHEMA_CD, GS_VERSION_NUMBER, UNIT_ASS_ITEM_GROUP_ID — grading schema and item grouping context.
• MIDTERM_MANDATORY_TYPE_CODE, MIDTERM_WEIGHT_QTY, FINAL_MANDATORY_TYPE_CODE, FINAL_WEIGHT_QTY — mandatory status and weighting for midterm and final components.
• DEG_AUD_DETAIL_ID, UOO_ID — degree audit detail and unit offering option linkage.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Several legacy columns (UAI_LOCATION_CD, UAI_UNIT_CLASS, UAI_UNIT_MODE, SUA_LOCATION_CD, SUA_UNIT_CLASS, SUA_UNIT_MODE) are projected as NULL literals, retaining column positions for backward compatibility while no longer returning data.

Common Use Cases and Queries

Typical scenarios include generating a student-facing assessment schedule, feeding assessment weightings into a results calculation extract, and reconciling allocation records against the assessment item master for a calendar instance.

Retrieving all applicable assessment items for a person and unit:

SELECT person_id, unit_cd, version_number, cal_type, ci_sequence_number, uai_reference, description, uai_due_dt, final_weight_qty FROM apps.igs_as_uai_sua_v WHERE person_id = :p_person_id AND unit_cd = :p_unit_cd;

Listing items due within a date range for a calendar instance:

SELECT person_id, unit_cd, uai_reference, uai_due_dt FROM apps.igs_as_uai_sua_v WHERE cal_type = :p_cal_type AND ci_sequence_number = :p_ci_seq AND uai_due_dt BETWEEN :p_from AND :p_to AND uai_logical_delete_dt IS NULL;

Resolving weightings for midterm and final components:

SELECT unit_cd, uai_reference, midterm_mandatory_type_code, midterm_weight_qty, final_mandatory_type_code, final_weight_qty FROM apps.igs_as_uai_sua_v WHERE person_id = :p_person_id;

As the view applies its own applicability check through the validation function, queries should not attempt to reimplement that rule; instead, filter on the identifying and date columns shown above. Because the view is owned by APPS, callers should reference it as APPS.IGS_AS_UAI_SUA_V or rely on a synonym appropriate to their environment.