Results for “igw_exp_rate_types_u1”

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

Overview

IGW.IGW_EXP_TYPE_RATE_TYPES is a reference and association table within the Oracle E-Business Suite Grants and Contracts (IGW) schema. It stores the mapping between expenditure categories and the rate classes and rate types to which they belong, capturing the rule that an expenditure category may be assigned to only one rate type within a given rate class. This mapping governs how indirect cost rates are applied to sponsored project expenditures and is used by the rate calculation and burdening logic in Oracle Grants and Oracle Projects.

From a dimensional modeling perspective, the table exhibits satellite-leaning characteristics. Its grain is a single valid combination of expenditure category, rate class, and rate type, and its non-key columns are largely Standard Who audit fields. This suggests a design in which the natural business key of the combination is carried directly on the row rather than through a generated surrogate, with the table acting at the detail level of an existing rate hierarchy rather than as a standalone hub of identity.

Key Information Stored

The table contains eight documented columns, of which three are functional and five are Standard Who audit columns.

• EXPENDITURE_CATEGORY (VARCHAR2(30)) — The expenditure category being mapped. This is one component of the composite business key and identifies which category of cost (for example, a specific spend classification) is being associated with a rate.
• RATE_CLASS_ID (NUMBER(10)) — The rate class identifier. This column carries a foreign key relationship to IGW_RATE_TYPES and participates in the rate class scoping that enforces one rate type per category per class.
• RATE_TYPE_ID (NUMBER(10)) — The rate type identifier, the third element of the composite key.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Who columns recording the audit trail for row creation and modification.

The primary key IGW_EXP_RATE_TYPES_PK is defined over (EXPENDITURE_CATEGORY, RATE_CLASS_ID, RATE_TYPE_ID). The unique index IGW_EXP_RATE_TYPES_U1 covers the identical three-column set, so there is no separate generated surrogate key; the business-key candidate and the primary key coincide entirely.

Common Use Cases and Queries

Typical usage involves retrieving the valid rate type assignments for an expenditure category or validating that a proposed category-to-rate-type mapping does not violate the one-type-per-class rule.

• List all rate assignments for a given rate class: SELECT EXPENDITURE_CATEGORY, RATE_TYPE_ID FROM IGW.IGW_EXP_TYPE_RATE_TYPES WHERE RATE_CLASS_ID = :class_id;
• Determine which rate type applies to a specific category within a class: filter on all three key columns.
• Reporting on rate setup completeness, comparing configured categories against available expenditure categories.
• Feeding indirect cost calculation logic in Oracle Grants that must resolve the proper rate type for a category before applying burden.
• Auditing recent configuration changes using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Related Objects

The table has a documented foreign key relationship on RATE_CLASS_ID referencing the IGW_RATE_TYPES table, which defines the rate classes and rate types available for assignment. In addition, the object appears in dependency listings as referenced by the APPS synonym IGW_EXP_TYPE_RATE_TYPES, through which application code and concurrent programs access the underlying IGW table. Rate calculation and burdening flows in Oracle Grants and Oracle Projects query this table when resolving expenditure category to rate type relationships, and its contents are typically maintained through the Grants rate setup user interface rather than by direct DML.