Search Results igs_pe_data_groups_all




Overview
Explore in AI Chat

Overview

The table IGS_PE_DATA_GROUPS_ALL is a core data entity within the now-obsolete Oracle E-Business Suite Student System (IGS). It was designed to define and manage person data groups, which are logical classifications or categories used to organize and control access to person-related information within the student management module. Its primary role was to serve as a master reference table, enabling the segmentation of person data for administrative, security, or functional purposes. As indicated by the "_ALL" suffix, this table was architected to support a multi-organization structure (Multi-Org), storing records specific to different operating units. The ETRM explicitly notes this object is "Not implemented in this database," indicating it may exist in the data dictionary but is not actively used in standard deployments of versions 12.1.1 or 12.2.2, reflecting the module's obsolete status.

Key Information Stored

Based on the provided ETRM metadata, the central piece of information stored is the DATA_GROUP_ID, which serves as the unique primary key identifier for each person data group record. While specific descriptive column details are not listed in the excerpt, typical tables of this nature in EBS would also include columns to define the data group's name, description, and effective dates. Given its multi-org design, it would also contain an ORG_ID column to partition data by operating unit. The table's purpose is to establish a controlled list of valid data groups that can be referenced by other security and configuration entities within the IGS module.

Common Use Cases and Queries

The primary historical use case for this table was to support the configuration of data security and privacy levels. By categorizing person records into distinct groups, the system could enforce data access rules. A common administrative task would involve querying the master list of defined groups. A typical query pattern would be a simple SELECT statement to retrieve all active data groups for a specific operating unit, though the exact column names beyond the primary key are not specified in the provided documentation. Given the module's obsolete status, current use cases are largely confined to data analysis, migration projects, or supporting legacy customizations that may still reference this table structure.

SELECT DATA_GROUP_ID
  FROM IGS_PE_DATA_GROUPS_ALL
 WHERE ORG_ID = :p_org_id;

Related Objects

The documented foreign key relationship explicitly defines this table's interaction with the IGS security model. The relationship data confirms that IGS_PE_DATA_GROUPS_ALL is referenced as a parent table by IGS_PE_PRIV_LEVEL.

  • IGS_PE_PRIV_LEVEL: This table references IGS_PE_DATA_GROUPS_ALL via the foreign key column DATA_GROUP_ID, which joins to the primary key of the same name in IGS_PE_DATA_GROUPS_ALL. This relationship establishes which privacy levels are associated with specific person data groups, forming a link between data classification and security privileges.