Quote Details

view: quote_details {
  sql_table_name: Latest.QuoteDetails ;;

  dimension: amortization_schedule {
    type: string
    sql: ${TABLE}.amortizationSchedule ;;
  }

  dimension: annual_interest_rate {
    type: number
    value_format: "0.00\%"
    sql: ${TABLE}.annualInterestRate ;;
  }

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

  dimension: auto_decline_reasons {
    type: string
    sql: ${TABLE}.autoDeclineReasons ;;
  }

  dimension: average_principal_outstanding_over_term_of_loan {
    type: number
    sql: ${TABLE}.<redacted> ;;
  }

  dimension: borrower_age {
    type: number
    sql: ${TABLE}.borrowerAge ;;
  }

  dimension: borrower_stated_income {
    type: number
    sql: ${TABLE}.borrowerStatedIncome ;;
  }

  dimension: cdata_banking_closed_for_cause {
    type: string
    sql: ${TABLE}.cdataBankingClosedForCause ;;
  }

  dimension: cdata_bankruptcies {
    type: string
    sql: ${TABLE}.cdataBankruptcies ;;
  }

  dimension: cdata_collections {
    type: string
    sql: ${TABLE}.cdataCollections ;;
  }

  dimension: cdata_legal_items {
    type: string
    sql: ${TABLE}.cdataLegalItems ;;
  }

  dimension: cdata_trade_first_opened {
    type: string
    sql: ${TABLE}.cdataTradeFirstOpened ;;
  }

  dimension: cost_of_credit {
    type: number
    sql: ${TABLE}.costOfCredit ;;
  }

  dimension: credit_utilization {
    type: number
    sql: ${TABLE}.creditUtilization ;;
  }

  dimension: dsr_balance {
    type: number
    sql: ${TABLE}.dsrBalance ;;
  }

  dimension: dsr_limit {
    type: number
    sql: ${TABLE}.dsrLimit ;;
  }

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

  dimension: fico_score {
    type: number
    sql: ${TABLE}.ficoScore ;;
  }

  dimension: fico_tier {
    type: tier
    sql: ${TABLE}.ficoScore ;;
  }

  dimension: grouplend_fee {
    type: number
    sql: ${TABLE}.grouplendFee ;;
  }

  dimension: grouplend_score {
    type: number
    sql: ${TABLE}.grouplendScore ;;
  }

  dimension: loan_amount {
    type: number
    sql: ${TABLE}.loanAmount ;;
  }

  dimension: loan_purpose {
    type: string
    sql: ${TABLE}.loanPurpose ;;
  }

  dimension: max_allowed_amount {
    type: number
    sql: ${TABLE}.maxAllowedAmount ;;
  }

  dimension: min_allowed_amount {
    type: number
    sql: ${TABLE}.minAllowedAmount ;;
  }

  dimension: monthly_payment {
    type: number
    sql: ${TABLE}.monthlyPayment ;;
  }

  dimension: net_proceeds {
    type: number
    sql: ${TABLE}.netProceeds ;;
  }

  dimension: number_of_inquiries {
    type: number
    sql: ${TABLE}.numberOfInquiries ;;
  }

  dimension: number_of_negative_trades {
    type: number
    sql: ${TABLE}.numberOfNegativeTrades ;;
  }

  dimension: number_of_public_records {
    type: number
    sql: ${TABLE}.numberOfPublicRecords ;;
  }

  dimension: number_of_trades {
    type: number
    sql: ${TABLE}.numberOfTrades ;;
  }

  dimension: quote_details_state {
    type: string
    sql: ${TABLE}.quoteDetailsState ;;
  }

  dimension: referral_code {
    type: string
    sql: ${TABLE}.referralCode ;;
  }

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

  dimension: total_repayment {
    type: number
    sql: ${TABLE}.totalRepayment ;;
  }

  dimension: tranche {
    type: string
    sql: ${TABLE}.tranch ;;
  }

  dimension: user_accepted {
    type: yesno
    sql: ${TABLE}.userAccepted ;;
  }

  dimension: user_agreed_to_credit_check {
    type: yesno
    sql: ${TABLE}.userAgreedToCreditCheck ;;
  }

  dimension: user_agreed_to_terms_of_service {
    type: yesno
    sql: ${TABLE}.userAgreedToTermsOfService ;;
  }

  dimension: user_uuid {
    type: string
    sql: ${TABLE}.userUuid ;;
  }

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

  dimension_group: date_created {
    description: "The time at which the quote was created (the applied time); in PST time"
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.dateCreated ;;
  }

  dimension_group: date_last_modified {
    description: "The last time at which this quote was modified in the system; in PST time"
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.dateLastModified ;;
  }

  dimension_group: date_created_local {
    description: "The time at which the quote was created (the applied time); in the user`s local time"
    type: time
    timeframes: [time, date, week, month, hour]
    sql: ${TABLE}.dateCreatedLocal ;;
  }

  dimension_group: date_last_modified_local {
    description: "The last time at which this quote was modified in the system; in the user`s local time"
    type: time
    timeframes: [time, date, week, month, hour]
    sql: ${TABLE}.dateLastModifiedLocal ;;
  }

  dimension_group: date_user_accepted {
    description: "If the user accepted, this is the time when they did so in PST time"
    type: time
    timeframes: [time, date, week, month, hour]
    sql: ${TABLE}.dateUserAccepted ;;
  }

  dimension_group: date_user_accepted_local {
    description: "If the user accepted, this is the time they did so in their local time"
    type: time
    timeframes: [time, date, week, month, hour]
    sql: ${TABLE}.dateUserAcceptedLocal ;;
  }

  dimension_group: date_user_agreed_to_credit_check {
    type: time
    timeframes: [time, date, week, month, hour]
    sql: ${TABLE}.dateUserAgreedToCreditCheck ;;
  }

  dimension_group: date_user_agreed_to_terms_of_service {
    type: time
    timeframes: [time, date, week, month, hour]
    sql: ${TABLE}.dateUserAgreedToTermsOfService ;;
  }

  dimension_group: date_user_agreed_to_credit_check_local {
    type: time
    timeframes: [time, date, week, month, hour]
    sql: ${TABLE}.dateUserAgreedToCreditCheckLocal ;;
  }

  dimension_group: date_user_agreed_to_terms_of_service_local {
    type: time
    timeframes: [time, date, week, month, hour]
    sql: ${TABLE}.dateUserAgreedToTermsOfServiceLocal ;;
  }

  measure: count {
    type: count
  }

  measure: avg_annual_interest_rate {
    type: avg
    value_format: "0.00\%"
    sql: ${annual_interest_rate} ;;
  }

  measure: avg_apr {
    type: avg
    sql: ${apr} ;;
  }

  measure: avg_average_principal_outstanding_over_term_of_loan {
    type: avg
    sql: ${average_principal_outstanding_over_term_of_loan} ;;
  }

  measure: avg_borrower_age {
    type: avg
    sql: ${borrower_age} ;;
  }

  measure: avg_borrower_stated_income {
    type: avg
    sql: ${borrower_stated_income} ;;
  }

  measure: avg_cost_of_credit {
    type: avg
    sql: ${cost_of_credit} ;;
  }

  measure: avg_credit_utilization {
    type: avg
    sql: ${credit_utilization} ;;
  }

  measure: avg_dsr_balance {
    type: avg
    sql: ${dsr_balance} ;;
  }

  measure: avg_dsr_limit {
    type: avg
    sql: ${dsr_limit} ;;
  }

  measure: avg_fees {
    type: avg
    sql: ${fees} ;;
  }

  measure: avg_fico_score {
    type: avg
    sql: ${fico_score} ;;
  }

  measure: avg_grouplend_fee {
    type: avg
    sql: ${grouplend_fee} ;;
  }

  measure: avg_grouplend_score {
    type: avg
    sql: ${grouplend_score} ;;
  }

  measure: avg_loan_amount {
    type: avg
    drill_fields: [personal_information.first_name, personal_information.last_name, date_created_time, date_user_accepted_time, loan.date_funding_date, loan.loan_state, loan_amount, user_uuid, uuid]
    sql: ${loan_amount} ;;
  }

  measure: sum_loan_amount {
    type: sum
    drill_fields: [personal_information.first_name, personal_information.last_name, date_created_time, date_user_accepted_time, loan.date_funding_date, loan.loan_state, loan_amount, user_uuid, uuid]
    sql: ${loan_amount} ;;
  }

  measure: avg_max_allowed_amount {
    type: avg
    sql: ${max_allowed_amount} ;;
  }

  measure: avg_min_allowed_amount {
    type: avg
    sql: ${min_allowed_amount} ;;
  }

  measure: avg_monthly_payment {
    type: avg
    sql: ${monthly_payment} ;;
  }

  measure: avg_net_proceeds {
    type: avg
    sql: ${net_proceeds} ;;
  }

  measure: avg_number_of_inquiries {
    type: avg
    sql: ${number_of_inquiries} ;;
  }

  measure: avg_number_of_negative_trades {
    type: avg
    sql: ${number_of_negative_trades} ;;
  }

  measure: avg_number_of_public_records {
    type: avg
    sql: ${number_of_public_records} ;;
  }

  measure: avg_number_of_trades {
    type: avg
    sql: ${number_of_trades} ;;
  }
}

- view: quote_details
  sql_table_name: Latest.QuoteDetails
  fields:
  - dimension: amortization_schedule
    type: string
    sql: ${TABLE}.amortizationSchedule
  - dimension: annual_interest_rate
    type: number
    value_format: '0.00\%'
    sql: ${TABLE}.annualInterestRate
  - dimension: apr
    type: number
    sql: ${TABLE}.apr
  - dimension: auto_decline_reasons
    type: string
    sql: ${TABLE}.autoDeclineReasons
  - dimension: average_principal_outstanding_over_term_of_loan
    type: number
    sql: ${TABLE}.<redacted>
  - dimension: borrower_age
    type: number
    sql: ${TABLE}.borrowerAge
  - dimension: borrower_stated_income
    type: number
    sql: ${TABLE}.borrowerStatedIncome
  - dimension: cdata_banking_closed_for_cause
    type: string
    sql: ${TABLE}.cdataBankingClosedForCause
  - dimension: cdata_bankruptcies
    type: string
    sql: ${TABLE}.cdataBankruptcies
  - dimension: cdata_collections
    type: string
    sql: ${TABLE}.cdataCollections
  - dimension: cdata_legal_items
    type: string
    sql: ${TABLE}.cdataLegalItems
  - dimension: cdata_trade_first_opened
    type: string
    sql: ${TABLE}.cdataTradeFirstOpened
  - dimension: cost_of_credit
    type: number
    sql: ${TABLE}.costOfCredit
  - dimension: credit_utilization
    type: number
    sql: ${TABLE}.creditUtilization
  - dimension: dsr_balance
    type: number
    sql: ${TABLE}.dsrBalance
  - dimension: dsr_limit
    type: number
    sql: ${TABLE}.dsrLimit
  - dimension: fees
    type: number
    sql: ${TABLE}.fees
  - dimension: fico_score
    type: number
    sql: ${TABLE}.ficoScore
  - dimension: fico_tier
    type: tier
    sql: ${TABLE}.ficoScore
  - dimension: grouplend_fee
    type: number
    sql: ${TABLE}.grouplendFee
  - dimension: grouplend_score
    type: number
    sql: ${TABLE}.grouplendScore
  - dimension: loan_amount
    type: number
    sql: ${TABLE}.loanAmount
  - dimension: loan_purpose
    type: string
    sql: ${TABLE}.loanPurpose
  - dimension: max_allowed_amount
    type: number
    sql: ${TABLE}.maxAllowedAmount
  - dimension: min_allowed_amount
    type: number
    sql: ${TABLE}.minAllowedAmount
  - dimension: monthly_payment
    type: number
    sql: ${TABLE}.monthlyPayment
  - dimension: net_proceeds
    type: number
    sql: ${TABLE}.netProceeds
  - dimension: number_of_inquiries
    type: number
    sql: ${TABLE}.numberOfInquiries
  - dimension: number_of_negative_trades
    type: number
    sql: ${TABLE}.numberOfNegativeTrades
  - dimension: number_of_public_records
    type: number
    sql: ${TABLE}.numberOfPublicRecords
  - dimension: number_of_trades
    type: number
    sql: ${TABLE}.numberOfTrades
  - dimension: quote_details_state
    type: string
    sql: ${TABLE}.quoteDetailsState
  - dimension: referral_code
    type: string
    sql: ${TABLE}.referralCode
  - dimension: term
    type: number
    sql: ${TABLE}.term
  - dimension: total_repayment
    type: number
    sql: ${TABLE}.totalRepayment
  - dimension: tranche
    type: string
    sql: ${TABLE}.tranch
  - dimension: user_accepted
    type: yesno
    sql: ${TABLE}.userAccepted
  - dimension: user_agreed_to_credit_check
    type: yesno
    sql: ${TABLE}.userAgreedToCreditCheck
  - dimension: user_agreed_to_terms_of_service
    type: yesno
    sql: ${TABLE}.userAgreedToTermsOfService
  - dimension: user_uuid
    type: string
    sql: ${TABLE}.userUuid
  - dimension: uuid
    type: string
    sql: ${TABLE}.uuid
  - dimension_group: date_created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dateCreated
  - dimension_group: date_last_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dateLastModified
  - dimension_group: date_created_local
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour
    sql: ${TABLE}.dateCreatedLocal
  - dimension_group: date_last_modified_local
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour
    sql: ${TABLE}.dateLastModifiedLocal
  - dimension_group: date_user_accepted
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour
    sql: ${TABLE}.dateUserAccepted
  - dimension_group: date_user_accepted_local
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour
    sql: ${TABLE}.dateUserAcceptedLocal
  - dimension_group: date_user_agreed_to_credit_check
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour
    sql: ${TABLE}.dateUserAgreedToCreditCheck
  - dimension_group: date_user_agreed_to_terms_of_service
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour
    sql: ${TABLE}.dateUserAgreedToTermsOfService
  - dimension_group: date_user_agreed_to_credit_check_local
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour
    sql: ${TABLE}.dateUserAgreedToCreditCheckLocal
  - dimension_group: date_user_agreed_to_terms_of_service_local
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour
    sql: ${TABLE}.dateUserAgreedToTermsOfServiceLocal
  - measure: count
    type: count
  - measure: avg_annual_interest_rate
    type: avg
    value_format: '0.00\%'
    sql: ${annual_interest_rate}
  - measure: avg_apr
    type: avg
    sql: ${apr}
  - measure: avg_average_principal_outstanding_over_term_of_loan
    type: avg
    sql: ${average_principal_outstanding_over_term_of_loan}
  - measure: avg_borrower_age
    type: avg
    sql: ${borrower_age}
  - measure: avg_borrower_stated_income
    type: avg
    sql: ${borrower_stated_income}
  - measure: avg_cost_of_credit
    type: avg
    sql: ${cost_of_credit}
  - measure: avg_credit_utilization
    type: avg
    sql: ${credit_utilization}
  - measure: avg_dsr_balance
    type: avg
    sql: ${dsr_balance}
  - measure: avg_dsr_limit
    type: avg
    sql: ${dsr_limit}
  - measure: avg_fees
    type: avg
    sql: ${fees}
  - measure: avg_fico_score
    type: avg
    sql: ${fico_score}
  - measure: avg_grouplend_fee
    type: avg
    sql: ${grouplend_fee}
  - measure: avg_grouplend_score
    type: avg
    sql: ${grouplend_score}
  - measure: avg_loan_amount
    type: avg
    drill_fields:
    - personal_information.first_name
    - personal_information.last_name
    - date_created_time
    - date_user_accepted_time
    - loan.date_funding_date
    - loan.loan_state
    - loan_amount
    - user_uuid
    - uuid
    sql: ${loan_amount}
  - measure: sum_loan_amount
    type: sum
    drill_fields:
    - personal_information.first_name
    - personal_information.last_name
    - date_created_time
    - date_user_accepted_time
    - loan.date_funding_date
    - loan.loan_state
    - loan_amount
    - user_uuid
    - uuid
    sql: ${loan_amount}
  - measure: avg_max_allowed_amount
    type: avg
    sql: ${max_allowed_amount}
  - measure: avg_min_allowed_amount
    type: avg
    sql: ${min_allowed_amount}
  - measure: avg_monthly_payment
    type: avg
    sql: ${monthly_payment}
  - measure: avg_net_proceeds
    type: avg
    sql: ${net_proceeds}
  - measure: avg_number_of_inquiries
    type: avg
    sql: ${number_of_inquiries}
  - measure: avg_number_of_negative_trades
    type: avg
    sql: ${number_of_negative_trades}
  - measure: avg_number_of_public_records
    type: avg
    sql: ${number_of_public_records}
  - measure: avg_number_of_trades
    type: avg
    sql: ${number_of_trades}