view: performance_delivery_claiming_job {
  sql_table_name: ORCHARD_APP_REPORTING_V2.PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVERY.CLAIMING_JOB ;;

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

  dimension: order_id {
    type: number
    sql: ${TABLE}.ORDER_ID ;;
    label: "Order ID"
    description: "Foreign key linking directly to delivery_claiming_order.id."
  }

  dimension: contributor_uuid {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_UUID ;;
    label: "Contributor UUID"
    description: "Foreign key linking directly back to the Salesforce or Content contributor directory."
  }

  # =========================================================================
  # 2. RAW OPERATIONAL & AUDIT FIELDS
  # =========================================================================
  dimension: status {
    type: string
    sql: ${TABLE}.STATUS ;;
    group_label: "Job Status & Files"
    description: "The current execution processing status of this claiming job."
  }

  dimension: last_updated_by {
    type: string
    sql: ${TABLE}.LAST_UPDATED_BY ;;
    group_label: "Job Status & Files"
    description: "System user identifier who triggered the last modification state."
  }

  dimension: success_file {
    type: string
    sql: ${TABLE}.SUCCESS_FILE ;;
    group_label: "Job Audit Files"
    description: "Filename/path for successful execution delivery file payloads."
  }

  dimension: error_file {
    type: string
    sql: ${TABLE}.ERROR_FILE ;;
    group_label: "Job Audit Files"
    description: "Filename/path mapping for error execution error telemetry."
  }

  dimension: exclusion_file {
    type: string
    sql: ${TABLE}.EXCLUSION_FILE ;;
    group_label: "Job Audit Files"
    description: "Filename or pointer mapping for rows/records filtered during preflight."
  }

  # =========================================================================
  # 3. DATE / TIMESTAMPS
  # =========================================================================
  dimension_group: last_updated {
    type: time
    timeframes: [raw, time, date, week, month, quarter, year]
    datatype: timestamp
    sql: ${TABLE}.LAST_UPDATED ;;
    group_label: "Job 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: job_count {
    type: count
    description: "The total number of orchestrated delivery claiming jobs processed."
  }
}