Search Results igs_fi_fee_as_rt




Overview
Explore in AI Chat

Overview

The IGS_FI_FEE_AS_RT table is a core data entity within the Oracle E-Business Suite Student System (IGS). Its primary function is to manage student-specific fee assessment rate overrides. It stores contract-based fee rates that are explicitly defined for an individual student and a specific fee type. These stored rates supersede the standard fee liability assessment rates that would otherwise be applied based on the broader fee category. This table is essential for implementing bespoke financial agreements, scholarships, or special billing arrangements within the institution's student financial management framework.

Key Information Stored

The table's structure is designed to uniquely identify a student's program and the applicable fee type for a defined period. Its primary key consists of PERSON_ID, COURSE_CD, FEE_TYPE, and START_DT, ensuring a unique rate record per student, program, fee, and effective date. Important columns include PERSON_ID (the student identifier), COURSE_CD (the academic program code), FEE_TYPE (the specific fee code being overridden), and START_DT (the effective date of the rate). Additional key attributes, often used to further refine the rate's applicability, include ATTENDANCE_MODE, ATTENDANCE_TYPE, and LOCATION_CD, which are linked to their respective master tables via foreign key constraints.

Common Use Cases and Queries

This table is central to scenarios requiring individualized fee calculations. Common use cases include applying special scholarship rates, honoring legacy tuition rates for continuing students, or enforcing contract-specific fees for sponsored students. A typical reporting query would join this table with student and fee master tables to list all active custom fee rates. For example:

  • Identifying all override rates for a specific student: SELECT * FROM igs_fi_fee_as_rt WHERE person_id = :student_id AND sysdate BETWEEN start_dt AND NVL(end_dt, sysdate);
  • Determining the applicable custom rate for fee assessment: Queries often filter by PERSON_ID, COURSE_CD, FEE_TYPE, and the current date to find the valid overriding rate during batch assessment processes.
  • Auditing rate changes: Tracking history through START_DT (and implied END_DT) for a given student and fee combination.

Related Objects

IGS_FI_FEE_AS_RT maintains integral relationships with several master and transactional tables via foreign keys. Critical dependencies include IGS_EN_STDNT_PS_ATT_ALL (student program attempt) and HZ_PARTIES (person) for the student context, and IGS_FI_FEE_TYPE_ALL for the fee type definition. It also references IGS_EN_ATD_MODE_ALL (attendance mode), IGS_EN_ATD_TYPE_ALL (attendance type), and IGS_AD_LOCATION_ALL (location) to align the custom rate with specific academic delivery parameters. These relationships ensure data integrity and that overrides are applied within the correct academic and logistical context.