Search Results fee_structure_status

Overview

The IGS_FI_FEE_STR_STAT table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product family. It serves as a lookup and mapping table for fee structure statuses. Its primary role is to enable institutional flexibility by allowing the definition of custom, user-defined statuses that are internally mapped to a finite set of system-recognized statuses. This design provides the functional ability to support a large number of business-specific statuses while ensuring they correctly tie back to the underlying system logic and workflows governing fee structures.

Key Information Stored

The table stores the configuration data that defines each valid fee structure status. The key columns and their purposes are:

• FEE_STRUCTURE_STATUS (VARCHAR2(10)): The primary key and unique identifier for the institution-defined status code.
• DESCRIPTION (VARCHAR2(60)): A textual explanation of the status for reporting and user interface clarity.
• S_FEE_STRUCTURE_STATUS (VARCHAR2(10)): The critical mapping column. It holds the system-recognized status code to which the user-defined status correlates, dictating the functional behavior.
• CLOSED_IND (VARCHAR2(1)): A control flag (typically 'Y' or 'N') indicating if the status is closed. When set to closed, this status is prevented from being used in new or modified records elsewhere in the system.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns tracking the creation and modification history of each record.

Common Use Cases and Queries

This table is central to queries involving the lifecycle and validity of fee structures. A common use case is generating a list of all active (non-closed) statuses available for assignment to a new fee structure. System interfaces and custom reports will join to this table to translate a fee structure's status into its user-friendly description or to enforce business rules based on the mapped system status (S_FEE_STRUCTURE_STATUS) or the CLOSED_IND flag. A fundamental query to retrieve all configured statuses is:

SELECT fee_structure_status,
       description,
       s_fee_structure_status,
       closed_ind
FROM   igs.igs_fi_fee_str_stat
ORDER BY fee_structure_status;

To find all user-defined statuses that map to a specific system status, such as 'ACTIVE', and are available for use, a typical query would be:

SELECT fee_structure_status, description
FROM   igs.igs_fi_fee_str_stat
WHERE  s_fee_structure_status = 'ACTIVE'
AND    NVL(closed_ind, 'N') = 'N';

Related Objects

Based on the provided dependency information, the IGS_FI_FEE_STR_STAT table is a referenced object, meaning its primary key (FEE_STRUCTURE_STATUS) is likely used as a foreign key in other tables within the IGS schema to enforce data integrity for fee-related entities. The ETRM states it is referenced by an object named IGS_FI_FEE_STR_STAT under the APPS synonym. This suggests a direct foreign key relationship, possibly in a main transaction table like IGS_FI_FEE_STR (Fee Structure) or similar, where a column stores the FEE_STRUCTURE_STATUS value to indicate the current status of a fee structure record. Any join would typically be on the FEE_STRUCTURE_STATUS column.