Search Results igs_fi_f_typ_ca_inst_all




Overview
Explore in AI Chat

Overview

The IGS_FI_F_TYP_CA_INST_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS), specifically for releases 12.1.1 and 12.2.2. It is designated as an obsolete module, indicating it is part of a legacy codebase that may be superseded in future releases. The table's primary function is to define the relationship between a specific fee type and the calendar instances (periods) during which that fee is assessed. It serves as a critical junction table, linking the definition of a fee to the academic calendar structure and governing the financial accounting and assessment rules for that fee within a given timeframe. This enables the system to manage complex, time-bound fee structures across different academic periods.

Key Information Stored

The table stores configuration data that dictates how and when a fee is applied. Its composite primary key consists of FEE_TYPE, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER, uniquely identifying a fee type's rules for a specific calendar instance. Key columns include status (FEE_TYPE_CI_STATUS), date aliases for the assessment start and end (START_DT_ALIAS, END_DT_ALIAS), and a retroactive date alias (RETRO_DT_ALIAS). Crucially, it holds links to the General Ledger via multiple account code columns (ACCOUNT_CD, REV_ACCOUNT_CD, REC_ACCOUNT_CD, RET_ACCOUNT_CD) and a SUBACCOUNT_ID. The table also references rule engines (RUL_SEQUENCE_NUMBER, SCOPE_RUL_SEQUENCE_NUM) for applying conditional logic to fee assessments.

Common Use Cases and Queries

This table is central to fee assessment batch processes and configuration reporting. Common operational scenarios include validating the active fee calendar periods for a charge batch, troubleshooting assessment errors by reviewing date aliases and statuses, and auditing the GL account mappings for financial reconciliation. A typical query would join this table to the fee type and calendar instance tables to list all configured fees for a given term.

  • Sample Query: Retrieving active fee configurations for a specific calendar.
    SELECT ftca.* FROM igs_fi_f_typ_ca_inst_all ftca JOIN igs_ca_inst_all ci ON ftca.fee_cal_type = ci.cal_type AND ftca.fee_ci_sequence_number = ci.sequence_number WHERE ci.cal_type = 'TERM' AND ci.cal_status = 'ACTIVE';
  • Reporting Use Case: Generating a report of all fee types with their associated GL accounts and assessment periods for audit purposes.

Related Objects

As indicated by its extensive foreign keys, IGS_FI_F_TYP_CA_INST_ALL is a hub within the Student System's financial schema. Key dependencies include:

  • IGS_FI_FEE_TYPE_ALL: The master definition of the fee type.
  • IGS_CA_INST_ALL: The calendar instance defining the assessment period.
  • IGS_FI_ACC_ALL: Provides the General Ledger account codes for revenue, receivables, and refunds.
  • IGS_CA_DA_INST: Provides the specific dates for the start, end, and retroactive date aliases.
  • IGS_RU_RULE: Contains the conditional rules applied during fee assessment.
  • IGS_FI_FEE_STR_STAT: Contains the valid statuses for the fee type calendar instance relationship.

The metadata notes the table is "Not implemented in this database," which may indicate the provided environment lacks the full IGS schema, but its defined structure remains essential for understanding the fee assessment model.