Search Results igs_ad_qual_type_pk

Overview

The IGS_AD_QUAL_TYPE table is a core setup table within the Oracle E-Business Suite Student System (IGS) module. Its primary function is to define and manage the permissible qualification types that can be associated with specific admission categories and admission process types. This table acts as a validation and configuration entity, ensuring that during the student admissions process, only pre-defined and appropriate qualification types are linked to an applicant's record based on their chosen admission pathway. It is a fundamental component for enforcing business rules related to applicant eligibility and prerequisites within the admissions lifecycle.

Key Information Stored

The table stores a unique combination of three key identifiers that together form its primary key. The ADMISSION_CAT column holds the code for the admission category, which classifies the type of admission (e.g., undergraduate, graduate, transfer). The S_ADMISSION_PROCESS_TYPE column stores the lookup code for the specific process type within that category. The QUALIFYING_TYPE_CODE column contains the code for the type of qualification (e.g., high school diploma, bachelor's degree, professional certification) deemed valid for that specific admission context. This structure allows administrators to configure precisely which qualifications are acceptable for each distinct admission scenario.

Common Use Cases and Queries

A primary use case is the validation of an applicant's entered qualifications against the setup rules when they apply for a specific program. The system queries this table to confirm the applicant's qualification type is allowed. This setup is also critical for generating eligibility reports and audit trails. Common queries involve listing all valid qualification types for a given admission category and process, or checking if a specific qualification type is configured for an admission path.

• To retrieve all configured qualification types for the 'UG' admission category and 'FRESH' process type:
  SELECT qualifying_type_code FROM igs.igs_ad_qual_type WHERE admission_cat = 'UG' AND s_admission_process_type = 'FRESH';
• To validate a specific applicant's qualification against the setup:
  SELECT COUNT(*) FROM igs.igs_ad_qual_type WHERE admission_cat = :p_adm_cat AND s_admission_process_type = :p_proc_type AND qualifying_type_code = :p_qual_type;

Related Objects

The IGS_AD_QUAL_TYPE table has a direct foreign key relationship with the IGS_AD_PRCS_CAT_ALL table, which is a central table for admission process categories. The relationship is defined on the ADMISSION_CAT and S_ADMISSION_PROCESS_TYPE columns, ensuring that any qualification type configuration must reference a valid, existing admission process category. This enforces referential integrity and means that qualification type setup is dependent on the higher-level admission process definitions. The primary key constraint IGS_AD_QUAL_TYPE_PK ensures that the combination of admission category, process type, and qualification code remains unique within the system.