Search Results igs_uc_cond_details

Overview

The IGS_UC_COND_DETAILS table is a core data object within the Oracle E-Business Suite's Student System (IGS), specifically within the now-obsolete offer management functionality. It functioned as the detail table in the offer library, designed to store the individual conditions that collectively constitute a formal offer made to a prospective student. Its primary role was to provide a structured repository for the specific academic, financial, or administrative stipulations a student must meet to gain or retain admission, enabling systematic tracking and evaluation of offer compliance. The provided metadata explicitly states this table was "Not implemented in this database," indicating it may have been part of a data model that was not fully deployed in standard installations of EBS 12.1.1 or 12.2.2.

Key Information Stored

The table's structure organizes condition data to support the offer lifecycle. The primary key is a composite of CONDITION_CATEGORY, CONDITION_NAME, and CONDITION_LINE, which allows for multiple line items (CONDITION_LINE) under a single named condition within a specific category. While the full column list is not provided in the excerpt, the foreign key relationships imply the storage of critical reference identifiers. The column ABBREVIATION links to the IGS_UC_REF_OFF_ABRV table, likely storing a short code for the associated offer or condition type. The composite foreign key to IGS_UC_OFFER_CONDS (CONDITION_CATEGORY, CONDITION_NAME) establishes the master-detail relationship, connecting the detailed line items to their parent condition definition.

Common Use Cases and Queries

In a live implementation, this table would be central to generating and managing conditional offers. Common operational use cases would include assembling the complete list of conditions for a specific offer template, reviewing condition details for compliance checking, and reporting on the frequency of different condition types. A typical query would join to the master condition table to retrieve a full description. For example:

• SELECT cd.*, oc.description FROM igs_uc_cond_details cd JOIN igs_uc_offer_conds oc ON cd.condition_category = oc.condition_category AND cd.condition_name = oc.condition_name WHERE cd.abbreviation = :offer_code;

Given its "Not implemented" status, direct transactional use in standard EBS is unlikely; however, the data model serves as a reference for custom extensions in student admissions.

Related Objects

The IGS_UC_COND_DETAILS table has documented foreign key relationships with two other tables in the obsolete Student System module, forming a key part of the offer data model.

• IGS_UC_REF_OFF_ABRV: Related via the ABBREVIATION column in IGS_UC_COND_DETAILS. This table likely stores reference codes and abbreviations for offers.
• IGS_UC_OFFER_CONDS: Related via a composite foreign key consisting of the CONDITION_CATEGORY and CONDITION_NAME columns. This is the master table for offer conditions, with IGS_UC_COND_DETAILS holding the line-level details for each condition.