Search Results igw_awards_u1

Overview

IGW.IGW_AWARDS is a transactional table in the Oracle E-Business Suite Grants and Proposal Management modules, operating within the IGW schema. It stores award and installment data that originates in the proposal lifecycle and is subsequently transferred to Grants Accounting. A single funded proposal may be transferred as multiple awards and installments, meaning that the table can hold several rows for one proposal, each distinguished by the proposal award identifier. Records in this table therefore represent either a parent award or an installment associated with that award, and the table acts as the staging point before data is committed into the Oracle Grants Accounting award structure.

From a data modeling perspective, the mined foreign key structure classifies IGW_AWARDS as satellite-leaning. In Data Vault terms, this suggests the table is best modeled as a satellite attached to the proposal and award hubs, with PROPOSAL_ID and AWARD_ID supplying the hub references and the descriptive attributes (names, dates, billing and revenue rules) changing over time. The surrogate primary key IGW_AWARDS_PK on PROPOSAL_AWARD_ID uniquely identifies each award or installment row, while IGW_AWARDS_U1 provides a unique index on the same column.

Key Information Stored

The table is documented in ETRM 12.1.1 with 52 columns, stored in the APPS_TS_TX_DATA tablespace. The most functionally significant columns include:

• PROPOSAL_AWARD_ID — the surrogate primary key (IGW_AWARDS_PK, and the unique index IGW_AWARDS_U1) identifying each award or installment.
• PROPOSAL_ID — foreign key to IGW_PROPOSALS_ALL, linking the row to its originating proposal; indexed non-uniquely via IGW_AWARDS_N1.
• AWARD_ID — foreign key to IGF_AW_AWARD_ALL, tying the row to the Grants Accounting award.
• AWARD_NUMBER, AWARD_SHORT_NAME, AWARD_FULL_NAME — descriptive business identifiers for the award.
• FUNDING_SOURCE_ID — foreign key to OKE_K_FUNDING_SOURCES, with FUNDING_SOURCE_AWARD_NUMBER holding the sponsor's award reference.
• START_DATE, END_DATE, CLOSE_DATE — the active period and close date for the installment.
• AWARD_TYPE, AWARD_PURPOSE_CODE, AWARD_STATUS_CODE — classification and lifecycle status values such as Federal Grant, Private Grant, Active, Closed, AT_RISK, and ON_HOLD.
• AWARD_MANAGER_ID, AWARD_ORGANIZATION_ID — ownership and organizational responsibility.
• REVENUE_DISTRIBUTION_RULE, BILLING_DISTRIBUTION_RULE — distribution rules, either event or cost based.
• BILLING_TERM_ID, BILLING_CYCLE_ID — billing term and cycle identifiers that drive invoice generation for the award.
• LABOR_INVOICE_FORMAT_ID, NON_LABOR_INVOICE_FORMAT_ID, ALLOWABLE_SCHEDULE_ID, INDIRECT_SCHEDULE_ID — invoice formatting and rate schedule references.
• TRANSFERRED_FLAG, TRANSFER_AS, TEMPORARY_FLAG — indicators controlling transfer behavior to Grants Accounting.

Common Use Cases and Queries

The most frequent application of this table is to determine and validate billing configuration before invoices are generated, since the user search term billing_term_id maps directly to the BILLING_TERM_ID column. A typical query joining awards to their installments is:

• SELECT aw.PROPOSAL_AWARD_ID, aw.AWARD_NUMBER, aw.BILLING_TERM_ID, aw.BILLING_CYCLE_ID FROM IGW.IGW_AWARDS aw WHERE aw.PROPOSAL_ID = :proposal_id;
• SELECT aw.AWARD_NUMBER, aw.AWARD_STATUS_CODE, aw.START_DATE, aw.END_DATE FROM IGW.IGW_AWARDS aw WHERE aw.TRANSFERRED_FLAG = 'N' AND aw.TEMPORARY_FLAG = 'N';
• SELECT aw.AWARD_NUMBER, i.PROPOSAL_AWARD_ID FROM IGW.IGW_AWARDS aw, IGW.IGW_INSTALLMENTS i WHERE aw.PROPOSAL_AWARD_ID = i.PROPOSAL_AWARD_ID;

Reporting use cases include reconciling awards not yet transferred to Grants Accounting, auditing billing term assignments across awards, and reviewing active versus at-risk awards by manager or organization.

Related Objects

The following objects are most significant to IGW_AWARDS based on the documented foreign key relationships:

• IGW.IGW_PROPOSALS_ALL — referenced via PROPOSAL_ID; the parent proposal record.
• IGF.IGF_AW_AWARD_ALL — referenced via AWARD_ID; the Grants Accounting award.
• OKE.OKE_K_FUNDING_SOURCES — referenced via FUNDING_SOURCE_ID; the funding source definition.
• IGW.IGW_INSTALLMENTS — references IGW_AWARDS via PROPOSAL_AWARD_ID; holds installment detail.
• IGW.IGW_PROP_PERSON_SUPPORT — references IGW_AWARDS via PROPOSAL_AWARD_ID; holds person support data.

These relationships confirm that IGW_AWARDS functions as the central award header within the IGW schema, aggregating proposal, funding, and Grants Accounting references while serving as the parent for installment and personnel support detail.