Search Results igs_ad_prcs_cat_all




Overview
Explore in AI Chat

Overview

The IGS_AD_PRCS_CAT_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It functions as the master definition table for user-defined admission categories that are linked to specific admission process types. This table enables institutions to model and manage distinct admission workflows, such as those for undergraduate, graduate, or international applicants, by categorizing them under configurable processes. Its role is central to the admission lifecycle, serving as a key reference point that governs how applications are processed, evaluated, and progressed through the system.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships define its critical structural elements. The table's composite primary key consists of ADMISSION_CAT and S_ADMISSION_PROCESS_TYPE, which together uniquely identify each admission process category record. The ADMISSION_CAT column is a foreign key referencing IGS_AD_CAT_ALL, linking to the master list of admission categories. The S_ADMISSION_PROCESS_TYPE defines the type of process (e.g., standard, transfer). Another significant column is RATING_SCALE_ID, a foreign key to IGS_AD_RATING_SCALES, which associates a specific evaluation or scoring scale with this process category. Additional columns typically store descriptive data, system control flags (like closed indicator), and audit information such as creation date and last update details.

Common Use Cases and Queries

This table is primarily accessed for configuring admission processes and for reporting on applications by their process category. Common operational scenarios include setting up new admission cycles, defining evaluation criteria for different applicant types, and generating management reports on application volumes segmented by admission process. A typical query might join this table to the application master (IGS_AD_APPL_ALL) to analyze the distribution of applications. For example:

  • SELECT apc.admission_cat, apc.s_admission_process_type, COUNT(app.person_id) FROM igs_ad_prcs_cat_all apc, igs_ad_appl_all app WHERE apc.admission_cat = app.admission_cat AND apc.s_admission_process_type = app.s_admission_process_type GROUP BY apc.admission_cat, apc.s_admission_process_type;

Another common use is validating setup data by checking for process categories linked to a specific rating scale used for applicant scoring.

Related Objects

The IGS_AD_PRCS_CAT_ALL table maintains extensive relationships with other Student System tables, as documented in the foreign key metadata. It references two parent tables: IGS_AD_CAT_ALL via ADMISSION_CAT and IGS_AD_RATING_SCALES via RATING_SCALE_ID. Crucially, it is referenced as a parent table by numerous key transactional and setup entities, demonstrating its central role. These child tables include:

These relationships ensure data integrity and enforce business rules across the admission process configuration and execution modules.