view: orch_app_ar_focus_track {
  sql_table_name: intelligence.dbt_prod.focus_track_pitch_grid ;;

  dimension: focus_track_name {
     type: string
     sql: ${TABLE}.track_name ;;
   }

  dimension: unique_track_id {
     type: number
     hidden: yes
     sql: ${TABLE}.unique_track_id ;;
     description: "Focus Track TUID"
   }

  dimension: release_id {
    type: number
    hidden: yes
    sql: ${TABLE}.release_id ;;
    description: "Release ID for Focus Track"
  }

  dimension: is_focus_track {
    type: yesno
    sql: ${orch_app_ar_focus_track.unique_track_id} IS NOT NULL ;;
    description: "Indicates whether this track is a focus track"
  }

  dimension: focus_track_isrc {
    type: string
    label: "Focus Track ISRC"
    sql: ${TABLE}.isrc ;;
    description: "focus track isrc"
  }
}