Search Results organization_type_code

Overview

IGW.IGW_ORG_TYPES is a reference table in the Oracle E-Business Suite (EBS) Grants/IGW schema that stores the classification of an organization by one or more organization types. Each row associates a specific organization, identified by ORGANIZATION_ID, with a particular type code, identified by ORGANIZATION_TYPE_CODE. The Organization Types list of values in EBS includes values such as minority-owned businesses, nonprofit organizations, and Federal facilities. In this manner, the table enables agencies and grantors to categorize the entities they fund, contract with, or track for regulatory and reporting purposes.

From a data-modeling perspective, the mined relationship data classifies IGW_ORG_TYPES as satellite-leaning. First, the surrogate combination of ORGANIZATION_ID and ORGANIZATION_TYPE_CODE acts as the primary key (IGW_ORG_TYPE_PK), meaning each organization-to-type pairing is stored as a discrete row. Because the table extends the description of the referenced organization (from HR_ALL_ORGANIZATION_UNITS) with additional classifying attributes, while its own key includes that foreign reference, it is best modeled as a satellite attached to the organization hub, with the type code serving as part of the descriptive payload rather than a standalone business entity.

Key Information Stored

Of the seven documented columns, the following are the most important for querying and integration:

• ORGANIZATION_ID (NUMBER 15, mandatory) — The organization identifier. This is the surrogate key referencing HR_ALL_ORGANIZATION_UNITS and, together with the organization type code, forms primary key IGW_ORG_TYPE_PK.
• ORGANIZATION_TYPE_CODE (VARCHAR2 30, mandatory) — The organization-type classification applied to the entity. Valid values are drawn from the lookups IGW_ORGANIZATION_TYPES, which makes the code a controlled business key candidate rather than a surrogate.
• LAST_UPDATE_DATE (DATE) — Standard Who column recording the most recent change to the row.
• LAST_UPDATED_BY (NUMBER 15) — Standard Who column identifying the user who made the most recent change.
• CREATION_DATE (DATE) — Standard Who column recording when the row was inserted.
• CREATED_BY (NUMBER 15) — Standard Who column identifying the user who created the row.
• LAST_UPDATE_LOGIN (NUMBER 15) — Standard Who column capturing the login session associated with the last update.

The unique index IGW_ORG_TYPES_U1 (ORGANIZATION_ID, ORGANIZATION_TYPE_CODE) in tablespace APPS_TS_TX_IDX enforces the business-key uniqueness of each organization/type pairing. Because the same columns also define the primary key, there is no separate surrogate sequence identifier beyond ORGANIZATION_ID.

Common Use Cases and Queries

The primary use case is classification lookup and cross-reference. Common patterns include:

• Listing all organization types assigned to a given organization: SELECT organization_type_code FROM igw.igw_org_types WHERE organization_id = :org_id;
• Counting organizations of a given type for reporting: SELECT organization_type_code, COUNT(*) FROM igw.igw_org_types GROUP BY organization_type_code;
• Joining back to the organization unit to obtain the name: SELECT o.organization_id, o.name, t.organization_type_code FROM hr_all_organization_units o JOIN igw.igw_org_types t ON t.organization_id = o.organization_id;

These patterns support certification reporting (for example, tracking minority- or women-owned entities), compliance monitoring, and grant/contract eligibility analysis. Because the table carries Standard Who columns, change-audit reports can also be built around LAST_UPDATE_DATE, LAST_UPDATED_BY, and CREATED_BY.

Related Objects

The most significant related objects include:

• HR_ALL_ORGANIZATION_UNITS — referenced by IGW_ORG_TYPES.ORGANIZATION_ID; provides organization names, dates, and status for descriptive joins.
• IGW_ORG_TYPES (APPS synonym/view) — the APPS-level exposure referenced by IGW.IGW_ORG_TYPES, commonly queried by form and report logic.

Because the FK association is limited to HR_ALL_ORGANIZATION_UNITS and the documented dependency section records no other references, downstream satellite usage should be confirmed against the IGW_ORGANIZATION_TYPES lookup and any grants/administration tables that consume the type code for eligibility logic.