Search Results igs_rc_is_race

Overview

The table IGS_RC_IS_RACE is a data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function is to store and manage race or ethnicity information specifically for an inquirer within the student lifecycle. An inquirer typically represents a prospective student or contact who has expressed interest in the institution but has not yet formally applied or been admitted. This table plays a critical role in supporting diversity reporting, demographic analysis, and compliance tracking for the inquiry pool. It is part of the broader recruitment and admissions data model, enabling institutions to segment and understand their prospective student population.

Key Information Stored

Based on the provided ETRM metadata, the table's structure centers on a unique identifier and a link to the inquirer's core personal record. The primary key column, INQ_RACE_ID, is a system-generated unique identifier for each race record associated with an inquirer. The foreign key column, PERSON_ID, is the critical link that associates the race data with a specific individual stored in the IGS_RC_IS_PER_ALL table. While the explicit race code or description column is not listed in the provided excerpt, the table's purpose implies it would contain at least one such attribute to categorize the race or ethnicity (e.g., RACE_CD), alongside standard WHO columns (CREATED_BY, CREATION_DATE, etc.). The metadata note "Not implemented in this database" suggests this table may be part of a reference or template data model not active in all deployments.

Common Use Cases and Queries

This table supports operational and analytical processes related to prospective student demographics. A common use case is generating diversity reports on the inquiry population to measure outreach effectiveness. Administrators may query this table to list all race designations for a specific inquirer or to count inquiries by racial category for trend analysis. A typical SQL pattern involves joining to the person table to retrieve names and other details.

• Sample Query (Pattern): SELECT per.inquiry_number, race.race_cd FROM igs_rc_is_race race, igs_rc_is_per_all per WHERE race.person_id = per.person_id;
• Reporting Use Case: Analyzing the demographic composition of inquiries generated from a specific marketing campaign to assess its reach across diverse communities.

Related Objects

The table IGS_RC_IS_RACE has a defined dependency on the central inquirer person table, as documented in the ETRM relationship data.

• IGS_RC_IS_PER_ALL: This is the primary related table. The column IGS_RC_IS_RACE.PERSON_ID is a foreign key that references the corresponding person record in IGS_RC_IS_PER_ALL. This relationship is essential for retrieving the inquirer's identifying information (name, contact details) alongside their stored race data. Any query or report will typically join these two tables via the PERSON_ID column.