view: int_dev_smoore_o_o {
  sql_table_name: intelligence.dev.owned_and_operated_artist_royalty_rates ;;

  dimension: isrc {
    hidden: yes
    view_label: "Owned & Operated"
    label: "Artist Royalty Percentage ISRC"
    type: string
    sql: ${TABLE}.ISRC ;;
  }

  dimension: upc {
    hidden: yes
    view_label: "Owned & Operated"
    type: string
    sql: ${TABLE}.UPC ;;
  }

  dimension: artist_royalty_percentage {
    view_label: "Owned & Operated"
    label: "O&O Artist Royalty Percentage"
    type: string
    #value_format_name: decimal_4
    sql: ${TABLE}.ARTIST_ROYALTY_PERCENTAGE ;;
  }

  dimension: streaming_rate {
    view_label: "Owned & Operated"
    label: "O&O Streaming Rate"
    type: number
    sql: ${TABLE}.STREAMING_RATE ;;
  }

  dimension: isrc_available {
    view_label: "Xtra Advanced Fields"
    hidden:  yes
    label: "Track Has O&O Artist Royalty Percentage? (Yes/No)"
    type: string
    sql: case when ${TABLE}.isrc is null THEN 'No'
         Else 'Yes'
        END;;
  }

}