Results for “currency_cd”

50+ results




Overview
Explore in AI Chat

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

Overview

IGS_FI_FEE_CAT_ALL is a core setup and reference table within the Oracle E-Business Suite Student System (IGS) product family. It defines the master list of fee categories that drive special contract-based fee assessment rates. Each row in this table represents a distinct fee category—such as tuition, activity fees, or program-specific charges—that can be associated with contractual fee arrangements, student applications, applicant instances, and student program terms.

Because this table functions as the authoritative source of fee category identifiers, downstream transactional and mapping tables reference it through foreign keys rather than duplicating category definitions. This design promotes consistency across fee assessment, billing, and enrollment processes.

From a data-modeling perspective, the mined foreign-key structure suggests this object behaves as a hub. It maintains the canonical set of business keys (FEE_CAT) that other tables point to, with descriptive attributes and audit columns positioned as satellite-like properties attached to the same entity.

Key Information Stored

The table contains ten documented columns. The most significant are:

  • FEE_CAT — The primary business identifier for each fee category. It serves as both the primary key component (IGS_FI_FEE_CAT_PK) and the unique business key (IGS_FI_FEE_CAT_ALL_U1). All referencing tables join on this column.
  • DESCRIPTION — Human-readable name or explanation of the fee category, used extensively in reports and user interfaces.
  • CURRENCY_CD — Currency code associated with the fee category, supporting multi-currency institutions and exchange-rate determination.
  • CLOSED_IND — Flag indicating whether the fee category is active or closed. Closed categories should be excluded from new fee assessments.
  • ORG_ID — Operating unit identifier, supporting multi-organization partitioning of fee categories.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture standard Oracle EBS who-did-what auditing.

The primary key is a surrogate structure anchored on FEE_CAT, which is also the single unique business-key candidate. The remaining columns are attributes or audit metadata rather than alternative keys.

Common Use Cases and Queries

Fee category data is consumed when configuring and validating special contractual fee rates. Typical scenarios include listing all active fee categories for an operating unit, verifying currency assignments before billing, and joining fee categories to student applications to derive assessment rules.

Example query to retrieve active fee categories for a specific operating unit:

  • SELECT FEE_CAT, DESCRIPTION, CURRENCY_CD FROM IGS_FI_FEE_CAT_ALL WHERE CLOSED_IND = 'N' AND ORG_ID = :org_id ORDER BY FEE_CAT;

A common reporting pattern joins the table to dependent entities to trace usage, such as identifying which student applications reference a given fee category via IGS_AD_PS_APPL_INST_ALL.FEE_CAT. Institutions also validate referential integrity by detecting orphaned foreign keys or unused categories before purging setup data.

Related Objects

The following tables reference IGS_FI_FEE_CAT_ALL through the FEE_CAT column and are the most significant dependencies:

  • IGS_AD_PS_APPL_INST_ALL — Applicant instance data; joins on FEE_CAT to associate contractual fee categories with specific applications.
  • IGS_FI_F_CAT_CA_INST — Institution-level fee category configuration; joins on FEE_CAT to hold category-instance details.
  • IGS_FI_FEE_CAT_MAP — Mapping table linking fee categories to other fee structures; joins on FEE_CAT.
  • IGS_EN_SPA_TERMS — Student program terms; joins on FEE_CAT to apply category-based assessments across terms.
  • IGS_EN_STDNT_PS_ATT_ALL — Student program attempt records; joins on FEE_CAT to determine assessment against enrolled attempts.

Together these relationships establish IGS_FI_FEE_CAT_ALL as the central reference point for fee category definition across the Student System.