HR_ORGANIZATION_INFORMATION

-- ============================================================
-- 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;