Search Results igs_ad_gov_bas_fr_ty_pk

Overview

The IGS_AD_GOV_BAS_FR_TY table is a core reference table within the Oracle E-Business Suite Student System (IGS). Its primary function is to define and maintain the valid codes for the government-reported basis for admission, specifically for the Australian Department of Education, Training and Youth Affairs (DETYA) context. This table acts as a master list or lookup, ensuring data integrity and standardization when recording how a student's admission to an educational program is classified for official government reporting purposes. Its existence is critical for compliance, enabling institutions to accurately map their internal admission processes to the standardized codes required by the governing body.

Key Information Stored

Based on the provided metadata, the table's structure centers on a code column that serves as the primary key. While the full column list is not detailed in the excerpt, the documented relationships confirm the presence and significance of the GOVT_BASIS_FOR_ADM_TYPE column. This column stores the unique DETYA admission basis code. It is highly probable the table also contains descriptive columns, such as a name or description for each code, and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing. The primary key constraint IGS_AD_GOV_BAS_FR_TY_PK is enforced on the GOVT_BASIS_FOR_ADM_TYPE column to guarantee uniqueness.

Common Use Cases and Queries

The primary use case is as a validation source for student admission records. When a user enters or updates a basis for admission on a student's application or offer that must be reported to DETYA, the system validates the entry against this table. It is also essential for generating compliant government submissions. Common queries involve listing all valid codes for setup or reporting purposes and joining to transactional data for validation reports.

• Listing all active DETYA basis for admission codes: SELECT govt_basis_for_adm_type, description FROM igs_ad_gov_bas_fr_ty ORDER BY 1;
• Validating codes used in student admissions against the master list: SELECT DISTINCT a.govt_basis_for_adm_type FROM igs_ad_basis_for_ad a WHERE NOT EXISTS (SELECT 'X' FROM igs_ad_gov_bas_fr_ty g WHERE g.govt_basis_for_adm_type = a.govt_basis_for_adm_type);

Related Objects

The table has a direct parent-child relationship with the transactional table IGS_AD_BASIS_FOR_AD, which stores the basis for admission details for specific admissions applications. The documented foreign key relationship is:

• Referencing Table: IGS_AD_BASIS_FOR_AD
• Foreign Key Column: IGS_AD_BASIS_FOR_AD.GOVT_BASIS_FOR_ADM_TYPE
• Joins to: IGS_AD_GOV_BAS_FR_TY.GOVT_BASIS_FOR_ADM_TYPE

This relationship ensures that any government basis for admission type recorded for a student in the IGS_AD_BASIS_FOR_AD table must have a corresponding valid entry in the IGS_AD_GOV_BAS_FR_TY lookup table, enforcing referential integrity for critical reporting data.