Search Results igs_pe_race_pk

Overview

The IGS_PE_RACE table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Student System) product module. Its primary function is to store and manage race or ethnicity information associated with a person, typically a student or constituent within the educational institution. This table plays a critical role in supporting demographic reporting, diversity tracking, and compliance with regulatory requirements that mandate the collection of such data. It operates within the broader Person (PE) model of the Student System, linking individual demographic details to the central person record.

Key Information Stored

The table's structure is designed to associate a person with one or more race codes. Based on the provided metadata, the two critical columns forming the composite primary key (IGS_PE_RACE_PK) are PERSON_ID and RACE_CD. The PERSON_ID column is a foreign key that links the record to a specific individual in the HZ_PARTIES table, which is the foundational table for parties in Oracle Trading Community Architecture (TCA). The RACE_CD column stores the code representing a specific race or ethnicity classification. This design allows a single person to have multiple race records, supporting multi-racial identification. While the metadata excerpt does not list all columns, typical supporting columns in such tables might include creation date, created by, last update date, and last updated by for auditing purposes.

Common Use Cases and Queries

The primary use case is the retrieval of race demographics for reporting and analysis. Human Resources, Admissions, and Institutional Research offices frequently query this data for government compliance reports, diversity dashboards, and internal equity studies. A common query pattern involves joining IGS_PE_RACE to person and lookup tables to produce a readable report.

• Listing Race Information for a Specific Person: SELECT race_cd FROM igs.igs_pe_race WHERE person_id = <PERSON_ID_VALUE>;
• Reporting Student Demographics: A more complex query would join IGS_PE_RACE to HZ_PARTIES (for person names) and potentially IGS_PE_PERSON (for student-specific data) via the PERSON_ID, and to a lookup table for the race code description (e.g., IGS_LOOKUPS_VL where lookup_type = 'RACE').

Data is typically maintained through the Oracle EBS application forms for person management, not via direct SQL manipulation.

Related Objects

IGS_PE_RACE is centrally connected to the Oracle TCA model and other Student System entities. The documented foreign key relationship is fundamental.

• HZ_PARTIES: This is the primary related table. The foreign key (IGS_PE_RACE.PERSON_ID) ensures referential integrity to the master person record in TCA.
• IGS_PE_PERSON: While not explicitly listed in the metadata, this key Student System table, which also links to HZ_PARTIES, is often used in conjunction with IGS_PE_RACE to filter or report specifically on student persons.
• Race Code Lookup Table: The RACE_CD column's values are typically validated against a code lookup table, such as IGS_LOOKUPS_VL with a specific lookup type (e.g., 'RACE'), to provide descriptive meaning.