Results for “igw_installments_pk”

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

Overview

IGW_INSTALLMENTS is a transactional table within the Oracle E-Business Suite Grants Proposal (IGW) product family. It stores award installment schedules created against sponsored awards and serves as the staging bridge that transfers installment data from the Grants Proposal application into Grants Accounting. Each row represents a discrete installment line — including its amount split between direct and indirect cost, its validity window, and its billing characteristics — associated with a parent award.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key topology is satellite-leaning. The table carries a dependent, descriptive payload keyed to parent award and project funding structures rather than acting as an independent hub of business keys or a pure associative link. Practitioners designing downstream warehouses should consider treating IGW_INSTALLMENTS as a satellite attached to an award hub, with the installment identifier as a descriptive business key rather than a standalone enterprise key.

Key Information Stored

The table contains 19 documented columns. The most operationally significant are:

• PROPOSAL_INSTALLMENT_ID — the surrogate primary key defined by IGW_INSTALLMENTS_PK and reinforced by the unique index IGW_INSTALLMENTS_U1. This is the primary business-key candidate referenced by child tables.
• PROPOSAL_AWARD_ID — foreign key to IGW_AWARDS, identifying the award under which the installment is scheduled.
• INSTALLMENT_ID — foreign key to IGS_FI_PP_INSTLMNTS, linking the proposal installment to the corresponding Grants Accounting installment definition.
• INSTALLMENT_NUMBER — the sequential or logical position of the installment within the award schedule.
• INSTALLMENT_TYPE_CODE — classifies the installment (for example, billing versus funding pattern distinctions).
• ISSUE_DATE and CLOSE_DATE — the dates on which the installment becomes issuable and is closed.
• START_DATE and END_DATE — the service or performance period the installment covers.
• DIRECT_COST and INDIRECT_COST — the monetary split of the installment amount between direct and facilities-and-administrative components.
• BILLABLE_FLAG — indicates whether the installment is billable to the sponsor.
• DESCRIPTION — free-form text describing the installment.
• RECORD_VERSION_NUMBER — supports optimistic locking and change tracking.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — standard Oracle EBS audit columns capturing who created and last modified each row.

Common Use Cases and Queries

Typical reporting scenarios include installment schedules for an award, direct-versus-indirect cost breakdowns, billable installment tracking, and reconciliation between Grants Proposal schedules and their Grants Accounting counterparts.

• Retrieving all installments for a given award: SELECT * FROM IGW.IGW_INSTALLMENTS WHERE PROPOSAL_AWARD_ID = :award_id ORDER BY INSTALLMENT_NUMBER;
• Summarizing billed versus non-billed amounts by award: SELECT PROPOSAL_AWARD_ID, SUM(DIRECT_COST), SUM(INDIRECT_COST) FROM IGW.IGW_INSTALLMENTS WHERE BILLABLE_FLAG = 'Y' GROUP BY PROPOSAL_AWARD_ID;
• Reconciling proposal installments to accounting installments: SELECT i.PROPOSAL_INSTALLMENT_ID, i.INSTALLMENT_ID FROM IGW.IGW_INSTALLMENTS i JOIN IGS.IGS_FI_PP_INSTLMNTS p ON i.INSTALLMENT_ID = p.INSTALLMENT_ID;
• Identifying recently modified schedules via LAST_UPDATE_DATE for incremental ETL loads.

Related Objects

The FK and PK relationships reveal the core object graph around IGW_INSTALLMENTS:

• IGW_AWARDS — parent award referenced by PROPOSAL_AWARD_ID.
• IGS_FI_PP_INSTLMNTS — Grants Accounting installment definition referenced by INSTALLMENT_ID.
• IGW_PROJECT_FUNDINGS — child table referencing this table via PROPOSAL_INSTALLMENT_ID.
• IGW_AWARD_BUDGETS — child table also referencing this table via PROPOSAL_INSTALLMENT_ID.
• IGW_INSTALLMENTS_PK and IGW_INSTALLMENTS_U1 — the primary key constraint and unique index enforcing installment identity.