Search Results qualifying_type_code




Overview
Explore in AI Chat

Overview

The IGS_AD_APPQUAL_CODE table is a core transactional data store within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions module (IGS). It is designed to capture and persist detailed qualification information associated with individual admission applications. Its primary role is to store the qualification type and its corresponding value for each application instance, serving as a critical component for evaluating applicant eligibility and meeting specific program entry requirements. The table's structure supports both standardized codes and free-form text entries, accommodating diverse admission processes.

Key Information Stored

The table's columns are organized to uniquely identify an application and its associated qualifications. The primary key is a composite of five columns: PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, SEQUENCE_NUMBER, and QUALIFYING_TYPE_CODE. This ensures a unique record for each qualification type per application line. Key data columns include:

  • QUALIFYING_TYPE_CODE (VARCHAR2(30)): A mandatory code that categorizes the type of qualification being recorded (e.g., a specific exam, prior degree, or skill).
  • QUALIFYING_CODE_ID (NUMBER): A foreign key referencing a predefined, valid code from the IGS_AD_CODE_CLASSES table, providing a standardized value for the qualification type.
  • QUALIFYING_VALUE (VARCHAR2(80)): A free-text field allowing manual entry of a qualification detail, used when a predefined code is insufficient or for custom workflow inputs.
  • The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit purposes.

Common Use Cases and Queries

This table is central to reporting and validating applicant qualifications. A common use case is generating a report of all qualifications for applicants to a specific course. The following query pattern retrieves this information, joining to the main application instance table for context:

SELECT aapc.PERSON_ID, aapc.ADMISSION_APPL_NUMBER, aapc.NOMINATED_COURSE_CD, aapc.QUALIFYING_TYPE_CODE, aapc.QUALIFYING_CODE_ID, aapc.QUALIFYING_VALUE FROM IGS.IGS_AD_APPQUAL_CODE aapc WHERE aapc.NOMINATED_COURSE_CD = :course_code ORDER BY aapc.PERSON_ID, aapc.ADMISSION_APPL_NUMBER;

Another critical scenario is data validation, ensuring that mandatory qualification types have been provided. Administrators may query for applications missing a required QUALIFYING_TYPE_CODE or where the QUALIFYING_CODE_ID is null for a type that mandates a standardized value. The non-unique index on QUALIFYING_TYPE_CODE (IGS_AD_APPQUAL_CODE_N2) optimizes such queries.

Related Objects

The IGS_AD_APPQUAL_CODE table is part of a defined data model with specific foreign key relationships, ensuring referential integrity with core application data.

  • IGS_AD_PS_APPL_INST_ALL: The table references this application instance table via the PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, and SEQUENCE_NUMBER columns. This links each qualification record to a specific line on an applicant's submission.
  • IGS_AD_CODE_CLASSES: The QUALIFYING_CODE_ID column is a foreign key to this table, which holds the master list of valid, predefined codes for admission qualification classes.

As a transactional table, it is referenced by various application components (APPS) and forms within the Admissions module to display and manage applicant qualification data.