Results for “igr_i_e_orgunits”

21 results




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

Overview

IGR_I_E_ORGUNITS is a transactional table in the Oracle E-Business Suite Student System (IGS) product family, owned by the IGS schema. It stores organization units corresponding to inquiry types, functioning as the association layer between higher-education recruitment inquiries and the organizational structures responsible for handling them. In the Oracle EBS 12.1.1 and 12.2.2 releases, this table is part of the recruiting and admissions inquiry infrastructure, supporting prospect tracking and inquiry routing at institutions using Oracle Student System.

Under the heuristic Data Vault classification derived from its foreign-key topology, IGR_I_E_ORGUNITS is best modeled as a link entity. This classification reflects its role as an intersection table that resolves the many-to-many relationship between inquiry types and the party (organization unit) records that manage them. It is not a standalone hub of business entities, nor a pure satellite, because its primary identity derives from the combination of referenced entities plus a composite business key.

Key Information Stored

The documented physical schema contains ten columns. The most significant are summarized below.

  • ENT_ORG_UNIT_ID — Surrogate primary key, enforced by IGR_I_E_ORGUNITS_PK. It provides the row-level identity used for internal joins and referential integrity.
  • INQUIRY_TYPE_ID — Identifies the inquiry type associated with the organization unit. This column participates in the composite business key and is a foreign-key candidate to the inquiry type reference entity (shown as "%" in the mined metadata, indicating an unresolved parent).
  • PARTY_ID — Foreign key to HZ_PARTIES, linking the row to the Trading Community Architecture party record that represents the organization unit. This is the anchor that ties recruiting setup data into the shared HZ party model.
  • INQ_ENTRY_STAT_ID — Status identifier for the inquiry entry, supporting workflow or lifecycle states for the organization unit's inquiry handling.
  • CLOSED_IND — Indicator flag denoting whether the organization unit's association with the inquiry type is closed or inactive.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture Who columns consistent with the Oracle EBS standard audit convention.

The unique index IGR_I_E_ORGUNITS_UK on (INQUIRY_TYPE_ID, PARTY_ID) is the business-key candidate, ensuring a given party is associated with a given inquiry type only once. The surrogate ENT_ORG_UNIT_ID exists independently of this natural key.

Common Use Cases and Queries

Typical use cases include prospecting and inquiry routing reports, admissions workload analysis by organizational unit, and recruitment configuration validation. A representative query retrieves the organizational units assigned to a given inquiry type:

  • Join IGR_I_E_ORGUNITS to HZ_PARTIES on PARTY_ID to resolve the organization unit name and party details.
  • Filter on CLOSED_IND = 'N' to return only active assignments.
  • Group by INQUIRY_TYPE_ID to count organization units per inquiry type for coverage analysis.

Sample pattern: SELECT o.ENT_ORG_UNIT_ID, o.INQUIRY_TYPE_ID, p.party_name FROM igs.igr_i_e_orgunits o, hz_parties p WHERE o.party_id = p.party_id AND o.closed_ind = 'N'; Reporting on inquiry assignment coverage by unit supports recruitment planning and is frequently extracted to a data warehouse.

Related Objects

The principal related objects are:

  • HZ_PARTIES — Referenced via IGR_I_E_ORGUNITS.PARTY_ID; supplies the organization unit identity and name.
  • Inquiry type reference table — Referenced via IGR_I_E_ORGUNITS.INQUIRY_TYPE_ID (parent unresolved in the mined metadata).
  • IGR_I_E_ORGUNITS_PK / IGR_I_E_ORGUNITS_UK — Primary and unique indexes enforcing row identity and the (INQUIRY_TYPE_ID, PARTY_ID) business key.
  • Inquiry entry status entity — Related through INQ_ENTRY_STAT_ID, providing status context.
  • IGS recruiting inquiry tables — Other IGR inquiry structures that share the inquiry type and party dimensions for integrated recruitment reporting.