F0005

-- ============================================================
-- Table  : F0005 User defined code values — the lookup rows behind every UDC-validated field, keyed by system, type, and code
-- Purpose: Column-selected read of F0005 — auto-generated from field metadata
-- Grain  : One row per DRSY + DRRT + DRKY
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  udc.DRSY AS "System code of the UDC table",
  udc.DRRT AS "User defined code type within the system",
  TRIM(udc.DRKY) AS "The code value itself; short/numeric codes are stored right-justified with leading blanks - TRIM before joining",
  udc.DRDL01 AS "Code description",
  udc.DRDL02 AS "Second description line",
  udc.DRSPHD AS "Special handling code - extra behavior many programs key off",
  udc.DRUDCO AS "Ownership flag distinguishing Oracle-delivered vs customer codes",
  udc.DRHRDC AS "Hard coded flag - Y means programs depend on this exact value"
FROM <catalog>.<schema_ctl>.f0005 udc
ORDER BY udc.DRSY;