Search Results igs_ad_os_sec_edu_qf

Overview

The IGS_AD_OS_SEC_EDU_QF table is a core reference table within the Oracle E-Business Suite Student System (IGS), versions 12.1.1 and 12.2.2. It functions as a master data repository for defining and storing distinct types of secondary education qualifications. This table is essential for standardizing the classification of academic credentials obtained at the secondary school level, which is a critical component of the admissions and student records management processes. Its primary role is to provide a validated list of qualification codes that can be consistently referenced across the application to ensure data integrity in student profiles and academic histories.

Key Information Stored

The table's structure is designed to catalog qualification types with associated contextual data. The primary and most critical column is OS_SCNDRY_EDU_QUALIFICATION, which serves as the unique identifier or code for a specific secondary education qualification. This column constitutes the table's primary key. A second key column is COUNTRY_CD, which stores the country code associated with the qualification. This foreign key links to the IGS_PE_COUNTRY_CD table, enabling the system to associate qualifications with their country of origin or recognition, which is vital for processing international student applications and credentials.

Common Use Cases and Queries

This table is predominantly used in scenarios involving applicant data entry, validation, and reporting. During the admissions process, users select from the predefined values in this table when entering an applicant's prior educational background. Common operational and reporting queries include retrieving the full list of qualifications for a specific country to populate a list of values (LOV), or joining with student data to generate reports on applicant demographics based on prior education. A typical SQL pattern involves joining with the IGS_AD_OS_SEC_EDU table to get detailed applicant records.

• SELECT qf.os_scndry_edu_qualification, cc.country_name FROM igs_ad_os_sec_edu_qf qf, igs_pe_country_cd cc WHERE qf.country_cd = cc.country_cd ORDER BY country_name;
• SELECT se.*, qf.* FROM igs_ad_os_sec_edu se, igs_ad_os_sec_edu_qf qf WHERE se.os_scndry_edu_qualification = qf.os_scndry_edu_qualification;

Related Objects

The IGS_AD_OS_SEC_EDU_QF table maintains defined relationships with other critical tables in the Student System schema, as documented in the ETRM metadata. It references one parent table and is referenced by one child table, forming a key part of the data model for overseas secondary education information.

• Parent Table (Referenced Foreign Key): The table references IGS_PE_COUNTRY_CD via the COUNTRY_CD column. This enforces that the country code assigned to a qualification must exist in the master country codes table.
• Child Table (Referencing Foreign Key): The table is referenced by IGS_AD_OS_SEC_EDU via its OS_SCNDRY_EDU_QUALIFICATION column. This relationship ensures that any secondary education record stored for a person (applicant or student) uses a valid, predefined qualification code from this master table.