Search Results igs_ad_deplvl_prgty_u1

Overview

The IGS_AD_DEPLVL_PRGTY table is a configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, owned by the IGS schema. Its full name, "Program Type Deposit Level Details For An Admission Application," indicates its core function: to define the relationship between an admission application type and a program type, particularly concerning deposit requirements. This table acts as a control mechanism, enabling institutions to specify which program types are valid or applicable for a given admission application type and to manage their operational status (e.g., open or closed for selection).

Key Information Stored

The table stores a concise set of columns that define the application-type-to-program-type relationship and its administrative state. The primary business columns are ADMISSION_APPLICATION_TYPE (VARCHAR2(30)) and PROGRAM_TYPE (VARCHAR2(10)), which together form the unique key for the table, as enforced by the IGS_AD_DEPLVL_PRGTY_U1 index. The CLOSED_IND (VARCHAR2(1)) flag controls whether this specific combination is active or inactive within the application process. Standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track the audit history for each record.

Common Use Cases and Queries

This table is central to enforcing business rules during the admission application setup and entry. A primary use case is validating user input: when an applicant or administrator selects a program type for a given application type, the system can check this table to ensure the combination is permitted and active (CLOSED_IND = 'N'). Common reporting and administrative queries include listing all valid program types for a specific application type or identifying all combinations that have been deactivated. A foundational query to extract all active mappings is:

• SELECT admission_application_type, program_type FROM igs.igs_ad_deplvl_prgty WHERE closed_ind = 'N' ORDER BY 1, 2;

For troubleshooting or audit purposes, administrators may query the full record, including WHO columns, for specific combinations to understand their configuration history.

Related Objects

Based on the provided dependency information, the IGS_AD_DEPLVL_PRGTY table is referenced by an object within the APPS schema named IGS_AD_DEPLVL_PRGTY. This is typically a public synonym, pointing to the IGS-owned table, which is a standard EBS architecture pattern to facilitate access for other modules and custom code. The metadata states the table does not reference other objects but is referenced, indicating it serves as a master or reference table. While explicit foreign key relationships are not listed in the excerpt, the ADMISSION_APPLICATION_TYPE and PROGRAM_TYPE columns are likely referenced by foreign keys in child transactional tables within the IGS schema that store actual application data, linking them to this configuration entity.