Results for “rate_class_type”

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

Overview

IGWBV_GRANT_PRPSL_RATE_CLASS is a read-only database view belonging to the Oracle E-Business Suite Grants Proposal module (product code IGW). In the context of ETRM 12.1.1 and 12.2.2, this view functions as a thin projection layer over the IGW_RATE_CLASSES base table, exposing the rate classification attributes that govern how indirect costs, overhead, and burden rates are applied to grant proposals and awards. The view carries the "Obsolete" designation in the ETRM documentation, indicating that it is retained for backward compatibility with earlier Grants Accounting releases but is no longer actively maintained or shipped as part of the current product footprint. In the documented 12.2.2 ETRM metadata, the object is explicitly recorded as "Not implemented in this database," meaning that the underlying IGW_RATE_CLASSES table and its dependent view will not be present in a standard vanilla installation. Its role in reporting and integration is therefore historical: it was used by Grants proposal forms, concurrent programs, and downstream extracts to resolve the rate class and overhead type associated with a given rate class identifier, and any custom integration referencing this view must be validated against the actual schema before deployment.

Underlying Base Objects

The view is defined over a single documented base object, IGW_RATE_CLASSES (aliased as RCL in the view text), with no other base tables or joins documented in the ETRM metadata. The defining query is a straightforward projection:

• It selects DESCRIPTION, RATE_CLASS_TYPE, OVERHEAD_TYPE, RATE_CLASS_ID, and the standard WHO audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY) from IGW_RATE_CLASSES.
• It applies a redundant WHERE 1=1 predicate, a common Oracle Applications convention that simplifies runtime predicate appending and has no filtering effect.
• It is declared WITH READ ONLY, enforcing that no DML may be performed through the view; all maintenance must occur directly on IGW_RATE_CLASSES.

Because the ETRM metadata lists "Referenced base objects: none documented" in the 12.2.2 entry, the view is best treated as a compatibility alias rather than a functional dependency in the current release.

Key Columns

• RATE_CLASS_ID — The primary identifier of the rate class record; joins to rate class references in Grants proposal and award tables.
• RATE_CLASS_TYPE — The classification code that distinguishes rate classes (for example, indirect cost, fringe, or service center categories). This is the column most frequently used as a filter, and it is the term behind the search "rate_class_type."
• OVERHEAD_TYPE — Identifies the overhead or burden category associated with the rate class, used in indirect cost calculations.
• RATE_CLASS_DESCRIPTION — The descriptive name of the rate class, exposed from the underlying DESCRIPTION column of IGW_RATE_CLASSES.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE provide standard Oracle WHO tracking for auditing and reconciliation.

Common Use Cases and Queries

Typical usage centers on resolving a rate class identifier into its type, overhead category, and description for reporting or data migration. A representative query is:

• Filtering by rate class type:
  SELECT rate_class_id, rate_class_description, rate_class_type, overhead_type FROM igwbv_grant_prpsl_rate_class WHERE rate_class_type = :p_type;
• Lookup by identifier:
  SELECT rate_class_description, overhead_type FROM igwbv_grant_prpsl_rate_class WHERE rate_class_id = :p_id;
• Audit reconciliation: selecting the WHO columns to identify when a rate class definition was last changed.

Before relying on this view in a 12.1.1 or 12.2.2 instance, confirm that IGW_RATE_CLASSES exists in the target schema. Where the object is absent, the equivalent data is typically sourced from the active rate and burden tables of the Grants and Costing modules, and any custom report or interface referencing IGWBV_GRANT_PRPSL_RATE_CLASS should be re-pointed accordingly.