view: facts_prod_registry_audit {
  sql_table_name: facts.prod.registry_audit ;;

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

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

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

  dimension: user {
    type: string
    label: "User"
    group_label: "Master Rights"
    sql: ${TABLE}.user;;
    hidden: no
  }

  dimension: timestamp {
    type: date
    label: "Timestamp"
    group_label: "Master Rights"
    sql: ${TABLE}.timestamp;;
  }

  dimension: oa_user {
    type: number
    label: "OA User ID"
    group_label: "Master Rights"
    sql: case
    when ${TABLE}.user like '%oa%' then split_part(${TABLE}.user,':',-1)
    when ${TABLE}.user not like '%:%' then ${TABLE}.user
    else null
    end;;
    hidden: yes
  }

}