Search Results sup_waiver_name

Overview

The IGS_FI_WAV_PR_PREQS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Financials module. It functions as a relationship table that defines prerequisite rules between waiver programs for a specific fee period. Its primary role is to enforce business logic where one waiver program (the subordinate) cannot be applied unless another waiver program (the superior or prerequisite) has already been granted. This ensures a controlled and sequential application of financial waivers, which is critical for accurate fee assessment and compliance in an educational institution.

Key Information Stored

The table stores the relationship definition and its context. The WAIVER_RELATION_ID is the system-generated primary key, uniquely identifying each prerequisite rule. The FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER columns define the specific academic fee period (calendar instance) to which the rule applies, ensuring prerequisites can be period-specific. The core relationship is defined by SUB_WAIVER_NAME (the dependent waiver program) and SUP_WAIVER_NAME (the prerequisite waiver program that must be satisfied). The OBJECT_VERSION_NUMBER column supports optimistic locking for data integrity in multi-user environments, while the standard WHO columns (CREATED_BY, CREATION_DATE, etc.) provide audit trails.

Common Use Cases and Queries

A primary use case is validating a student's eligibility for a waiver during a fee assessment run. The system queries this table to check if a requested waiver has unmet prerequisites. Another scenario is administrative reporting on waiver program dependencies. Common SQL queries include identifying all prerequisites for a given waiver in a specific period, or listing all waiver programs that depend on a particular prerequisite. The foundational query from the ETRM is:

SELECT WAIVER_RELATION_ID,
       FEE_CAL_TYPE,
       FEE_CI_SEQUENCE_NUMBER,
       SUP_WAIVER_NAME,
       SUB_WAIVER_NAME
FROM IGS.IGS_FI_WAV_PR_PREQS
WHERE FEE_CAL_TYPE = :p_cal_type
  AND FEE_CI_SEQUENCE_NUMBER = :p_sequence_num;

To find waivers blocked by a specific prerequisite, a query would join SUB_WAIVER_NAME to the main waiver programs table while filtering on SUP_WAIVER_NAME.

Related Objects

The table's integrity is maintained through defined relationships with other key Financials tables. Its primary key, WAIVER_RELATION_ID, is enforced by the unique IGS_FI_WAV_PR_PREQS_PK index. According to the provided relationship data, the table references the IGS_FI_WAIVER_PGMS table via the FEE_CAL_TYPE column (and implicitly through the SUP_WAIVER_NAME and SUB_WAIVER_NAME columns, which are foreign keys to the waiver program name in that table). This ensures that both the prerequisite and dependent waiver programs are valid, defined entities. The table is also referenced by an APPS synonym (IGS_FI_WAV_PR_PREQS), which is the standard access point for EBS application code.