Search Results igs_fi_fee_str_stat




Overview
Explore in AI Chat

Overview

The IGS_FI_FEE_STR_STAT table is a core reference table within the Oracle E-Business Suite Student System (IGS). It defines the valid statuses that can be applied to special contract-based fee assessment structures. These statuses govern the lifecycle and applicability of fee structures, which are used to define customized fee rates for specific contracts or agreements, such as those with corporate clients or sponsored students. The table's primary role is to maintain data integrity by providing a controlled list of status codes (e.g., ACTIVE, INACTIVE, PENDING) that other transactional tables in the fees module must reference, ensuring consistent and valid fee structure state management across the application.

Key Information Stored

The table's structure is centered on a status code, which is its primary key. While the provided metadata does not list all columns, the core column is FEE_STRUCTURE_STATUS. This column stores the short code representing the status. Typically, such reference tables also include descriptive columns like DESCRIPTION for the status name, and system columns for tracking, such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY. The data is static and maintained by the application, defining the business rules for which fee structure statuses are permissible within the system.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and setup. Administrators may query it to view all available statuses when configuring the system or troubleshooting data. Common SQL patterns include joining this table to transactional fee tables to translate status codes into meaningful descriptions for reports. For instance, a report listing all active contract fee structures would join on the FEE_STRUCTURE_STATUS column.

  • Sample Query for Status Lookup: SELECT fee_structure_status, description FROM igs.igs_fi_fee_str_stat ORDER BY 1;
  • Use in Validation: Application logic will validate that any status assigned to a fee structure in related tables (IGS_FI_F_CAT_CA_INST, etc.) exists in this table, enforcing referential integrity.
  • Reporting: Critical for generating fee liability reports that need to filter or group records based on the fee structure's status description rather than its opaque code.

Related Objects

The IGS_FI_FEE_STR_STAT table is referenced as a foreign key by several important transactional tables in the Fees module, as documented in the ETRM metadata. These relationships are fundamental to the data model.

In all cases, the join condition is on the primary key column IGS_FI_FEE_STR_STAT.FEE_STRUCTURE_STATUS to the respective foreign key column in the related table. This design centralizes status control and ensures data consistency.