Search Results igs_fi_fee_pay_schd_pk

Overview

The IGS_FI_FEE_PAY_SCHD table is a core data entity within the Oracle E-Business Suite Student System (IGS). It is specifically designed to manage special contract-based fee assessment rates. Its primary role is to define and store payment schedules associated with particular fee types and categories for a given academic calendar instance. This table enables the configuration of structured payment plans, allowing educational institutions to model complex, time-based fee obligations that deviate from standard assessments. The metadata indicates a note stating "Not implemented in this database," which may suggest the table is part of the application's data model but was not deployed in a specific reference instance, a scenario sometimes encountered in ETRM documentation.

Key Information Stored

The table's structure centers on identifying a specific fee context and its associated schedule. The primary key (FPS_UK) consists of columns that pinpoint the exact fee agreement: FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER define the academic calendar instance; FEE_TYPE and FEE_CAT specify the category of fee; and SCHEDULE_NUMBER uniquely identifies a payment schedule within that fee agreement. An alternative primary key (IGS_FI_FEE_PAY_SCHD_PK) is also documented, using S_RELATION_TYPE and SEQUENCE_NUMBER alongside the calendar instance fields, hinting at different relational contexts. Critical foreign key columns, such as DT_ALIAS and DAI_SEQUENCE_NUMBER, link to date aliases (IGS_CA_DA_INST), which are essential for determining the specific calendar dates when payments are due according to the schedule.

Common Use Cases and Queries

This table is central to generating student invoices and tracking payment plans for non-standard fee contracts. A common operational use case is to retrieve all active payment schedules for a specific fee type in an upcoming academic period for billing preparation. For reporting and troubleshooting, administrators may query the table to validate the setup of contract-based fees. A sample SQL pattern to list schedules for a given fee calendar would be:

• SELECT fee_type, fee_cat, schedule_number, dt_alias FROM igs_fi_fee_pay_schd WHERE fee_cal_type = :cal_type AND fee_ci_sequence_number = :seq_num ORDER BY fee_type, schedule_number;

Another critical use case involves joining with the date alias table (IGS_CA_DA_INST) to resolve schedule due dates into actual calendar dates for statement generation.

Related Objects

The IGS_FI_FEE_PAY_SCHD table maintains defined foreign key relationships with several foundational tables in the Student System, ensuring referential integrity for fee and calendar data. The documented relationships are:

• IGS_CA_DA_INST: Joined via columns DT_ALIAS and DAI_SEQUENCE_NUMBER. This relationship ties the payment schedule to specific calendar dates.
• IGS_FI_F_CAT_CA_INST: Joined via columns FEE_CAT, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER. This links the schedule to a valid fee category defined for a calendar instance.
• IGS_FI_F_TYP_CA_INST_ALL: Joined via columns FEE_TYPE, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER. This links the schedule to a valid fee type defined for a calendar instance.

These relationships position IGS_FI_FEE_PAY_SCHD as a dependent entity that draws its valid context from master data defining fee types, categories, and the academic calendar.