Search Results rate_type_description




Overview
Explore in AI Chat

Overview

IGWFV_GRANT_PROPOSAL_RATE_TYPE is a Business Intelligence System (BIS) view owned by the APPS schema within the Oracle E-Business Suite Grants Management (IGW) module. In Oracle EBS 12.1.1 and 12.2.2, this view exposes the descriptive and identifying attributes of grant proposal rate classes and rate types. Its principal function is to present human-readable descriptions — most notably RATE_TYPE_DESCRIPTION — alongside the numeric surrogate keys that link to the underlying rate configuration tables. Because it is a BIS view, its design favors query friendliness: it denormalizes the descriptive text so that reporting tools, OBIEE extracts, and ad hoc SQL do not need to join base tables to obtain readable labels.

A common search against this object is for the "rate_type_description" field, which indicates the view is frequently used to resolve a rate type ID into its descriptive name for display in reports, list of values, or integration payloads related to grant proposals and indirect cost rate processing.

Underlying Base Objects

According to the documented dependency information, APPS.IGWFV_GRANT_PROPOSAL_RATE_TYPE is defined over two base tables:

The view joins these tables to produce a combined listing of rate classes with their associated rate types. It also passes through the standard Oracle EBS audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) sourced from the underlying records. The view is not referenced by any other database object, confirming it functions as a terminal reporting object rather than a building block consumed by further views or packages.

Key Columns

  • RATE_TYPE_DESCRIPTION (VARCHAR2, 250) — the descriptive name of the rate type; the field most commonly targeted by users searching this view.
  • RATE_CLASS_DESCRIPTION (VARCHAR2, 250) — the descriptive name of the rate class to which the rate type belongs.
  • RATE_CLASS_ID (NUMBER, 10) — the numeric identifier for the rate class, joinable to IGW_RATE_CLASSES.
  • RATE_TYPE_ID (NUMBER, 10) — the numeric identifier for the rate type, joinable to IGW_RATE_TYPES.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY — audit tracking for the most recent modification.
  • CREATION_DATE / CREATED_BY — audit tracking for the original record creation.

Common Use Cases and Queries

Typical scenarios include building rate type list-of-values queries, validating grant proposal indirect cost setup, and populating BI dashboards that display rate configuration. A basic query to retrieve all rate classes and types is:

  • SELECT RATE_CLASS_DESCRIPTION, RATE_TYPE_DESCRIPTION, RATE_CLASS_ID, RATE_TYPE_ID FROM APPS.IGWFV_GRANT_PROPOSAL_RATE_TYPE ORDER BY RATE_CLASS_DESCRIPTION, RATE_TYPE_DESCRIPTION;
  • SELECT RATE_TYPE_ID, RATE_TYPE_DESCRIPTION FROM APPS.IGWFV_GRANT_PROPOSAL_RATE_TYPE WHERE RATE_CLASS_ID = :p_class_id; — resolving rate types for a specific rate class.
  • SELECT RATE_TYPE_DESCRIPTION FROM APPS.IGWFV_GRANT_PROPOSAL_RATE_TYPE WHERE RATE_TYPE_ID = :p_type_id; — resolving a single description from an ID.

Because the view already supplies descriptions, it eliminates the need to join IGW_RATE_CLASSES and IGW_RATE_TYPES manually, simplifying report development and reducing join overhead in high-volume queries.