Results for “sport_indicator”

50+ results




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

Overview

HZ_PERSON_INTEREST is a Receivables (AR) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. It stores information about a person's personal interests — for example sporting activities, hobbies, or extracurricular pursuits recorded against a party — and is a child of the Trading Community Architecture (TCA) party model. The table is owned by the AR schema and holds 25 documented columns in the ETRM 12.2.2 physical schema. Its status is VALID.

From a dimensional modeling perspective, the mined relationship structure suggests a hub-leaning classification. The table carries its own surrogate identifier and a foreign key to HZ_PARTIES, which is characteristic of a hub entity in a Data Vault style model; the descriptive attributes on the row (level of interest, participation, comments) behave like satellite attributes attached to that hub.

Key Information Stored

The primary key is HZ_PERSON_INTEREST_PK, defined on PERSON_INTEREST_ID, which is also the sole unique index documented (HZ_PERSON_INTEREST_U1). This surrogate key uniquely identifies each interest record and is the join anchor for dependent tables.

Common Use Cases and Queries

Typical scenarios include customer profiling, marketing segmentation, and enrichment of party records for higher-education or membership applications, where extracurricular interests feed admissions and alumni reporting. A common query pattern joins the interest table to HZ_PARTIES to retrieve interests for a named party:

  • SELECT pi.interest_name, pi.interest_type_code, pi.level_of_interest FROM hz_person_interest pi, hz_parties p WHERE pi.party_id = p.party_id AND p.party_name = :name;
  • Reporting by category: grouping records by INTEREST_TYPE_CODE and SUB_INTEREST_TYPE_CODE to profile a population.
  • Extract/reconciliation involving the IGS tables that reference this entity, joining on PERSON_INTEREST_ID or DUP_PERSON_INTEREST_ID.

Related Objects

  • HZ_PARTIES — parent party entity, joined on HZ_PERSON_INTEREST.PARTY_ID = HZ_PARTIES.PARTY_ID.
  • IGS_AD_HZ_EXTRACURR_ACT — references this table via PERSON_INTEREST_ID.
  • IGS_AD_EXCURR_INT_ALL — references this table via DUP_PERSON_INTEREST_ID.

The TCA public APIs that maintain party information are the supported means of creating and updating these records, with the table itself serving as the persistent store beneath them.