Search Results igs_pe_aborg_torescd

Overview

The table IGS_PE_ABORG_TORESCD is a core reference data entity within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It serves as the master repository for user-defined codes that classify an individual's status regarding Aboriginal and Torres Strait Islander heritage. This table is fundamental to the system's demographic and statistical reporting capabilities, enabling institutions to accurately capture, track, and report on this critical data point in compliance with governmental and internal requirements. Its role is to provide a validated list of codes that can be assigned to person records, ensuring data consistency and integrity across the student information system.

Key Information Stored

The table's primary function is to store a discrete set of classification codes. The central column is ABORIG_TORRES_CD, which serves as the unique primary key for the table. This column holds the user-defined code values (e.g., 'ATSI', 'Non-ATSI', specific community codes). A significant relational column is GOVT_ABORIG_TORRES_CD, which is a foreign key linking to the IGS_PE_GOV_ABRGRESCD table. This relationship allows the institution's internal code to be mapped to an official government-standard code for external reporting purposes. While the provided metadata does not list descriptive columns like MEANING or DESCRIPTION, such columns are typical in EBS lookup tables to provide a human-readable explanation for each code value stored in ABORIG_TORRES_CD.

Common Use Cases and Queries

The primary use case is the maintenance of the code lookup list via the application's administrative forms, which populate this table. It is heavily utilized in person data entry and validation. For reporting, it is joined to person or statistics tables to generate demographic summaries. A common query pattern involves joining to the IGS_PE_STATISTICS table to count individuals by classification. For instance, a report showing the distribution of students across these codes would use a SQL pattern similar to:

• SELECT atc.ABORIG_TORRES_CD, atc.MEANING, COUNT(s.PERSON_ID) FROM IGS_PE_ABORG_TORESCD atc, IGS_PE_STATISTICS s WHERE atc.ABORIG_TORRES_CD = s.ABORIG_TORRES_CD GROUP BY atc.ABORIG_TORRES_CD, atc.MEANING;

Another critical use case is data transformation for government submissions, where a query joins IGS_PE_ABORG_TORESCD to IGS_PE_GOV_ABRGRESCD via the GOVT_ABORIG_TORRES_CD column to translate institutional codes to mandated reporting codes.

Related Objects

This table is a central node in the EBS data model for person classification. Its documented relationships are as follows:

• Primary Key: IGS_PE_ABORG_TORESCD_PK on column ABORIG_TORRES_CD.
• Foreign Key (Outgoing Reference): The column GOVT_ABORIG_TORRES_CD references the primary key of the table IGS_PE_GOV_ABRGRESCD. This links a user-defined code to its corresponding government-standard code.
• Foreign Key (Incoming Reference): The column ABORIG_TORRES_CD is referenced by the column ABORIG_TORRES_CD in the table IGS_PE_STATISTICS. This is the primary usage link, where the code is assigned to a person's statistical record.

Consequently, any data integration, upgrade, or reporting effort involving Aboriginal and Torres Strait Islander classification must account for this table and its relationships to ensure data continuity and accuracy.