HR_ORGANIZATION_INFORMATION
Schema: HRcontrolPer inventory orgClassification rows for each organization unit — which orgs are operating units, inventory orgs, or legal entities, and the per-classification attributes, keyed by a context code with generic attribute columns
Multi-org structure is encoded here as context-discriminated generic columns — the same physical column changes meaning per context, so read it through the delivered views (HR_OPERATING_UNITS, ORG_ORGANIZATION_DEFINITIONS) unless you know the contexts.
What the badges mean
- master
- Data class: what the table holds — master data, transaction documents, control/configuration, interface/staging, or an APPS-schema view.
Fields
6 fields · 1 key
| # | Field | Description | Type | Flags |
|---|---|---|---|---|
| 1 | ORG_INFORMATION_ID | Surrogate key of the classification/attribute row | NUMBER | Key |
| 2 | ORGANIZATION_ID | The organization this row classifies — joins to HR_ALL_ORGANIZATION_UNITS | NUMBER | |
| 3 | ORG_INFORMATION_CONTEXT | The context code that decides what the generic columns mean on this row | VARCHAR2 | |
| 4 | ORG_INFORMATION1 | Generic attribute 1 — meaning depends on the context | VARCHAR2 | |
| 5 | ORG_INFORMATION2 | Generic attribute 2 — meaning depends on the context | VARCHAR2 | |
| 6 | ORG_INFORMATION3 | Generic attribute 3 — meaning depends on the context | VARCHAR2 |
Field provenance: hand-curated. 1 key field.
Boilerplate SQL
Starting point for reading HR_ORGANIZATION_INFORMATIONon Databricks — real DATE columns need no conversion, and the org anchor and the LAST_UPDATE_DATE watermark are already in place. Set your Unity Catalog location, schema, and org values below; they’re substituted into the SQL and the copy button.
-- ============================================================
-- Table : HR_ORGANIZATION_INFORMATION — Classification rows for each organization unit — which orgs are operating units, inventory orgs, or legal entities, and the per-classification attributes, keyed by a context code with generic attribute columns
-- Purpose: Column-selected read of HR_ORGANIZATION_INFORMATION — auto-generated from field metadata
-- Grain : One row per inventory org (ORGANIZATION_ID) + ORG_INFORMATION_ID
-- Notes : Auto-generated skeleton for Oracle EBS R12 data landed in your lakehouse. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts.
-- ============================================================
SELECT
t.ORG_INFORMATION_ID AS "Surrogate key of the classification/attribute row",
t.ORGANIZATION_ID AS "The organization this row classifies — joins to HR_ALL_ORGANIZATION_UNITS",
t.ORG_INFORMATION_CONTEXT AS "The context code that decides what the generic columns mean on this row",
t.ORG_INFORMATION1 AS "Generic attribute 1 — meaning depends on the context",
t.ORG_INFORMATION2 AS "Generic attribute 2 — meaning depends on the context",
t.ORG_INFORMATION3 AS "Generic attribute 3 — meaning depends on the context"
FROM <catalog>.<schema>.HR_ORGANIZATION_INFORMATION t
WHERE
t.ORGANIZATION_ID = <inventory_org_id> -- inventory org, NOT the operating unit — see quirks guide #two-orgs
-- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>' -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.ORG_INFORMATION_ID;4 parameters not filled: <catalog>, <schema>, <inventory_org_id>, <watermark>
Relationships
1-hop neighbors — click a table to navigate there. FND lookup decode and translation edges are highlighted; they’re the joins newcomers most often get wrong.
Join details
ON HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID = HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID