data.ml
LKML Fintech consulting

Trs

Trs model for fintech consulting.

inferred

Blocks

trs.view.lkml · 301 lines
inferred 
view: trs {
  sql_table_name: TRS ;;

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

  dimension: deposit_no {
    type: int
    sql: ${TABLE}.deposit_no ;;
  }

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

  dimension: remit_no {
    type: int
    sql: ${TABLE}.remit_no ;;
  }

  dimension: sweep_no {
    type: int
    hidden: yes
    sql: ${TABLE}.sweep_no ;;
  }

  dimension: trs_amt {
    type: number
    sql: ${TABLE}.TRS_AMT ;;
  }

  dimension: trs_amt_no {
    sql: ${TABLE}.TRS_AMT_NO ;;
  }

  dimension: trs_ar_agency {
    sql: ${TABLE}.TRS_AR_AGENCY ;;
  }

  dimension: trs_ar_client {
    sql: ${TABLE}.TRS_AR_CLIENT ;;
  }

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

  dimension: trs_batch_no {
    type: number
    sql: ${TABLE}.TRS_BATCH_NO ;;
  }

  dimension: trs_check_amt {
    type: number
    sql: ${TABLE}.TRS_CHECK_AMT ;;
  }

  dimension: trs_check_no {
    sql: ${TABLE}.TRS_CHECK_NO ;;
  }

  dimension: trs_cn_byte {
    sql: ${TABLE}.TRS_CN_BYTE ;;
  }

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

  dimension: trs_comm_amt {
    type: number
    sql: ${TABLE}.TRS_COMM_AMT ;;
  }

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

  dimension: trs_dbr_no {
    sql: ${TABLE}.TRS_DBR_NO ;;
  }

  dimension: trs_desk {
    sql: ${TABLE}.TRS_DESK ;;
  }

  dimension: trs_entry_no {
    type: number
    sql: ${TABLE}.TRS_ENTRY_NO ;;
  }

  dimension: trs_hold_days {
    type: number
    sql: ${TABLE}.TRS_HOLD_DAYS ;;
  }

  dimension: trs_int_due {
    type: number
    sql: ${TABLE}.TRS_INT_DUE ;;
  }

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

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

  dimension: trs_mop {
    sql: ${TABLE}.TRS_MOP ;;
  }

  dimension: trs_note_1 {
    sql: ${TABLE}.TRS_NOTE_1 ;;
  }

  dimension: trs_note_2 {
    sql: ${TABLE}.TRS_NOTE_2 ;;
  }

  dimension: trs_note_3 {
    hidden: yes
    sql: ${TABLE}.TRS_NOTE_3 ;;
  }

  dimension: trs_note_4 {
    hidden: yes
    sql: ${TABLE}.TRS_NOTE_4 ;;
  }

  dimension: trs_note_5 {
    hidden: yes
    sql: ${TABLE}.TRS_NOTE_5 ;;
  }

  dimension: trs_note_6 {
    hidden: yes
    sql: ${TABLE}.TRS_NOTE_6 ;;
  }

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

  dimension: trs_other_due {
    type: number
    sql: ${TABLE}.TRS_OTHER_DUE ;;
  }

  dimension: trs_pdc_flag {
    sql: ${TABLE}.TRS_PDC_FLAG ;;
  }

  dimension: trs_princ_due {
    type: number
    sql: ${TABLE}.TRS_PRINC_DUE ;;
  }

  dimension: trs_remitted_flag {
    hidden: yes
    sql: ${TABLE}.TRS_REMITTED_FLAG ;;
  }

  dimension: trs_seq_no {
    sql: ${TABLE}.TRS_SEQ_NO ;;
  }

  dimension: trs_seq_sub {
    sql: ${TABLE}.TRS_SEQ_SUB ;;
  }

  dimension: trs_sign_adj {
    type: number
    sql: ${TABLE}.TRS_SIGN_ADJ ;;
  }

  dimension: trs_sman {
    sql: ${TABLE}.TRS_SMAN ;;
  }

  dimension: trs_status {
    hidden: yes
    sql: ${TABLE}.TRS_STATUS ;;
  }

  dimension: trs_stmt_byte {
    sql: ${TABLE}.TRS_STMT_BYTE ;;
  }

  dimension: trs_total_due {
    type: number
    sql: ${TABLE}.TRS_TOTAL_DUE ;;
  }

  dimension: trs_trans_class {
    hidden: yes
    sql: ${TABLE}.TRS_TRANS_CLASS ;;
  }

  dimension: trs_trust_code {
    type: number
    sql: ${TABLE}.TRS_TRUST_CODE ;;
  }

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

  dimension: trs_trx_state {
    sql: ${TABLE}.TRS_TRX_STATE ;;
  }

  dimension: trs_userid {
    sql: ${TABLE}.TRS_USERID ;;
  }

  dimension_group: trs_trx_date_o {
    type: time
    timeframes: [date, week, month, year, dow]
    sql: ${TABLE}.TRS_TRX_DATE_O ;;
  }

  measure: total_assigned {
    type: sum
    sql: DBR.dbr_assign_amt ;;
  }

  measure: count {
    type: count
  }

  measure: pmt_count {
    type: count
    filters: [trs_sign_adj: "-1"]
    sql: ${trs_dbr_no} ;;
  }

  measure: total_trs_amt {
    label: "TOTAL PAYMENTS"
    type: sum
    filters: [trs_sign_adj: "= -1"]
    sql: ${trs_amt} ;;
  }

  measure: avg_trs_amt {
    type: sum
    sql: ${trs_amt} ;;
  }

  measure: this_week_count {
    type: count_distinct
    filters: [trs_trx_date_o_date: "7 days"]
    sql: ${TABLE}.id ;;
  }

  measure: this_last_14_days_count {
    type: count_distinct
    filters: [trs_trx_date_o_date: "14 days"]
    sql: ${TABLE}.id ;;
  }

  measure: this_last_30_days_count {
    type: count_distinct
    filters: [trs_trx_date_o_date: "30 days"]
    sql: ${TABLE}.id ;;
  }

  measure: order_percent_change {
    type: percent_of_previous
    sql: ${count} ;;
  }

  measure: count_percent_of_total {
    label: "Count (Percent of Total)"
    type: percent_of_total
    sql: ${count} ;;
  }

  measure: liquidation_percent {
    type: number
    sql: 100.0 * ${total_trs_amt}/NULLIF(${dbr_facts.plac},0) ;;
  }
}
trs.view.lookml · 191 lines
source-preserved 
- view: trs
  sql_table_name: TRS
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: deposit_no
    type: int
    sql: ${TABLE}.deposit_no
  - dimension: invoice_updated
    sql: ${TABLE}.invoice_updated
  - dimension: remit_no
    type: int
    sql: ${TABLE}.remit_no
  - dimension: sweep_no
    type: int
    hidden: true
    sql: ${TABLE}.sweep_no
  - dimension: trs_amt
    type: number
    sql: ${TABLE}.TRS_AMT
  - dimension: trs_amt_no
    sql: ${TABLE}.TRS_AMT_NO
  - dimension: trs_ar_agency
    sql: ${TABLE}.TRS_AR_AGENCY
  - dimension: trs_ar_client
    sql: ${TABLE}.TRS_AR_CLIENT
  - dimension: trs_atty_due
    type: number
    hidden: true
    sql: ${TABLE}.TRS_ATTY_DUE
  - dimension: trs_batch_no
    type: number
    sql: ${TABLE}.TRS_BATCH_NO
  - dimension: trs_check_amt
    type: number
    sql: ${TABLE}.TRS_CHECK_AMT
  - dimension: trs_check_no
    sql: ${TABLE}.TRS_CHECK_NO
  - dimension: trs_cn_byte
    sql: ${TABLE}.TRS_CN_BYTE
  - dimension: trs_cntf_due
    type: number
    hidden: true
    sql: ${TABLE}.TRS_CNTF_DUE
  - dimension: trs_comm_amt
    type: number
    sql: ${TABLE}.TRS_COMM_AMT
  - dimension: trs_court_due
    type: number
    hidden: true
    sql: ${TABLE}.TRS_COURT_DUE
  - dimension: trs_dbr_no
    sql: ${TABLE}.TRS_DBR_NO
  - dimension: trs_desk
    sql: ${TABLE}.TRS_DESK
  - dimension: trs_entry_no
    type: number
    sql: ${TABLE}.TRS_ENTRY_NO
  - dimension: trs_hold_days
    type: number
    sql: ${TABLE}.TRS_HOLD_DAYS
  - dimension: trs_int_due
    type: number
    sql: ${TABLE}.TRS_INT_DUE
  - dimension: trs_jint_due
    type: number
    hidden: true
    sql: ${TABLE}.TRS_JINT_DUE
  - dimension: trs_misc_due
    type: number
    hidden: true
    sql: ${TABLE}.TRS_MISC_DUE
  - dimension: trs_mop
    sql: ${TABLE}.TRS_MOP
  - dimension: trs_note_1
    sql: ${TABLE}.TRS_NOTE_1
  - dimension: trs_note_2
    sql: ${TABLE}.TRS_NOTE_2
  - dimension: trs_note_3
    hidden: true
    sql: ${TABLE}.TRS_NOTE_3
  - dimension: trs_note_4
    hidden: true
    sql: ${TABLE}.TRS_NOTE_4
  - dimension: trs_note_5
    hidden: true
    sql: ${TABLE}.TRS_NOTE_5
  - dimension: trs_note_6
    hidden: true
    sql: ${TABLE}.TRS_NOTE_6
  - dimension: trs_nsf_reference_code
    type: number
    hidden: true
    sql: ${TABLE}.TRS_NSF_REFERENCE_CODE
  - dimension: trs_other_due
    type: number
    sql: ${TABLE}.TRS_OTHER_DUE
  - dimension: trs_pdc_flag
    sql: ${TABLE}.TRS_PDC_FLAG
  - dimension: trs_princ_due
    type: number
    sql: ${TABLE}.TRS_PRINC_DUE
  - dimension: trs_remitted_flag
    hidden: true
    sql: ${TABLE}.TRS_REMITTED_FLAG
  - dimension: trs_seq_no
    sql: ${TABLE}.TRS_SEQ_NO
  - dimension: trs_seq_sub
    sql: ${TABLE}.TRS_SEQ_SUB
  - dimension: trs_sign_adj
    type: number
    sql: ${TABLE}.TRS_SIGN_ADJ
  - dimension: trs_sman
    sql: ${TABLE}.TRS_SMAN
  - dimension: trs_status
    hidden: true
    sql: ${TABLE}.TRS_STATUS
  - dimension: trs_stmt_byte
    sql: ${TABLE}.TRS_STMT_BYTE
  - dimension: trs_total_due
    type: number
    sql: ${TABLE}.TRS_TOTAL_DUE
  - dimension: trs_trans_class
    hidden: true
    sql: ${TABLE}.TRS_TRANS_CLASS
  - dimension: trs_trust_code
    type: number
    sql: ${TABLE}.TRS_TRUST_CODE
  - dimension: trs_trx_date
    type: number
    hidden: true
    sql: ${TABLE}.TRS_TRX_DATE
  - dimension: trs_trx_state
    sql: ${TABLE}.TRS_TRX_STATE
  - dimension: trs_userid
    sql: ${TABLE}.TRS_USERID
  - dimension_group: trs_trx_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    - year
    - dow
    sql: ${TABLE}.TRS_TRX_DATE_O
  - measure: total_assigned
    type: sum
    sql: DBR.dbr_assign_amt
  - measure: count
    type: count
  - measure: pmt_count
    type: count
    filters:
    - trs_sign_adj: -1
    sql: ${trs_dbr_no}
  - measure: total_trs_amt
    type: sum
    label: TOTAL PAYMENTS
    filters:
    - trs_sign_adj: = -1
    sql: ${trs_amt}
  - measure: avg_trs_amt
    type: sum
    sql: ${trs_amt}
  - measure: this_week_count
    type: count_distinct
    filters:
    - trs_trx_date_o_date: 7 days
    sql: ${TABLE}.id
  - measure: this_last_14_days_count
    type: count_distinct
    filters:
    - trs_trx_date_o_date: 14 days
    sql: ${TABLE}.id
  - measure: this_last_30_days_count
    type: count_distinct
    filters:
    - trs_trx_date_o_date: 30 days
    sql: ${TABLE}.id
  - measure: order_percent_change
    type: percent_of_previous
    sql: ${count}
  - measure: count_percent_of_total
    type: percent_of_total
    label: Count (Percent of Total)
    sql: ${count}
  - measure: liquidation_percent
    type: number
    sql: 100.0 * ${total_trs_amt}/NULLIF(${dbr_facts.plac},0)

Contents

  • trs.view.lkml
  • trs.view.lookml