Search Results igs_ps_grp_mbr_u1

Overview

The IGS_PS_GRP_MBR table is a core data entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions product, residing under the IGS (Integrated Global Systems) schema. Its primary function is to define membership relationships between academic programs (courses) and program groupings. The table acts as a junction entity, linking individual program offerings to user-defined groups that share common properties. This structure is fundamental for administrative processes that require treating multiple programs as a collective unit, enabling efficient management of academic rules and student progression pathways.

Key Information Stored

The table's structure is focused on establishing the membership link and maintaining audit trails. The key columns are:

• COURSE_CD and VERSION_NUMBER: Together, these columns uniquely identify a specific program (course) that is a member of a group. The COURSE_CD is a unique identifier for the program.
• COURSE_GROUP_CD: This is a critical 10-character identifier for the program group itself. As per the documentation, program groups are used to link programs with user-defined common properties for purposes such as student progression and permitted double degree combinations. This is the column referenced in the user's search.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): These columns provide essential audit information, tracking who created or last modified each membership record and when.

The unique index (IGS_PS_GRP_MBR_U1) on COURSE_CD, VERSION_NUMBER, and COURSE_GROUP_CD enforces that a specific program version can belong to a specific group only once.

Common Use Cases and Queries

This table is central to queries that need to list or analyze programs belonging to a particular functional group. A common use case is generating reports for academic advisors or administrators to view all programs within a group designated for a specific progression rule or double-degree combination. For instance, to find all members of a specific program group, a straightforward SELECT statement is used:

SELECT COURSE_CD, VERSION_NUMBER
FROM IGS.IGS_PS_GRP_MBR
WHERE COURSE_GROUP_CD = '&GROUP_CODE';

Conversely, to find all groups a specific program belongs to:

SELECT COURSE_GROUP_CD
FROM IGS.IGS_PS_GRP_MBR
WHERE COURSE_CD = '&COURSE_CODE'
AND VERSION_NUMBER = &VERSION_NUM;

This data is often joined with the main program/course table (e.g., IGS_PS_VER) to retrieve descriptive details about the member programs for comprehensive reporting.

Related Objects

While the provided dependency information states the table does not reference other objects, it is a foundational table referenced by higher-level application logic. The key related object is the entity that defines the program group header information, which likely has a code matching the COURSE_GROUP_CD (e.g., a table like IGS_PS_GRP). The membership records in IGS_PS_GRP_MBR are children of such a header record. Furthermore, the table is referenced by the APPS synonym IGS_PS_GRP_MBR, which is used by the EBS application code and custom reports to access this data through a consistent public name, insulating them from the underlying schema.