Search Results igr_is_race_pk

Overview

The IGR_IS_RACE table is a data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases. It belongs to the IGS (Student System) product family, which is documented as obsolete. The table's core function is to store race or ethnicity information specifically for an inquirer within the student system's inquiry management module. It serves as a child table, linking demographic details to a primary person record, thereby supporting compliance reporting and demographic analysis for prospective students or contacts.

Key Information Stored

Based on the provided ETRM metadata, the table's structure centers on a unique identifier and a foreign key relationship. The primary key column, INQ_RACE_ID, uniquely identifies each race record for an inquirer. The critical foreign key column is PERSON_ID, which establishes the link to the master inquirer person record stored in the IGR_IS_PER_ALL table. While specific race code or description columns are not detailed in the excerpt, the table's purpose indicates it would contain at least one column to categorize the race information, likely referencing a lookup value. The metadata note "Not implemented in this database" suggests this table may exist in the data dictionary but was not populated or activated in some implementations.

Common Use Cases and Queries

The primary use case for IGR_IS_RACE is to retrieve or report on the demographic composition of inquirers. This data is crucial for generating Equal Employment Opportunity (EEO) or other regulatory compliance reports related to prospective student populations. A typical query would join this table to the person master to compile a list. For example:

• SELECT per.person_number, race.race_code FROM igr_is_per_all per, igr_is_race race WHERE per.person_id = race.person_id;

In operational scenarios, processes would insert records into this table when capturing or updating an inquirer's demographic profile. However, given the obsolete status of the IGS module and the "not implemented" note, direct interaction with this table in active development or reporting is uncommon in later EBS lifecycles.

Related Objects

The ETRM documentation specifies a single, critical foreign key relationship for the IGR_IS_RACE table. This defines its dependency within the data model.

• IGR_IS_PER_ALL: This is the primary related table. The relationship is defined as IGR_IS_RACE.PERSON_ID referencing IGR_IS_PER_ALL. This join is essential for connecting the race information to the broader inquirer record, which contains core biographical and contact details. Any query or data integrity constraint relies on this parent-child link.