view: ownership_delivery_jobs {
  sql_table_name: ORCHARD_APP_REPORTING_V2.PROD_NR_OWNERSHIP_DELIVERY_NEIGHBOURING_RIGHTS_OWNERSHIP_DELIVERY.JOBS ;;

  # =========================================================================
  # 1. PRIMARY KEYS & COUPLING LINKS
  # =========================================================================
  dimension: id {
    primary_key: yes
    type: number
    sql: ${TABLE}.ID ;;
    label: "Job ID"
    description: "The primary unique immutable identifier for an execution pipeline job run."
  }

  dimension: order_id {
    type: number
    sql: ${TABLE}.ORDER_ID ;;
    label: "Order ID Link"
    description: "Foreign key joining directly back to ownership_delivery_orders.id."
  }

  # =========================================================================
  # 2. RAW OPERATIONAL FIELDS
  # =========================================================================
  dimension: status {
    type: string
    sql: ${TABLE}.STATUS ;;
    group_label: "Job Run Parameters"
    description: "The run state processing status of this job instance."
  }

  dimension: type {
    type: string
    sql: ${TABLE}.TYPE ;;
    group_label: "Job Run Parameters"
    label: "Job Run Type"
    description: "Categorical processing run designation strategy applied to the job."
  }

  dimension: entity_name {
    type: string
    sql: ${TABLE}.ENTITY_NAME ;;
    group_label: "Job Run Parameters"
    description: "The legal or collection society corporate name targeted by the script release."
  }

  dimension: delivery_completed {
    type: yesno
    sql: ${TABLE}.DELIVERY_COMPLETED ;;
    group_label: "Job Run Parameters"
    description: "Flag indicating whether the file package reached the destination end system successfully."
  }

  dimension: instance_count {
    type: number
    sql: ${TABLE}.INSTANCE_COUNT ;;
    group_label: "Job Run Parameters"
    description: "The aggregate quantity tracking volume metrics bundled inside the operation pass."
  }

  dimension: job_file_url {
    type: string
    sql: ${TABLE}.JOB_FILE_URL ;;
    group_label: "Assets & File Links"
    label: "Job Output Document URL"
    description: "Secure path location pointing to the manifest asset output produced by the processor."
  }

  dimension: last_updated_by {
    type: string
    sql: ${TABLE}.LAST_UPDATED_BY ;;
    group_label: "Job Audit Context"
    hidden: yes
  }

  # =========================================================================
  # 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 Audit Context"
  }

  # =========================================================================
  # 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. MEASURES
  # =========================================================================
  measure: job_count {
    type: count
    description: "The total number of orchestrated technical delivery processing jobs."
  }
}