Search Results igs_ad_deplvl_prgty




Overview
Explore in AI Chat

Overview

The table IGS_AD_DEPLVL_PRGTY is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as a configuration and transactional table that defines and manages deposit requirements for admission applications. Its primary role is to establish a relationship between an admission application type and a program type, linking the specific deposit level or financial obligation that an applicant must fulfill. This table is essential for automating and enforcing the financial prerequisites of the application process, ensuring that deposit rules are consistently applied based on the type of program and application.

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the uniqueness of each record. The key columns are ADMISSION_APPLICATION_TYPE and PROGRAM_TYPE. While the provided metadata does not list all specific data columns, the table's description and relationships indicate it stores details related to the deposit level for a given combination of application and program type. This likely includes columns for deposit amounts, currency, due dates, waiver conditions, and status indicators. The primary key ensures that for any specific admission application type and program type, there is a single, definitive deposit rule.

Common Use Cases and Queries

This table is central to processes that calculate, display, and track application deposits. Common use cases include dynamically determining the required deposit amount during the online application entry, generating financial reports for the admissions office on expected revenue from deposits, and validating that an applicant has met all financial conditions before their application can progress. A typical query would join this table with application data to retrieve the deposit rule for a specific applicant.

  • Retrieve Deposit Rules for an Application Type: SELECT * FROM igs.igs_ad_deplvl_prgty WHERE admission_application_type = '&APPL_TYPE';
  • Validate Deposit for a Specific Applicant: Queries would join IGS_AD_DEPLVL_PRGTY with applicant tables (e.g., IGS_AD_APPL) via the PROGRAM_TYPE and ADMISSION_APPLICATION_TYPE to fetch the applicable deposit amount for comparison against payments received.

Related Objects

IGS_AD_DEPLVL_PRGTY is not a standalone entity; it is integral to the Student System's data model through defined foreign key relationships. These relationships enforce referential integrity and are critical for accurate joins in reports and application logic.

  • IGS_AD_SS_APPL_TYP: The ADMISSION_APPLICATION_TYPE column in IGS_AD_DEPLVL_PRGTY references this table, which defines valid admission application types (e.g., Undergraduate, Graduate, Transfer).
  • IGS_PS_TYPE_ALL: The PROGRAM_TYPE column in IGS_AD_DEPLVL_PRGTY references this table, which contains the definitions of all academic program types (e.g., B.Sc., M.A., Certificate).

These relationships ensure that deposit levels are only defined for valid, existing application and program types within the system.