Search Results igs_ps_ver_all

Overview

The IGS_PS_VER_ALL table is a core entity within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It serves as the master repository for all versions of academic programs offered by an institution. This includes both award-bearing programs (like degrees and diplomas) and non-award programs. The table operates on a multi-org model, as indicated by the "_ALL" suffix, meaning it stores data for multiple operating units and is typically accessed via views that filter by the MOAC (Multi-Org Access Control) security profile. Its primary function is to define the specific characteristics and lifecycle of each iteration of a program, enabling institutions to manage curriculum changes over time while maintaining historical integrity for student records.

Key Information Stored

The table's structure is centered on uniquely identifying and describing a program version. The primary key is a composite of COURSE_CD and VERSION_NUMBER, which together uniquely identify a specific version of a program. Key descriptive and control columns include COURSE_STATUS (linked to IGS_PS_STAT), which defines the active, inactive, or planned state of the version, and COURSE_TYPE (linked to IGS_PS_TYPE_ALL), which categorizes the program. Other significant attributes govern financial, governmental, and administrative aspects, such as REV_ACCOUNT_CD for revenue accounting, GOVT_SPECIAL_COURSE_TYPE for government reporting, and various date fields to control the effective lifecycle of the version. The table also holds critical control flags for processes like unit set enrollment, advanced standing, and attendance type.

Common Use Cases and Queries

This table is fundamental to numerous academic operations and reporting scenarios. Common use cases include generating catalogs of active programs, auditing curriculum history, and validating data during student application and enrollment processes. For reporting, it is frequently joined with related entities like IGS_PS_OFR_ALL (program offerings) and IGS_PS_AWARD. A typical query to list all active program versions would be:

• SELECT course_cd, version_number, title
  FROM igs_ps_ver_all
  WHERE course_status = 'ACTIVE'
  AND SYSDATE BETWEEN start_dt AND NVL(end_dt, SYSDATE);

Another common pattern involves retrieving the current version of a specific program for use in an application interface or to check prerequisites. Data fixes or audits often require tracing the lineage of a program by querying multiple versions sorted by version number and effective dates.

Related Objects

As a central hub table, IGS_PS_VER_ALL has extensive relationships within the Student System. It is a parent table to numerous critical entities, including IGS_PS_OFR_ALL (program offerings at locations), IGS_PS_AWARD (award details), IGS_PS_OWN (ownership history), and IGS_PS_ANL_LOAD (annual load). It is also referenced by application processing tables (IGS_AD_PS_APPL_INST_ALL), advanced standing records (IGS_AV_ADV_STANDING_ALL), and curriculum item details (IGS_CO_ITM_ALL). Key foreign key relationships exist with reference tables such as IGS_PS_COURSE (for the base program code), IGS_PS_TYPE_ALL, IGS_PS_STAT, IGS_FI_ACC_ALL, and IGS_PS_GOVT_SPL_TYPE, ensuring data integrity across the program definition domain.