Search Results igs_fi_acc_class

Overview

The IGS_FI_ACC_CLASS table is a core reference entity within the Oracle E-Business Suite Student System (IGS), specifically within the financial modules. Its primary function is to define and store usage classifications for financial account codes. This classification system enables the structured categorization of financial transactions and accounts, which is critical for detailed reporting, fee distribution modeling, and unit accounting. The table serves as a master lookup, ensuring data integrity and consistency across related financial entities. It is important to note that the IGS product line is marked as obsolete in the provided ETRM documentation for versions 12.1.1 and 12.2.2, indicating that while the table may exist in upgraded systems, its associated application logic may no longer be actively developed or supported by Oracle.

Key Information Stored

The table's structure is centered on a single primary key column that defines the classification. Based on the documented metadata, the most critical column is CLASSIFICATION_CD. This column serves as the unique identifier (Primary Key: IGS_FI_ACC_CLASS_PK) for each account classification record. While the full column list is not detailed in the excerpt, the existence of a primary key implies this code is a mandatory, unique value, such as 'TUITION', 'LIBRARY_FEE', or 'LAB_FEE'. The table's description confirms it holds the descriptive data that defines what each classification code represents, forming a controlled list of valid values for use in other financial tables.

Common Use Cases and Queries

The primary use case for IGS_FI_ACC_CLASS is as a validation and reporting source for financial data classification. It is queried to populate list of values (LOVs) in application forms or to generate reports that group financial data by account classification. A common reporting pattern would involve joining this table to transactional data to translate codes into meaningful descriptions. For instance, to list all valid account classifications, a simple query would be used. When analyzing fee distribution formulas or unit account assignments, queries would join this table to the related foreign key tables to ensure referential integrity and provide descriptive context.

• Sample Query to List All Classifications: SELECT classification_cd FROM igs_fi_acc_class ORDER BY 1;
• Sample Join for Descriptive Reporting: SELECT fml.*, acl.classification_cd FROM igs_fi_fee_dsbr_fml fml, igs_fi_acc_class acl WHERE fml.classification_cd = acl.classification_cd;

Related Objects

The IGS_FI_ACC_CLASS table is referenced as a parent table in two key relationships, as documented by its foreign keys. These relationships enforce that the CLASSIFICATION_CD used in the child tables must already exist in IGS_FI_ACC_CLASS.

• IGS_FI_FEE_DSBR_FML: This table, likely storing Fee Disbursement Formulas, references IGS_FI_ACC_CLASS via its CLASSIFICATION_CD column. This links specific fee distribution rules to an account classification.
• IGS_OR_UNIT_AC: This table, likely for Unit Account assignments, references IGS_FI_ACC_CLASS via its CLASSIFICATION_CD column. This associates unit-level accounting details with a broader account classification.

These relationships highlight the table's role in centralizing account classification definitions for both disbursement logic (IGS_FI_FEE_DSBR_FML) and organizational unit accounting (IGS_OR_UNIT_AC).