Results for “igw_rate_types”

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

Overview

IGW_RATE_TYPES is a foundation table within the Oracle EBS Grants Proposal (IGW) module, present in both release 12.1.1 and 12.2.2. It stores the set of rate types that may be defined for each rate class, forming the master reference layer against which institution-level and proposal-level rate amounts are captured. In the Grants Proposal data model, a rate class represents a grouping or category of indirect cost recovery (for example, on-campus research or off-campus instruction), while a rate type identifies the individual rate definitions permitted under that class. IGW_RATE_TYPES is therefore the parent of the rate transactions, not the rate values themselves; the actual negotiated percentages and effective periods reside in the child tables.

The documented physical schema is owned by the IGW schema and contains eight columns. Under the heuristic Data Vault classification mined from its foreign key structure, the object is characterized as hub-leaning. From a modeling standpoint this suggests treating IGW_RATE_TYPES as a hub-like reference entity, with its unique business key acting as the durable identity and the descriptive attributes suitable for satellite placement.

Key Information Stored

The table’s documented column list is compact, reflecting its role as an enabling reference set rather than a transactional store. The most significant elements are:

• RATE_CLASS_ID — identifies the parent rate class; also the leading column of the primary key and of the unique business key.
• RATE_TYPE_ID — identifies the specific rate type within the class; the second component of both the primary and unique keys.
• DESCRIPTION — the user-facing name or explanation of the rate type, used in list-of-values and reporting output.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard Oracle EBS who-column audit set, supporting change tracking and concurrency control.

The surrogate primary key is enforced by the constraint IGW_RATE_TYPES_PK over (RATE_CLASS_ID, RATE_TYPE_ID). A separate unique index, IGW_RATE_TYPES_U1, covers the same two columns and serves as the documented business-key candidate. Because no independent generated identifier column exists, the composite of class and type functions as both the technical and business identity.

Common Use Cases and Queries

The principal use case is validation and lookup: confirming that a proposed combination of rate class and rate type is defined before inserting institution or proposal rate records, and driving rate type list-of-values in the Grants Proposal setup and proposal entry forms. Reporting use cases center on rate setup audits and on denormalizing descriptions into operational reports.

A typical lookup query joins the class parent to obtain both descriptors:

• SELECT rt.rate_class_id, rt.rate_type_id, rt.description FROM igw_rate_types rt WHERE rt.rate_class_id = :p_class_id ORDER BY rt.rate_type_id;

A referential-integrity exception check identifies orphaned child rows:

• SELECT r.rate_class_id, r.rate_type_id FROM igw_institute_rates r WHERE NOT EXISTS (SELECT 1 FROM igw_rate_types rt WHERE rt.rate_class_id = r.rate_class_id AND rt.rate_type_id = r.rate_type_id);

Institution rate extracts and proposal rate reconciliations should always drive from this table so that configurations with no associated rate amounts are still surfaced for review.

Related Objects

IGW_RATE_TYPES participates in a documented set of foreign key relationships. It references the rate class master and is itself referenced by three dependent tables:

• IGW_RATE_CLASSES — parent lookup; joined on IGW_RATE_TYPES.RATE_CLASS_ID = IGW_RATE_CLASSES.RATE_CLASS_ID.
• IGW_EXP_TYPE_RATE_TYPES — governs which rate types apply to a given expenditure type; joined on both RATE_CLASS_ID and RATE_TYPE_ID.
• IGW_INSTITUTE_RATES — holds institution-level negotiated rate amounts; joined on RATE_CLASS_ID and RATE_TYPE_ID.
• IGW_PROP_RATES — holds proposal-level applied rates; joined on RATE_CLASS_ID and RATE_TYPE_ID.

Together these objects form the core rate-definition hierarchy, with IGW_RATE_TYPES acting as the controlling reference that constrains valid rate combinations across expenditure types, institutions, and proposals.