Results for “overhead_type”
9 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:
SELECT RCL.DESCRIPTION, RCL.RATE_CLASS_TYPE, RCL.OVERHEAD_TYPE, RCL.RATE_CLASS_ID, RCL.LAST_UPDATE_DATE, RCL.LAST_UPDATED_BY, RCL.CREATION_DATE, RCL.CREATED_BY FROM IGW_RATE_CLASSES RCL WHERE 1=1 WITH READ ONLY
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
DESCRIPTIONfromIGW_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.
-
APPS.IGWFV_GRANT_PRPSL_RATE_CLASS·↳ IGW_RATE_CLASSES·Explore IGW module →
-
APPS.IGWBV_GRANT_PRPSL_RATE_CLASS·↳ IGW_RATE_CLASSES·Explore IGW module →
-
Information about rate classes
-
TABLE: IGW.IGW_RATE_CLASSES 12.1.1
-
Not implemented in this database·Explore IGW module →
-
Not implemented in this database·Explore IGW module →
-
eTRM - IGW Tables and Views 12.1.1
Information on proposal subjects