Search Results igs_ad_cat




Overview
Explore in AI Chat

Overview

The IGS_AD_CAT view is a critical data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It provides a filtered, multi-organization (Multi-Org) aware representation of the underlying IGS_AD_CAT_ALL table, which stores master data for admission categories. An admission category is a fundamental classification used throughout the student lifecycle to group and manage applicants and students based on the type of admission they are seeking, such as undergraduate, graduate, transfer, or non-degree. The view's primary role is to enforce data security at the operating unit level, ensuring users and processes only access admission category records relevant to their specific organizational context.

Key Information Stored

The view exposes a focused set of columns essential for managing admission category definitions. The key columns include ADMISSION_CAT, which is the unique code for the category, and its DESCRIPTION. The S_CITIZENSHIP_TYPE links the category to a citizenship classification, which can drive fee and regulatory reporting. The CLOSED_IND flag indicates whether the category is active for new use. Crucially, the ORG_ID column stores the operating unit identifier, enabling the Multi-Org partitioning of data. The view's WHERE clause dynamically filters records based on the ORG_ID value stored in the user's session context (USERENV('CLIENT_INFO')), comparing it to the record's ORG_ID. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are also included for tracking data changes.

Common Use Cases and Queries

This view is central to setup, transactional processing, and reporting. Common use cases include populating list of values (LOVs) in application forms for admissions, enrollment, and academic records, and serving as a validation source for applicant data entry. For reporting and data extraction, typical queries involve selecting active categories for a given operating unit or joining to applicant data. For example, to list all active admission categories for the current operating unit, a developer or report writer would use:

  • SELECT admission_cat, description FROM apps.igs_ad_cat WHERE closed_ind = 'N' ORDER BY admission_cat;

To analyze applicants by category, a common join pattern is:

  • SELECT ap.person_id, ap.admission_cat, cat.description FROM igs_ad_ps_appl_inst_all ap, igs_ad_cat cat WHERE ap.admission_cat = cat.admission_cat AND ap.org_id = cat.org_id;

Related Objects

The IGS_AD_CAT view is intrinsically linked to several core objects in the Student System. Its primary source is the base table IGS_AD_CAT_ALL, from which it selects and filters data. It is a key reference for numerous transactional and setup tables that store the ADMISSION_CAT code as a foreign key. These related objects likely include, but are not limited to, application headers (e.g., IGS_AD_PS_APPL_INST), applicant records, and possibly enrollment and program attempt tables. The view ensures that all downstream processes and integrations consuming admission category data adhere to the enforced Multi-Org security model.