Search Results igs_pe_family_dtls




Overview
Explore in AI Chat

Overview

The IGS_PE_FAMILY_DTLS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Student System) product module. Its primary function is to store detailed family relationship information for individuals within the student system. However, as explicitly noted in the ETRM documentation, this table is marked as "Obsolete." This status indicates that while the table may still exist in the database schema for backward compatibility, its use in new development is discouraged, and it may have been superseded by other data models or tables within the application's architecture. Its role was to maintain a structured link between a person (member) and their family details.

Key Information Stored

The table's structure centers on two primary identifiers. The first is FAMILY_DTL_ID, which serves as the primary key for the table (IGS_PE_FAMILY_DTLS_PK). This column uniquely identifies each family detail record. The second critical column is MEMBER_ID, which is also defined as a unique key (IGS_PE_FAMILY_DTLS_UK). This column stores the identifier linking to a person or party record. As per the documented foreign key relationship, MEMBER_ID references the PARTY_ID column in the HZ_PARTIES table, which is the master table for all parties (people, organizations, groups) in Oracle Trading Community Architecture (TCA). This establishes that the "member" in this context is a standardized TCA entity.

Common Use Cases and Queries

Given its obsolete status, direct operational use or new reporting against this table is not recommended. Historical queries or data migration scripts might reference it. A typical pattern would involve joining to the core party table to retrieve family details for a specific person. For example, a query to audit existing data might resemble:

  • SELECT f.member_id, hz.party_name, f.family_dtl_id FROM igs.igs_pe_family_dtls f, hz_parties hz WHERE f.member_id = hz.party_id;

The primary use case today is for understanding legacy data relationships during system upgrades or when analyzing historical information that has not yet been migrated to a successor data structure. Developers and DBAs must consult current application documentation to identify the active replacement for this table's functionality.

Related Objects

The most significant related object is the HZ_PARTIES table, as defined by the foreign key constraint. This relationship anchors the family details to the universal party model. The primary key constraints (IGS_PE_FAMILY_DTLS_PK and IGS_PE_FAMILY_DTLS_UK) are also key dependencies. Other tables within the IGS module may have historically held foreign keys to FAMILY_DTL_ID or MEMBER_ID, but these are not listed in the provided metadata. Given the table's obsolete nature, it is likely that other application programming interfaces (APIs), views, or public synonyms may have been created to abstract access away from this underlying table, directing traffic to newer, supported data entities.