Search Results billing_term_id

Overview

IGW_AWARDS is a table within the Oracle E-Business Suite Grants Proposal module (product code IGW), which is documented as obsolete in the Oracle EBS 12.1.1 and 12.2.2 reference documentation. The table stores information about awards that have been transferred to Grants Accounting, functioning as a staging and tracking repository that bridges the proposal side of the grants lifecycle with the award management functionality in Oracle Grants Accounting (IGF). Because the module is marked obsolete, the object is not implemented in current Fusion or later EBS database instances, but it remains relevant to historical data migrations, upgrades, and legacy reporting in 12.1.1 and 12.2.2 environments.

From a data modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is satellite-leaning. This suggests IGW_AWARDS behaves primarily as a descriptive satellite that enriches a central business key (the proposal or award identity) with attributes such as dates, amounts, and distribution rules, rather than acting as a pure hub or a transactional link. Modelers designing an integrated reporting layer should therefore treat the table as an attribute-bearing satellite keyed to the proposal-award relationship.

Key Information Stored

The table contains 52 documented columns. Its surrogate primary key is PROPOSAL_AWARD_ID, enforced through the IGW_AWARDS_PK constraint and also exposed as a unique business-key candidate via the unique index IGW_AWARDS_U1. Key attribute columns include:

• PROPOSAL_ID — foreign key linking the record back to IGW_PROPOSALS_ALL, identifying the originating proposal.
• AWARD_ID — foreign key to IGF_AW_AWARD_ALL, anchoring the record to the canonical award in Grants Accounting.
• AWARD_NUMBER, AWARD_SHORT_NAME, AWARD_FULL_NAME — descriptive identifiers for the award as transferred.
• FUNDING_SOURCE_ID — foreign key to OKE_K_FUNDING_SOURCES, identifying the sponsoring funding source.
• FUNDING_SOURCE_AWARD_NUMBER — the external award reference number used by the sponsor.
• START_DATE, END_DATE, CLOSE_DATE — the award's performance period and close date for lifecycle tracking.
• AWARD_STATUS_CODE and AWARD_TYPE — status and classification codes governing the award's current state.
• AWARD_MANAGER_ID — the internal manager responsible for the award.
• REVENUE_DISTRIBUTION_RULE and BILLING_DISTRIBUTION_RULE — accounting distribution rules applied during receivables and billing.
• BILLING_TERM_ID and BILLING_CYCLE_ID — billing configuration inherited by the award.
• INDIRECT_SCHEDULE_ID and ALLOWABLE_SCHEDULE_ID — indirect cost and allowable cost schedules attached to the award.
• TRANSFERRED_FLAG and TRANSFER_AS — control columns indicating whether and how the award was transferred to Grants Accounting.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 — the standard EBS DFF (Descriptive Flexfield) segment set for extensible attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, RECORD_VERSION_NUMBER — standard WHO audit columns and optimistic locking.

Common Use Cases and Queries

Because IGW_AWARDS sits between the proposal and award domains, typical use cases include reconciling transferred proposals against their corresponding awards in IGF_AW_AWARD_ALL, auditing the transfer status of awards, and reporting on award financials by funding source. A reconstruction query joining the proposal and award may look like:

• SELECT a.PROPOSAL_AWARD_ID, p.PROPOSAL_NUMBER, a.AWARD_NUMBER, a.START_DATE, a.END_DATE, a.TRANSFERRED_FLAG FROM IGW_AWARDS a JOIN IGW_PROPOSALS_ALL p ON a.PROPOSAL_ID = p.PROPOSAL_ID;
• Filtering records pending transfer with WHERE TRANSFERRED_FLAG = 'N' to identify incomplete award staging.
• Joining to IGF_AW_AWARD_ALL on AWARD_ID to compare staged award attributes with the posted award record.
• Aggregating by FUNDING_SOURCE_ID, joined to OKE_K_FUNDING_SOURCES, to produce sponsor-level award summaries.
• Reporting on billing behavior grouped by BILLING_TERM_ID and BILLING_CYCLE_ID.

Related Objects

The following objects are the most significant in the IGW_AWARDS relationship graph:

• IGW_PROPOSALS_ALL — referenced via IGW_AWARDS.PROPOSAL_ID; the proposal master that precedes award creation.
• IGF_AW_AWARD_ALL — referenced via IGW_AWARDS.AWARD_ID; the canonical Grants Accounting award record.
• OKE_K_FUNDING_SOURCES — referenced via IGW_AWARDS.FUNDING_SOURCE_ID; the sponsor/funding source lookup.
• IGW_INSTALLMENTS — references IGW_AWARDS.PROPOSAL_AWARD_ID; child records for scheduled award installments.
• IGW_PROP_PERSON_SUPPORT — references IGW_AWARDS.PROPOSAL_AWARD_ID; personnel support allocations tied to the award.

Together these relationships confirm that IGW_AWARDS functions as a central satellite connecting proposals, awards, funding sources, and downstream installment and personnel data.