Search Results igs_ps_grp_type




Overview
Explore in AI Chat

Overview

The IGS_PS_GRP_TYPE table is a core reference entity within the Oracle E-Business Suite Student System (IGS) module. It functions as a master data repository that defines the permissible types of academic program groups an institution can configure. This table is fundamental for establishing the framework within which related program groups are created and managed. Its primary role is to enforce data integrity by providing a controlled list of valid group types, such as equivalents or double programs, which are then referenced by the main program group records stored in the IGS_PS_GRP_ALL table.

Key Information Stored

Based on the provided ETRM metadata, the table's structure is centered on a primary key column that stores the unique identifier for each program group type. While the full column list is not detailed in the excerpt, the documented primary key and foreign key relationships confirm the existence and critical nature of the COURSE_GROUP_TYPE column. This column is the unique code representing a specific category of program group, such as 'EQUIV' for equivalent programs or 'DBL' for available double programs. The table's description indicates it stores the available types, suggesting it likely contains additional descriptive columns, potentially including a name and an active indicator, to fully define each type.

Common Use Cases and Queries

This table is primarily used in administrative setup and reporting contexts. A common operational use case is during the creation of a new program group in the application's user interface, where the valid types are queried from this table to populate a list of values (LOV). For reporting and data validation, analysts frequently join this table to the main program group table to generate meaningful descriptions. A typical SQL pattern involves a simple select to list all configured types or a join to enrich program group data.

  • SELECT COURSE_GROUP_TYPE FROM IGS.IGS_PS_GRP_TYPE WHERE <active condition>; – Retrieves valid codes for an LOV.
  • SELECT gt.COURSE_GROUP_TYPE, g.GROUP_NAME FROM IGS.IGS_PS_GRP_TYPE gt, IGS.IGS_PS_GRP_ALL g WHERE gt.COURSE_GROUP_TYPE = g.COURSE_GROUP_TYPE; – Joins type codes to group details for a report.

Related Objects

The IGS_PS_GRP_TYPE table has a direct parent-child relationship with the primary program group table, as documented in the foreign key metadata. The IGS_PS_GRP_ALL table's COURSE_GROUP_TYPE column is a foreign key that references the COURSE_GROUP_TYPE primary key in IGS_PS_GRP_TYPE. This relationship ensures that every program group created in the system must be assigned a valid, pre-defined type from this reference table. No other foreign key relationships are documented in the provided excerpt, indicating this is the primary dependent object.

  • IGS_PS_GRP_ALL: This is the main transactional table for program groups. It references IGS_PS_GRP_TYPE via the foreign key constraint on the column IGS_PS_GRP_ALL.COURSE_GROUP_TYPE.