Search Results igs_ps_grp_all




Overview
Explore in AI Chat

Overview

The IGS_PS_GRP_ALL table is a core data object within the Oracle E-Business Suite Student System (IGS), specifically designed for managing academic program structures. Its primary function is to define and store logical groupings of academic programs (courses). These groupings serve as versatile administrative constructs used for various operational purposes across the student lifecycle, such as applying fees, managing enrollment controls, defining progression rules, and implementing exclusions. The table supports multi-organization architecture, as indicated by the "_ALL" suffix, meaning it stores data for multiple operating units with appropriate security filtering via the ORG_ID column. It is critical to note that the provided metadata explicitly states the Student System module is marked as "Obsolete" and the table is "Not implemented in this database," indicating its use is likely confined to legacy installations or specific upgrade paths.

Key Information Stored

The table's structure centers on identifying and classifying each program group. The primary key is the COURSE_GROUP_CD, a unique code that identifies the specific grouping. A critical attribute is the COURSE_GROUP_TYPE, which categorizes the group's purpose by referencing the IGS_PS_GRP_TYPE lookup table. This type dictates the group's permissible uses within the system. While the full column list is not detailed in the excerpt, standard practice suggests the table would also include descriptive fields (such as a name or description), start and end dates for validity, the ORG_ID for multi-org support, and standard Oracle EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The essence of the data is the relationship between this group header and its member programs, which is maintained in the separate child table IGS_PS_GRP_MBR.

Common Use Cases and Queries

This table is central to administrative rules and reporting based on program collections. A primary use case is fee management, where a specific fee trigger (IGS_PS_GRP_FEE_TRG) is associated with a course group rather than individual programs. Another is defining enrollment embargoes or prerequisites, where rules (IGS_PR_RU_OU_ALL, IGS_PR_STDNT_PR_OU_ALL) reference a group to control student eligibility. Common queries involve listing all active groups of a certain type or identifying the programs within a specific group for reporting. For example, to find all programs in a 'SCHOLARSHIP' group, one would join IGS_PS_GRP_ALL to IGS_PS_GRP_MBR and then to the main programs table.

  • Sample Query: SELECT g.COURSE_GROUP_CD, m.COURSE_CD FROM IGS_PS_GRP_ALL g, IGS_PS_GRP_MBR m WHERE g.COURSE_GROUP_CD = m.COURSE_GROUP_CD AND g.COURSE_GROUP_TYPE = 'FEE' AND SYSDATE BETWEEN g.START_DATE AND NVL(g.END_DATE, SYSDATE);

Related Objects

The IGS_PS_GRP_ALL table sits at the center of a relational hierarchy. Its primary relationships, as defined by foreign keys, are as follows:

  • IGS_PS_GRP_TYPE: Lookup table for validating the COURSE_GROUP_TYPE.
  • IGS_PS_GRP_MBR: Child table that stores the individual program codes that are members of each group.
  • IGS_PS_GRP_FEE_TRG: Links course groups to specific financial fee triggers.
  • IGS_PE_CRS_GRP_EXCL: Used to define exclusions where persons (students) are prevented from enrolling in programs within a specific group.
  • IGS_PR_RU_OU_ALL & IGS_PR_STDNT_PR_OU_ALL: Reference the group to enforce progression rules and enrollment embargoes (ENCMB_COURSE_GROUP_CD).