Search Results os_scndry_edu_qualification

Overview

The IGS_AD_OS_SEC_EDU_QF table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions (IGS) module. It serves as a master repository for defining and managing codes that represent types of overseas secondary education qualifications. Its primary role is to ensure data integrity and standardization when capturing the educational background of international applicants or students. By maintaining a controlled list of qualification codes, the system enables consistent reporting, validation, and processing of admissions records related to pre-tertiary education obtained outside the institution's home country.

Key Information Stored

The table stores the definitional attributes for each qualification code. The most critical column is OS_SCNDRY_EDU_QUALIFICATION, a mandatory 10-character code serving as the unique primary key. The DESCRIPTION column provides the full textual explanation of the qualification. A significant business rule is enforced via the COUNTRY_CD field, which optionally restricts the qualification to specific countries; if populated, it limits the list of valid countries when this qualification is used elsewhere in the system. The CLOSED_IND flag controls the lifecycle of the code, preventing its use in new records when set to 'Closed'. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing.

Common Use Cases and Queries

This table is central to operations involving international applicant data. Common use cases include the setup and maintenance of qualification codes via administrative forms, the validation of data entered on an applicant's secondary education records, and generating reports on the educational profiles of international cohorts. A typical query to retrieve all active qualifications for a specific country would be:

SELECT os_scndry_edu_qualification, description, country_cd
FROM igs.igs_ad_os_sec_edu_qf
WHERE (country_cd = '&country_code' OR country_cd IS NULL)
AND closed_ind = 'N'
ORDER BY description;

For integration or data migration scripts, the standard query provided in the ETRM documentation serves as the foundational extract:

SELECT os_scndry_edu_qualification,
       description,
       country_cd,
       closed_ind,
       created_by,
       creation_date,
       last_updated_by,
       last_update_date,
       last_update_login
FROM igs.igs_ad_os_sec_edu_qf;

Related Objects

The table maintains defined relationships with other key entities in the IGS schema, as documented in the Foreign Key metadata.

• Primary Key Reference: The table's primary key (OS_SCNDRY_EDU_QUALIFICATION) is referenced by the IGS_AD_OS_SEC_EDU table. This foreign key relationship ensures that any overseas secondary education record (IGS_AD_OS_SEC_EDU) must use a qualification code that is pre-defined and valid in this master table.
• Foreign Key Reference: The COUNTRY_CD column in this table references the IGS_PE_COUNTRY_CD table. This enforces referential integrity, ensuring that any country code specified for a qualification is a valid country within the system's global address model.

These relationships position IGS_AD_OS_SEC_EDU_QF as a critical lookup table between detailed applicant education records and the standardized lists of countries and qualification types.