view: facts_prod_registry_locked {
  sql_table_name: facts.prod.registry_locked ;;

  dimension: isrc {
    type: string
    hidden: yes
    sql: ${TABLE}.isrc ;;
  }

  dimension: territory {
    label: "Locked Territory"
    group_label: "Master Rights"
    type: string
    sql: ${TABLE}.territory ;;
  }

  dimension: lock_reason {
    label: "Locked Reason"
    group_label: "Master Rights"
    type: string
    sql: ${TABLE}.lock_reason ;;
  }

  dimension: isrc_locked_in_registry {
    type: yesno
    sql: IFF(${TABLE}.isrc IS NULL, FALSE, TRUE) ;;
    group_label: "Master Rights"
  }

  measure: locked_territory_list{
    description: "List of Territories"
    type: list
    list_field: territory
  }

}