Search Results igs_pe_hz_rel




Overview
Explore in AI Chat

Overview

The IGS.IGS_PE_HZ_REL table is a core relationship table within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to record family details of a person, capturing the manner in which two parties—typically a student and a related individual—are connected, together with the flags and attributes that qualify that relationship. In EBS 12.1.1 and 12.2.2 the object is owned by the IGS schema and carries a VALID status in the ETRM data dictionary. Because the table stores only the association between persons and the descriptors of that association, it functions as a relationship or junction structure rather than as an independent master entity.

The heuristic Data Vault classification mined from the foreign-key structure is standalone. From a dimensional or Data Vault perspective, this suggests modeling IGS_PE_HZ_REL as a link (relationship) table whose grain is one row per directional relationship. Each row would then serve as an association between party hubs, with the several "REP_" columns acting as role or classification attributes on that link rather than as transactional facts. The absence of a documented upstream hub dependency reinforces that the table is self-contained and materialized directly from Student System processing.

Key Information Stored

The documented physical schema for 12.1.1 contains sixteen columns. The most significant are:

The surrogate primary key is IGS_PE_HZ_REL_PK, defined on the composite of RELATIONSHIP_ID and DIRECTIONAL_FLAG. That same unique index is the only documented business-key candidate, meaning no separate natural unique constraint is exposed in the ETRM metadata.

Common Use Cases and Queries

Typical reporting and integration scenarios include student emergency-contact listings, next-of-kin extracts for regulatory reporting, and alumni or faculty family rosters. A representative query returns the parties and their role flags for a given relationship identifier:

  • SELECT relationship_id, directional_flag, primary, secondary, next_to_kin, emergency_contact_flag FROM igs.igs_pe_hz_rel;
  • SELECT * FROM igs.igs_pe_hz_rel WHERE emergency_contact_flag = 'Y';
  • SELECT relationship_id, primary, secondary FROM igs.igs_pe_hz_rel WHERE rep_student = 'Y' AND rep_alumni = 'Y';

Because the table is standalone, extracts for downstream persons or party hubs should be joined on the PRIMARY and SECONDARY columns to the corresponding person identifiers. Analysts commonly filter on NEXT_TO_KIN or EMERGENCY_CONTACT_FLAG to produce contact directories, and on the REP_* flags to segment family members who are themselves affiliated with the institution.

Related Objects

As a standalone relationship structure, IGS_PE_HZ_REL is referenced or supplemented by the following objects in the Student System and Trading Community models:

  • HZ_PARTIES — the party master holding person records identified by the PRIMARY and SECONDARY columns.
  • HZ_RELATIONSHIPS — the standard Trading Community relationship entity that provides context for party-to-party links.
  • IGS_PE_HZ_PERSON / person tables in IGS — supply student, faculty, and alumni identity details for the REP_* role flags.
  • IGS_PE_HZ_REL_PK — the unique index enforcing uniqueness on (RELATIONSHIP_ID, DIRECTIONAL_FLAG).
  • Relationship APIs in IGS — the packaged procedures that insert and maintain family relationship rows consumed by this table.

Join these objects on the person identifier derived from the PRIMARY and SECONDARY columns to obtain complete party names and demographic attributes alongside the documented relationship flags.