Search Results igs_ad_devlvl_prg_pk

Overview

The IGS_AD_DEPLVL_PRG table is a core data object within the Oracle E-Business Suite Student System (IGS) module, specifically supporting the admissions process. It functions as a configuration and transactional table that stores program-specific deposit level details for individual admission applications. Its primary role is to manage the financial deposit requirements associated with applying to a specific academic program, linking the admission application type to a particular program and its version. This table ensures that deposit rules are correctly applied and tracked at the most granular level of an applicant's intended course of study, forming a critical part of the application fee and financial obligation framework in Oracle EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies a deposit rule for a program within an application context. The key columns are ADMISSION_APPLICATION_TYPE, PROGRAM_CODE, and VERSION_NUMBER. While the provided metadata does not list all columns, the primary and foreign key relationships indicate the table holds at least these three identifiers. It is highly probable the table contains additional columns to specify the deposit amount, currency, due date logic, waiver conditions, and status. These attributes define the exact financial deposit required from an applicant for a given program under a specific application type (e.g., undergraduate, graduate, international).

Common Use Cases and Queries

This table is central to operations involving application fees and deposits. Common use cases include: configuring deposit amounts for new academic programs; determining the correct deposit during the online application process; generating reports on deposit requirements by program or application type; and supporting financial reconciliation for received deposits. A typical query would join this table to program and application type master tables to retrieve a complete view of deposit rules.

• Sample Query Pattern: Retrieving deposit rules for a specific program.
  SELECT d.*, p.title, a.description
FROM igs.igs_ad_deplvl_prg d,
igs.igs_ps_ver_all p,
igs.igs_ad_ss_appl_typ a
WHERE d.program_code = p.program_code
AND d.version_number = p.version_number
AND d.admission_application_type = a.admission_application_type
AND d.program_code = 'BSC-CS';

Related Objects

The IGS_AD_DEPLVL_PRG table maintains defined referential integrity with key master tables in the Student System, as documented in the ETRM metadata.

• IGS_PS_VER_ALL: The table references this Program Versions table via the PROGRAM_CODE and VERSION_NUMBER columns. This ensures deposit levels are defined only for valid, active program offerings.
• IGS_AD_SS_APPL_TYP: The table references this Admission Application Types table via the ADMISSION_APPLICATION_TYPE column. This links the deposit rule to a valid application category.
• The table itself is referenced by its primary key constraint, IGS_AD_DEVLVL_PRG_PK, which enforces uniqueness on the combination of the three key columns.