Search Results igs_ad_cat_all




Overview
Explore in AI Chat

Overview

The IGS_AD_CAT_ALL table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It serves as the master repository for user-defined applicant categories, which are critical for segmenting and managing the admissions process. These categories are configured by an institution to identify distinct groups of applicants, such as domestic undergraduate, international graduate, or transfer students, each potentially associated with different processing rules, fee structures, and eligibility requirements. The table's role is to provide a centralized definition for these classifications, enabling the systematic application of business logic throughout the student lifecycle from initial application to enrollment. Its multi-org structure, indicated by the "_ALL" suffix, allows it to store data for multiple operating units, making it essential for enterprise-level implementations.

Key Information Stored

While the provided metadata does not list specific columns, the primary key and foreign key relationships define its critical data elements. The table's primary key is the ADMISSION_CAT column, which stores the unique code for each applicant category. This identifier is the central reference point used across the Student System. Based on standard EBS design patterns for "_ALL" tables, it also contains an ORG_ID column to partition data by operating unit. Other typical columns would include descriptive fields such as a name and description for the category, effective dates (START_DATE and END_DATE) to control its active period, and various control attributes that dictate processing behavior. The existence of numerous foreign key relationships confirms that this table holds the master definitions referenced by child tables governing processing types, fee mappings, and period associations.

Common Use Cases and Queries

This table is fundamental for admissions configuration and reporting. Common operational use cases include setting up admission periods for specific applicant categories, defining fee structures, and mapping categories to enrollment classes. Administrators query this table to maintain category definitions and generate lists for downstream processes. Sample SQL patterns often involve joining IGS_AD_CAT_ALL to its related child tables for analysis. For instance, to list all active applicant categories and their associated processing types, a query might join to IGS_AD_CAT_PS_TYPE. A basic report to audit all configured categories would filter by ORG_ID and effective dates.

  • Listing all active admission categories for a specific operating unit: SELECT admission_cat FROM igs_ad_cat_all WHERE org_id = :p_org_id AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE+1);
  • Finding categories linked to a specific program of study pattern: SELECT cat.admission_cat FROM igs_ad_cat_all cat, igs_ps_pat_of_study pat WHERE pat.admission_cat = cat.admission_cat AND pat.program_code = :p_program_code;

Related Objects

The IGS_AD_CAT_ALL table is a central hub in the Admissions data model, as evidenced by the extensive list of foreign key dependencies. Key related objects include:

These relationships demonstrate that the ADMISSION_CAT value drives configuration in processing, financial, academic, and enrollment subsystems, making IGS_AD_CAT_ALL a critical setup table.