Ae Applications

view: ae_applications {
  sql_table_name: public.ae_applications ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: flgacceptstext {
    type: yesno
    sql: ${TABLE}.flgacceptstext ;;
  }

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

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

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

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

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

  dimension: flgcc {
    type: yesno
    sql: ${TABLE}.flgcc ;;
  }

  dimension: flgdebitauto {
    type: yesno
    sql: ${TABLE}.flgdebitauto ;;
  }

  dimension: flgdenyauto {
    type: yesno
    sql: ${TABLE}.flgdenyauto ;;
  }

  dimension: flgdenymanual {
    type: yesno
    sql: ${TABLE}.flgdenymanual ;;
  }

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

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

  dimension: flgdirectdeposit {
    type: yesno
    sql: ${TABLE}.flgdirectdeposit ;;
  }

  dimension: flgdownsell {
    type: yesno
    sql: ${TABLE}.flgdownsell ;;
  }

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

  dimension: flgfraudulent {
    type: yesno
    sql: ${TABLE}.flgfraudulent ;;
  }

  dimension: flghascookies {
    type: yesno
    sql: ${TABLE}.flghascookies ;;
  }

  dimension: flginstantdecision {
    type: yesno
    sql: ${TABLE}.flginstantdecision ;;
  }

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

  dimension: flgmilitary {
    type: yesno
    sql: ${TABLE}.flgmilitary ;;
  }

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

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

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

  dimension: flgprepaid {
    type: yesno
    sql: ${TABLE}.flgprepaid ;;
  }

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

  dimension: flgredbankaccountseenbefore {
    type: yesno
    sql: ${TABLE}.flgredbankaccountseenbefore ;;
  }

  dimension: flgredprepaiddebit {
    type: yesno
    sql: ${TABLE}.flgredprepaiddebit ;;
  }

  dimension: flgredssnseenbefore {
    type: yesno
    sql: ${TABLE}.flgredssnseenbefore ;;
  }

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

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

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

  dimension: flgwarnemailseenbefore {
    type: yesno
    sql: ${TABLE}.flgwarnemailseenbefore ;;
  }

  dimension: hassocialprofile {
    type: yesno
    sql: ${TABLE}.hassocialprofile ;;
  }

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

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

  dimension: howusemoneybillsauto {
    type: yesno
    sql: ${TABLE}.howusemoneybillsauto ;;
  }

  dimension: howusemoneybillsgeneral {
    type: yesno
    sql: ${TABLE}.howusemoneybillsgeneral ;;
  }

  dimension: howusemoneybillshomeorutilities {
    type: yesno
    sql: ${TABLE}.howusemoneybillshomeorutilities ;;
  }

  dimension: howusemoneybillsmedical {
    type: yesno
    sql: ${TABLE}.howusemoneybillsmedical ;;
  }

  dimension: howusemoneygiftsorleisure {
    type: yesno
    sql: ${TABLE}.howusemoneygiftsorleisure ;;
  }

  dimension: howusemoneyother {
    type: yesno
    sql: ${TABLE}.howusemoneyother ;;
  }

  dimension: howusemoneypayoffloansoroverdrawnacct {
    type: yesno
    sql: ${TABLE}.howusemoneypayoffloansoroverdrawnacct ;;
  }

  dimension: howusemoneyrentormortgage {
    type: yesno
    sql: ${TABLE}.howusemoneyrentormortgage ;;
  }

  dimension: howusemoneyschool {
    type: yesno
    sql: ${TABLE}.howusemoneyschool ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: usesemailforsocialprofile {
    type: yesno
    sql: ${TABLE}.usesemailforsocialprofile ;;
  }

  dimension: is_repeat_borrower {
    type: yesno
    sql: ${flgrepeatborrower} = 1 ;;
  }

  dimension: is_new_borrower {
    type: yesno
    sql: ${flgrepeatborrower} = 0 ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}

- view: ae_applications
  sql_table_name: public.ae_applications
  fields:
  - dimension: acctnumbank
    sql: ${TABLE}.acctnumbank
  - dimension: acctnumbankconfirm
    sql: ${TABLE}.acctnumbankconfirm
  - dimension: acctnumbankrouting
    sql: ${TABLE}.acctnumbankrouting
  - dimension: acctnumbankroutingconfirm
    sql: ${TABLE}.acctnumbankroutingconfirm
  - dimension: addrapt
    sql: ${TABLE}.addrapt
  - dimension: addrcity
    sql: ${TABLE}.addrcity
  - dimension: addrspousecity
    sql: ${TABLE}.addrspousecity
  - dimension: addrspousestate
    sql: ${TABLE}.addrspousestate
  - dimension: addrspousestreet1
    sql: ${TABLE}.addrspousestreet1
  - dimension: addrspousestreet2
    sql: ${TABLE}.addrspousestreet2
  - dimension: addrspousezip
    sql: ${TABLE}.addrspousezip
  - dimension: addrstate
    sql: ${TABLE}.addrstate
  - dimension: addrstreet
    sql: ${TABLE}.addrstreet
  - dimension: addrzip
    sql: ${TABLE}.addrzip
  - dimension: amtapprovedcredittier
    sql: ${TABLE}.amtapprovedcredittier
  - dimension: amtexpensehome
    type: number
    sql: ${TABLE}.amtexpensehome
  - dimension: amtfeensf
    sql: ${TABLE}.amtfeensf
  - dimension: amtfeeorig
    type: number
    sql: ${TABLE}.amtfeeorig
  - dimension: amtincome
    sql: ${TABLE}.amtincome
  - dimension: amtincomeother
    sql: ${TABLE}.amtincomeother
  - dimension: amtloanapproved
    type: number
    sql: ${TABLE}.amtloanapproved
  - dimension: amtloanreq
    type: number
    sql: ${TABLE}.amtloanreq
  - dimension: amtmonthlyincome
    type: number
    sql: ${TABLE}.amtmonthlyincome
  - dimension: amtpmt
    sql: ${TABLE}.amtpmt
  - dimension: amtpmtapproved
    type: number
    sql: ${TABLE}.amtpmtapproved
  - dimension: cntcallbacks
    type: int
    sql: ${TABLE}.cntcallbacks
  - dimension: cv_fdicloandays
    type: int
    sql: ${TABLE}.cv_fdicloandays
  - dimension: cv_loans
    type: int
    sql: ${TABLE}.cv_loans
  - dimension: dayincomefreqbiweekly
    sql: ${TABLE}.dayincomefreqbiweekly
  - dimension: dayincomefreqmonthly
    sql: ${TABLE}.dayincomefreqmonthly
  - dimension: dayincomefreqsemi1
    sql: ${TABLE}.dayincomefreqsemi1
  - dimension: dayincomefreqsemi2
    sql: ${TABLE}.dayincomefreqsemi2
  - dimension: denialreasonborrower
    sql: ${TABLE}.denialreasonborrower
  - dimension: driverslicensestate
    sql: ${TABLE}.driverslicensestate
  - dimension: dtlastincome
    sql: ${TABLE}.dtlastincome
  - dimension: dtlastpayment
    sql: ${TABLE}.dtlastpayment
  - dimension: dtnextincome
    sql: ${TABLE}.dtnextincome
  - dimension: durapprovedcredittier
    sql: ${TABLE}.durapprovedcredittier
  - dimension: durbankacct
    sql: ${TABLE}.durbankacct
  - dimension: durloanapproved
    type: int
    sql: ${TABLE}.durloanapproved
  - dimension: durloanreq
    type: int
    sql: ${TABLE}.durloanreq
  - dimension: durresidence
    sql: ${TABLE}.durresidence
  - dimension: dx_achdebitattempts60
    type: int
    sql: ${TABLE}.dx_achdebitattempts60
  - dimension: dx_activetradelines14
    type: int
    sql: ${TABLE}.dx_activetradelines14
  - dimension: dx_applicationinquiries14
    type: int
    sql: ${TABLE}.dx_applicationinquiries14
  - dimension: dx_applicationinquiries180
    type: int
    sql: ${TABLE}.dx_applicationinquiries180
  - dimension: dx_firstpaymentreturns180
    type: int
    sql: ${TABLE}.dx_firstpaymentreturns180
  - dimension: dx_nsfreturns90
    type: int
    sql: ${TABLE}.dx_nsfreturns90
  - dimension: dx_totalchargeoffs180
    type: int
    sql: ${TABLE}.dx_totalchargeoffs180
  - dimension: email
    sql: ${TABLE}.email
  - dimension: flgabletopay
    sql: ${TABLE}.flgabletopay
  - dimension: flgacceptstext
    type: yesno
    sql: ${TABLE}.flgacceptstext
  - dimension: flgagreetoterms
    sql: ${TABLE}.flgagreetoterms
  - dimension: flgappstep
    sql: ${TABLE}.flgappstep
  - dimension: flgcallifcantpay
    sql: ${TABLE}.flgcallifcantpay
  - dimension: flgcallinadvance
    sql: ${TABLE}.flgcallinadvance
  - dimension: flgcallstep
    sql: ${TABLE}.flgcallstep
  - dimension: flgcc
    type: yesno
    sql: ${TABLE}.flgcc
  - dimension: flgdebitauto
    type: yesno
    sql: ${TABLE}.flgdebitauto
  - dimension: flgdenyauto
    type: yesno
    sql: ${TABLE}.flgdenyauto
  - dimension: flgdenymanual
    type: yesno
    sql: ${TABLE}.flgdenymanual
  - dimension: flgdenymanualrm
    sql: ${TABLE}.flgdenymanualrm
  - dimension: flgdenyprepaiddebit
    sql: ${TABLE}.flgdenyprepaiddebit
  - dimension: flgdirectdeposit
    type: yesno
    sql: ${TABLE}.flgdirectdeposit
  - dimension: flgdownsell
    type: yesno
    sql: ${TABLE}.flgdownsell
  - dimension: flgfraud
    sql: ${TABLE}.flgfraud
  - dimension: flgfraudulent
    type: yesno
    sql: ${TABLE}.flgfraudulent
  - dimension: flghascookies
    type: yesno
    sql: ${TABLE}.flghascookies
  - dimension: flginstantdecision
    type: yesno
    sql: ${TABLE}.flginstantdecision
  - dimension: flgmarried
    sql: ${TABLE}.flgmarried
  - dimension: flgmilitary
    type: yesno
    sql: ${TABLE}.flgmilitary
  - dimension: flgmoneywillshowup
    sql: ${TABLE}.flgmoneywillshowup
  - dimension: flgotherincome
    sql: ${TABLE}.flgotherincome
  - dimension: flgoverride
    sql: ${TABLE}.flgoverride
  - dimension: flgprepaid
    type: yesno
    sql: ${TABLE}.flgprepaid
  - dimension: flgprimaryphonetextable
    sql: ${TABLE}.flgprimaryphonetextable
  - dimension: flgredbankaccountseenbefore
    type: yesno
    sql: ${TABLE}.flgredbankaccountseenbefore
  - dimension: flgredprepaiddebit
    type: yesno
    sql: ${TABLE}.flgredprepaiddebit
  - dimension: flgredssnseenbefore
    type: yesno
    sql: ${TABLE}.flgredssnseenbefore
  - dimension: flgrepeatborrower
    type: int
    sql: ${TABLE}.flgrepeatborrower
  - dimension: flgsecondaryphonetextable
    sql: ${TABLE}.flgsecondaryphonetextable
  - dimension: flgstatus
    sql: ${TABLE}.flgstatus
  - dimension: flgwarnemailseenbefore
    type: yesno
    sql: ${TABLE}.flgwarnemailseenbefore
  - dimension: hassocialprofile
    type: yesno
    sql: ${TABLE}.hassocialprofile
  - dimension: howdidyoufindus
    sql: ${TABLE}.howdidyoufindus
  - dimension: howdidyoufindusother
    sql: ${TABLE}.howdidyoufindusother
  - dimension: howusemoneybillsauto
    type: yesno
    sql: ${TABLE}.howusemoneybillsauto
  - dimension: howusemoneybillsgeneral
    type: yesno
    sql: ${TABLE}.howusemoneybillsgeneral
  - dimension: howusemoneybillshomeorutilities
    type: yesno
    sql: ${TABLE}.howusemoneybillshomeorutilities
  - dimension: howusemoneybillsmedical
    type: yesno
    sql: ${TABLE}.howusemoneybillsmedical
  - dimension: howusemoneygiftsorleisure
    type: yesno
    sql: ${TABLE}.howusemoneygiftsorleisure
  - dimension: howusemoneyother
    type: yesno
    sql: ${TABLE}.howusemoneyother
  - dimension: howusemoneypayoffloansoroverdrawnacct
    type: yesno
    sql: ${TABLE}.howusemoneypayoffloansoroverdrawnacct
  - dimension: howusemoneyrentormortgage
    type: yesno
    sql: ${TABLE}.howusemoneyrentormortgage
  - dimension: howusemoneyschool
    type: yesno
    sql: ${TABLE}.howusemoneyschool
  - dimension: httpreferer
    sql: ${TABLE}.httpreferer
  - dimension: idapp
    primary_key: true
    sql: ${TABLE}.idapp
  - dimension: idborrower
    type: int
    sql: ${TABLE}.idborrower
  - dimension: idcallrequester
    type: int
    sql: ${TABLE}.idcallrequester
  - dimension: idcreditpolicy
    type: int
    sql: ${TABLE}.idcreditpolicy
  - dimension: idcsr
    type: int
    sql: ${TABLE}.idcsr
  - dimension: idcust
    sql: ${TABLE}.idcust
  - dimension: idloan
    sql: ${TABLE}.idloan
  - dimension: idssn
    sql: ${TABLE}.idssn
  - dimension: idtmsession
    sql: ${TABLE}.idtmsession
  - dimension: ipaddress
    sql: ${TABLE}.ipaddress
  - dimension: ipaddresstermsaccepted
    sql: ${TABLE}.ipaddresstermsaccepted
  - dimension: ln_addrchangecount24
    type: int
    sql: ${TABLE}.ln_addrchangecount24
  - dimension: ln_addrstability
    type: int
    sql: ${TABLE}.ln_addrstability
  - dimension: ln_bankruptcycount24
    type: int
    sql: ${TABLE}.ln_bankruptcycount24
  - dimension: ln_curraddrblockindex
    type: int
    sql: ${TABLE}.ln_curraddrblockindex
  - dimension: ln_educationattendedcollege
    type: int
    sql: ${TABLE}.ln_educationattendedcollege
  - dimension: ln_evictioncount24
    type: int
    sql: ${TABLE}.ln_evictioncount24
  - dimension: ln_felonycount24
    type: int
    sql: ${TABLE}.ln_felonycount24
  - dimension: ln_inputaddrlenofres
    type: int
    sql: ${TABLE}.ln_inputaddrlenofres
  - dimension: ln_lienfiledcount24
    type: int
    sql: ${TABLE}.ln_lienfiledcount24
  - dimension: ln_nonderogcount24
    type: int
    sql: ${TABLE}.ln_nonderogcount24
  - dimension: ln_predictedannualincome
    type: int
    sql: ${TABLE}.ln_predictedannualincome
  - dimension: ln_prevaddrblockindex
    type: int
    sql: ${TABLE}.ln_prevaddrblockindex
  - dimension: ln_proflicexpirecount24
    type: int
    sql: ${TABLE}.ln_proflicexpirecount24
  - dimension: ln_propownedhistoricalcount
    type: int
    sql: ${TABLE}.ln_propownedhistoricalcount
  - dimension: ln_proppurchasedcount60
    type: int
    sql: ${TABLE}.ln_proppurchasedcount60
  - dimension: ln_propsoldcount60
    type: int
    sql: ${TABLE}.ln_propsoldcount60
  - dimension: ln_subjectaddrrecentcount
    type: int
    sql: ${TABLE}.ln_subjectaddrrecentcount
  - dimension: ln_subjectphonerecentcount
    sql: ${TABLE}.ln_subjectphonerecentcount
  - dimension: ln_subjectssnrecentcount
    type: int
    sql: ${TABLE}.ln_subjectssnrecentcount
  - dimension: ln_subprimesolicitedcount24
    type: int
    sql: ${TABLE}.ln_subprimesolicitedcount24
  - dimension: ln_wealthindex
    type: int
    sql: ${TABLE}.ln_wealthindex
  - dimension: numpmts
    type: int
    sql: ${TABLE}.numpmts
  - dimension: numredbankaccountseenbeforecount
    type: int
    sql: ${TABLE}.numredbankaccountseenbeforecount
  - dimension: numredssnseenbeforecount
    type: int
    sql: ${TABLE}.numredssnseenbeforecount
  - dimension: numwarnemailseenbeforecount
    type: int
    sql: ${TABLE}.numwarnemailseenbeforecount
  - dimension: phoneemployer
    sql: ${TABLE}.phoneemployer
  - dimension: phoneextemployer
    sql: ${TABLE}.phoneextemployer
  - dimension: phoneexthome
    sql: ${TABLE}.phoneexthome
  - dimension: phoneextother
    sql: ${TABLE}.phoneextother
  - dimension: phonehome
    sql: ${TABLE}.phonehome
  - dimension: phoneother
    sql: ${TABLE}.phoneother
  - dimension: phoneref1
    sql: ${TABLE}.phoneref1
  - dimension: phoneref1ext
    sql: ${TABLE}.phoneref1ext
  - dimension: phoneref2
    sql: ${TABLE}.phoneref2
  - dimension: phoneref2ext
    sql: ${TABLE}.phoneref2ext
  - dimension: phoneref3
    sql: ${TABLE}.phoneref3
  - dimension: phoneref3ext
    sql: ${TABLE}.phoneref3ext
  - dimension: phonespouse
    sql: ${TABLE}.phonespouse
  - dimension: phonespouseext
    sql: ${TABLE}.phonespouseext
  - dimension: pmtfreq
    sql: ${TABLE}.pmtfreq
  - dimension: residenceownership
    sql: ${TABLE}.residenceownership
  - dimension: rtapproval
    type: number
    sql: ${TABLE}.rtapproval
  - dimension: rtinterestapproved
    type: number
    sql: ${TABLE}.rtinterestapproved
  - dimension: rtinterestapprovedcredittier
    sql: ${TABLE}.rtinterestapprovedcredittier
  - dimension: rtinterestreq
    type: number
    sql: ${TABLE}.rtinterestreq
  - dimension: rtorigapproved
    type: number
    sql: ${TABLE}.rtorigapproved
  - dimension: rtorigcredittier
    sql: ${TABLE}.rtorigcredittier
  - dimension: rtorigreq
    type: number
    sql: ${TABLE}.rtorigreq
  - dimension: samplenumber
    type: number
    sql: ${TABLE}.samplenumber
  - dimension: scrautodeny
    type: int
    sql: ${TABLE}.scrautodeny
  - dimension: scrclv
    type: number
    sql: ${TABLE}.scrclv
  - dimension: scrfinal
    type: number
    sql: ${TABLE}.scrfinal
  - dimension: scrgraunta
    type: int
    sql: ${TABLE}.scrgraunta
  - dimension: scrgraunta_autodeny
    type: int
    sql: ${TABLE}.scrgraunta_autodeny
  - dimension: scrhollerithautodeny
    sql: ${TABLE}.scrhollerithautodeny
  - dimension: scrhollerithb
    sql: ${TABLE}.scrhollerithb
  - dimension: scrl2c
    type: number
    sql: ${TABLE}.scrl2c
  - dimension: scrlaplacea
    type: int
    sql: ${TABLE}.scrlaplacea
  - dimension: scrlaplacea_autodeny
    type: int
    sql: ${TABLE}.scrlaplacea_autodeny
  - dimension: scrlnauto
    type: number
    sql: ${TABLE}.scrlnauto
  - dimension: scrlnbankcard
    type: number
    sql: ${TABLE}.scrlnbankcard
  - dimension: scrlnmoney
    type: number
    sql: ${TABLE}.scrlnmoney
  - dimension: scrlnretail
    type: number
    sql: ${TABLE}.scrlnretail
  - dimension: scrlntel
    type: number
    sql: ${TABLE}.scrlntel
  - dimension: scrmbfico
    type: number
    sql: ${TABLE}.scrmbfico
  - dimension: scrmbseisint
    type: number
    sql: ${TABLE}.scrmbseisint
  - dimension: scrmodelused
    sql: ${TABLE}.scrmodelused
  - dimension: scrnextaction
    type: number
    sql: ${TABLE}.scrnextaction
  - dimension: scrraw
    type: number
    sql: ${TABLE}.scrraw
  - dimension: scrrawautodeny
    type: number
    sql: ${TABLE}.scrrawautodeny
  - dimension: scrrepay
    type: number
    sql: ${TABLE}.scrrepay
  - dimension: scrthreat
    type: number
    sql: ${TABLE}.scrthreat
  - dimension: scrtruth
    type: number
    sql: ${TABLE}.scrtruth
  - dimension: scrwtdl2c
    type: number
    sql: ${TABLE}.scrwtdl2c
  - dimension: scrwtdln
    type: number
    sql: ${TABLE}.scrwtdln
  - dimension: scrwtdmilitaryornoachpmt
    type: number
    sql: ${TABLE}.scrwtdmilitaryornoachpmt
  - dimension: scrwtdrepay
    type: number
    sql: ${TABLE}.scrwtdrepay
  - dimension: scrwtdtruth
    type: number
    sql: ${TABLE}.scrwtdtruth
  - dimension: timecalllater
    sql: ${TABLE}.timecalllater
  - dimension: txtanswersapi
    sql: ${TABLE}.txtanswersapi
  - dimension: txtbankname
    sql: ${TABLE}.txtbankname
  - dimension: txtcalllatertime
    sql: ${TABLE}.txtcalllatertime
  - dimension: txtcomments
    sql: ${TABLE}.txtcomments
  - dimension: txtcontactnotes
    sql: ${TABLE}.txtcontactnotes
  - dimension: txtdomain
    sql: ${TABLE}.txtdomain
  - dimension: txtemployerdept
    sql: ${TABLE}.txtemployerdept
  - dimension: txtemployermgr
    sql: ${TABLE}.txtemployermgr
  - dimension: txtemployerrole
    sql: ${TABLE}.txtemployerrole
  - dimension: txtfirstname
    sql: ${TABLE}.txtfirstname
  - dimension: txtfirstnameref1
    sql: ${TABLE}.txtfirstnameref1
  - dimension: txtfirstnameref2
    sql: ${TABLE}.txtfirstnameref2
  - dimension: txtfirstnameref3
    sql: ${TABLE}.txtfirstnameref3
  - dimension: txthowusemoneyother
    sql: ${TABLE}.txthowusemoneyother
  - dimension: txtincomedeductions
    sql: ${TABLE}.txtincomedeductions
  - dimension: txtincomefreq
    sql: ${TABLE}.txtincomefreq
  - dimension: txtincomename
    sql: ${TABLE}.txtincomename
  - dimension: txtincomeotherfreq
    sql: ${TABLE}.txtincomeotherfreq
  - dimension: txtincomeothername
    sql: ${TABLE}.txtincomeothername
  - dimension: txtlastname
    sql: ${TABLE}.txtlastname
  - dimension: txtlastnameref1
    sql: ${TABLE}.txtlastnameref1
  - dimension: txtlastnameref2
    sql: ${TABLE}.txtlastnameref2
  - dimension: txtlastnameref3
    sql: ${TABLE}.txtlastnameref3
  - dimension: txtloanreason
    sql: ${TABLE}.txtloanreason
  - dimension: txtmiddlename
    sql: ${TABLE}.txtmiddlename
  - dimension: txtoverrideexplanation
    sql: ${TABLE}.txtoverrideexplanation
  - dimension: txtreddataxlist
    sql: ${TABLE}.txtreddataxlist
  - dimension: txtredlnlist
    sql: ${TABLE}.txtredlnlist
  - dimension: txtredtmxlist
    sql: ${TABLE}.txtredtmxlist
  - dimension: txtref1relationship
    sql: ${TABLE}.txtref1relationship
  - dimension: txtref1relationshipother
    sql: ${TABLE}.txtref1relationshipother
  - dimension: txtref2relationship
    sql: ${TABLE}.txtref2relationship
  - dimension: txtref2relationshipother
    sql: ${TABLE}.txtref2relationshipother
  - dimension: txtref3relationship
    sql: ${TABLE}.txtref3relationship
  - dimension: txtref3relationshipother
    sql: ${TABLE}.txtref3relationshipother
  - dimension: txtspousefirstname
    sql: ${TABLE}.txtspousefirstname
  - dimension: txtspouselastname
    sql: ${TABLE}.txtspouselastname
  - dimension: txtstatesetamtapproved
    sql: ${TABLE}.txtstatesetamtapproved
  - dimension: txtstatesetdurapproved
    sql: ${TABLE}.txtstatesetdurapproved
  - dimension: txtstatesetrtinterest
    sql: ${TABLE}.txtstatesetrtinterest
  - dimension: txtstatesetrtorig
    sql: ${TABLE}.txtstatesetrtorig
  - dimension: txtwarnlnlist
    sql: ${TABLE}.txtwarnlnlist
  - dimension: txtwarntmxlist
    sql: ${TABLE}.txtwarntmxlist
  - dimension: txtwhydenyl2c
    sql: ${TABLE}.txtwhydenyl2c
  - dimension: txtwhydenyln
    sql: ${TABLE}.txtwhydenyln
  - dimension: txtwhydeny
    sql: ${TABLE}.txtwhydeny
  - dimension: typeapp
    sql: ${TABLE}.typeapp
  - dimension: typebankacct
    sql: ${TABLE}.typebankacct
  - dimension: typecontactbest
    sql: ${TABLE}.typecontactbest
  - dimension: typeincome
    sql: ${TABLE}.typeincome
  - dimension: typeincomeother
    sql: ${TABLE}.typeincomeother
  - dimension: typeincomewage
    sql: ${TABLE}.typeincomewage
  - dimension: typephonehome
    sql: ${TABLE}.typephonehome
  - dimension: typephoneother
    sql: ${TABLE}.typephoneother
  - dimension: usesemailforsocialprofile
    type: yesno
    sql: ${TABLE}.usesemailforsocialprofile
  - dimension: is_repeat_borrower
    type: yesno
    sql: ${flgrepeatborrower} = 1
  - dimension: is_new_borrower
    type: yesno
    sql: ${flgrepeatborrower} = 0
  - dimension_group: dtbirth
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.dtbirth
  - dimension_group: dtcalllater
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.dtcalllater
  - dimension_group: dtcreated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dtcreated
  - dimension_group: dtcreated_pt
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dtcreated_pt
  - dimension_group: dtnextactionscorecalculatedat
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dtnextactionscorecalculatedat
  - dimension_group: dtpmtschedfirst
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.dtpmtschedfirst
  - dimension_group: dttimecallback
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dttimecallback
  - dimension_group: dttimecallback_pt
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dttimecallback_pt
  - dimension_group: dttimeconfirmed
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dttimeconfirmed
  - dimension_group: dttimeconfirmed_pt
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dttimeconfirmed_pt
  - dimension_group: dttimesubmitted
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dttimesubmitted
  - dimension_group: dttimesubmitted_pt
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dttimesubmitted_pt
  - dimension_group: dtupdated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dtupdated
  - dimension_group: dtupdated_pt
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dtupdated_pt
  - measure: count
    type: count
    drill_fields:
    - detail*