Ae Historic Loan States

view: ae_historic_loan_states {
  sql_table_name: public.ae_historic_loan_states ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: dtperf {
    sql: ${TABLE}.dtperf ;;
  }

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

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

  dimension: flggood {
    sql: ${TABLE}.flggood ;;
  }

  dimension: flgstatusperf {
    sql: ${TABLE}.flgstatusperf ;;
  }

  dimension: flgstatuspreviousmonth {
    sql: ${TABLE}.flgstatuspreviousmonth ;;
  }

  dimension: flgstatussimpleperf {
    sql: ${TABLE}.flgstatussimpleperf ;;
  }

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

  dimension: idcust {
    sql: ${TABLE}.idcust ;;
  }

  dimension: idloan {
    primary_key: yes
    sql: ${TABLE}.idloan ;;
  }

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

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

  dimension: txtcsr {
    sql: ${TABLE}.txtcsr ;;
  }

  dimension_group: dtchargeoff {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.dtchargeoff ;;
  }

  dimension_group: dteffect {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.dteffect ;;
  }

  dimension_group: dtzerobalance {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.dtzerobalance ;;
  }

  measure: total_balprinperf {
    type: sum
    sql: ${balprinperf} ;;
  }

  measure: count {
    type: count
  }
}

- view: ae_historic_loan_states
  sql_table_name: public.ae_historic_loan_states
  fields:
  - dimension: amtchargedofffeeperf
    type: number
    sql: ${TABLE}.amtchargedofffeeperf
  - dimension: amtchargedoffprincipalperf
    type: number
    sql: ${TABLE}.amtchargedoffprincipalperf
  - dimension: amtchargedofftotalperf
    type: number
    sql: ${TABLE}.amtchargedofftotalperf
  - dimension: amtcumulativechargedofffee
    type: number
    sql: ${TABLE}.amtcumulativechargedofffee
  - dimension: amtcumulativechargedoffprincipal
    type: number
    sql: ${TABLE}.amtcumulativechargedoffprincipal
  - dimension: amtcumulativechargedofftotal
    type: number
    sql: ${TABLE}.amtcumulativechargedofftotal
  - dimension: amtcumulativewaivedfee
    type: number
    sql: ${TABLE}.amtcumulativewaivedfee
  - dimension: amtcumulativewaivedinterest
    type: number
    sql: ${TABLE}.amtcumulativewaivedinterest
  - dimension: amtcumulativewaivedprincipal
    type: number
    sql: ${TABLE}.amtcumulativewaivedprincipal
  - dimension: amtcumulativewaivedtotal
    type: number
    sql: ${TABLE}.amtcumulativewaivedtotal
  - dimension: amtpaidint
    type: number
    sql: ${TABLE}.amtpaidint
  - dimension: amtpaidintperf
    type: number
    sql: ${TABLE}.amtpaidintperf
  - dimension: amtpaidlate
    type: number
    sql: ${TABLE}.amtpaidlate
  - dimension: amtpaidotherperf
    type: number
    sql: ${TABLE}.amtpaidotherperf
  - dimension: amtpaidperf
    type: number
    sql: ${TABLE}.amtpaidperf
  - dimension: amtpaidprin
    type: number
    sql: ${TABLE}.amtpaidprin
  - dimension: amtpaidprinperf
    type: number
    sql: ${TABLE}.amtpaidprinperf
  - dimension: amtpaidtotal
    type: number
    sql: ${TABLE}.amtpaidtotal
  - dimension: balbehind
    type: number
    sql: ${TABLE}.balbehind
  - dimension: baldq
    type: number
    sql: ${TABLE}.baldq
  - dimension: balintperf
    type: number
    sql: ${TABLE}.balintperf
  - dimension: balotherperf
    type: number
    sql: ${TABLE}.balotherperf
  - dimension: balperf
    type: number
    sql: ${TABLE}.balperf
  - dimension: balprinperf
    type: number
    sql: ${TABLE}.balprinperf
  - dimension: cntdaysactive
    type: number
    sql: ${TABLE}.cntdaysactive
  - dimension: cntdayspastdue
    type: number
    sql: ${TABLE}.cntdayspastdue
  - dimension: cntdelinquencies
    type: number
    sql: ${TABLE}.cntdelinquencies
  - dimension: cntdelinquenciesperf
    type: number
    sql: ${TABLE}.cntdelinquenciesperf
  - dimension: cntpmtsattempted
    type: number
    sql: ${TABLE}.cntpmtsattempted
  - dimension: cntpmtsattemptedperf
    type: number
    sql: ${TABLE}.cntpmtsattemptedperf
  - dimension: cntpmtsdeferred
    type: number
    sql: ${TABLE}.cntpmtsdeferred
  - dimension: cntpmtsdeferredperf
    type: number
    sql: ${TABLE}.cntpmtsdeferredperf
  - dimension: cntpmtsmade
    type: number
    sql: ${TABLE}.cntpmtsmade
  - dimension: cntpmtsmadeperf
    type: number
    sql: ${TABLE}.cntpmtsmadeperf
  - dimension: cntpmtsmissed
    type: number
    sql: ${TABLE}.cntpmtsmissed
  - dimension: cntpmtsmissedperf
    type: number
    sql: ${TABLE}.cntpmtsmissedperf
  - dimension: dtperf
    sql: ${TABLE}.dtperf
  - dimension: flgautodebit
    type: number
    sql: ${TABLE}.flgautodebit
  - dimension: flgcuredmonth
    type: number
    sql: ${TABLE}.flgcuredmonth
  - dimension: flggood
    sql: ${TABLE}.flggood
  - dimension: flgstatusperf
    sql: ${TABLE}.flgstatusperf
  - dimension: flgstatuspreviousmonth
    sql: ${TABLE}.flgstatuspreviousmonth
  - dimension: flgstatussimpleperf
    sql: ${TABLE}.flgstatussimpleperf
  - dimension: idcsr
    type: number
    sql: ${TABLE}.idcsr
  - dimension: idcust
    sql: ${TABLE}.idcust
  - dimension: idloan
    primary_key: true
    sql: ${TABLE}.idloan
  - dimension: monthsonfile
    type: number
    sql: ${TABLE}.monthsonfile
  - dimension: rtinterestcurrent
    type: number
    sql: ${TABLE}.rtinterestcurrent
  - dimension: txtcsr
    sql: ${TABLE}.txtcsr
  - dimension_group: dtchargeoff
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.dtchargeoff
  - dimension_group: dteffect
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.dteffect
  - dimension_group: dtzerobalance
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.dtzerobalance
  - measure: total_balprinperf
    type: sum
    sql: ${balprinperf}
  - measure: count
    type: count