Search Results next_to_kin




Overview
Explore in AI Chat

Overview

The view APPS.IGSBV_FAMILY_RELATIONSHIPS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data IGS.IGSBV_FAMILY_RELATIONSHIPS and reported as VALID in 12.1.1 and 12.2.2. It is part of the Oracle Student System (IGS) product family and exposes information about the family relationships that exist between two persons tracked in the institution's person registry. Each row represents a single relationship direction, binding a subject person to an object person through a coded relationship type.

Because it is a BIS view, it is intended primarily for reporting, analytics, and read-only integration rather than transactional data entry. The view denormalizes the relationship records so that consumers receive human-consumable identification numbers alongside coded relationship values, salutations, and status indicators. It is the natural reporting surface for enquiries such as "who has been nominated as next of kin," which is one of the columns explicitly exposed by the view.

Underlying Base Objects

The ETRM metadata for this object documents no referenced base objects, and no subobject name is supplied. In practice, a BIS view of this shape is defined over the core IGS relationship tables — principally IGS_RELATIONSHIPS (or its business-intelligence counterpart IGS_BV_RELATIONSHIPS) joined to the person/party identification tables — with the _LA:RELATIONSHIP_CODE column resolved against the relationship lookup. Since the documented metadata does not enumerate the base tables, implementers should not assume a fixed join path; the dependency list should be confirmed against the dictionary in the target instance before writing custom SQL against the base tables directly.

The leading IGSBV_ prefix identifies the object as a business-intelligence extension view, meaning its underlying SQL is generated and shipped as part of the IGS design data rather than being user-maintained.

Key Columns

  • SUBJECT_ID_NUMBER and OBJECT_ID_NUMBER — the unique identification numbers of the two persons in the relationship. The subject is the person whose record is being viewed; the object is the related person.
  • _LA:RELATIONSHIP_CODE — the relationship code, exposed through a lookup-aware (LOV/attribute) column reference. Values describe the nature of the link (for example spouse, parent, guardian).
  • RELATIONSHIP_START_DATE / RELATIONSHIP_END_DATE — the validity window of the relationship, supporting point-in-time reporting.
  • PRIMARY / SECONDARY — indicators classifying the relationship's priority for the subject person.
  • NEXT_TO_KIN — flags the related person as the subject's next of kin; this is the column most directly relevant to next-of-kin reporting and emergency-contact extracts.
  • JOINT_SALUTATION — a salutation string used during letter generation where both parties are addressed together.
  • REPORTED_FACULTY, REPORTED_STAFF, REPORTED_STUDENT, REPORTED_ALUMNI — the institutional affiliations reported for the related person, allowing a single query to identify whether a next of kin is also a member of the institution.
  • RELATIONSHIP_ID — the unique identifier of the relationship row.
  • DIRECTIONAL_FLAG — F for a forward relationship (parent-to-child) and B for a backward relationship, distinguishing the orientation of the link.
  • CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard WHO audit columns.

Common Use Cases and Queries

The predominant use case is next-of-kin and emergency-contact reporting, followed by relationship-graph extraction for student services, alumni relations, and letter generation.

Retrieve all next-of-kin nominations for a person:

  • SELECT subject_id_number, object_id_number, joint_salutation, relationship_start_date FROM apps.igsbv_family_relationships WHERE next_to_kin IS NOT NULL AND (relationship_end_date IS NULL OR relationship_end_date > SYSDATE);

Identify next of kin who are also students or staff at the institution:

  • SELECT subject_id_number, object_id_number, reported_student, reported_staff, reported_faculty, reported_alumni FROM apps.igsbv_family_relationships WHERE next_to_kin IS NOT NULL;

List all current forward relationships for a given subject, useful when reconstructing a family tree:

  • SELECT object_id_number, _LA:RELATIONSHIP_CODE, primary, secondary FROM apps.igsbv_family_relationships WHERE subject_id_number = :person_id AND directional_flag = 'F' AND (relationship_end_date IS NULL OR relationship_end_date > SYSDATE);

Because the object is a BIS view, queries should be restricted to reporting workloads and bound by subject or relationship identifiers to avoid full scans against large person populations.