Search Results igs_ps_grp_mbr




Overview
Explore in AI Chat

Overview

The IGS_PS_GRP_MBR table is a core data entity within the Oracle E-Business Suite Student System (IGS). It functions as the definitive repository for managing program groupings, a key academic structure. Specifically, it defines the membership relationship between individual academic programs (courses) and the program groups to which they are assigned. This table is essential for administrative processes that require the categorization, reporting, and rule application across sets of related programs, such as cohort analysis, fee grouping, or applying standard academic regulations.

Key Information Stored

The table's structure is designed to establish a clear link between a program and its group. The primary key uniquely identifies each membership record and consists of three columns: COURSE_CD (the code of the program), VERSION_NUMBER (the specific version of that program), and COURSE_GROUP_CD (the code of the group to which the program belongs). This composite key ensures that a specific program version can be a member of only one instance of a given group, maintaining data integrity. The table primarily serves as a junction entity, with its columns acting as foreign keys to the master tables for programs and program groups.

Common Use Cases and Queries

This table is central to queries that need to list or analyze programs within a defined category. A common reporting use case is to generate a list of all programs belonging to a specific group, such as all "Postgraduate Research" programs, for accreditation or funding purposes. Administrators may also query it to validate program assignments before running batch processes. A typical SQL pattern involves joining IGS_PS_GRP_MBR with the program (IGS_PS_VER_ALL) and group (IGS_PS_GRP_ALL) master tables.

  • Sample Query: To find all members of a program group:
    SELECT pv.course_cd, pv.version_number, pv.title
    FROM igs_ps_grp_mbr gm, igs_ps_ver_all pv
    WHERE gm.course_group_cd = '&GROUP_CODE'
    AND gm.course_cd = pv.course_cd
    AND gm.version_number = pv.version_number;

Related Objects

The IGS_PS_GRP_MBR table maintains critical foreign key relationships with master definition tables, ensuring referential integrity. These documented relationships are fundamental for any data extraction or integration involving program groups.

  • IGS_PS_GRP_ALL: This is the master table for program groups. The COURSE_GROUP_CD column in IGS_PS_GRP_MBR references this table to validate the existence of the group.
  • IGS_PS_VER_ALL: This is the master table for program (course) versions. A composite foreign key from the columns COURSE_CD and VERSION_NUMBER in IGS_PS_GRP_MBR references this table, ensuring that only valid, active program versions can be assigned to a group.