DimensionAttributeValue

-- ============================================================
-- Table  : DimensionAttributeValue One row per used value of a financial dimension — the middle hop that ties a value-set item back to the dimension it belongs to and the backing record that defines it
-- Purpose: Column-selected read of DimensionAttributeValue — auto-generated from field metadata
-- Grain  : One row per recid (surrogate key)
-- Notes  : Auto-generated skeleton for Synapse Link / Fabric Link-landed F&O data (lowercase column names). Enums decoded inline where verified; datetimes stored in UTC; 1900-01-01 dates are sentinels mapped to NULL. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
  d.dimensionattribute AS "RecId of the dimension in DimensionAttribute this value belongs to — the hop that tells you whether a value is a cost center or a department",
  d.entityinstance AS "RecId of the backing record (in the dimension's backing view) that defines this value",
  d.displayvalue AS "The dimension value code as displayed (e.g. the cost-center code)",
  d.issuspended AS "Whether the value is suspended and blocked from new postings",  -- enum: decode d.issuspended via GlobalOptionsetMetadata join — see quirks guide #enums
  d.isdeleted AS "Soft-delete flag — filter deleted values out of dimension lookups",  -- enum: decode d.isdeleted via GlobalOptionsetMetadata join — see quirks guide #enums
  d.activefrom AS "Date the value becomes valid for posting",
  d.activeto AS "Date the value stops being valid for posting",
  d.backingrecorddataareaid AS "Company of the backing record, populated for company-specific dimension values",
  d.recid AS "The 64-bit surrogate key DimensionAttributeValueSetItem.DimensionAttributeValue joins to"
FROM <catalog>.<schema>.dimensionattributevalue d
-- Resolve DimensionAttribute (via DimensionAttribute): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.dimensionattribute dim ON dim.recid = d.dimensionattribute
;