Search Results govt_aborig_torres_cd




Overview
Explore in AI Chat

Overview

The IGS_PE_GOV_ABRGRESCD table is a reference code table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (Campus Solutions) product under the IGS (iGrants) schema. It serves as the system of record for standardized codes related to Australian Aboriginal and Torres Strait Islander (ATSI) identification, as mandated by the Australian Department of Education, Employment and Training (DEET). Its primary role is to provide a controlled set of valid government codes—such as '1' for descent and '2' for no descent—which are then mapped to institution-specific internal codes. This table is critical for ensuring accurate and compliant reporting for government data collections, specifically for Element 316 of the Higher Education Student Data Collection.

Key Information Stored

The table stores the authoritative list of government-defined ATSI codes and their operational status. The key columns are:

  • GOVT_ABORIG_TORRES_CD (NUMBER, Primary Key): The numeric government code (e.g., 1, 2, 9) representing the student's identification status.
  • DESCRIPTION (VARCHAR2(60)): The textual explanation of the code, sourced from official DETYA documentation.
  • CLOSED_IND (VARCHAR2(1)): A critical control flag indicating whether the code is open for new mappings to institutional codes. A closed status prevents further mappings, preserving data integrity.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns tracking the record's creation and last update details.

Common Use Cases and Queries

This table is central to setup, validation, and reporting processes. Administrators use it to configure the mapping between government and institutional codes during system implementation. For ongoing operations, it validates data entry in student demographic forms. A typical query to review all active government codes for a data load or audit would be:

SELECT GOVT_ABORIG_TORRES_CD,
       DESCRIPTION,
       CLOSED_IND
FROM IGS.IGS_PE_GOV_ABRGRESCD
ORDER BY 1;

For reporting, this table is joined to student data to translate stored codes into meaningful descriptions for government submissions or internal analytics concerning Indigenous student enrollment and outcomes.

Related Objects

The IGS_PE_GOV_ABRGRESCD table is a parent reference table with a defined foreign key relationship. The primary related object is:

  • IGS_PE_ABORG_TORESCD: This table references IGS_PE_GOV_ABRGRESCD via the foreign key column GOVT_ABORIG_TORRES_CD. The IGS_PE_ABORG_TORESCD table typically stores the institution's internal ATSI codes and their mappings to the standard government codes defined in IGS_PE_GOV_ABRGRESCD. This relationship enforces referential integrity, ensuring that institutional mappings always point to a valid government code.