Search Results igs_pe_data_groups_u1

Overview

The IGS_PE_DATA_GROUPS_ALL table is a core repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Higher Education) product family. It functions as the master definition table for person data groups. These groups are logical classifications used to organize and manage different categories of information related to persons (e.g., students, staff, alumni) within the system. Its primary role is to provide a centralized, multi-organization (multi-org) enabled control structure for segmenting person-related data, which is critical for data privacy, security, and targeted processing in a complex higher education environment.

Key Information Stored

The table stores the metadata that defines each data group. The key columns include DATA_GROUP_ID, serving as the unique primary key identifier. The DATA_GROUP column holds the name or code for the group, while DESCRIPTION provides detailed context on the specific person data included. The LVL and LVL_DESCRIPTION columns manage privacy levels associated with private data groups. The CLOSED_IND flag is a critical control column indicating whether a data group is active ('N') or inactive/closed ('Y'). Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) audit all changes. Crucially, the ORG_ID column enables the multi-org architecture, allowing definitions to be specific to an operating unit or shared globally when NULL.

Common Use Cases and Queries

This table is central to configuration and operational reporting. Common use cases include auditing active data group configurations, integrating person data with external systems by mapping group codes, and supporting data governance initiatives. A typical query to retrieve all active data groups for a specific operating unit (e.g., ORG_ID=101) would be:

• SELECT DATA_GROUP, DESCRIPTION, LVL_DESCRIPTION FROM IGS.IGS_PE_DATA_GROUPS_ALL WHERE CLOSED_IND = 'N' AND (ORG_ID = 101 OR ORG_ID IS NULL) ORDER BY DATA_GROUP;

For technical analysis, joining the group name to its unique identifier is fundamental: SELECT DATA_GROUP_ID FROM IGS.IGS_PE_DATA_GROUPS_ALL WHERE DATA_GROUP = 'STUDENT_FINANCIAL';. Reporting on creation and modification patterns is also common for change management.

Related Objects

Based on the provided dependency information, the IGS_PE_DATA_GROUPS_ALL table is referenced by the APPS synonym of the same name (APPS.IGS_PE_DATA_GROUPS_ALL). This synonym is the standard access point for all application code and queries within EBS, abstracting the underlying IGS schema. While the provided metadata does not list foreign key relationships from other tables, the presence of a unique index (IGS_PE_DATA_GROUPS_U1) on DATA_GROUP_ID strongly implies it is referenced as a parent key in other IGS person-related tables (not listed in this excerpt) that store the actual grouped data, forming the backbone of the person data architecture.