Search Results igw_exp_type_rate_types




Overview
Explore in AI Chat

Overview

The table IGW_EXP_TYPE_RATE_TYPES is a core data structure within the Oracle E-Business Suite (EBS) Grants Proposal module (IGW). It functions as a critical junction table, establishing and managing the permissible associations between specific expenditure categories and the defined rate classes and rate types used for calculating indirect costs (overhead) on grant proposals. Its role is to enforce business rules by defining which types of project expenditures are eligible for which specific overhead or fringe benefit rates. This configuration is fundamental to ensuring accurate and compliant proposal costing in accordance with sponsor guidelines and institutional policy across both EBS 12.1.1 and 12.2.2 versions.

Key Information Stored

The table's structure is designed to store a unique combination of identifiers that link three key entities. The primary key constraint IGW_EXP_RATE_TYPES_PK enforces uniqueness on the combination of the following columns:

  • EXPENDITURE_CATEGORY: Identifies a specific category of project cost (e.g., Salaries, Equipment, Travel).
  • RATE_CLASS_ID: A foreign key referencing the classification of a rate (e.g., Overhead, Fringe Benefits).
  • RATE_TYPE_ID: A foreign key referencing the specific rate value or schedule within the given rate class.

Each record signifies that the specified expenditure category can be charged using the associated rate class and type during proposal development and subsequent award financial planning.

Common Use Cases and Queries

A primary use case is the validation and defaulting of rates during the entry of budget lines in a grant proposal. The system consults this table to determine which rate options are valid for a user-selected expenditure item. It is also central to configuration reports that audit institutional costing policies. A typical query would retrieve all rate setups for a given expenditure category or validate a specific combination.

-- Sample: Find all valid rate types for the 'Salaries' expenditure category
SELECT ert.rate_class_id,
       ert.rate_type_id,
       rc.rate_class_code,
       rt.rate_type_code
FROM igw_exp_type_rate_types ert,
     igw_rate_classes rc,
     igw_rate_types rt
WHERE ert.expenditure_category = 'SALARIES'
  AND ert.rate_class_id = rc.rate_class_id
  AND ert.rate_class_id = rt.rate_class_id
  AND ert.rate_type_id = rt.rate_type_id;

Related Objects

IGW_EXP_TYPE_RATE_TYPES has defined foreign key relationships to the IGW_RATE_TYPES table on both the RATE_CLASS_ID and RATE_TYPE_ID columns, ensuring referential integrity to the master list of available rates. It is intrinsically linked to the IGW_RATE_CLASSES table via the rate class identifier. This table is a foundational reference for the proposal budgeting engine and is likely referenced by key program units within the IGW module, such as the rate calculation and validation APIs, as well as the underlying budget lines table (e.g., IGW_PROP_BUDGET_LINES).