view: int_prod_vw_deleted_labels {
  sql_table_name: intelligence.prod.vw_deleted_labels ;;

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

  dimension: date_deleted_fd {
    type: date
    sql: ${TABLE}.date_deleted_fd ;;
    view_label: "Label"
    group_label: "Deleted Date"
    label: "by Full Deletions"
    description: "The operational Deleted Date, derived from when the last release was updated for full deletion within a label's entire catalog"
  }

  dimension: date_deleted_sc {
    type: date
    sql: ${TABLE}.date_deleted_sc ;;
    view_label: "Label"
    group_label: "Deleted Date"
    label: "by Status Change"
    description: "The legal Deleted Date, upon which a label's status was changed from 'signed' to 'deletion'"
  }

  dimension: label_is_deleted {
    type: yesno
    sql: IFF(${TABLE}.label_id IS NULL, FALSE, TRUE) ;;
    view_label: "Label"
    group_label: "Deleted Date"
    label: "Has Deleted Date"
  }
}