view: stmt_db_prod_remaps_physical {

    sql_table_name: STMT_DB.PROD.REMAPS_PHYSICAL ;;

  dimension: old_upc {
    type: number
    sql: ${TABLE}.old_upc ;;
  }

  dimension: new_upc {
    type: number
    sql: ${TABLE}.new_upc ;;
  }

  dimension_group: start_date{
    label:"Start"
    type: time
    sql:${TABLE}.start_date;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }

  dimension_group: end_date{
    label:"End"
    type: time
    sql:${TABLE}.start_date;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }

  dimension: territory_flag {
    type: string
    sql: ${TABLE}.territory_flag ;;
  }

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

  dimension: active {
    type: string
    sql: ${TABLE}.active ;;
  }

  dimension: notes {
    type: string
    sql: ${TABLE}.notes ;;
  }
}