Loan

view: loan {
  sql_table_name: Latest.Loan ;;

  dimension: application_uuid {
    type: string
    sql: ${TABLE}.applicationUuid ;;
  }

  dimension: loan_state {
    type: string
    sql: ${TABLE}.loanState ;;
  }

  dimension: loan_agreement_state {
    type: string
    sql: ${TABLE}.loanAgreementState ;;
  }

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

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

  dimension_group: date_created {
    description: "The date at which the loan object was generated in our system in PST time"
    type: time
    timeframes: [time, date, week, month, hour_of_day, day_of_week, year]
    sql: ${TABLE}.dateCreated ;;
  }

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

  dimension_group: date_created_local {
    description: "The date at which the loan object was generated 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 date at which the loan object was last modified in our system in the user`s local time"
    type: time
    timeframes: [time, date, week, month, hour]
    sql: ${TABLE}.dateLastModifiedLocal ;;
  }

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

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

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

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

  measure: count {
    type: count
    drill_fields: [uuid, dateCreated, user_uuid, loan_state]
  }
}

- view: loan
  sql_table_name: Latest.Loan
  fields:
  - dimension: application_uuid
    type: string
    sql: ${TABLE}.applicationUuid
  - dimension: loan_state
    type: string
    sql: ${TABLE}.loanState
  - dimension: loan_agreement_state
    type: string
    sql: ${TABLE}.loanAgreementState
  - dimension: user_uuid
    type: string
    sql: ${TABLE}.userUuid
  - dimension: uuid
    type: string
    primary_key: true
    sql: ${TABLE}.uuid
  - dimension_group: date_created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour_of_day
    - day_of_week
    - year
    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_effective
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dateEffective
  - dimension_group: date_funding
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.dateFunding
  - dimension_group: date_first_payment
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.dateFirstPayment
  - dimension_group: date_final_payment
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.dateFinalPayment
  - measure: count
    type: count
    drill_fields:
    - uuid
    - dateCreated
    - user_uuid
    - loan_state