Search Results igw_rate_classes




Overview
Explore in AI Chat

Overview

The IGW_RATE_CLASSES table is a core data object within the Oracle E-Business Suite (EBS) module IGW - Grants Proposal, which is documented as obsolete. This table serves as a master repository for defining and storing distinct rate classes. In the context of grant proposal and budget management, a rate class is a categorization mechanism for different types of indirect cost rates, such as overhead (OH), fringe benefits, or general and administrative (G&A) rates. The table's primary role is to provide a reference structure, enabling the association of specific rate types and budget line items with a standardized classification, thereby ensuring consistent application of costing rules across proposal budgets.

Key Information Stored

While the provided ETRM excerpt does not list specific columns beyond the primary key, the structure of the table and its relationships imply critical data points. The central column is RATE_CLASS_ID, a unique system-generated identifier serving as the primary key. Based on standard EBS design patterns and the table's purpose, it would also contain columns such as RATE_CLASS (a code or short name) and NAME or DESCRIPTION (a longer, descriptive text). Additional columns likely include standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing and a START_DATE_ACTIVE and END_DATE_ACTIVE to control the valid date range for the rate class.

Common Use Cases and Queries

The primary use case is to support the setup and validation of indirect cost rates within grant proposals. When defining a rate type (e.g., a specific overhead percentage for a fiscal year), it must be linked to a valid rate class. Budget calculations then reference these rates via their class. A common reporting query would involve joining rate classes to their associated rate types to list all active costing structures. A sample SQL pattern to retrieve all rate classes might be:

  • SELECT rate_class_id, rate_class, name, start_date_active, end_date_active FROM igw_rate_classes WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE) ORDER BY rate_class;

Another critical query would validate budget assignments by joining IGW_BUDGETS to IGW_RATE_CLASSES via the OH_RATE_CLASS_ID foreign key to ensure the referenced rate class is active and valid.

Related Objects

The IGW_RATE_CLASSES table has defined foreign key relationships with two other tables in the Grants Proposal module, as documented in the ETRM metadata.

  • IGW_BUDGETS: Budget records reference a rate class for overhead calculations via the column IGW_BUDGETS.OH_RATE_CLASS_ID, which joins to IGW_RATE_CLASSES.RATE_CLASS_ID.
  • IGW_RATE_TYPES: Individual rate definitions (specific percentages or amounts) are categorized under a rate class. The column IGW_RATE_TYPES.RATE_CLASS_ID is a foreign key to IGW_RATE_CLASSES.RATE_CLASS_ID.

These relationships establish IGW_RATE_CLASSES as a parent lookup table, ensuring referential integrity for overhead assignments in budgets and the classification of all defined rate types.