Search Results family_dtl_id




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 under the IGS (Oracle Student Management) product family. Its primary function is to store detailed relationship information about the family members associated with a person in the system, such as a student or staff member. As indicated by its "Obsolete" status in the documentation, this table represents a legacy data model component. However, it remains a critical repository for historical family linkage data, supporting functionalities related to demographic reporting, communication (e.g., joint salutations for correspondence), and institutional relationship tracking.

Key Information Stored

The table's columns capture both the relationship metadata and the institutional affiliations of family members. The primary identifier is the FAMILY_DTL_ID, a system-generated unique key. The MEMBER_ID serves as the foreign key linking to the person record of the family member. Key descriptive attributes include the PRIMARY and SECONDARY indicators, which define the member's role within the family context, and the JOINT_SALUTATION field, used for formal letter generation. A significant portion of the table is dedicated to institutional status flags (FACULTY, STAFF, ALUMNI, CURRENT_STUDENT), enabling the institution to understand the multifaceted relationships an individual's family may have with the organization. Standard WHO columns (CREATED_BY, CREATION_DATE, etc.) are present for audit purposes.

Common Use Cases and Queries

This table is central to queries that analyze familial connections within the institutional community. Common use cases include generating mailing lists for family communications, reporting on legacy family relationships for alumni offices, and supporting data validation during system migrations. A typical query to retrieve all family details for a specific person would join on the MEMBER_ID to the core person table. For example, to find all family members flagged as alumni for a set of primary persons:

  • SELECT fd.* FROM igs.igs_pe_family_dtls fd JOIN igs.igs_pe_person_base_v p ON fd.member_id = p.person_id WHERE fd.alumni = 'Y';

Another common pattern involves using the JOINT_SALUTATION field to personalize bulk correspondence sent to a primary person's household.

Related Objects

Based on the provided dependency information, the IGS_PE_FAMILY_DTLS table is referenced by objects within the APPS schema. The most critical relationship is implied by the MEMBER_ID column, which is a foreign key to a person table (commonly IGS_PE_PERSON or a related view) to resolve the identity of the family member. The non-unique index IGS_PE_FAMILY_DTLS_U2 on MEMBER_ID supports this join. While the ETRM excerpt states it does not reference other objects, it is a parent table for any downstream objects that require detailed family member information. Developers should note that its obsolete status suggests newer functionalities may utilize alternative tables or APIs, but existing custom reports and integrations may still depend on it.