view: int_dbt_prod_awal_applications_model {
 sql_table_name: INTELLIGENCE.DBT_PROD.AWAL_APPLICATIONS_MODEL ;;

dimension: status {
  view_label: "Application"
  type: string
  sql: ${TABLE}.status ;;
}

  dimension: id {
    view_label: "Application"
    type: string
    sql: ${TABLE}.id ;;
  }

  dimension: proffessional_name {
    view_label: "Application"
    type: string
    sql: ${TABLE}.proffessional_name ;;
  }

  dimension_group: submission_date {
    view_label: "Date"
    sql: ${TABLE}.submission_date ;;
    type: time
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num
    ]
  }

  dimension_group: created_date {
    view_label: "Date"
    sql: ${TABLE}.created_date ;;
    type: time
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num
    ]
  }

  dimension_group: modified_date {
    view_label: "Date"
    sql: ${TABLE}.modified_date ;;
    type: time
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num
    ]
  }

  dimension: terminated_date {
    view_label: "Date"
    sql: ${TABLE}.terminated_date ;;
    type: date
  }

  dimension_group: date_from {
    view_label: "Date"
    sql: ${TABLE}.date_from ;;
    type: time
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num
    ]
  }

  dimension_group: date_to {
    view_label: "Date"
    sql: ${TABLE}.date_to ;;
    type: time
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num
    ]
  }

  # dimension: country {
  #   view_label: "Application"
  #   type: string
  #   sql: ${TABLE}.country ;;
  # }
}