Search Results spcl_consideration_cat




Overview
Explore in AI Chat

Overview

The IGS_AS_SPCL_CONS_CAT table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, owned by the IGS schema. It serves as a master repository for defining and managing the categories under which students can apply for special consideration regarding their assessments. A special consideration application is typically submitted when a student's performance is adversely affected by extenuating circumstances. This table standardizes the classification of these applications, enabling consistent processing, reporting, and policy enforcement across the institution. Its role is foundational to the special consideration workflow, as it provides the valid list of categories that can be linked to individual student applications.

Key Information Stored

The table stores the definitional attributes for each special consideration category. The primary and most critical column is SPCL_CONSIDERATION_CAT, a 10-character code serving as the unique identifier (primary key) for the category. The DESCRIPTION column provides a concise 60-character label, while the EXPLANATION column allows for a detailed 2000-character narrative that can be used in official reports or communications. The operational status of a category is controlled by the CLOSED_IND flag; when set, the category is prevented from being used for new applications, supporting data integrity and phased policy changes. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing purposes.

Common Use Cases and Queries

A primary use case is the maintenance of the category code lookup via an administration form, where authorized users can add new categories or close obsolete ones. For reporting, the table is frequently joined to application data to analyze the volume and types of special consideration requests. Common SQL patterns include querying all active categories for a dropdown list in an application form or generating a summary report.

  • Retrieve all active categories:
    SELECT SPCL_CONSIDERATION_CAT, DESCRIPTION FROM IGS.IGS_AS_SPCL_CONS_CAT WHERE CLOSED_IND = 'N' ORDER BY 1;
  • Find categories containing specific text in their explanation:
    SELECT SPCL_CONSIDERATION_CAT, DESCRIPTION, EXPLANATION FROM IGS.IGS_AS_SPCL_CONS_CAT WHERE UPPER(EXPLANATION) LIKE '%MEDICAL%';
  • Standard query for data extraction or interface programs:
    SELECT SPCL_CONSIDERATION_CAT, DESCRIPTION, EXPLANATION, CLOSED_IND, CREATION_DATE, LAST_UPDATE_DATE FROM IGS.IGS_AS_SPCL_CONS_CAT;

Related Objects

The IGS_AS_SPCL_CONS_CAT table has a direct parent-child relationship with the special consideration application table. It is referenced as a foreign key to ensure data integrity, meaning an application cannot be submitted with an invalid category code.

  • Primary Key: IGS_AS_SPCL_CONS_CAT_PK on column SPCL_CONSIDERATION_CAT.
  • Foreign Key Reference: The table IGS_AS_SPL_CONS_APPL (Special Consideration Application) contains a column named SPCL_CONSIDERATION_CAT. This column references IGS_AS_SPCL_CONS_CAT.SPCL_CONSIDERATION_CAT, enforcing that every application must belong to a predefined, valid category.