Results for “igw_rate_classes”

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

Overview

IGW_RATE_CLASSES is a reference table within the Oracle E-Business Suite Grants Proposal (IGW) module, a legacy application that is now documented as obsolete across EBS 12.1.1 and 12.2.2. The table stores information about rate classes, which are categorization constructs used to group indirect cost rates for institutional proposals, budgets, and sponsored project costing. In the broader Grants Proposal data model, rate classes serve as a lookup and classification layer that governs how overhead or indirect cost treatment is applied to budgetary transactions.

Per the ETRM documentation metadata, the object is marked "Not implemented in this database," meaning that in the referenced instance the physical table is not present. Its schema definition remains documented historically for reference purposes across the 12.1.1 release line and the 12.2.2 upgrade path. The heuristic Data Vault classification assigned to IGW_RATE_CLASSES is hub-leaning. This classification is a modeling suggestion: the table behaves primarily as a hub because it carries a stable surrogate identifier (RATE_CLASS_ID) and is the target of foreign keys from other tables, rather than acting as a transactional link or an attribute satellite.

Key Information Stored

IGW_RATE_CLASSES has a documented physical schema of nine columns under owner IGW. The most significant columns are:

• RATE_CLASS_ID — the surrogate primary key, enforced by the unique constraint and index IGW_RATE_CLASSES_PK. It uniquely identifies each rate class record and is the tenant of the hub classification.
• DESCRIPTION — the human-readable name or label of the rate class, used in reporting and list-of-values presentation.
• RATE_CLASS_TYPE — a classifier that distinguishes categories of rate class, driving downstream logic around which rates apply.
• OVERHEAD_TYPE — indicates the overhead treatment associated with the rate class, relevant to indirect cost computation on budgets.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — the standard Oracle EBS audit columns that record who created and last modified the record and when.

A unique index, IGW_RATE_CLASSES_U1, is documented on RATE_CLASS_ID, making it both the primary key and the single documented business-key candidate. No additional natural key columns are identified in the metadata; DESCRIPTION and the type columns are descriptive attributes rather than unique identifiers.

Common Use Cases and Queries

In installations where the Grants Proposal module operated, rate classes were queried to drive overhead application on proposal budgets and to validate rate type assignments. Typical reporting scenarios include listing available rate classes, finding the class attached to a given budget, and reconciling rate types to their parent classes.

A representative query retrieving the rate class attached to a budget via the documented foreign key:

• SELECT rc.rate_class_id, rc.description, rc.rate_class_type, rc.overhead_type FROM igw_rate_classes rc, igw_budgets b WHERE rc.rate_class_id = b.oh_rate_class_id;
• To find all rate types belonging to a class: SELECT rt.* FROM igw_rate_types rt, igw_rate_classes rc WHERE rt.rate_class_id = rc.rate_class_id AND rc.description = :name;
• To enumerate the reference list with its classification attributes: SELECT rate_class_id, description, rate_class_type, overhead_type FROM igw_rate_classes ORDER BY description;

Because the object is obsolete and reportedly not implemented, any query should be preceded by an existence check against ALL_TABLES for owner IGW before being deployed in a script.

Related Objects

The following objects reference or depend on IGW_RATE_CLASSES, based on the documented foreign key relationships:

• IGW_BUDGETS — references IGW_RATE_CLASSES via IGW_BUDGETS.OH_RATE_CLASS_ID, linking a proposal budget to its overhead rate class.
• IGW_RATE_TYPES — references IGW_RATE_CLASSES via IGW_RATE_TYPES.RATE_CLASS_ID, associating individual rate types with their parent class.
• IGW_RATE_CLASSES_PK — the primary key constraint and unique index on RATE_CLASS_ID.
• IGW_RATE_CLASSES_U1 — the documented unique index on RATE_CLASS_ID.

Together these relationships confirm the hub-leaning classification: IGW_RATE_CLASSES is referenced by IGW_BUDGETS and IGW_RATE_TYPES but itself depends on no parent reference table through its documented foreign keys.