view: int_prod_vw_active_vendor_contract {
  sql_table_name: intelligence.dbt_prod.active_vendor_contracts ;;

  dimension: vendor_id {
    label: "Label ID"
    type: number
    sql: ${TABLE}.vendor_id ;;
    hidden: yes
  }

  dimension: vendor_contract_id {
    label: "Label Contract ID"
    type: number
    sql: ${TABLE}.vendor_contract_id ;;
    hidden: yes
  }

  dimension: active_label {
    view_label: "Label"
    label: "Is Active"
    type: yesno
    sql: IFF(${TABLE}.vendor_id IS NULL, FALSE, TRUE) ;;
  }

  dimension: active_contract {
    view_label: "Label Contract"
    label: "Is Active"
    type: yesno
    sql: IFF(${TABLE}.vendor_contract_id IS NULL, FALSE, TRUE) ;;
  }
}