Search Results igw_org_type_pk

Overview

IGW_ORG_TYPES is a table within the IGW — Grants Proposal product family in Oracle E-Business Suite. The ETRM metadata classifies IGW as Obsolete in the 12.1.1 and 12.2.2 releases, and the object is documented as Not implemented in this database. Its declared purpose is to store information about organization types — that is, the classification of an operating unit, business group, or other organization unit against one or more type codes used by the Grants Proposal application.

From a dimensional or Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is satellite-leaning. This is a modeling suggestion rather than a documented fact: the table carries descriptive attributes keyed by an organization identifier supplied from a parent entity, and it holds no independent business identity of its own. In a Data Vault design it would most naturally be modeled as a satellite attached to an organization hub, where the hub would be sourced from HR_ALL_ORGANIZATION_UNITS.

Because the product is obsolete and the table is not implemented in supported databases, references to IGW_ORG_TYPES generally appear in legacy scripts, historical migration notes, or ETRM documentation lookups rather than in active 12.1.1 / 12.2.2 code paths.

Key Information Stored

The documented physical schema describes an owner of IGW with seven columns. The primary key constraint is IGW_ORG_TYPE_PK, defined over the composite of ORGANIZATION_ID and ORGANIZATION_TYPE_CODE. A unique index, IGW_ORG_TYPES_U1, is defined over the same two columns and therefore constitutes the documented business-key candidate.

• ORGANIZATION_ID — Identifies the organization unit being classified. This column is also the foreign key to HR_ALL_ORGANIZATION_UNITS and forms the leading column of the primary key and the unique index.
• ORGANIZATION_TYPE_CODE — The type classification assigned to the organization. It forms the trailing column of the composite primary key and the unique index, meaning a single organization may carry multiple distinct type codes.
• LAST_UPDATE_DATE — Standard EBS audit column recording the most recent modification timestamp.
• LAST_UPDATED_BY — Standard EBS audit column identifying the user who last modified the row.
• CREATION_DATE — Standard EBS audit column recording when the row was inserted.
• CREATED_BY — Standard EBS audit column identifying the user who created the row.
• LAST_UPDATE_LOGIN — Standard EBS audit column capturing the login that performed the last update.

No descriptive or denormalized name column is documented; the type is carried only as a code.

Common Use Cases and Queries

In legacy Grants Proposal implementations, this table would be joined to the organization master to filter organizations by type — for example, restricting proposal processing to a specific class of organization unit. The dominant access path is by ORGANIZATION_ID, since that is the leading key column.

• Retrieving all types for one organization: SELECT organization_type_code FROM igw_org_types WHERE organization_id = :org_id;
• Filtering organizations by type through the master table: SELECT hou.name, iot.organization_type_code FROM hr_all_organization_units hou, igw_org_types iot WHERE hou.organization_id = iot.organization_id AND iot.organization_type_code = :type_code;
• Detecting organizations with no type assignment, useful when auditing legacy data before migration: an outer join from HR_ALL_ORGANIZATION_UNITS to IGW_ORG_TYPES where the type code is null.
• Change tracking for audit reporting, using LAST_UPDATE_DATE and LAST_UPDATED_BY as the standard EBS audited columns.

Because the table is obsolete and not implemented, these patterns should be validated against the target environment before being relied upon in a supported release.

Related Objects

The documented foreign-key relationship and the surrounding Grants Proposal schema define the most significant associated objects:

• HR_ALL_ORGANIZATION_UNITS — The parent organization master. The FK is IGW_ORG_TYPES.ORGANIZATION_ID referencing HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID, and this is the only documented join path.
• IGW_ORG_TYPE_PK — The primary key constraint over (ORGANIZATION_ID, ORGANIZATION_TYPE_CODE).
• IGW_ORG_TYPES_U1 — The unique index over (ORGANIZATION_ID, ORGANIZATION_TYPE_CODE), acting as the business-key candidate.
• Other IGW Grants Proposal tables keyed to the same organization identifier, which would share the ORGANIZATION_ID column and follow the same satellite pattern.

Given the obsolete status, no supported application programming interface is documented for this object, and integration should target HR_ALL_ORGANIZATION_UNITS or its successors instead.