Search Results igs_ps_unit_ver_all




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT_VER_ALL table is a core entity within the Oracle E-Business Suite's now-obsolete Student System (IGS). It represents a specific version of an academic unit (or course module) offered by an educational institution. Each record defines the characteristics and administrative details for a particular iteration of a unit, allowing for curriculum evolution over time while maintaining historical integrity. As an "ALL" table, it is designed to support the Multi-Org architecture, storing data partitioned by the ORG_ID column. Its primary role is to serve as the master definition for unit versions, linking to critical academic structures like calendars, coordinators, curriculum frameworks, and financial accounts, thereby forming a central hub for academic planning and delivery data.

Key Information Stored

The table's structure captures comprehensive version-specific attributes for a unit. The primary key is a composite of UNIT_CD (the unit code) and VERSION_NUMBER, uniquely identifying each version. Critical descriptive columns include TITLE and a link to SUBTITLE_ID for extended naming. Academic governance is managed through links to UNIT_STATUS, UNIT_TYPE_ID, and UNIT_LEVEL. Operational planning data is stored via foreign keys to calendar instances (CAL_TYPE_ENROL_LOAD_CAL/SEQUENCE_NUM_ENROL_LOAD_CAL) for enrollment and offering loads. The table also holds financial information (REV_ACCOUNT_CD), coordinator assignment (COORD_PERSON_ID), and curriculum classification (CURRICULUM_ID, RPT_FMLY_ID). The UNIT_INT_COURSE_LEVEL_CD facilitates integration with other course levels.

Common Use Cases and Queries

This table is fundamental for queries related to academic catalog management, unit scheduling, and historical reporting. Common use cases include generating the official unit catalog for a given term, identifying all active versions of a unit for student enrollment, and auditing changes to unit attributes across versions. A typical query might join to IGS_PS_UNIT for the base unit description and IGS_PS_UNIT_STAT for status meaning. For example, to find all currently offered versions of units within a specific curriculum, one might query: SELECT uv.unit_cd, uv.version_number, uv.title FROM igs_ps_unit_ver_all uv JOIN igs_ps_unt_crclm_all cr ON uv.curriculum_id = cr.curriculum_id WHERE cr.curriculum_cd = '&CURR_CODE' AND uv.unit_status = (SELECT unit_status FROM igs_ps_unit_stat WHERE s_unit_status = 'ACTIVE') AND SYSDATE BETWEEN uv.start_dt AND NVL(uv.end_dt, SYSDATE);. Reporting on unit coordinator assignments also heavily relies on this table.

Related Objects

As indicated by its extensive foreign key relationships, IGS_PS_UNIT_VER_ALL integrates with numerous other entities in the Student System. Key documented relationships include:

These relationships underscore its central role in connecting unit definitions to assessment schedules, advanced standing rules, application instructions, load calculations, and outcome items.