view: orch_app_ar_vendor_agreement {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.vendor_agreement ;;

  dimension: vendor_agreement_id {
    type: number
    sql: ${TABLE}.vendor_agreement_id ;;
    primary_key: yes
    hidden: yes
  }

  dimension: vendor_id {
    type: number
    sql: ${TABLE}.vendor_id ;;
    hidden: yes
  }

  dimension: user_id {
    type: number
    sql: ${TABLE}.user_id ;;
    hidden: yes
  }

  dimension: opted_in {
    type: yesno
    sql: IFF(${TABLE}.opt_in_preference_id = 1, TRUE, FALSE) ;;
    group_label: "Marketing Agreement"
  }

  dimension: opted_in_date {
    type: date_time
    sql: ${TABLE}.date_accepted ;;
    group_label: "Marketing Agreement"
  }

  dimension: impersonator_user_id {
    type: number
    sql: ${TABLE}.impersonator_user_id ;;
    group_label: "Marketing Agreement"
  }
}