Search Results igw_org_details




Overview
Explore in AI Chat

Overview

IGW_ORG_DETAILS is a table within the IGW (Grants Proposal) product module of Oracle E-Business Suite, owned by the IGW schema. It stores organization-level detail records that support the Oracle Grants Proposal application, furnishing the institutional, financial, and regulatory attributes associated with organizations that participate in the grants and proposals lifecycle. The table is documented as VALID in both the 12.1.1 and 12.2.2 environments, and its physical schema is reported as containing 42 columns.

The primary key is defined by the constraint IGW_ORG_DETAILS_PK on the ORGANIZATION_ID column. The table carries a foreign key from IGW_ORG_DETAILS.ORGANIZATION_ID to HR_ALL_ORGANIZATION_UNITS, anchoring each row to a valid organization unit defined in the Human Resources foundation. A unique index, IGW_ORG_DETAILS_U1, also covers ORGANIZATION_ID, making it the sole documented business-key candidate.

Under the heuristic Data Vault classification mined from the foreign key structure, this table is characterized as satellite-leaning. As a modeling suggestion, this classification implies that IGW_ORG_DETAILS is best treated as a descriptive satellite attached to the ORGANIZATION_ID hub, rather than as an independent hub or a link table. The ORGANIZATION_ID column serves simultaneously as the primary key and the foreign key to HR_ALL_ORGANIZATION_UNITS, which is consistent with a one-row-per-organization extension of the organization hub.

Key Information Stored

Although the documented schema lists 42 columns, the most significant columns cluster into institutional identification, regulatory numbers, agreement and rate data, and audit attributes.

Common Use Cases and Queries

Typical reporting needs include retrieving the regulatory and identification profile of an organization, validating DUNS and EIN data for proposal submissions, and joining organization details to HR organization definitions for master data reconciliation. A representative query pattern is:

  • SELECT d.ORGANIZATION_ID, d.DUNS_NUMBER, d.EIN, d.CAGE_NUMBER FROM IGW.IGW_ORG_DETAILS d WHERE d.ORGANIZATION_ID = :org_id;
  • Joining to the HR foundation: SELECT h.NAME, d.EIN, d.NIH_SUBDIVISION_CODE FROM IGW.IGW_ORG_DETAILS d JOIN HR_ALL_ORGANIZATION_UNITS h ON h.ORGANIZATION_ID = d.ORGANIZATION_ID;
  • Audit reporting filtered by LAST_UPDATE_DATE to track recently modified organization detail records.

Related Objects

The following objects are most significant to IGW_ORG_DETAILS, based on the documented relationship data:

  • HR_ALL_ORGANIZATION_UNITS — The foreign table referenced by IGW_ORG_DETAILS.ORGANIZATION_ID, providing the parent organization unit definition.
  • IGW_ORG_DETAILS_PK — The primary key constraint on ORGANIZATION_ID.
  • IGW_ORG_DETAILS_U1 — The unique index on ORGANIZATION_ID serving as the business-key candidate.

Additional Grants Proposal tables within the IGW schema that consume organization identifiers may depend on this table's ORGANIZATION_ID values, since it supplies the institutional detail extension to the HR organization hub.