Dbr

view: dbr {
  sql_table_name: DBR ;;

  dimension: dbr_no {
    primary_key: yes
    sql: ${TABLE}.DBR_NO ;;
  }

  dimension: college_status {
    label: "BNCOLLEGE STATUS"
  }

  dimension: college_active {
    label: "BNCOLLEGE ACTIVE"
    type: yesno
    sql: ${TABLE}.DBR_STATUS not in ('CON','RTP','SKE','PIF','SIF','APR') ;;
  }

  dimension: college_concession {
    label: "BNCOLLEGE CONCESSION"
    type: yesno
    sql: ${TABLE}.DBR_STATUS in ('CON','RTP','SKE') ;;
  }

  dimension: college_resolved {
    label: "BNCOLLEGE RESOLVED"
    type: yesno
    sql: ${TABLE}.DBR_STATUS in ('PIF','SIF','APR') ;;
  }

  dimension: dbr_1_flag {
    hidden: yes
    sql: ${TABLE}.DBR_1_FLAG ;;
  }

  dimension: dbr_2_flag {
    hidden: yes
    sql: ${TABLE}.DBR_2_FLAG ;;
  }

  dimension: dbr_3_flag {
    hidden: yes
    sql: ${TABLE}.DBR_3_FLAG ;;
  }

  dimension: dbr_4_flag {
    hidden: yes
    sql: ${TABLE}.DBR_4_FLAG ;;
  }

  dimension: dbr_acn {
    hidden: yes
    sql: ${TABLE}.DBR_ACN ;;
  }

  dimension: dbr_adv_costs {
    type: number
    sql: ${TABLE}.DBR_ADV_COSTS ;;
  }

  dimension: dbr_agency {
    sql: ${TABLE}.DBR_AGENCY ;;
  }

  dimension: dbr_assign_amt {
    type: number
    sql: ${TABLE}.DBR_ASSIGN_AMT ;;
  }

  dimension: dbr_assign_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_ASSIGN_DATE ;;
  }

  dimension: dbr_atty_due {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_ATTY_DUE ;;
  }

  dimension: dbr_atty_tot {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_ATTY_TOT ;;
  }

  dimension: dbr_batch_no {
    sql: ${TABLE}.DBR_BATCH_NO ;;
  }

  dimension: dbr_batch_seq {
    sql: ${TABLE}.DBR_BATCH_SEQ ;;
  }

  dimension: dbr_category {
    sql: ${TABLE}.DBR_CATEGORY ;;
  }

  dimension: dbr_cl_codes_1 {
    sql: ${TABLE}.DBR_CL_CODES_1 ;;
  }

  dimension: dbr_cl_codes_2 {
    sql: ${TABLE}.DBR_CL_CODES_2 ;;
  }

  dimension: dbr_cl_codes_3 {
    sql: ${TABLE}.DBR_CL_CODES_3 ;;
  }

  dimension: dbr_cl_codes_4 {
    sql: ${TABLE}.DBR_CL_CODES_4 ;;
  }

  dimension: dbr_cl_dates_1 {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_CL_DATES_1 ;;
  }

  dimension: dbr_cl_dates_2 {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_CL_DATES_2 ;;
  }

  dimension: dbr_cl_dates_3 {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_CL_DATES_3 ;;
  }

  dimension: dbr_cl_dates_4 {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_CL_DATES_4 ;;
  }

  dimension: dbr_cl_misc_1 {
    sql: ${TABLE}.DBR_CL_MISC_1 ;;
  }

  dimension: dbr_cl_misc_2 {
    sql: ${TABLE}.DBR_CL_MISC_2 ;;
  }

  dimension: dbr_cl_misc_3 {
    sql: ${TABLE}.DBR_CL_MISC_3 ;;
  }

  dimension: dbr_cl_misc_4 {
    sql: ${TABLE}.DBR_CL_MISC_4 ;;
  }

  dimension: dbr_class {
    sql: ${TABLE}.DBR_CLASS ;;
  }

  dimension: dbr_class_desc {
    label: "ACCOUNT CLASS"
  }

  dimension: dbr_cli_ref_no {
    sql: ${TABLE}.DBR_CLI_REF_NO ;;
  }

  dimension: dbr_client {
    sql: ${TABLE}.DBR_CLIENT ;;
  }

  dimension: dbr_client_int_amt {
    type: number
    sql: ${TABLE}.DBR_CLIENT_INT_AMT ;;
  }

  dimension: dbr_close_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_CLOSE_DATE ;;
  }

  dimension: dbr_cntf_due {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_CNTF_DUE ;;
  }

  dimension: dbr_cntf_tot {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_CNTF_TOT ;;
  }

  dimension: dbr_coll_flags {
    hidden: yes
    sql: ${TABLE}.DBR_COLL_FLAGS ;;
  }

  dimension: dbr_com_rate {
    type: number
    sql: ${TABLE}.DBR_COM_RATE ;;
  }

  dimension: dbr_com_rule {
    type: number
    sql: ${TABLE}.DBR_COM_RULE ;;
  }

  dimension: dbr_comm_status {
    hidden: yes
    sql: ${TABLE}.DBR_COMM_STATUS ;;
  }

  dimension: dbr_comm_to_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_COMM_TO_DATE ;;
  }

  dimension: dbr_court_due {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_COURT_DUE ;;
  }

  dimension: dbr_court_tot {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_COURT_TOT ;;
  }

  dimension: dbr_cr_flags {
    hidden: yes
    sql: ${TABLE}.DBR_CR_FLAGS ;;
  }

  dimension: dbr_desk {
    sql: ${TABLE}.DBR_DESK ;;
  }

  dimension: dbr_first_del_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_FIRST_DEL_DATE ;;
  }

  dimension: dbr_int_due {
    type: number
    sql: ${TABLE}.DBR_INT_DUE ;;
  }

  dimension: dbr_int_rate {
    type: number
    sql: ${TABLE}.DBR_INT_RATE ;;
  }

  dimension: dbr_int_thru_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_INT_THRU_DATE ;;
  }

  dimension: dbr_int_tot {
    type: number
    sql: ${TABLE}.DBR_INT_TOT ;;
  }

  dimension: dbr_jint_due {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_JINT_DUE ;;
  }

  dimension: dbr_judgment_amt {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_JUDGMENT_AMT ;;
  }

  dimension: dbr_judgment_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_JUDGMENT_DATE ;;
  }

  dimension: dbr_judgment_int_stdt {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_JUDGMENT_INT_STDT ;;
  }

  dimension: dbr_last_chg_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_LAST_CHG_DATE ;;
  }

  dimension: dbr_last_letter {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_LAST_LETTER ;;
  }

  dimension: dbr_last_pay_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_LAST_PAY_DATE ;;
  }

  dimension: dbr_last_pdc_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_LAST_PDC_DATE ;;
  }

  dimension: dbr_last_pdc_post {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_LAST_PDC_POST ;;
  }

  dimension: dbr_last_trust_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_LAST_TRUST_DATE ;;
  }

  dimension: dbr_last_worked {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_LAST_WORKED ;;
  }

  dimension: dbr_letter_set {
    hidden: yes
    sql: ${TABLE}.DBR_LETTER_SET ;;
  }

  dimension: dbr_lt_coll_flag {
    hidden: yes
    sql: ${TABLE}.DBR_LT_COLL_FLAG ;;
  }

  dimension: dbr_misc_due {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_MISC_DUE ;;
  }

  dimension: dbr_misc_tot {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_MISC_TOT ;;
  }

  dimension: dbr_name1 {
    sql: ${TABLE}.DBR_NAME1 ;;
  }

  dimension: dbr_negotiate_amt {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_NEGOTIATE_AMT ;;
  }

  dimension: dbr_next_ltr_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_NEXT_LTR_DATE ;;
  }

  dimension: dbr_next_ltr_no {
    type: number
    sql: ${TABLE}.DBR_NEXT_LTR_NO ;;
  }

  dimension: dbr_no_ack {
    hidden: yes
    sql: ${TABLE}.DBR_NO_ACK ;;
  }

  dimension: dbr_no_autos {
    hidden: yes
    sql: ${TABLE}.DBR_NO_AUTOS ;;
  }

  dimension: dbr_no_real_estate {
    hidden: yes
    sql: ${TABLE}.DBR_NO_REAL_ESTATE ;;
  }

  dimension: dbr_org_db {
    hidden: yes
    sql: ${TABLE}.DBR_ORG_DB ;;
  }

  dimension: dbr_os_score {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_OS_SCORE ;;
  }

  dimension: dbr_other_due {
    type: number
    sql: ${TABLE}.DBR_OTHER_DUE ;;
  }

  dimension: dbr_other_tot {
    type: number
    sql: ${TABLE}.DBR_OTHER_TOT ;;
  }

  dimension: dbr_owner {
    sql: ${TABLE}.DBR_OWNER ;;
  }

  dimension: dbr_payments_made {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_PAYMENTS_MADE ;;
  }

  dimension: dbr_pc_charges {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_PC_CHARGES ;;
  }

  dimension: dbr_pc_ser {
    hidden: yes
    sql: ${TABLE}.DBR_PC_SER ;;
  }

  dimension: dbr_pcasgn_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_PCASGN_DATE ;;
  }

  dimension: dbr_principal_due {
    type: number
    sql: ${TABLE}.DBR_PRINCIPAL_DUE ;;
  }

  dimension: dbr_principal_recvd {
    type: number
    sql: ${TABLE}.DBR_PRINCIPAL_RECVD ;;
  }

  dimension: dbr_priority {
    sql: ${TABLE}.DBR_PRIORITY ;;
  }

  dimension: provider_database {
    hidden: yes
    sql: ${TABLE}.DBR_PROVID_DBASE ;;
  }

  dimension: dbr_recvd_tot {
    type: number
    sql: ${TABLE}.DBR_RECVD_TOT ;;
  }

  dimension: dbr_review_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_REVIEW_DATE ;;
  }

  dimension: dbr_rj_letter {
    hidden: yes
    sql: ${TABLE}.DBR_RJ_LETTER ;;
  }

  dimension: dbr_rs {
    hidden: yes
    sql: ${TABLE}.DBR_RS ;;
  }

  dimension: dbr_status {
    sql: ${TABLE}.DBR_STATUS ;;
  }

  dimension: dbr_stl_amt {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_STL_AMT ;;
  }

  dimension: dbr_stl_dis {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_STL_DIS ;;
  }

  dimension: dbr_stl_exp {
    hidden: yes
    sql: ${TABLE}.DBR_STL_EXP ;;
  }

  dimension: dbr_stl_per {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_STL_PER ;;
  }

  dimension: dbr_tie_series {
    sql: ${TABLE}.DBR_TIE_SERIES ;;
  }

  dimension: dbr_tiger_link {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_TIGER_LINK ;;
  }

  dimension: dbr_time_zone {
    sql: ${TABLE}.DBR_TIME_ZONE ;;
  }

  dimension: dbr_trw_ccc {
    hidden: yes
    sql: ${TABLE}.DBR_TRW_CCC ;;
  }

  dimension: dbr_trw_first_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_TRW_FIRST_DATE ;;
  }

  dimension: dbr_trw_flag {
    hidden: yes
    sql: ${TABLE}.DBR_TRW_FLAG ;;
  }

  dimension: dbr_trw_flag_1 {
    hidden: yes
    sql: ${TABLE}.DBR_TRW_FLAG_1 ;;
  }

  dimension: dbr_trw_flag_2 {
    hidden: yes
    sql: ${TABLE}.DBR_TRW_FLAG_2 ;;
  }

  dimension: dbr_trw_flag_3 {
    hidden: yes
    sql: ${TABLE}.DBR_TRW_FLAG_3 ;;
  }

  dimension: dbr_trw_flag_4 {
    hidden: yes
    sql: ${TABLE}.DBR_TRW_FLAG_4 ;;
  }

  dimension: dbr_trw_last_date {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_TRW_LAST_DATE ;;
  }

  dimension: dbr_trw_status {
    hidden: yes
    sql: ${TABLE}.DBR_TRW_STATUS ;;
  }

  dimension: dbr_ttl_bankos {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_TTL_BANKOS ;;
  }

  dimension: dbr_ttl_crd_rpts {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_TTL_CRD_RPTS ;;
  }

  dimension: dbr_ttl_ext_skp_tr {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_TTL_EXT_SKP_TR ;;
  }

  dimension: dbr_ws_days_worked_cnt {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_WS_DAYS_WORKED_CNT ;;
  }

  dimension: dbr_ws_ltr_cnt {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_WS_LTR_CNT ;;
  }

  dimension: dbr_ws_ltr_ncnt {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_WS_LTR_NCNT ;;
  }

  dimension: dbr_ws_phn_conn_cnt {
    type: number
    hidden: yes
    sql: ${TABLE}.DBR_WS_PHN_CONN_CNT ;;
  }

  dimension: dbr_ws_rule {
    hidden: yes
    sql: ${TABLE}.DBR_WS_RULE ;;
  }

  dimension: dbr_years_at_emp {
    hidden: yes
    sql: ${TABLE}.DBR_YEARS_AT_EMP ;;
  }

  dimension: dbr_years_at_res {
    hidden: yes
    sql: ${TABLE}.DBR_YEARS_AT_RES ;;
  }

  dimension_group: dbr_assign_date_o {
    label: "PLACEMENT"
    type: time
    timeframes: [date, week, month]
    sql: ${TABLE}.DBR_ASSIGN_DATE_O ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: total_assign_amt {
    label: "TOTAL PLACED"
    type: sum
    sql: ${dbr_assign_amt} ;;
  }

  measure: month1_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month1_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month1_display {
    label: "MONTH1"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month1_sum},0),'<BR/>',FORMAT(${month1_pct},2),'%') ;;
  }

  measure: month2_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month2_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month2_display {
    label: "MONTH2"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month2_sum},0),'<BR/>',FORMAT(${month2_pct},2),'%') ;;
  }

  measure: month3_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month3_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month3_display {
    label: "MONTH3"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month3_sum},0),'<BR/>',FORMAT(${month3_pct},2),'%') ;;
  }

  measure: month4_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month4_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month4_display {
    label: "MONTH4"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month4_sum},0),'<BR/>',FORMAT(${month4_pct},2),'%') ;;
  }

  measure: month5_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month5_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month5_display {
    label: "MONTH5"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month5_sum},0),'<BR/>',FORMAT(${month5_pct},2),'%') ;;
  }

  measure: month6_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month6_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month6_display {
    label: "MONTH6"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month6_sum},0),'<BR/>',FORMAT(${month6_pct},2),'%') ;;
  }

  measure: month7_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month7_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month7_display {
    label: "MONTH7"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month7_sum},0),'<BR/>',FORMAT(${month7_pct},2),'%') ;;
  }

  measure: month8_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month8_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month8_display {
    label: "MONTH8"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month8_sum},0),'<BR/>',FORMAT(${month8_pct},2),'%') ;;
  }

  measure: month9_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month9_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month9_display {
    label: "MONTH9"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month9_sum},0),'<BR/>',FORMAT(${month9_pct},2),'%') ;;
  }

  measure: month10_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month10_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month10_display {
    label: "MONTH10"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month10_sum},0),'<BR/>',FORMAT(${month10_pct},2),'%') ;;
  }

  measure: month11_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month11_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month11_display {
    label: "MONTH11"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month11_sum},0),'<BR/>',FORMAT(${month11_pct},2),'%') ;;
  }

  measure: month12_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month12_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month12_display {
    label: "MONTH12"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month12_sum},0),'<BR/>',FORMAT(${month12_pct},2),'%') ;;
  }

  measure: month13_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.month13_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: month13_display {
    label: "MONTH13"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month13_sum},0),'<BR/>',FORMAT(${month13_pct},2),'%') ;;
  }

  measure: total_pct {
    type: number
    hidden: yes
    sql: ${dbr_trs_facts.total_sum} / NULLIF(${total_assign_amt},0) * 100 ;;
  }

  measure: total_display {
    label: "TOTALS"
    type: string
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.total_sum},0),'<BR/>',FORMAT(${total_pct},2),'%') ;;
  }

  measure: count {
    label: "ACCOUNTS PLACED"
    type: count
  }

  measure: total_dbr_assign_amt {
    label: "ASSIGNED AMOUNT"
    type: sum
    sql: ${dbr_assign_amt} ;;
  }

  measure: total_dbr_collected {
    label: "AMOUNT COLLECTED FOR WEDGE"
    type: number
    sql: ${dbr_trs_facts.total_sum} ;;
  }

  measure: total_dbr_principal_due {
    label: "BALANCE"
    type: sum
    sql: ${dbr_principal_due} ;;
  }

  measure: total_dbr_pmt {
    label: "TOTAL PAYMENT AMOUNT"
    type: sum
    sql: ${dbr_pmt_facts.total_pmt} ;;
  }

  measure: total_recovery_pct {
    label: "COLLECTED PERCENT FOR WEDGE"
    type: number
    sql: ${total_dbr_collected} / NULLIF(${total_dbr_assign_amt},0) * 100 ;;
  }

  measure: total_pmt_pct {
    label: "PAID PERCENT"
    type: number
    sql: ${total_dbr_pmt} / NULLIF(${total_dbr_assign_amt},0) * 100 ;;
  }

  measure: count_active {
    type: count
    filters: [dbr_class_desc: "Active"]
  }

  measure: percent_active {
    type: number
    sql: 100.0 * ${count_active}/ NULLIF(${count},0) ;;
  }
}

- view: dbr
  sql_table_name: DBR
  fields:
  - dimension: dbr_no
    primary_key: true
    sql: ${TABLE}.DBR_NO
  - dimension: college_status
    label: BNCOLLEGE STATUS
  - dimension: college_active
    type: yesno
    label: BNCOLLEGE ACTIVE
    sql: ${TABLE}.DBR_STATUS not in ('CON','RTP','SKE','PIF','SIF','APR')
  - dimension: college_concession
    type: yesno
    label: BNCOLLEGE CONCESSION
    sql: ${TABLE}.DBR_STATUS in ('CON','RTP','SKE')
  - dimension: college_resolved
    type: yesno
    label: BNCOLLEGE RESOLVED
    sql: ${TABLE}.DBR_STATUS in ('PIF','SIF','APR')
  - dimension: dbr_1_flag
    hidden: true
    sql: ${TABLE}.DBR_1_FLAG
  - dimension: dbr_2_flag
    hidden: true
    sql: ${TABLE}.DBR_2_FLAG
  - dimension: dbr_3_flag
    hidden: true
    sql: ${TABLE}.DBR_3_FLAG
  - dimension: dbr_4_flag
    hidden: true
    sql: ${TABLE}.DBR_4_FLAG
  - dimension: dbr_acn
    hidden: true
    sql: ${TABLE}.DBR_ACN
  - dimension: dbr_adv_costs
    type: number
    sql: ${TABLE}.DBR_ADV_COSTS
  - dimension: dbr_agency
    sql: ${TABLE}.DBR_AGENCY
  - dimension: dbr_assign_amt
    type: number
    sql: ${TABLE}.DBR_ASSIGN_AMT
  - dimension: dbr_assign_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_ASSIGN_DATE
  - dimension: dbr_atty_due
    type: number
    hidden: true
    sql: ${TABLE}.DBR_ATTY_DUE
  - dimension: dbr_atty_tot
    type: number
    hidden: true
    sql: ${TABLE}.DBR_ATTY_TOT
  - dimension: dbr_batch_no
    sql: ${TABLE}.DBR_BATCH_NO
  - dimension: dbr_batch_seq
    sql: ${TABLE}.DBR_BATCH_SEQ
  - dimension: dbr_category
    sql: ${TABLE}.DBR_CATEGORY
  - dimension: dbr_cl_codes_1
    sql: ${TABLE}.DBR_CL_CODES_1
  - dimension: dbr_cl_codes_2
    sql: ${TABLE}.DBR_CL_CODES_2
  - dimension: dbr_cl_codes_3
    sql: ${TABLE}.DBR_CL_CODES_3
  - dimension: dbr_cl_codes_4
    sql: ${TABLE}.DBR_CL_CODES_4
  - dimension: dbr_cl_dates_1
    type: number
    hidden: true
    sql: ${TABLE}.DBR_CL_DATES_1
  - dimension: dbr_cl_dates_2
    type: number
    hidden: true
    sql: ${TABLE}.DBR_CL_DATES_2
  - dimension: dbr_cl_dates_3
    type: number
    hidden: true
    sql: ${TABLE}.DBR_CL_DATES_3
  - dimension: dbr_cl_dates_4
    type: number
    hidden: true
    sql: ${TABLE}.DBR_CL_DATES_4
  - dimension: dbr_cl_misc_1
    sql: ${TABLE}.DBR_CL_MISC_1
  - dimension: dbr_cl_misc_2
    sql: ${TABLE}.DBR_CL_MISC_2
  - dimension: dbr_cl_misc_3
    sql: ${TABLE}.DBR_CL_MISC_3
  - dimension: dbr_cl_misc_4
    sql: ${TABLE}.DBR_CL_MISC_4
  - dimension: dbr_class
    sql: ${TABLE}.DBR_CLASS
  - dimension: dbr_class_desc
    label: ACCOUNT CLASS
  - dimension: dbr_cli_ref_no
    sql: ${TABLE}.DBR_CLI_REF_NO
  - dimension: dbr_client
    sql: ${TABLE}.DBR_CLIENT
  - dimension: dbr_client_int_amt
    type: number
    sql: ${TABLE}.DBR_CLIENT_INT_AMT
  - dimension: dbr_close_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_CLOSE_DATE
  - dimension: dbr_cntf_due
    type: number
    hidden: true
    sql: ${TABLE}.DBR_CNTF_DUE
  - dimension: dbr_cntf_tot
    type: number
    hidden: true
    sql: ${TABLE}.DBR_CNTF_TOT
  - dimension: dbr_coll_flags
    hidden: true
    sql: ${TABLE}.DBR_COLL_FLAGS
  - dimension: dbr_com_rate
    type: number
    sql: ${TABLE}.DBR_COM_RATE
  - dimension: dbr_com_rule
    type: number
    sql: ${TABLE}.DBR_COM_RULE
  - dimension: dbr_comm_status
    hidden: true
    sql: ${TABLE}.DBR_COMM_STATUS
  - dimension: dbr_comm_to_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_COMM_TO_DATE
  - dimension: dbr_court_due
    type: number
    hidden: true
    sql: ${TABLE}.DBR_COURT_DUE
  - dimension: dbr_court_tot
    type: number
    hidden: true
    sql: ${TABLE}.DBR_COURT_TOT
  - dimension: dbr_cr_flags
    hidden: true
    sql: ${TABLE}.DBR_CR_FLAGS
  - dimension: dbr_desk
    sql: ${TABLE}.DBR_DESK
  - dimension: dbr_first_del_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_FIRST_DEL_DATE
  - dimension: dbr_int_due
    type: number
    sql: ${TABLE}.DBR_INT_DUE
  - dimension: dbr_int_rate
    type: number
    sql: ${TABLE}.DBR_INT_RATE
  - dimension: dbr_int_thru_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_INT_THRU_DATE
  - dimension: dbr_int_tot
    type: number
    sql: ${TABLE}.DBR_INT_TOT
  - dimension: dbr_jint_due
    type: number
    hidden: true
    sql: ${TABLE}.DBR_JINT_DUE
  - dimension: dbr_judgment_amt
    type: number
    hidden: true
    sql: ${TABLE}.DBR_JUDGMENT_AMT
  - dimension: dbr_judgment_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_JUDGMENT_DATE
  - dimension: dbr_judgment_int_stdt
    type: number
    hidden: true
    sql: ${TABLE}.DBR_JUDGMENT_INT_STDT
  - dimension: dbr_last_chg_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_LAST_CHG_DATE
  - dimension: dbr_last_letter
    type: number
    hidden: true
    sql: ${TABLE}.DBR_LAST_LETTER
  - dimension: dbr_last_pay_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_LAST_PAY_DATE
  - dimension: dbr_last_pdc_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_LAST_PDC_DATE
  - dimension: dbr_last_pdc_post
    type: number
    hidden: true
    sql: ${TABLE}.DBR_LAST_PDC_POST
  - dimension: dbr_last_trust_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_LAST_TRUST_DATE
  - dimension: dbr_last_worked
    type: number
    hidden: true
    sql: ${TABLE}.DBR_LAST_WORKED
  - dimension: dbr_letter_set
    hidden: true
    sql: ${TABLE}.DBR_LETTER_SET
  - dimension: dbr_lt_coll_flag
    hidden: true
    sql: ${TABLE}.DBR_LT_COLL_FLAG
  - dimension: dbr_misc_due
    type: number
    hidden: true
    sql: ${TABLE}.DBR_MISC_DUE
  - dimension: dbr_misc_tot
    type: number
    hidden: true
    sql: ${TABLE}.DBR_MISC_TOT
  - dimension: dbr_name1
    sql: ${TABLE}.DBR_NAME1
  - dimension: dbr_negotiate_amt
    type: number
    hidden: true
    sql: ${TABLE}.DBR_NEGOTIATE_AMT
  - dimension: dbr_next_ltr_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_NEXT_LTR_DATE
  - dimension: dbr_next_ltr_no
    type: number
    sql: ${TABLE}.DBR_NEXT_LTR_NO
  - dimension: dbr_no_ack
    hidden: true
    sql: ${TABLE}.DBR_NO_ACK
  - dimension: dbr_no_autos
    hidden: true
    sql: ${TABLE}.DBR_NO_AUTOS
  - dimension: dbr_no_real_estate
    hidden: true
    sql: ${TABLE}.DBR_NO_REAL_ESTATE
  - dimension: dbr_org_db
    hidden: true
    sql: ${TABLE}.DBR_ORG_DB
  - dimension: dbr_os_score
    type: number
    hidden: true
    sql: ${TABLE}.DBR_OS_SCORE
  - dimension: dbr_other_due
    type: number
    sql: ${TABLE}.DBR_OTHER_DUE
  - dimension: dbr_other_tot
    type: number
    sql: ${TABLE}.DBR_OTHER_TOT
  - dimension: dbr_owner
    sql: ${TABLE}.DBR_OWNER
  - dimension: dbr_payments_made
    type: number
    hidden: true
    sql: ${TABLE}.DBR_PAYMENTS_MADE
  - dimension: dbr_pc_charges
    type: number
    hidden: true
    sql: ${TABLE}.DBR_PC_CHARGES
  - dimension: dbr_pc_ser
    hidden: true
    sql: ${TABLE}.DBR_PC_SER
  - dimension: dbr_pcasgn_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_PCASGN_DATE
  - dimension: dbr_principal_due
    type: number
    sql: ${TABLE}.DBR_PRINCIPAL_DUE
  - dimension: dbr_principal_recvd
    type: number
    sql: ${TABLE}.DBR_PRINCIPAL_RECVD
  - dimension: dbr_priority
    sql: ${TABLE}.DBR_PRIORITY
  - dimension: provider_database
    hidden: true
    sql: ${TABLE}.DBR_PROVID_DBASE
  - dimension: dbr_recvd_tot
    type: number
    sql: ${TABLE}.DBR_RECVD_TOT
  - dimension: dbr_review_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_REVIEW_DATE
  - dimension: dbr_rj_letter
    hidden: true
    sql: ${TABLE}.DBR_RJ_LETTER
  - dimension: dbr_rs
    hidden: true
    sql: ${TABLE}.DBR_RS
  - dimension: dbr_status
    sql: ${TABLE}.DBR_STATUS
  - dimension: dbr_stl_amt
    type: number
    hidden: true
    sql: ${TABLE}.DBR_STL_AMT
  - dimension: dbr_stl_dis
    type: number
    hidden: true
    sql: ${TABLE}.DBR_STL_DIS
  - dimension: dbr_stl_exp
    hidden: true
    sql: ${TABLE}.DBR_STL_EXP
  - dimension: dbr_stl_per
    type: number
    hidden: true
    sql: ${TABLE}.DBR_STL_PER
  - dimension: dbr_tie_series
    sql: ${TABLE}.DBR_TIE_SERIES
  - dimension: dbr_tiger_link
    type: number
    hidden: true
    sql: ${TABLE}.DBR_TIGER_LINK
  - dimension: dbr_time_zone
    sql: ${TABLE}.DBR_TIME_ZONE
  - dimension: dbr_trw_ccc
    hidden: true
    sql: ${TABLE}.DBR_TRW_CCC
  - dimension: dbr_trw_first_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_TRW_FIRST_DATE
  - dimension: dbr_trw_flag
    hidden: true
    sql: ${TABLE}.DBR_TRW_FLAG
  - dimension: dbr_trw_flag_1
    hidden: true
    sql: ${TABLE}.DBR_TRW_FLAG_1
  - dimension: dbr_trw_flag_2
    hidden: true
    sql: ${TABLE}.DBR_TRW_FLAG_2
  - dimension: dbr_trw_flag_3
    hidden: true
    sql: ${TABLE}.DBR_TRW_FLAG_3
  - dimension: dbr_trw_flag_4
    hidden: true
    sql: ${TABLE}.DBR_TRW_FLAG_4
  - dimension: dbr_trw_last_date
    type: number
    hidden: true
    sql: ${TABLE}.DBR_TRW_LAST_DATE
  - dimension: dbr_trw_status
    hidden: true
    sql: ${TABLE}.DBR_TRW_STATUS
  - dimension: dbr_ttl_bankos
    type: number
    hidden: true
    sql: ${TABLE}.DBR_TTL_BANKOS
  - dimension: dbr_ttl_crd_rpts
    type: number
    hidden: true
    sql: ${TABLE}.DBR_TTL_CRD_RPTS
  - dimension: dbr_ttl_ext_skp_tr
    type: number
    hidden: true
    sql: ${TABLE}.DBR_TTL_EXT_SKP_TR
  - dimension: dbr_ws_days_worked_cnt
    type: number
    hidden: true
    sql: ${TABLE}.DBR_WS_DAYS_WORKED_CNT
  - dimension: dbr_ws_ltr_cnt
    type: number
    hidden: true
    sql: ${TABLE}.DBR_WS_LTR_CNT
  - dimension: dbr_ws_ltr_ncnt
    type: number
    hidden: true
    sql: ${TABLE}.DBR_WS_LTR_NCNT
  - dimension: dbr_ws_phn_conn_cnt
    type: number
    hidden: true
    sql: ${TABLE}.DBR_WS_PHN_CONN_CNT
  - dimension: dbr_ws_rule
    hidden: true
    sql: ${TABLE}.DBR_WS_RULE
  - dimension: dbr_years_at_emp
    hidden: true
    sql: ${TABLE}.DBR_YEARS_AT_EMP
  - dimension: dbr_years_at_res
    hidden: true
    sql: ${TABLE}.DBR_YEARS_AT_RES
  - dimension_group: dbr_assign_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_ASSIGN_DATE_O
  - dimension_group: dbr_cl_dates_1_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_CL_DATES_1_O
  - dimension_group: dbr_cl_dates_2_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_CL_DATES_2_O
  - dimension_group: dbr_cl_dates_3_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_CL_DATES_3_O
  - dimension_group: dbr_cl_dates_4_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_CL_DATES_4_O
  - dimension_group: dbr_close_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_CLOSE_DATE_O
  - dimension_group: dbr_first_del_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_FIRST_DEL_DATE_O
  - dimension_group: dbr_int_thru_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_INT_THRU_DATE_O
  - dimension_group: dbr_judgment_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_JUDGMENT_DATE_O
  - dimension_group: dbr_judgment_int_stdt_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_JUDGMENT_INT_STDT_O
  - dimension_group: dbr_last_chg_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_LAST_CHG_DATE_O
  - dimension_group: dbr_last_letter_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_LAST_LETTER_O
  - dimension_group: dbr_last_pay_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_LAST_PAY_DATE_O
  - dimension_group: dbr_last_pdc_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_LAST_PDC_DATE_O
  - dimension_group: dbr_last_trust_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_LAST_TRUST_DATE_O
  - dimension_group: dbr_last_worked_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_LAST_WORKED_O
  - dimension_group: dbr_next_ltr_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_NEXT_LTR_DATE_O
  - dimension_group: dbr_pcasgn_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_PCASGN_DATE_O
  - dimension_group: dbr_review_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_REVIEW_DATE_O
  - dimension_group: dbr_trw_first_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_TRW_FIRST_DATE_O
  - dimension_group: dbr_trw_last_date_o
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.DBR_TRW_LAST_DATE_O
  - measure: total_assign_amt
    type: sum
    label: TOTAL PLACED
    sql: ${dbr_assign_amt}
  - measure: month1_pct
    type: number
    sql: ${dbr_trs_facts.month1_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month1_display
    type: string
    label: MONTH1
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month1_sum},0),'<BR/>',FORMAT(${month1_pct},2),'%')
  - measure: month2_pct
    type: number
    sql: ${dbr_trs_facts.month2_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month2_display
    type: string
    label: MONTH2
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month2_sum},0),'<BR/>',FORMAT(${month2_pct},2),'%')
  - measure: month3_pct
    type: number
    sql: ${dbr_trs_facts.month3_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month3_display
    type: string
    label: MONTH3
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month3_sum},0),'<BR/>',FORMAT(${month3_pct},2),'%')
  - measure: month4_pct
    type: number
    sql: ${dbr_trs_facts.month4_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month4_display
    type: string
    label: MONTH4
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month4_sum},0),'<BR/>',FORMAT(${month4_pct},2),'%')
  - measure: month5_pct
    type: number
    sql: ${dbr_trs_facts.month5_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month5_display
    type: string
    label: MONTH5
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month5_sum},0),'<BR/>',FORMAT(${month5_pct},2),'%')
  - measure: month6_pct
    type: number
    sql: ${dbr_trs_facts.month6_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month6_display
    type: string
    label: MONTH6
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month6_sum},0),'<BR/>',FORMAT(${month6_pct},2),'%')
  - measure: month7_pct
    type: number
    sql: ${dbr_trs_facts.month7_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month7_display
    type: string
    label: MONTH7
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month7_sum},0),'<BR/>',FORMAT(${month7_pct},2),'%')
  - measure: month8_pct
    type: number
    sql: ${dbr_trs_facts.month8_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month8_display
    type: string
    label: MONTH8
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month8_sum},0),'<BR/>',FORMAT(${month8_pct},2),'%')
  - measure: month9_pct
    type: number
    sql: ${dbr_trs_facts.month9_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month9_display
    type: string
    label: MONTH9
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month9_sum},0),'<BR/>',FORMAT(${month9_pct},2),'%')
  - measure: month10_pct
    type: number
    sql: ${dbr_trs_facts.month10_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month10_display
    type: string
    label: MONTH10
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month10_sum},0),'<BR/>',FORMAT(${month10_pct},2),'%')
  - measure: month11_pct
    type: number
    sql: ${dbr_trs_facts.month11_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month11_display
    type: string
    label: MONTH11
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month11_sum},0),'<BR/>',FORMAT(${month11_pct},2),'%')
  - measure: month12_pct
    type: number
    sql: ${dbr_trs_facts.month12_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month12_display
    type: string
    label: MONTH12
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month12_sum},0),'<BR/>',FORMAT(${month12_pct},2),'%')
  - measure: month13_pct
    type: number
    sql: ${dbr_trs_facts.month13_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: month13_display
    type: string
    label: MONTH13
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.month13_sum},0),'<BR/>',FORMAT(${month13_pct},2),'%')
  - measure: total_pct
    type: number
    sql: ${dbr_trs_facts.total_sum} / NULLIF(${total_assign_amt},0) * 100
  - measure: total_display
    type: string
    label: TOTALS
    sql: CONCAT('$',FORMAT(${dbr_trs_facts.total_sum},0),'<BR/>',FORMAT(${total_pct},2),'%')
  - measure: count
    type: count
    label: ACCOUNTS PLACED
  - measure: total_dbr_assign_amt
    type: sum
    label: ASSIGNED AMOUNT
    sql: ${dbr_assign_amt}
  - measure: total_dbr_collected
    type: number
    label: AMOUNT COLLECTED FOR WEDGE
    sql: ${dbr_trs_facts.total_sum}
  - measure: total_dbr_principal_due
    type: sum
    label: BALANCE
    sql: ${dbr_principal_due}
  - measure: total_dbr_pmt
    type: sum
    label: TOTAL PAYMENT AMOUNT
    sql: ${dbr_pmt_facts.total_pmt}
  - measure: total_recovery_pct
    type: number
    label: COLLECTED PERCENT FOR WEDGE
    sql: ${total_dbr_collected} / NULLIF(${total_dbr_assign_amt},0) * 100
  - measure: total_pmt_pct
    type: number
    label: PAID PERCENT
    sql: ${total_dbr_pmt} / NULLIF(${total_dbr_assign_amt},0) * 100
  - measure: count_active
    type: count
    filters:
    - dbr_class_desc: Active
  - measure: percent_active
    type: number
    sql: 100.0 * ${count_active}/ NULLIF(${count},0)