Search Results igw_institute_rates




Overview
Explore in AI Chat

Overview

The IGW_INSTITUTE_RATES table is a core data structure within the Oracle E-Business Suite (EBS) Grants Proposal module (IGW). It serves as the central repository for institutional rate definitions, which are critical for the accurate calculation of indirect costs, facilities and administrative (F&A) costs, and other overheads associated with grant and contract proposals. The table's role is to store the approved, institution-specific rates that are applied to proposal budgets based on a combination of key classifying attributes. By maintaining this master data, the system ensures consistent, rule-based cost calculations across all proposals, which is a fundamental requirement for sponsored research administration and compliance.

Key Information Stored

The table's structure is designed to uniquely identify a specific rate through a composite primary key. The key columns define the precise context for the stored rate value. According to the provided metadata, the primary key consists of RATE_CLASS_ID, RATE_TYPE_ID, ACTIVITY_TYPE_CODE, FISCAL_YEAR, and LOCATION_CODE. This combination ensures that a unique rate is defined for a specific rate class (e.g., F&A), a specific rate type within that class, an activity type (e.g., research, instruction), a fiscal year, and an organizational location. The table likely contains additional columns to store the actual RATE value (percentage or multiplier), effective dates, and audit information like creation date and last update details. The foreign key relationships confirm it references the IGW_RATE_TYPES table to validate the rate class and type combination.

Common Use Cases and Queries

The primary use case is the automated application of indirect cost rates during proposal budget development. When a budget line is created, the system queries this table using the proposal's attributes to determine the correct rate. Common reporting and validation queries include retrieving all active rates for a fiscal year, comparing rates across locations, or auditing rate changes. A typical SQL pattern for finding a applicable rate would be:

  • SELECT rate FROM igw_institute_rates WHERE rate_class_id = 'F&A' AND rate_type_id = 'ON-CAMPUS' AND activity_type_code = 'RESEARCH' AND fiscal_year = 2024 AND location_code = 'MAIN_CAMPUS';

Data maintenance tasks involve bulk loading new fiscal year rates or inactivating obsolete records. Integration points include budget calculation engines and proposal reporting tools that summarize applied overhead costs.

Related Objects

As indicated by the foreign key metadata, the IGW_INSTITUTE_RATES table has a direct dependency on the IGW_RATE_TYPES table for valid rate class and type definitions. It is a foundational table referenced by numerous other objects within the IGW module. Key related objects typically include the proposal budget lines table (e.g., IGW_PROP_BUDGET_LINES or similar), which applies the rates, and various proposal summary and header tables. The table is also central to the rate setup and maintenance forms within the EBS application's functional interface. APIs for proposal import and budget calculation will internally query this table to perform validations and computations.