Search Results igs_fi_waiver_pgms




Overview
Explore in AI Chat

Overview

The IGS_FI_WAIVER_PGMS table is a core data repository within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master definition table for all institutional fee waiver programs. A waiver program is a formalized rule set that defines the conditions under which a student's financial charges can be reduced or eliminated. This table stores the fundamental configuration of each program, linking it to specific academic calendars, target fee types, and related financial components. Its integrity is critical for the accurate automated processing of student financial aid and fee adjustments.

Key Information Stored

The table's structure centers on defining the waiver program's scope, rules, and financial impact. Key columns include the composite primary key (FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, WAIVER_NAME), which uniquely identifies a waiver program within a specific academic calendar instance. The TARGET_FEE_TYPE column, part of an alternate unique key, identifies the primary fee type to which the waiver applies. Other significant columns define the financial mechanics: RULE_FEE_TYPE for the fee type used in waiver calculation rules, ADJUSTMENT_FEE_TYPE for the fee type that posts the actual waiver amount, and CREDIT_TYPE_ID linking to the general ledger account for the transaction. Additional columns manage program attributes like the maximum waiver amount, start and end dates, and active status.

Common Use Cases and Queries

This table is central to financial operations and reporting. Common use cases include the setup and maintenance of waiver programs via the application's user interface, the batch processing of student waivers, and auditing waiver program utilization. Technicians and system administrators frequently query this table to troubleshoot configuration issues or generate master data reports. A typical diagnostic query might join to related fee type tables to validate setup:

  • SELECT wp.waiver_name, wp.target_fee_type, ft.target_fee_type_meaning, wp.start_date, wp.end_date FROM igs_fi_waiver_pgms wp, igs_fi_fee_type_all ft WHERE wp.target_fee_type = ft.fee_type AND wp.fee_cal_type = :cal_type AND wp.fee_ci_sequence_number = :seq_num;

Another common pattern involves listing all active waiver programs for a given term to verify availability for student assignment or to analyze coverage.

Related Objects

The IGS_FI_WAIVER_PGMS table exists within a tightly integrated schema. Its primary and foreign key relationships are essential for data integrity. Key documented relationships include:

  • Referenced Tables (Foreign Keys): The table validates its key references against master tables: IGS_CA_INST_ALL (for the calendar instance), IGS_FI_CR_TYPES_ALL (for the credit type), and IGS_FI_FEE_TYPE_ALL (for the ADJUSTMENT_FEE_TYPE, RULE_FEE_TYPE, and TARGET_FEE_TYPE).
  • Referencing Tables (Child Tables): This table is a parent to critical operational tables. IGS_FI_WAV_STD_PGMS stores which students are enrolled in which waiver programs, using the waiver program's key. IGS_FI_WAV_PR_PREQS defines prerequisite relationships between different waiver programs, referencing IGS_FI_WAIVER_PGMS twice—once for the superior (SUP_WAIVER_NAME) and once for the subordinate (SUB_WAIVER_NAME) program in the relationship.