view: int_dbt_prod_vendor_contract_changes_missing_royalty_country_codes {
  sql_table_name:INTELLIGENCE.DBT_PROD.VENDOR_CONTRACT_CHANGE_HISTORY_MISSING_ROYALTY_COUNTRY_CODES  ;;

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

  dimension: missing_codes {
    type: string
    label: "Missing Country Codes"
    description: "The country codes missing from Royalty Collection Territories"
    sql: ${TABLE}.missing_codes ;;
  }

  dimension: existing_codes {
    type: string
    label: "Existing Country Codes"
    description: "List of country codes included in Royalty Collection Territories"
    sql: ${TABLE}.existing_codes ;;
  }

  dimension: has_all_codes {
    type: yesno
    label: "All Countries included"
    description: "Yes, where all countries are included in the Royalty Collection Territories"
    sql: ${TABLE}.has_all_codes ;;
  }
 }