view: performance_delivery_claiming_order {
  sql_table_name: ORCHARD_APP_REPORTING_V2.PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVERY.CLAIMING_ORDER ;;

  # =========================================================================
  # 1. PRIMARY KEYS & JOIN LINKS
  # =========================================================================
  dimension: id {
    primary_key: yes
    type: number
    sql: ${TABLE}.ID ;;
    label: "Order ID"
    description: "The primary unique identifier for the delivery claiming order."
  }

  dimension: customer_master_master_id {
    type: number
    sql: ${TABLE}.CUSTOMER_MASTER_MASTER_ID ;;
    label: "Customer Master ID Link"
    description: "Foreign key used to join back to global Customer Master view logs."
  }

  # =========================================================================
  # 2. RAW SYSTEM ORDER FIELDS
  # =========================================================================
  dimension: status {
    type: string
    sql: ${TABLE}.STATUS ;;
    group_label: "Order Status & Context"
    description: "The operational state status of the master execution delivery order."
  }

  dimension: created_by {
    type: string
    sql: ${TABLE}.CREATED_BY ;;
    group_label: "Order Status & Context"
    description: "System user who initiated this master order release request."
  }

  dimension: redeliver {
    type: yesno
    sql: ${TABLE}.REDELIVER ;;
    group_label: "Order Status & Context"
    description: "Flag indicating whether this represents a re-delivery execution pipeline attempt."
  }

  dimension: cmo_template_version {
    type: string
    sql: ${TABLE}.CMO_TEMPLATE_VERSION ;;
    group_label: "Order Status & Context"
    label: "CMO Template Version"
    description: "The Collective Management Organization layout configuration template format used."
  }

  dimension: output_file {
    type: string
    sql: ${TABLE}.OUTPUT_FILE ;;
    group_label: "Order Status & Context"
    description: "Master output filename data payload pushed to destination endpoints."
  }

  dimension: message_raw {
    type: string
    sql: TO_VARCHAR(${TABLE}.MESSAGE) ;;
    group_label: "Order Status & Context"
    label: "Order Message JSON"
    description: "Raw structural message variants returned during checkout generation."
  }

  # =========================================================================
  # 3. DATE / TIMESTAMPS
  # =========================================================================
  dimension_group: created {
    type: time
    timeframes: [raw, time, date, week, month, quarter, year]
    datatype: timestamp
    sql: ${TABLE}.CREATED_AT ;;
    group_label: "Order History Logs"
  }

  dimension_group: last_updated {
    type: time
    timeframes: [raw, time, date, week, month, quarter, year]
    datatype: timestamp
    sql: ${TABLE}.LAST_UPDATED ;;
    group_label: "Order History Logs"
  }

  # =========================================================================
  # 4. SYSTEM METADATA TIMESTAMPS (Hidden)
  # =========================================================================
  dimension: _fivetran_deleted { type: yesno sql: ${TABLE}._FIVETRAN_DELETED ;; group_label: "System Metadata" hidden: yes }
  dimension_group: _fivetran_synced { type: time timeframes: [raw, date] datatype: timestamp sql: ${TABLE}._FIVETRAN_SYNCED ;; group_label: "System Metadata" hidden: yes }

  # =========================================================================
  # 5. AGGREGATIONS / MEASURES
  # =========================================================================
  measure: order_count {
    type: count
    description: "The total number of unique delivery orders logged."
  }
}