Search Results gms_event_attribute




Overview
Explore in AI Chat

Overview

The GMS_EVENT_ATTRIBUTE table is a core data object within the Oracle E-Business Suite Grants Accounting (GMS) module. It functions as an extension table, storing supplemental attributes specifically required for grant and contract billing events. Its primary role is to map and enrich standard project billing event information, which is centrally maintained in the PA_EVENTS table of the Project Accounting (PA) module. This structure allows the GMS application to maintain grant-specific billing rules and compliance data while leveraging the common project foundation, ensuring integration between project management and sponsored project financial management.

Key Information Stored

The table's structure is defined by its foreign key relationship to PA_EVENTS, which dictates its core identifying columns. While the full column list is not detailed in the provided metadata, the foreign key definition and description indicate critical data points. The table is anchored by PROJECT_ID and EVENT_NUM, which form a composite foreign key to PA_EVENTS, ensuring a one-to-one or one-to-zero relationship with a master billing event. The additional attributes stored likely include fields critical for government or sponsor reporting, such as specific billing classification codes, allowable cost indicators, sponsor-defined event identifiers, or flags controlling the integration of billing events with the GMS award management and invoicing processes.

Common Use Cases and Queries

This table is essential for processes that generate sponsor invoices or reports that require grant-specific billing details. A common use case is the extraction of all billable events for a specific award, joining grant attributes to the standard event data. For example, a report to validate events before an invoice run might use a query such as:

  • SELECT pe.event_num, pe.event_type, gea.* FROM pa_events pe, gms_event_attribute gea WHERE pe.project_id = gea.project_id AND pe.event_num = gea.event_num AND pe.project_id = :p_project_id;

Another critical scenario is during the creation or update of billing events from the GMS interface, where the application populates this table with the grant-specific context. Data in this table is also queried by the GMS billing engine to apply appropriate award terms, ceilings, and billing rules when constructing draft revenue or invoice lines.

Related Objects

The GMS_EVENT_ATTRIBUTE table has a direct and fundamental relationship with the PA_EVENTS table, as defined by its foreign key. This is the primary relationship, linking grant-specific attributes to the universal project event. It is intrinsically related to other core GMS tables such as GMS_AWARDS (via the project association) and likely interfaces with the GMS_BILLING_EXT or revenue generation tables. Programmatically, it is accessed by GMS package logic, particularly within the billing and event management APIs, rather than through public views for end-user reporting.