Search Results fee_ci_sequence_number




Overview
Explore in AI Chat

Overview

The IGS_FI_FEE_AS_RATE table is a core entity within the Oracle E-Business Suite Student System (IGS), specifically for the Financials module. It defines the method and parameters required to calculate the monetary amount to be charged for a specific fee category during the fee assessment process. This table acts as a rule engine, storing the various rate structures and qualifying criteria that determine how a fee liability is computed for a student. Its role is critical for automating and ensuring accurate fee generation based on a complex set of academic and demographic attributes.

Key Information Stored

The table stores configuration data that links fee definitions to specific charge rates. Key columns include identifiers for the fee itself (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_CAT) and a RATE_NUMBER to sequence multiple rates. Crucially, it holds numerous foreign key columns that serve as qualifiers to determine which rate applies to a given student's enrollment context. These qualifiers include COURSE_CD, VERSION_NUMBER, ATTENDANCE_MODE, ATTENDANCE_TYPE, LOCATION_CD, UNIT_CLASS, UNIT_SET_CD, RESIDENCY_STATUS_ID, CLASS_STANDING, ORG_PARTY_ID, and government contribution bands (GOVT_HECS_CNTRBTN_BAND). The primary keys enforce uniqueness on combinations of the fee identifier, rate number, and, in one case, the student relationship type (S_RELATION_TYPE).

Common Use Cases and Queries

The primary use case is the backend assessment of fees during processes like enrollment or invoicing, where the system queries this table to find the applicable rate rule matching a student's profile. For reporting and analysis, administrators may query it to audit fee rate structures. A common query pattern involves joining to related fee definition tables and filtering on key attributes. For example, to list all rate rules for a specific fee type, one might use:

  • SELECT fee_type, fee_cat, rate_number, location_cd, attendance_mode FROM igs_fi_fee_as_rate WHERE fee_type = :p_fee_type ORDER BY rate_number;

Another critical query involves finding the precise rate applicable to a student by matching their course, attendance mode, residency, and other attributes against the qualifier columns in this table.

Related Objects

IGS_FI_FEE_AS_RATE has extensive relationships with other Student System entities, as indicated by its foreign keys. It is centrally dependent on the fee definition tables IGS_FI_F_CAT_FEE_LBL_ALL and IGS_FI_F_TYP_CA_INST_ALL. Its qualifier columns reference fundamental academic structures like IGS_PS_VER_ALL (Course Version), IGS_EN_ATD_MODE_ALL, IGS_EN_ATD_TYPE_ALL, IGS_AS_UNIT_CLASS_ALL, and IGS_EN_UNIT_SET_ALL. It also links to party (HZ_PARTIES), location (IGS_AD_LOCATION_ALL), and government contribution tables (IGS_FI_GOVT_HEC_CNTB). This web of relationships underscores its role as a nexus between fee policies and the operational data of students and programs.