Search Results igs_pe_gov_abrgrescd




Overview
Explore in AI Chat

Overview

The table IGS_PE_GOV_ABRGRESCD is a reference code table within the Oracle E-Business Suite's now-obsolete Student System (IGS). Its core function is to provide a standardized set of valid values for a specific demographic data point required by the Australian Department of Education, Employment and Training (DEET). This table stores the permissible responses to a government-mandated question regarding an individual's status as being of Aboriginal or Torres Strait Islander descent. It serves as a critical component for ensuring data integrity and compliance in student records, acting as the source of truth for this code set and enabling consistent reporting to governmental bodies.

Key Information Stored

The table's primary purpose is to store a concise set of code-value pairs. The central column is GOVT_ABORIG_TORRES_CD, which holds the primary key code values. Based on the provided description, the typical data stored in this column and its associated meaning column would include values such as '1' (representing "Aboriginal or Torres Strait Islander descent"), '2' (representing "Not Aboriginal or Torres Strait Islander descent"), and '9' (representing "No information"). This structure allows other transactional tables in the student system to store only the concise code while the full descriptive meaning is maintained in this reference table.

Common Use Cases and Queries

The primary use case for this table is data validation and descriptive reporting. When entering or updating a person's demographic details in the EBS forms, the application would validate the entered code against this table. For reporting purposes, a join is essential to translate stored codes into human-readable descriptions for compliance reports, statistical analysis, or government submissions. A typical query would join this reference table to the main person data table to produce a readable list.

SELECT per.person_id,
       per.govt_aborig_torres_cd,
       cd.meaning AS descent_description
FROM igs_pe_person_demographics per,
     igs_pe_gov_abrgrescd cd
WHERE per.govt_aborig_torres_cd = cd.govt_aborig_torres_cd;

Related Objects

As documented in the provided metadata, IGS_PE_GOV_ABRGRESCD has a direct foreign key relationship with another table in the student system. The table IGS_PE_ABORG_TORESCD references IGS_PE_GOV_ABRGRESCD via the GOVT_ABORIG_TORRES_CD column. This indicates that IGS_PE_ABORG_TORESCD is likely a transactional or staging table that stores an individual's specific response to this demographic question, enforcing referential integrity by ensuring only valid codes from the IGS_PE_GOV_ABRGRESCD table can be used.

  • Foreign Key Relationship: IGS_PE_ABORG_TORESCD references IGS_PE_GOV_ABRGRESCD
  • Join Column: IGS_PE_ABORG_TORESCD.GOVT_ABORIG_TORRES_CD = IGS_PE_GOV_ABRGRESCD.GOVT_ABORIG_TORRES_CD