Search Results igs_pe_persid_group_all




Overview
Explore in AI Chat

Overview

The table IGS_PE_PERSID_GROUP_ALL is a core entity within the Oracle E-Business Suite's now-obsolete Student System (IGS) module. Its primary function is to define and manage logical groupings of persons, typically students, for administrative and reporting purposes. These groups serve as reusable sets of individuals that can be referenced across various student-related processes, enabling batch operations and consolidated reporting without the need to repeatedly specify individual person IDs. The table is structured with multi-organization support, as indicated by the "_ALL" suffix, meaning it can store data partitioned by an operating unit identifier (ORG_ID).

Key Information Stored

While the provided metadata does not list all columns, the structure can be inferred from the primary and foreign keys. The central column is GROUP_ID, the unique primary key identifier for each person group. Another critical column is CREATOR_PERSON_ID, a foreign key to HZ_PARTIES, which links to the person who created the group. The table likely includes standard descriptive columns such as a group name, description, effective dates (START_DATE, END_DATE), and the ORG_ID for multi-org partitioning. It also contains standard EBS audit columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to track data changes.

Common Use Cases and Queries

This table is central to scenarios requiring the management of person cohorts. Common use cases include defining a group of students for a specific scholarship formula, creating a mailing list for a campus event, or identifying a set of applicants for a bulk admissions process. A typical query to retrieve active groups and their creators would be:

  • SELECT pg.GROUP_ID, pg.GROUP_NAME, hzp.PARTY_NAME AS CREATOR_NAME FROM IGS_PE_PERSID_GROUP_ALL pg, HZ_PARTIES hzp WHERE pg.CREATOR_PERSON_ID = hzp.PARTY_ID AND SYSDATE BETWEEN pg.START_DATE AND NVL(pg.END_DATE, SYSDATE+1);

To report on the members of a specific group, one would join to the IGS_PE_PRSID_GRP_MEM_ALL table, which stores the individual person assignments.

Related Objects

The table IGS_PE_PERSID_GROUP_ALL sits at the center of a relational network within the Student System. Its primary key (GROUP_ID) is referenced by numerous child tables, defining its key integrations. These include IGS_PE_PRSID_GRP_MEM_ALL (for group membership), IGS_PE_PRSID_GRP_SEC (for group security), and IGS_DA_RQST (for data audit requests). It is also referenced by setup tables for processes like IGS_EN_PIG_S_SETUP and IGS_EN_PIG_CP_SETUP, and by functional tables in the Awards module (IGF_AW_AWD_FRML_DET_ALL) and the Assessment module (IGS_AS_GPC_PE_ID_GRP). The link to HZ_PARTIES via CREATOR_PERSON_ID anchors it to the Trading Community Architecture.