view: ar_product_physical_change_history_latest_changes_and_deletions {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."AR_PRODUCT_PHYSICAL_CHANGE_HISTORY_LATEST_CHANGES_AND_DELETIONS" ;;

  dimension_group: date_changed {
    group_label: "Latest Physical Change History"
    type: time
    timeframes: [date]
    sql: ${TABLE}."DATE_CHANGED" ;;
  }
  dimension_group: deletion {
    group_label: "Latest Physical Change History"
    type: time
    timeframes: [date]
    sql: ${TABLE}."DELETION_DATE" ;;
  }
  dimension: product_id {
    group_label: "Latest Physical Change History"
    hidden: yes
    type: number
    sql: ${TABLE}."PRODUCT_ID" ;;
  }

  dimension: field_name {
    type: string
    sql: ${TABLE}."FIELD_NAME";;
  }

  dimension: store_id  {
    type: string
    sql:  ${TABLE}."STORE_ID" ;;
  }
}