Search Results fee_ci_sequence_number




Overview
Explore in AI Chat

Overview

The IGS_FI_FEE_RET_SCHD table is a core data entity within the obsolete Oracle Student System (IGS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It is designed to store special contract-based fee assessment rates. These rates are typically applied to specific fee types and categories within defined academic calendar instances, allowing for tailored fee calculations outside of standard fee schedules. Notably, the provided ETRM metadata explicitly states this table is "Not implemented in this database," indicating it may be a legacy or placeholder structure in standard deployments, though its defined relationships are critical for understanding the overall fee assessment data model.

Key Information Stored

The table's structure is defined by several key columns that form its primary and foreign keys, establishing its role in linking fee assessment rules to academic calendar structures and fee definitions. The primary identifier (IGS_FI_FEE_RET_SCHD_PK) consists of FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, S_RELATION_TYPE, and SEQUENCE_NUMBER. Other significant columns include FEE_TYPE and FEE_CAT, which categorize the fee, and SCHEDULE_NUMBER for identifying specific rate schedules. Crucially for the user's search context, the FEE_CAL_TYPE column is a pivotal foreign key that links the fee assessment schedule to a specific academic calendar type (e.g., 'TERM', 'SEMESTER') within the IGS_CA_DA_INST (Date Alias Instance) and related fee calendar instance tables.

Common Use Cases and Queries

Given its "not implemented" status, direct operational use is unlikely. However, for data analysis, migration, or system integration involving legacy IGS data, common queries would focus on retrieving defined special fee rates. A typical pattern would join to related calendar and fee definition tables to get a comprehensive view. For example, to find all special assessment rates for a specific fee calendar, one might use a query joining on FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER. Reporting use cases would center on auditing or documenting the configured contract-based fee exceptions that were intended to be managed through this entity.

Related Objects

The table maintains integral relationships with several other IGS entities, as documented by its foreign keys:

  • IGS_CA_DA_INST (Date Alias Instance): Joined via columns DT_ALIAS, DAI_SEQUENCE_NUMBER, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER. This links the fee schedule to specific dates within an academic calendar instance.
  • IGS_FI_F_CAT_CA_INST (Fee Category Calendar Instance): Joined via FEE_CAT, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER. This validates the fee category against the calendar.
  • IGS_FI_F_CAT_FEE_LBL_ALL (Fee Category Fee Label): Joined via FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FEE_TYPE. This associates the schedule with a specific fee label under a category.
  • IGS_FI_F_TYP_CA_INST_ALL (Fee Type Calendar Instance): Joined via FEE_TYPE, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER. This validates the fee type against the calendar instance.