view: royalty_accounting_prod_vw_contract_denormalized {
  sql_table_name: ROYALTY_ACCOUNTING.PROD.VW_CONTRACT_DENORMALIZED ;;

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

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

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

  dimension: contract_term_id {
    view_label: "Contract Term"
    type: number
    sql: ${TABLE}.contract_term_id ;;
  }

  dimension: contract_term_condition_id {
    view_label: "Contract Term Condition"
    type: string
    sql: ${TABLE}.contract_term_condition_id ;;
  }

  dimension_group: contract_term_start {
    view_label: "Contract Term"
    type: time
    sql: ${TABLE}.contract_term_start ;;
    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: contract_term_end {
    view_label: "Contract Term"
    type: time
    sql: ${TABLE}.contract_term_end ;;
    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: term_type {
    view_label: "Contract Term"
    type: string
    sql: ${TABLE}.term_type ;;
  }

  dimension: term_rate {
    view_label: "Contract Term Condition"
    type: number
    sql: ${TABLE}.term_rate ;;
    value_format: "0.00"
  }

  dimension: term_label_id {
    view_label: "Contract Term"
    type: string
    sql: ${TABLE}.term_label_id ;;
  }

  dimension: term_upc {
    view_label: "Contract Term"
    type: string
    sql: ${TABLE}.term_upc ;;
  }

  dimension: term_isrc {
    view_label: "Contract Term"
    type: string
    sql: ${TABLE}.term_isrc ;;
  }

  dimension: country_id {
    view_label: "Contract Term Condition"
    type: number
    sql: ${TABLE}.country_id ;;
  }

  dimension: store_id {
    view_label: "Contract Term Condition"
    type: number
    sql: ${TABLE}.store_id ;;
  }

  dimension: transaction_type_id {
    view_label: "Contract Term Condition"
    type: string
    sql: ${TABLE}.transaction_type_id ;;
  }

  dimension: priority {
    view_label: "Contract Term Condition"
    type: string
    sql: ${TABLE}.priority ;;
  }

  dimension: run_controller_id {
    type: number
    view_label: "Run Controller"
    # hidden: yes
    sql: ${TABLE}.run_controller_id ;;
  }

  dimension: track_rank {
    type: number
    view_label: "Contract Term"
    label: "Rank - Track Term"
    sql: ${TABLE}.track_rank ;;
  }

  dimension: product_rank {
    type: number
    view_label: "Contract Term"
    label: "Rank - Product Term"
    sql: ${TABLE}.product_rank ;;
  }

  dimension: label_rank {
    type: number
    view_label: "Contract Term"
    label: "Rank - Label Term"
    sql: ${TABLE}.label_rank ;;
  }

  dimension: upc_dimension {
    type: string
    sql: coalesce(${term_upc}, ${facts_prod_dim_release.upc}) ;;
  }
}