Search Results inq_race_id




Overview
Explore in AI Chat

Overview

The IGS.IGR_IS_RACE table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Research (IGS) product family. Its primary function is to store race and ethnicity information for an inquirer, which typically refers to a prospective student or contact within the admissions and recruitment modules. The table acts as a junction entity, linking a person (inquirer) to one or more standardized race codes, thereby enabling the institution to capture and report on demographic diversity within its applicant pool. Its storage in the APPS_TS_INTERFACE tablespace suggests its role in processing and staging data related to external interactions or data imports.

Key Information Stored

The table's structure is designed to track race information with full auditability. The most critical columns include:

Common Use Cases and Queries

This table is central to demographic reporting and compliance. A common operational use case is validating or listing the race information for a specific inquirer, often during application review or for generating diversity reports. The unique constraint on PERSON_ID and RACE_CD ensures an inquirer is not assigned the same race code multiple times. A typical query to retrieve all race information for a person would be:

SELECT race_cd, status, creation_date
FROM igs.igr_is_race
WHERE person_id = :p_person_id
ORDER BY inq_race_id;

For reporting on the distribution of races among inquirers, a summary query joining to the person table would be used. The STATUS column is frequently queried to identify records pending processing (e.g., STATUS = 'PENDING') or those that failed import during data loads from external systems.

Related Objects

The table maintains defined relationships with other EBS objects, primarily through foreign key constraints. The documented relationship is:

  • Foreign Key Reference: The PERSON_ID column in IGR_IS_RACE references a corresponding person identifier in the IGR_IS_PER_ALL table (or a similar person master). This enforces referential integrity, ensuring every race record is associated with a valid inquirer record.
  • Primary Key Reference: The table's primary key, IGR_IS_RACE_PK (on INQ_RACE_ID), is referenced by other objects within the IGS schema, as indicated by the dependency information. These are typically child tables or views that require a unique link to a specific race record.