Results for “igs_as_uai_exam_ci_init_v”

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

Overview

IGS_AS_UAI_EXAM_CI_INIT_V is a reporting view within the Oracle E-Business Suite Student System (IGS) product family, which is classified as obsolete in release 12.1.1 and 12.2.2. The view describes the examination calendar instances against which a unit assessment item record is examined. Its defining characteristic is that it deliberately ignores the relationship expressed by the uai.exam_cal_type and uai.exam_ci_sequence_number fields, presenting instead the examination calendar instances derived from the assessment item and the enrolment context. This design makes the view suitable for identifying all active examination instances that legitimately fall within an assessment item's delivery window, independent of the examination calendar instance explicitly recorded on the unit assessment item. The view is read-only and intended for inquiry and reporting rather than transactional processing.

Underlying Base Objects

The view is defined over six base tables in the IGS schema: IGS_AS_UNITASS_ITEM (alias UAI), IGS_AS_ASSESSMNT_ITM (alias AI), IGS_AS_ASSESSMNT_TYP (alias AT), IGS_CA_INST (alias CI), IGS_CA_TYPE (alias CAT), and IGS_CA_STAT (alias CS). It also invokes the database function IGS_EN_GEN_014.ENRS_GET_WITHIN_CI. The joins enforce that the unit assessment item is not logically deleted, that the assessment item is flagged as examination-scheduled, that the assessment type is examinable, that the calendar type belongs to the EXAM calendar category, and that the calendar instance status is ACTIVE. The function call constrains results to examination calendar instances that fall within the enrolment's calendar instance using the 'N' parameter. No base objects are separately documented in the ETRM metadata beyond the referenced tables listed above.

Key Columns

• EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER — the examination calendar type and sequence number from the unit assessment item, retained for reference even though the join does not depend on them.
• UAI_EXAM_CAL_TYPE, UAI_EXAM_CI_SEQUENCE_NUMBER — additional exam calendar identifiers carried from the unit assessment item record.
• CAL_TYPE, CI_SEQUENCE_NUMBER — the calendar type and sequence number of the examination calendar instance from IGS_CA_INST.
• UNIT_CD, VERSION_NUMBER — the unit code and version to which the assessment item belongs.
• ASS_ID, SEQUENCE_NUMBER — the assessment identifier and item sequence number.
• CI_START_DT, CI_END_DT — the start and end dates of the calendar instance window.
• UNIT_CLASS, UNIT_MODE, LOCATION_CD — delivery attributes of the unit offering.
• DUE_DT, REFERENCE, DFLT_ITEM_IND — due date, free-text reference, and default item indicator.
• LOGICAL_DELETE_DT, ACTION_DT — logical deletion and action dates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical usage centres on examination scheduling and assessment reporting. A common query retrieves all active examination instances associated with a specific unit assessment item:

SELECT exam_cal_type, exam_ci_sequence_number, unit_cd, version_number, ass_id, ci_start_dt, ci_end_dt, due_dt FROM igs_as_uai_exam_ci_init_v WHERE unit_cd = :unit_code AND ass_id = :ass_id;

Because the view abstracts the exam calendar relationship recorded on the unit assessment item, it is useful when reconciling examinations that occur within a broader enrolment calendar window. Reports may join the view to student enrolment tables to determine which learners are affected by a given examination instance, or filter on dflt_item_ind to isolate default assessment items. The view is equally applicable to data extraction routines feeding institutional reporting. As the underlying product is obsolete in 12.1.1 and 12.2.2, such queries should be regarded as legacy maintenance rather than forward-looking development.