Search Results igs_ps_govt_spl_type




Overview
Explore in AI Chat

Overview

The table IGS_PS_GOVT_SPL_TYPE is a core reference entity within the Oracle E-Business Suite Student System (IGS) module. It serves as a master table for defining and storing the government-recognized classifications for special program types. Its primary role is to provide a standardized, validated list of codes that describe non-standard or specialized course offerings, such as those with unique funding, accreditation, or reporting requirements mandated by a governmental education authority. This table ensures data integrity and consistency across the student system, particularly in areas of program definition, government reporting, and compliance tracking.

Key Information Stored

While the provided metadata does not list all columns, the structure centers on a primary key code that uniquely identifies each special program type. The most critical column is GOVT_SPECIAL_COURSE_TYPE, which acts as the primary key. This column stores the concise code representing the specific government special program classification. It is highly probable that the table also includes descriptive columns, such as a name or description field (e.g., GOVT_SPECIAL_COURSE_TYPE_DESC), to provide a meaningful explanation of the code. Additional columns may track data like an effective date range (START_DATE, END_DATE) to manage the validity of the type over time and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for audit purposes.

Common Use Cases and Queries

This table is essential for configuring and reporting on specialized academic programs. A primary use case is during the setup of a new course or program version (in IGS_PS_VER), where an administrator must assign the appropriate government special type code. It is also critical for generating statutory reports to education departments, where programs must be categorized according to official typologies. Common queries involve listing all active special types for use in LOVs or validating data integrity.

  • Sample Query to List All Active Types:
    SELECT govt_special_course_type, description
    FROM igs_ps_govt_spl_type
    WHERE SYSDATE BETWEEN NVL(start_date, SYSDATE) AND NVL(end_date, SYSDATE)
    ORDER BY 1;
  • Sample Query to Find Programs Using a Specific Type:
    SELECT pv.course_cd, pv.version_number
    FROM igs_ps_ver_all pv, igs_ps_govt_spl_type gs
    WHERE pv.govt_special_course_type = gs.govt_special_course_type
    AND gs.govt_special_course_type = '&SPECIAL_TYPE_CODE';

Related Objects

The IGS_PS_GOVT_SPL_TYPE table has a direct parent-child relationship with the primary program definition table. As documented in the foreign key metadata:

  • IGS_PS_VER_ALL: This table, which stores details of all course/program versions, contains a foreign key column named GOVT_SPECIAL_COURSE_TYPE. This column references IGS_PS_GOVT_SPL_TYPE.GOVT_SPECIAL_COURSE_TYPE. This relationship enforces that the special program type assigned to any course version must be a valid code defined in the master government special type table.