Results for “admission_application_type”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_AD_SS_TERMS table belongs to the IGS (Student System) product family in Oracle E-Business Suite, where it is catalogued as "Application Type Terms and Conditions." In the ETRM 12.1.1 physical schema, the object is owned by the IGS schema and contains 10 documented columns. The metadata classifies IGS as obsolete, and the implementation note states "Not implemented in this database," indicating that the table is a legacy artifact in most 12.1.1 and 12.2.2 environments and is frequently absent from live data models. Where it exists, it stores the terms and conditions text that accompanies an admission application type, together with display and inclusion controls that govern how those conditions are presented to applicants.

Because terms and conditions are attributes that describe an application type rather than independent business entities, the metadata's heuristic Data Vault classification is satellite-leaning. In a Data Vault model this would suggest treating IGS_AD_SS_TERMS as a satellite attached to the IGS_AD_SS_APPL_TYP hub, with the descriptive terms, conditions, and flags carried as non-key attributes. This classification is a modeling suggestion derived from the foreign-key structure, not a statement about the physical EBS implementation.

Key Information Stored

The primary key IGS_AD_SS_TERMS_PK is a composite key defined on (ADMISSION_APPLICATION_TYPE, COND_ID), and the unique index IGS_AD_SS_TERMS_PK confirms this pair as the business-key candidate. The column ADMISSION_APPLICATION_TYPE is also the foreign key that references IGS_AD_SS_APPL_TYP, linking each terms record to its parent application type; COND_ID distinguishes the individual condition within that application type.

The principal descriptive columns are COND_DISP_NAME and COND_DISP_TEXT, which hold the display name and the full display text of the condition presented to the applicant. INCLUDE_FLAG is a control flag determining whether the condition is included when terms and conditions are rendered. The remaining documented columns are standard Oracle EBS audit and concurrency attributes: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. These audit columns should be expected on any maintained IGS table and are used for row-level lineage and last-touch reporting.

Common Use Cases and Queries

Typical usage centers on retrieving the terms and conditions associated with a given application type for display on admission applications, prospectus pages, or self-service forms. A representative query joins the terms table to its parent application type and filters on the inclusion flag:

  • SELECT t.ADMISSION_APPLICATION_TYPE, t.COND_ID, t.COND_DISP_NAME, t.COND_DISP_TEXT FROM IGS_AD_SS_TERMS t WHERE t.ADMISSION_APPLICATION_TYPE = :app_type AND t.INCLUDE_FLAG = 'Y' ORDER BY t.COND_ID;
  • Reporting on application types that carry no configured conditions, using an outer join from IGS_AD_SS_APPL_TYP to IGS_AD_SS_TERMS.
  • Audit and change-tracking queries filtered on LAST_UPDATE_DATE or LAST_UPDATED_BY to identify recently modified condition text.

Because the product is obsolete and the table is frequently not implemented, these patterns should always be preceded by a metadata check such as ALL_TAB_COLUMNS or FND_TABLES before being embedded in production code. On 12.1.1 versus 12.2.2, differences in the underlying IGS schema availability mean the object may exist in one release's schema and not the other.

Related Objects

The singular documented foreign-key relationship is to the application type definition. The most significant related objects are:

  • IGS_AD_SS_APPL_TYP — parent table referenced by IGS_AD_SS_TERMS.ADMISSION_APPLICATION_TYPE; the natural join partner for all condition lookups.
  • IGS_AD_SS_TERMS_PK — the composite unique index and primary key constraint on (ADMISSION_APPLICATION_TYPE, COND_ID).
  • IGS_AD_SS_APPL_TYP_PK — the corresponding primary key on the parent application type table, forming the referential chain.
  • Other IGS_AD_SS_* admission tables — sibling objects in the Student System admission area that share the application type as a common discriminator.
  • FND_TABLES / ALL_TAB_COLUMNS — dictionary views commonly used to verify existence before querying this obsolete object.

Together these objects define the admission application type and its associated terms and conditions, with IGS_AD_SS_TERMS acting as the satellite that carries the descriptive condition attributes.