Search Results condition_line




Overview
Explore in AI Chat

Overview

The IGS_UC_COND_DETAILS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (iGradestar) product family. It functions as the detail table in the offer library, designed to store the individual conditions that collectively constitute an academic or admissions offer. Its primary role is to maintain a granular, line-item breakdown of offer conditions, which may include academic prerequisites, subject requirements, or other stipulations. The table is essential for managing and tracking conditional offers within the student lifecycle modules.

Key Information Stored

The table's columns are organized to define and sequence offer conditions. The composite primary key, enforced by the unique index IGS_UC_COND_DETAILS_U1, consists of CONDITION_CATEGORY, CONDITION_NAME, and CONDITION_LINE. This structure allows a single offer (identified by category and name) to have multiple, ordered condition lines. Key data elements include the CONDITION_LINE, which sequences the conditions; ABBREVIATION for the offer code; and specific academic requirement fields like SUBJECT, GRADE_MARK, and POINTS. The CONDITION_TEXT column provides a free-text description. Standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit information for each record.

Common Use Cases and Queries

This table is central to operations involving the generation, review, and compliance tracking of conditional offers. A common use case is retrieving all conditions for a specific offer to display on an offer letter or within an applicant portal. Another critical scenario is during the admissions clearing process, where applicant achievements are evaluated against stored conditions to determine if an offer is met. Reporting on the frequency of certain conditions (e.g., specific subject requirements) also relies on this table.

A fundamental query pattern retrieves the ordered condition lines for a given offer:

  • SELECT CONDITION_LINE, SUBJECT, GRADE_MARK, CONDITION_TEXT FROM IGS.IGS_UC_COND_DETAILS WHERE CONDITION_CATEGORY = :1 AND CONDITION_NAME = :2 ORDER BY CONDITION_LINE;

For analytical reporting, a query might aggregate conditions by subject or abbreviation to identify common offer requirements across different programs.

Related Objects

Based on the provided dependency information, the IGS_UC_COND_DETAILS table is a referenced object within the APPS schema. This indicates it is accessed by application code, likely through public synonyms and standard EBS APIs, rather than via direct foreign key constraints documented in the ETRM excerpt. The table's role as a detail table suggests a logical relationship with a parent or header table that defines the offer (CONDITION_CATEGORY and CONDITION_NAME), though this specific parent object is not listed in the provided dependencies. Applications and other database objects within the IGS product suite reference this table to validate and process offer conditions.