Results for “rate_class_type”

11 results




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

Overview

IGWFV_GRANT_PRPSL_RATE_CLASS is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It belongs to the IGW – Grants Proposal product family, which supports the full lifecycle of sponsored-research and grant proposal management. The view exposes rate-class definition data used when costing grant proposals, computing indirect costs, and applying overhead to budget lines.

The IGWFV_ prefix follows the IGW module naming convention, in which IGWF denotes a Grants/Proposal family view and the trailing V confirms that the object is a view rather than a base table. In ETRM 12.1.1 and 12.2.2, the object is documented as VALID, indicating that it compiles cleanly and can be referenced by concurrent programs, forms, OBIEE/RDF reports, and custom extensions without modification.

Functionally, the view answers a single question: "Which rate classes exist, and what type of cost or overhead does each represent?" Because rate classes are reference data consulted during proposal costing, this view is typically a lookup source rather than a transactional driver.

Underlying Base Objects

The view is defined exclusively over the base table IGW_RATE_CLASSES, aliased as RCL. The full documented view text is:

No other tables, joins, or database links are referenced. The WHERE 1=1 WITH READ ONLY clause is a standard Oracle Applications construct that enforces read-only semantics, preventing DML through the view even though all columns derive from a single table. Consequently, the view does not denormalize or aggregate — it is a straight projection of selected columns from IGW_RATE_CLASSES. Any insert or update to rate-class data must be performed against the base table, not the view.

Key Columns

  • RATE_CLASS_ID – Primary key of the rate class; the join key used by proposal costing and budget-generation logic.
  • RATE_CLASS_DESCRIPTION – Projection of DESCRIPTION from IGW_RATE_CLASSES; the human-readable name of the rate class (for example, "On-Campus Research" or "Off-Campus Instruction").
  • RATE_CLASS_TYPE – Classifies the rate class (such as direct, indirect, or fringe categories) and governs how the costing engine applies it.
  • OVERHEAD_TYPE – Identifies the overhead treatment associated with the rate class, determining how indirect costs are calculated and posted.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY – Standard Oracle Applications audit columns recording the most recent modification.
  • CREATION_DATE / CREATED_BY – Standard audit columns recording initial row creation.

Common Use Cases and Queries

Typical uses include populating LOVs and report parameters for rate-class selection, validating rate-class IDs during data conversion, and auditing the audit trail of reference data. A simple listing query:

  • SELECT rate_class_id, rate_class_description, rate_class_type, overhead_type FROM igwfv_grant_prpsl_rate_class ORDER BY rate_class_description;
  • SELECT rate_class_id, rate_class_description FROM igwfv_grant_prpsl_rate_class WHERE rate_class_type = :p_type;
  • SELECT rate_class_id, rate_class_description FROM igwfv_grant_prpsl_rate_class WHERE last_update_date >= :p_since ORDER BY last_update_date DESC;

Because the view is read-only and backed by a single base table, performance is equivalent to querying IGW_RATE_CLASSES directly, and no join or index tuning beyond the base table is required.