Search Results igs_ps_catlg_vers_all




Overview
Explore in AI Chat

Overview

The IGS_PS_CATLG_VERS_ALL table is a core entity within the Oracle E-Business Suite Student System (IGS) module, specifically designed to manage academic catalog versions. In the context of higher education institutions, an academic catalog is the official publication detailing programs, courses, policies, and requirements for a given academic period. This table serves as the master repository for different versions or editions of these catalogs over time. Its primary role is to provide a structured and version-controlled framework for academic offerings, enabling institutions to define and maintain distinct sets of rules and curricula that apply to specific student cohorts based on their entry term or year. The `_ALL` suffix indicates it is a multi-organization table capable of storing data for multiple operating units, a critical feature for enterprise deployments.

Key Information Stored

The table's structure is centered on uniquely identifying and describing each catalog version. The primary identifier is the system-generated `CATALOG_VERSION_ID`, which serves as the unique key for all related data. The business key, enforced by a unique constraint, is a combination of the `CATALOG_VERSION` (e.g., '2024-2025', '2023FALL') and the `CATALOG_SCHEDULE`. While the provided metadata does not list all columns, typical columns in such an entity would include a descriptive name, effective dates (start and end), status (e.g., 'ACTIVE', 'INACTIVE', 'PLANNED'), and the associated academic calendar or schedule to which the catalog version is tied. The `ORG_ID` column is also present to partition data by operating unit.

Common Use Cases and Queries

This table is fundamental for processes that depend on a student's governing catalog. Common use cases include determining the correct program requirements for degree audit, identifying which courses are valid for a given catalog year, and generating official academic transcripts. Administrators use this table to create and maintain new catalog versions during annual academic planning cycles. A typical reporting query would join this table to program and course offering entities to list all active programs within a specific catalog version.

  • Finding active catalog versions for a specific schedule:
    SELECT catalog_version, description FROM igs_ps_catlg_vers_all WHERE catalog_schedule = 'SEMESTER' AND sysdate BETWEEN start_date AND NVL(end_date, sysdate+1);
  • Retrieving the catalog version ID for a specific business key:
    SELECT catalog_version_id FROM igs_ps_catlg_vers_all WHERE catalog_version = '2024-2025' AND catalog_schedule = 'ANNUAL';

Related Objects

The IGS_PS_CATLG_VERS_ALL table sits at the center of a data model governing catalog information. Its primary key is referenced by child tables that store detailed catalog content. As documented in the provided relationship data:

  • IGS_PS_CATLG_NOTES_ALL: This table stores descriptive notes or commentary associated with a specific catalog version. It joins to IGS_PS_CATLG_VERS_ALL via the foreign key column `CATALOG_VERSION_ID`.

Beyond the explicitly documented foreign key, this table would logically have relationships with core academic structures like program versions (IGS_PS_VER), unit sets, and course offerings, which are typically defined within the context of a specific catalog version.