Results for “declared_ethnicity”

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

Overview

IGS_PE_SS_PERSON_V is a reporting view in the Oracle E-Business Suite Student System (IGS) product family, historically associated with the People Enterprise (PE) schema. It is documented in ETRM metadata as part of the IGS – Student System module, which Oracle has classified as obsolete. The view presents a consolidated, person-centric record intended for downstream reporting and integration scenarios within student and person management functionality. It exposes a flattened combination of party, person profile, and student-specific person attributes.

The user search term declared_ethnicity maps directly to a column in this view. DECLARED_ETHNICITY is sourced from HZ_PERSON_PROFILES and represents an individual's self-declared ethnic classification. In Oracle EBS 12.1.1 and 12.2.2, this view is not implemented in the current database according to the ETRM documentation ("Not implemented in this database"), meaning it may exist only in legacy or upgraded environments where the IGS Student System was previously installed.

Underlying Base Objects

The view is defined over three base tables joined in a single SELECT statement:

• HZ_PARTIES (alias P) — the primary registry of parties in Oracle EBS. This is the driving table and supplies identifiers, name components, attributes, and audit columns.
• HZ_PERSON_PROFILES (alias PP) — holds person-specific profile data, including date of birth, gender, declared ethnicity, marital status, and date of death. The join is by PARTY_ID and is time-bounded using EFFECTIVE_START_DATE and EFFECTIVE_END_DATE (with NVL defaulting the end date to SYSDATE), ensuring only the currently effective profile row is returned.
• IGS_PE_HZ_PARTIES (alias PHP) — a Student System extension table providing student-relevant attributes such as birth city, birth country, and veteran status. It is joined with an outer join (marked by PHP.PARTY_ID(+)), so persons without a Student System record are still returned.

Because the ETRM metadata lists no formally documented base objects, the view text itself is the authoritative source for these relationships. The view effectively bridges core HZ party data with IGS student extensions.

Key Columns

• PERSON_ID / PERSON_NUMBER — party identifier and human-readable party number.
• PREFIX, FIRST_NAME, MIDDLE_NAME, LAST_NAME, SUFFIX, FULL_NAME — name components drawn from HZ_PARTIES and the assembled person name.
• BIRTH_DATE, GENDER, DATE_OF_DEATH — demographic attributes from the person profile.
• DECLARED_ETHNICITY — the self-declared ethnicity value central to the user's search; sourced from HZ_PERSON_PROFILES.
• MARITAL_STATUS, MARITAL_STATUS_EFFECTIVE_DATE — marital state and its effective date.
• BIRTH_CITY, BIRTH_COUNTRY, VETERAN — student-specific attributes from IGS_PE_HZ_PARTIES.
• STATUS, KNOWN_AS, OBJECT_VERSION_NUMBER — party status, preferred name, and optimistic locking version.
• ATTRIBUTE_CATEGORY through ATTRIBUTE24 — the DFF context and descriptive flexfield columns for flexible extensions.
• ROW_ID and standard audit columns — ROWID identifier plus CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

This view is typically used to report on person demographics and student profile information, including ethnicity, marital status, and personal identification. A representative query to retrieve declared ethnicity for a given person is:

SELECT PERSON_NUMBER, FULL_NAME, DECLARED_ETHNICITY FROM IGS_PE_SS_PERSON_V WHERE DECLARED_ETHNICITY IS NOT NULL;

Analytical reporting by ethnicity, gender, or veteran status can be accomplished by grouping on the exposed columns. Because the view applies a SYSDATE-bounded join to HZ_PERSON_PROFILES, queries always reflect the current effective profile record. Caution is warranted: the IGS Student System is obsolete, the view is not implemented in current databases per ETRM, and any usage should be validated against the specific environment. In 12.2.2 installations where the object is absent, equivalent data must be retrieved directly from HZ_PARTIES and HZ_PERSON_PROFILES.