Search Results cond_id




Overview
Explore in AI Chat

Overview

The IGS_AD_SS_TERMS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions (IGS) module. It functions as the master repository for managing terms and conditions associated with different admission application types. Its primary role is to store the configurable text components that applicants must review and acknowledge during the online application process. The table enables institutions to define, sequence, and control the display of legal or procedural stipulations, ensuring compliance and informed consent is captured systematically within the student system.

Key Information Stored

The table's structure is designed to manage discrete terms and conditions components. The ADMISSION_APPLICATION_TYPE and COND_ID columns form a composite primary key, linking each term to a specific application type and providing a unique identifier. The COND_ID also dictates the display sequence on the applicant-facing page. Critical content columns include COND_DISP_NAME, which acts as a header or title for the term, and COND_DISP_TEXT, which holds the full text of the condition, up to 1000 characters. The INCLUDE_FLAG is a control column that determines whether a specific term is active and should be presented to applicants. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are present for auditability.

Common Use Cases and Queries

A primary use case is the administration and maintenance of application terms. Administrators can query all terms for a given application type to review or update content and display order. The INCLUDE_FLAG is frequently used in conditional logic to filter active terms for display. A typical reporting query retrieves all active terms for a specific application type, ordered for proper presentation:

  • SELECT cond_id, cond_disp_name, cond_disp_text FROM igs.igs_ad_ss_terms WHERE admission_application_type = 'UNDERGRADUATE' AND include_flag = 'Y' ORDER BY cond_id;

Another common operational query involves identifying when a specific term was last modified by joining the WHO columns to the FND_USER table to get the username of the modifier, which is essential for change tracking and audit reports.

Related Objects

Based on the provided relationship data, IGS_AD_SS_TERMS has defined relationships with other key EBS objects. Its primary key ensures data integrity for any dependent objects. A foreign key relationship exists where the ADMISSION_APPLICATION_TYPE column in this table references the IGS_AD_SS_APPL_TYP table. This links each term to a valid, defined application type within the system. The table is also referenced by an APPS synonym named IGS_AD_SS_TERMS, which is the standard access point for EBS applications and reports. This structure indicates that the table is a foundational source for terms and conditions data, consumed by the application's user interface and potentially by integration points.