Results for “igs_pe_prsid_grp_mem_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PE_PRSID_GRP_MEM_ALL is a core table within the Oracle E-Business Suite Student System (IGS) product family. It describes the occurrence of a person within a person identification group, effectively functioning as the association table that links individual parties to the identity groups to which they belong. In Oracle EBS 12.1.1 and 12.2.2, the IGS schema supports higher-education institutions by maintaining person-centric records that span admissions, registration, and student administration. This table plays a supporting role in establishing person identity groupings that drive eligibility rules, cohort tracking, and institutional reporting.

Within a heuristic Data Vault classification mined from its foreign key structure, this object is best modeled as a link. It resolves a many-to-many relationship between persons and person identification groups, carrying no descriptive attributes that would qualify it as a satellite, and acting as a connective junction rather than a standalone business hub. Modeling it as a link preserves the natural relationship between the two referenced entities.

Key Information Stored

The table contains fourteen documented columns in the 12.1.1 physical schema. The most significant columns are:

• GROUP_ID — Identifies the person identification group to which the member belongs; part of the composite primary key.
• PERSON_ID — Identifies the person (party) who is a member of the group; part of the composite primary key.
• START_DATE — Effective start date of the person's membership in the group.
• END_DATE — Effective end date of the membership, supporting date-tracked history.
• ORG_ID — Operating unit or organization context for the record.
• CREATED_BY, CREATION_DATE — Standard audit columns recording record creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns for the most recent modification.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program and request tracking columns used by Oracle's standard Who columns framework.

The surrogate primary key is defined by the constraint IGS_PE_PRSID_GRP_MEM_PK, composed of GROUP_ID and PERSON_ID, which represents a composite key rather than a single surrogate. A unique index, IGS_PE_PRSID_GRP_MEM_U1, also covers GROUP_ID and PERSON_ID, reinforcing the business rule that a person may appear only once per group. This composite uniqueness distinguishes the business-key candidate from a purely technical identifier.

Common Use Cases and Queries

Institutional users typically rely on this table to enumerate members of a given identity group, validate group membership during admissions or registration processing, and produce cohort rosters. A representative query to list active members for a group is:

• SELECT person_id, start_date, end_date FROM igs.igs_pe_prsid_grp_mem_all WHERE group_id = :p_group_id AND (end_date IS NULL OR end_date >= SYSDATE);

A reverse lookup to find all groups to which a person belongs can be written as:

• SELECT group_id FROM igs.igs_pe_prsid_grp_mem_all WHERE person_id = :p_person_id;

Reporting scenarios include generating group membership counts, auditing date-effective membership changes, and joining to HZ_PARTIES to enrich person demographics. Because membership is date-tracked, historical reporting should always apply START_DATE and END_DATE predicates.

Related Objects

The table participates in two documented foreign key relationships and is referenced by surrounding IGS and Trading Community (HZ) objects:

• IGS_PE_PERSID_GROUP_ALL — Parent group definition; joined on GROUP_ID.
• HZ_PARTIES — Person/party master; joined on PERSON_ID.
• HZ_PERSON_PROFILES — Common dependent for person demographic enrichment via PERSON_ID.
• IGS_PE_PERSON_BASE_V — Person view depending on party and group context.
• IGS_PE_PRSID_GRP_MEM_PK / _U1 — Primary key and unique index constraints that enforce membership uniqueness.

These relationships make IGS_PE_PRSID_GRP_MEM_ALL a central junction for person identity grouping within the Student System, supporting both transactional processing and analytical reporting in Oracle EBS 12.1.1 and 12.2.2.