Search Results igs_ad_fee_stat




Overview
Explore in AI Chat

Overview

The IGS_AD_FEE_STAT table is a core reference table within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for managing admissions processes. Its primary function is to define and maintain a mapping between user-defined admission fee statuses and the system-defined statuses that drive application workflow logic. This design allows institutions to customize the fee status descriptions presented to users and within reports while maintaining a consistent, controlled set of underlying system statuses for processing. The table acts as a critical lookup, ensuring data integrity for fee-related status tracking on admission applications and program-specific application instances.

Key Information Stored

As a reference table, IGS_AD_FEE_STAT is typically narrow in structure, centered on the status code and its mapping. The primary column is ADM_FEE_STATUS, which serves as the unique key (IGS_AD_FEE_STAT_PK) for each user-defined status value. While the provided metadata does not list all columns, a table of this nature commonly includes descriptive columns such as DESCRIPTION, along with columns to map to the corresponding system status (e.g., SYSTEM_STATUS). Standard EBS audit columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY are also invariably present to track changes.

Common Use Cases and Queries

This table is primarily used in two contexts: as a validation source for data entry and as a lookup for reporting. When users update the fee status on an application, the value is validated against this table. For reporting, it is joined to application tables to translate system codes into meaningful descriptions. A common query retrieves the mapping for all active statuses or joins to application data for analysis.

  • Sample Query for Status Mapping:
    SELECT adm_fee_status, description, system_status FROM igs.igs_ad_fee_stat WHERE enabled_flag = 'Y' ORDER BY adm_fee_status;
  • Reporting Join Pattern:
    SELECT appl.person_id, appl.adm_fee_status, stat.description FROM igs.igs_ad_appl_all appl, igs.igs_ad_fee_stat stat WHERE appl.adm_fee_status = stat.adm_fee_status;

Related Objects

The IGS_AD_FEE_STAT table is referenced by key admissions tables via foreign key constraints, as documented in the ETRM metadata. These relationships are fundamental to maintaining referential integrity for fee status data across the application lifecycle.

  • IGS_AD_APPL_ALL: The primary application table references IGS_AD_FEE_STAT through the column IGS_AD_APPL_ALL.ADM_FEE_STATUS. This links the current fee status of an admission application to the defined status catalog.
  • IGS_AD_PS_APPL_INST_ALL: This table, which holds program-specific application details, references IGS_AD_FEE_STAT for late fee status via the column IGS_AD_PS_APPL_INST_ALL.LATE_ADM_FEE_STATUS.

These documented foreign keys confirm the table's role as a central authority for admission fee status codes, ensuring consistency across the application's header and its program-level instructions.