Results for “igs_fi_fee_str_stat”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_FI_FEE_STR_STAT is a reference (lookup) table in the IGS — Student System product family of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2 releases. As stated in the ETRM documentation, this entity "describes special contract based fee assessment rates," meaning it stores the status codes used to classify the lifecycle state of fee structures applied to special contracts within the Student System's fee assessment engine. Fee structure status is a controlled vocabulary that governs whether a particular contract-based fee assessment rate arrangement is active, closed, or otherwise eligible for processing during fee calculation and invoicing.

The table is a lightweight, low-volume code table with only nine columns and a compact primary key structure. Under the heuristic Data Vault classification mined from its foreign key topology, the object is hub-leaning: it behaves as a business key hub that defines the set of valid fee structure statuses and is referenced by multiple surrounding tables. This classification should be treated as a modeling suggestion rather than a documented Data Vault design, since the ETRM metadata describes a conventional relational lookup rather than an explicitly Data Vault–modeled entity.

Key Information Stored

The table's primary key is IGS_FI_FEE_STR_STAT_PK, defined on the single column FEE_STRUCTURE_STATUS. A unique index, IGS_FI_FEE_STR_STAT_U1, is documented on the same column, confirming FEE_STRUCTURE_STATUS as the business-key candidate — the column holding the actual status code value (for example, an internal code representing active, inactive, or closed fee structures). Because the surrogate and business key coincide here, the primary key is effectively the natural status code.

• FEE_STRUCTURE_STATUS — the primary key and unique business key column; stores the status code identifier for a contract-based fee structure.
• DESCRIPTION — the user-facing, translatable description of the status (e.g., "Active," "Closed") used in forms, LOVs, and reports.
• S_FEE_STRUCTURE_STATUS — the seeded/system status value, typically the internal or predefined status used by delivered fee assessment logic distinct from the descriptive label.
• CLOSED_IND — a flag indicating whether the status represents a closed state, allowing downstream processes to filter out closed fee structures without hard-coding status values.
• CREATED_BY, CREATION_DATE — standard Oracle EBS WHO columns capturing the creating user and timestamp of the row.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the remaining WHO audit columns recording the last modifying user, the modification timestamp, and the login session of the updater.

The seven attributes beyond the status column consist of one descriptive field, one seeded-value field, one indicator, and the six standard WHO audit columns, reinforcing the table's role as a small, stable reference entity.

Common Use Cases and Queries

Typical usage centers on decoding and filtering fee structure status values in fee assessment reporting, contract setup validations, and reconciliation of fee categories to contract instances.

• Decoding status on fee assessment reports, joining FEE_STRUCTURE_STATUS to descriptive labels:

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

• Returning only open (non-closed) statuses for validation lists:

SELECT fee_structure_status, description
FROM   igs.igs_fi_fee_str_stat
WHERE  closed_ind = 'N';

• Auditing when status definitions were maintained, using the WHO columns:

SELECT fee_structure_status,
       last_updated_by,
       last_update_date
FROM   igs.igs_fi_fee_str_stat
WHERE  last_update_date >= TRUNC(SYSDATE) - 30;

These patterns support contract-based fee setup verification, status-driven process routing, and operational reporting on the Student System's financial components.

Related Objects

The documented foreign key relationships confirm that IGS_FI_FEE_STR_STAT is referenced as a status lookup by three significant tables in the IGS financial schema. Each foreign key targets the primary key column FEE_STRUCTURE_STATUS:

• IGS_FI_F_CAT_CA_INST — references IGS_FI_FEE_STR_STAT through FEE_CAT_CI_STATUS; ties fee category contract-instance records to their status definition.
• IGS_FI_F_CAT_FEE_LBL_ALL — references IGS_FI_FEE_STR_STAT through FEE_LIABILITY_STATUS; associates fee liability labels for categories with a status.
• IGS_FI_F_TYP_CA_INST_ALL — references IGS_FI_FEE_STR_STAT through FEE_TYPE_CI_STATUS; links fee type contract-instance records to the status lookup.

Together these tables depend on the status codes this entity defines, making IGS_FI_FEE_STR_STAT a small but structurally central hub for fee structure state management across the IGS Student System. Database administrators should treat it as reference data: changes to its rows propagate semantically to every dependent contract-instance and label record, so maintenance should follow standard lookup-table governance.