view: stmt_db_collections_substores {
  sql_table_name: collections_substores ;;

  dimension: row_id {
    description: "Unique ID for each row"
    type: number
    sql: ${TABLE}.row_id ;;
    primary_key: yes
    hidden: yes
  }

  dimension: grouping {
    description: "Short grouping name used in Actual Statement Name based on mapping provided by PC team. Same as used in collections_sub_transactions table, so this one is hidden."
    type: string
    sql: ${TABLE}.grouping_type ;;
    label: "Perf Rights Grouping 2"
    hidden:  yes
  }

  dimension: substore {
    description: "Substore name based on grouping name. Will not work for all societies. For updates to this, email becca@theorchard.com."
    label: "Perf Rights Substore Name"
    type: string
    sql: ${TABLE}.substore ;;
  }

}