Search Results govt_basis_for_adm_type

Overview

The IGS.IGS_AD_GOV_BAS_FR_TY table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, often under the IGS (iGrants) schema. It serves as the system of record for standardized government-defined admission criteria codes. Its primary role is to maintain the valid list of basis for admission types, such as "Completed Secondary Education" or "Employment Experience," as mandated by the Australian government's Department of Education, Training and Youth Affairs (DETYA), specifically for element 327. This table ensures data integrity and compliance in student admissions reporting by providing a controlled set of values for downstream transactional data entry.

Key Information Stored

The table stores the code, description, and status for each government admission basis type. The key columns are:

• GOVT_BASIS_FOR_ADM_TYPE (VARCHAR2): The primary key. A unique code (e.g., '11', '14', '19') representing the main admission criterion as defined by DETYA.
• DESCRIPTION (VARCHAR2(60)): The explanatory text for the corresponding code, providing context for users and reports.
• CLOSED_IND (VARCHAR2(1)): A flag indicating whether the code is active ('N') or closed ('Y'). A closed status prevents its selection in new admission records, supporting data governance.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns that track the user and timestamp for record creation and modifications, as per Oracle EBS conventions.

Common Use Cases and Queries

This table is primarily used for data validation, setup, and regulatory reporting. Administrators maintain the code values via the application's front-end forms, which write to this table. Common technical operations include querying active codes for validation lists and joining to transactional data for extracts. A fundamental query to retrieve all active basis types for a lookup list is:

SELECT govt_basis_for_adm_type, description
FROM igs.igs_ad_gov_bas_fr_ty
WHERE closed_ind = 'N'
ORDER BY govt_basis_for_adm_type;

For compliance reporting, a typical join to the related transactional table would be:
SELECT b.application_number, t.description AS govt_basis
FROM igs.igs_ad_basis_for_ad b,
igs.igs_ad_gov_bas_fr_ty t
WHERE b.govt_basis_for_adm_type = t.govt_basis_for_adm_type
AND b.person_id = :p_id;

Related Objects

The IGS_AD_GOV_BAS_FR_TY table functions as a parent lookup table in the data model. Its primary key is enforced by the index IGS_AD_GOV_BAS_FR_TY_U1. The documented foreign key relationship is:

• Child Table: IGS.IGS_AD_BASIS_FOR_AD
  Foreign Key Column: GOVT_BASIS_FOR_ADM_TYPE
  Relationship: This foreign key constraint ensures that every basis for admission recorded for an applicant in the IGS_AD_BASIS_FOR_AD table must reference a valid, pre-defined code in the IGS_AD_GOV_BAS_FR_TY table. This enforces referential integrity for critical government reporting data.