EGP_CATEGORIES_B

-- ============================================================
-- Table  : EGP_CATEGORIES_B — The category master — one row per category with its user-facing category code and active window; categories are global and keyed by CATEGORY_ID
-- Purpose: Column-selected read of EGP_CATEGORIES_B — auto-generated from field metadata
-- Grain  : One row per CATEGORY_ID
-- Notes  : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. 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.CATEGORY_ID AS "Category surrogate key",
  t.CATEGORY_CODE AS "The user-facing category code — the real identifier (the SEGMENTn columns are deprecated leftovers)",
  t.START_DATE_ACTIVE AS "Category active-from date",
  t.END_DATE_ACTIVE AS "Category active-to date",
  t.ENABLED_FLAG AS "Marked deprecated in the data dictionary — no longer used by the application"
FROM <catalog>.<schema>.EGP_CATEGORIES_B t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.CATEGORY_ID = <CATEGORY_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.CATEGORY_ID;