Search Results igs_pe_prsid_grp_mem_all




Overview
Explore in AI Chat

Overview

The table IGS_PE_PRSID_GRP_MEM_ALL is a core data entity within the Oracle E-Business Suite (EBS) Student System (IGS). It functions as a membership table, establishing and managing the relationship between individuals (persons) and defined person identification groups. Its primary role is to record the occurrence or assignment of a specific person to a specific group, enabling the logical grouping of individuals for administrative, reporting, or functional purposes within the student lifecycle. As an "_ALL" table, it is designed to support multi-organization architecture (MOAC), storing data partitioned by the ORG_ID column to segregate information for different operating units.

Key Information Stored

The table's structure is centered on the relationship between a person and a group. Its primary key is a composite of GROUP_ID and PERSON_ID, enforcing uniqueness for each membership record. The GROUP_ID column is a foreign key referencing IGS_PE_PERSID_GROUP_ALL, identifying the specific group definition. The PERSON_ID column is a foreign key referencing HZ_PARTIES, the central table for persons and organizations in Oracle Trading Community Architecture (TCA), thus linking student system data to the foundational EBS party model. While the provided metadata does not list all columns, typical attributes for such a table would include creation and last update dates, the ORG_ID for multi-org context, and potentially status or effective date columns to manage the temporal validity of the group membership.

Common Use Cases and Queries

This table is pivotal for queries that need to list or analyze sets of individuals belonging to a defined cohort. Common functional use cases include generating reports for students in a specific academic program cohort, creating mailing lists for members of a student club, or identifying all individuals associated with a particular research project group. A fundamental query pattern retrieves all persons in a given group:

  • SELECT p.party_name, m.* FROM igs_pe_prsid_grp_mem_all m, hz_parties p WHERE m.person_id = p.party_id AND m.group_id = :group_id;

Conversely, to find all groups to which a specific person belongs:

  • SELECT g.group_name, m.* FROM igs_pe_prsid_grp_mem_all m, igs_pe_persid_group_all g WHERE m.group_id = g.group_id AND m.person_id = :person_id;

Reporting often involves joining this table to core student entity tables via the PERSON_ID to enrich group lists with academic attributes.

Related Objects

IGS_PE_PRSID_GRP_MEM_ALL maintains critical foreign key relationships with two principal tables. Its link to IGS_PE_PERSID_GROUP_ALL provides access to the definitional attributes of the group itself, such as group name, type, and description. Its relationship to HZ_PARTIES is essential for retrieving the person's name, contact details, and other demographic information stored in the TCA model. The table's primary key constraint, IGS_PE_PRSID_GRP_MEM_PK, ensures data integrity for the core membership relationship. It is also likely referenced by various Student System forms, reports, and programmatic APIs that manage group membership operations.