Search Results igs_pe_prsid_grp_sec




Overview
Explore in AI Chat

Overview

The table IGS_PE_PRSID_GRP_SEC is a core data entity within the Oracle E-Business Suite Student System (IGS) modules, including versions 12.1.1 and 12.2.2. It functions as a junction or intersection table that explicitly links a person (party) to a specific person identification group for security authorization purposes. Its primary role is to manage and record security grants, defining which individuals are permitted access to or are associated with a particular identification group. This table is essential for enforcing data security and access control rules within the student information system, ensuring that person-to-group relationships are properly governed and auditable.

Key Information Stored

The table stores the fundamental pairing that constitutes a security grant. Its structure is defined by a concise composite primary key, which consists of two critical columns. The GROUP_ID column stores the unique identifier for a person identification group, as defined in the related master table. The PERSON_ID column stores the unique identifier for a person (party). Together, these columns create a unique record that signifies a specific person's security membership within a specific group. The existence of a record in this table is the definitive indicator of the granted security association.

Common Use Cases and Queries

This table is central to security validation and reporting processes. A common operational use case is verifying whether a given person has been granted access to a specific identification group, which may control visibility to certain student records or system functions. For reporting, administrators often need lists of all individuals authorized for a particular group. Sample SQL patterns include security checks and audit reports:

  • Security Validation: SELECT COUNT(*) FROM igs_pe_prsid_grp_sec WHERE person_id = :p_person_id AND group_id = :p_group_id;
  • Group Membership Report: SELECT p.party_name, g.group_name FROM igs_pe_prsid_grp_sec s, hz_parties p, igs_pe_persid_group_all g WHERE s.person_id = p.party_id AND s.group_id = g.group_id AND g.group_id = :p_group_id;

Related Objects

The IGS_PE_PRSID_GRP_SEC table maintains defined foreign key relationships with two primary tables, forming the backbone of its data integrity. The IGS_PE_PERSID_GROUP_ALL table is the master source for person identification groups. The foreign key on the GROUP_ID column ensures every security grant references a valid, existing group. The HZ_PARTIES table is the Trading Community Architecture (TCA) repository for all persons and organizations. The foreign key on the PERSON_ID column ensures every security grant is assigned to a valid party. These relationships are critical for any join operation to retrieve descriptive group or person information, as illustrated in the sample queries above.