Epic Loan History

view: epic_loan_history {
  sql_table_name: GenericLoanHistory ;;

  dimension: calc_outstanding_csofee {
    sql: ${TABLE}.Calc_OutstandingFee ;;
  }

  dimension: discount_finance_fee {
    sql: ${TABLE}.DiscountFinanceFee ;;
  }

  dimension: discount_late_fee {
    sql: ${TABLE}.DiscountLateFee ;;
  }

  dimension: discount_nsf_fee {
    sql: ${TABLE}.DiscountNsfFee ;;
  }

  dimension: discount_principle {
    sql: ${TABLE}.DiscountPrinciple ;;
  }

  dimension: effective {
    type: time
    sql: ${TABLE}.EffectiveDate ;;
  }

  dimension: loan_history_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.LoanHistoryId ;;
  }

  dimension: loan_id {
    type: int
    sql: ${TABLE}.LoanId ;;
  }

  dimension: loan_status {
    sql: ${TABLE}.LoanStatus ;;
  }

  dimension: outstanding_finance_fee {
    sql: ${TABLE}.OutstandingFinanceFee ;;
  }

  dimension: outstanding_late_fee {
    sql: ${TABLE}.OutstandingLateFee ;;
  }

  dimension: outstanding_nsf_fee {
    sql: ${TABLE}.OutstandingNsfFee ;;
  }

  dimension: outstanding_total {
    sql: ${TABLE}.OutstandingTotal ;;
  }

  dimension: paid_off_finance_fee {
    sql: ${TABLE}.PaidOffFinanceFee ;;
  }

  dimension: paid_off_late_fee {
    sql: ${TABLE}.PaidOffLateFee ;;
  }

  dimension: paid_off_nsf_fee {
    sql: ${TABLE}.PaidOffNsfFee ;;
  }

  dimension: paid_off_principle {
    sql: ${TABLE}.PaidOffPrinciple ;;
  }

  dimension: settlement_finance_fee {
    sql: ${TABLE}.SettlementFinanceFee ;;
  }

  dimension: settlement_late_fee {
    sql: ${TABLE}.SettlementLateFee ;;
  }

  dimension: settlement_nsf_fee {
    sql: ${TABLE}.SettlementNsfFee ;;
  }

  dimension: settlement_principle {
    sql: ${TABLE}.SettlementPrinciple ;;
  }

  dimension: vw_loan_history_id {
    type: int
    sql: ${TABLE}.view_LoanHistory_Id ;;
  }

  dimension_group: date_copied_from_epic_dart {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.DateCopiedFromGenericDart ;;
  }

  measure: count {
    type: count
  }

  measure: outstanding_principle_amount {
    type: sum
    sql: ${TABLE}.OutstandingPrinciple ;;
  }

  measure: outstanding_principle_div1m {
    label: "Balance Outstanding"
    type: number
    value_format: "#.00"
    sql: (${outstanding_principle_amount}) / 1000000.00 ;;
  }
}

- view: epic_loan_history
  sql_table_name: GenericLoanHistory
  fields:
  - dimension: calc_outstanding_csofee
    sql: ${TABLE}.Calc_OutstandingFee
  - dimension: discount_finance_fee
    sql: ${TABLE}.DiscountFinanceFee
  - dimension: discount_late_fee
    sql: ${TABLE}.DiscountLateFee
  - dimension: discount_nsf_fee
    sql: ${TABLE}.DiscountNsfFee
  - dimension: discount_principle
    sql: ${TABLE}.DiscountPrinciple
  - dimension: effective
    type: time
    sql: ${TABLE}.EffectiveDate
  - dimension: loan_history_id
    type: int
    primary_key: true
    sql: ${TABLE}.LoanHistoryId
  - dimension: loan_id
    type: int
    sql: ${TABLE}.LoanId
  - dimension: loan_status
    sql: ${TABLE}.LoanStatus
  - dimension: outstanding_finance_fee
    sql: ${TABLE}.OutstandingFinanceFee
  - dimension: outstanding_late_fee
    sql: ${TABLE}.OutstandingLateFee
  - dimension: outstanding_nsf_fee
    sql: ${TABLE}.OutstandingNsfFee
  - dimension: outstanding_total
    sql: ${TABLE}.OutstandingTotal
  - dimension: paid_off_finance_fee
    sql: ${TABLE}.PaidOffFinanceFee
  - dimension: paid_off_late_fee
    sql: ${TABLE}.PaidOffLateFee
  - dimension: paid_off_nsf_fee
    sql: ${TABLE}.PaidOffNsfFee
  - dimension: paid_off_principle
    sql: ${TABLE}.PaidOffPrinciple
  - dimension: settlement_finance_fee
    sql: ${TABLE}.SettlementFinanceFee
  - dimension: settlement_late_fee
    sql: ${TABLE}.SettlementLateFee
  - dimension: settlement_nsf_fee
    sql: ${TABLE}.SettlementNsfFee
  - dimension: settlement_principle
    sql: ${TABLE}.SettlementPrinciple
  - dimension: vw_loan_history_id
    type: int
    sql: ${TABLE}.view_LoanHistory_Id
  - dimension_group: date_copied_from_epic_dart
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DateCopiedFromGenericDart
  - measure: count
    type: count
  - measure: outstanding_principle_amount
    type: sum
    sql: ${TABLE}.OutstandingPrinciple
  - measure: outstanding_principle_div1m
    type: number
    label: Balance Outstanding
    value_format: '#.00'
    sql: (${outstanding_principle_amount}) / 1000000.00