Standard ACE DBnb` Ugr@?~1y0̝cßFN^7(K` 1{6߱/QC 3ly[|*|Atf_Љ$g'DeFx -bT4.03dv Y>D@S >> Y  | Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeADXBB\BDYYIdParentIdName        OYS  =Y Y Y  Y 2ACMFInheritableObjectIdSID YObjectId YS  Y  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order Y"ObjectIdAttribute   -YS  Y Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship?tp   YYYszObject$szReferencedObjectszRelationship v1b N  : k & HhV @ @@@ @ @  ^dJbJff^YMJbmk^dJbJff^YMJbmk8WdsMiQOYmkMdiQJbO^dJbJ`dobmkJSSQMmmWQ^QbUmWdSJffidqJ^YbmQiQkmiQqQboQMJ^Mo^JmQOSYQ^OYbmQiQkmiQqQboQUidofQOLvdSSYMQiYOJO`Yb OJmJJMMQkkfJUQkOJmJLJkQkSdi`k`dOo^QkiQ^JmYdbkWYfkiQfdimkkMiYfmkkvkiQ^mJL^Qk+kh+S^dJbJff^YMJbmk!+kh+S^dJbJff^YMJbmk8"Jff^YMJbmksYmWYbMd`QJm^QJkm866\#JqUYbMd`QLvLiJbMW$LY^YbUoJ^diJm^QJkm:Jff^YMJbmk%Md``QiMYJ^^dJbkYbUiJbJOJWY^^k&MdkmfQiJff^YMJbm'Mdobmbo`LQidSJff^YMJbmkLvLiJbMW^dMJmYdb+MiQOYmkMdiQ.BF6JbO^dJbJ`dobm2866\+S+S>>:LL8JM6LHFD<@HB+OJmJ+YbMd`QMd`fJiYkdbLQmsQQbUiJbJOJWY^^kJbOsddO^JbOWY^^k+YbmQiQkmiQqQboQMJ^Mo^JmQOSYQ^O+^dJbJff^YMJbmk+^dJbdSSYMQik+`kvkJMMQkkkmdiJUQ+`kvkJMMQkku`^+`kvkJMQk`kvkMd`f^QuMd^o`bk`kvkMd`f^QumvfQ+JmmJMW`Qbm`kvkMd`f^QumvfQ+OQMY`J^`kvkMd`f^QumvfQ+UoYO`kvkMd`f^QumvfQ+YQQQOdoL^Q `kvkMd`f^QumvfQ+YQQQkYbU^Q `kvkMd`f^QumvfQ+^dbU `kvkMd`f^QumvfQ+kWdim `kvkMd`f^QumvfQ+mQum`kvkMd`f^QumvfQ+obkYUbQOLvmQ `kvkbJ`Q`Jf+ `kvkbJqfJbQUidofMJmQUdiYQk+ `kvkbJqfJbQUidofk+ `kvkbJqfJbQUidofmddL[QMmk+ `kvkbJqfJbQdL[QMmYOk+ `kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfk`kvkiQkdoiMQk+dSSYMQikWYiQOLQSdiQvQJi:666+dSSYMQiksYmW`diQmWJb:Jff^YMJbmk+kJ^Jiv20D@666diJ`dobmJffidqQO20@66666+ko`dS^dJbkfQiQJMWdSSYMQi+JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO^dJbdSSYMQik^dJbJff^YMJbmk+`kvkbJqfJbQUidofMJmQUdiYQk`kvkbJqfJbQUidofk+`kvkbJqfJbQUidofk`kvkbJqfJbQUidofmddL[QMmk+  @ @ @ @ @ @ @ @      !"#$%&'++++++++++ +     !#%'-+4+:+@+m+r+ + + + + +v1 ` @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKLMNO      !"#$%& ' ( )      9:;345012-./*+,!'!(!)#$#%#&%6%7%8'!'"'#---444:::@@@@mmmmr<r=r>?@ABCDE  !"#v1 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ )))))))))) ) ) ) ))))))) )))))))) )))) )!)")#)$)%)&)'))()*)+),)-).)/)0)1)2)3)))4)6)7)8)9):);)<)=)>)? )@ )A )B )C )D)5)E)G)H)I)J)K,, ,)F,,,,,, , , , , ,,,,,,,,, , ,,,,,,,,, ,!,",#,$,%,&,,',),*,+,,,-,.,/,(,0,2,3,4,5,6,7,8,9,:,;,1,<,>,?,@,A,B,C,D,E    ,=        v1@  @^dJbdSSYMQik^dJbJff^YMJbmk`kvkbJqfJbQUidofMJmQUdiYQk`kvkbJqfJbQUidofk`kvkbJqfJbQUidofk`kvkbJqfJbQUidofmddL[QMmk @@@^dJbJff^YMJbmk`kvkbJqfJbQUidofk`kvkbJqfJbQUidofmddL[QMmk  ^dJbdSSYMQik`kvkbJqfJbQUidofMJmQUdiYQk`kvkbJqfJbQUidofk(d _ Z  G q  0 =XTG)h|xC.*By  9*@@Cost Per Applicant1Y@@^RRFFFFFFFD @K4[@X`"@Commercial loans in Granada Hills1Y@@|ppdddddddb @@z@Bi-Lingual or At Least 2 Applicants1Y@|@tthhhhhhhf @+#@#@Applicants with Income at least $100K1Y@@xxlllllllj @j@j@~sq_fLoan Applicants11Y4MR2KeepLocal TLLLLLLLJ @+ qG @G @Admin1Y@8,,,,,,,,,*  Vy@ܟ@Interest Revenue Grouped by Officer ID1Y@zzznnnnnnnl @ @yci@Interest Revenue Calculated Field1Y@pppdddddddb @ *7@?F@How Credit Score and Loan Amounts Affect the Length of Approval1Y@ @ Io@,r@Loan Applicants11Y@NNNBBBBBBB@ @ f@`tm@Loan Applicants1Y@LLL@@@@@@@> @ #^@#^@UserDefined1YA@DDD88888886 @ I#^@I#^@SummaryInfo1Y@DDD88888886 @+$^@$^@SysRel1Y.........., Z$^@Z$^@Scripts1Y0000000000. # $^@# $^@Reports1Y0000000000. $^@$^@Modules1Y0000000000. $^@$^@Forms1Y,,,,,,,,,,* $^@$^@DataAccessPages1Y@@@@@@@@@@> '\@\@MSysComplexType_AttachmentTTTTTTTTTTT %\@]@MSysComplexType_TextHHHHHHHHHHH #\@]@MSysComplexType_DecimalNNNNNNNNNNN !\@]@MSysComplexType_GUIDHHHHHHHHHHH \@]@MSysComplexType_IEEEDoubleTTTTTTTTTTT \@]@MSysComplexType_IEEESingleTTTTTTTTTTT \@]@MSysComplexType_LongHHHHHHHHHHH \@]@MSysComplexType_ShortJJJJJJJJJJJ \@]@MSysComplexType_UnsignedByteXXXXXXXXXXX \@\@MSysComplexColumnsDDDDDDDDDDD >u"^@>u"^@MSysRelationships0[DDDDDDDDDDB >u"^@>u"^@MSysQueries0[88888888886 >u"^@>u"^@MSysACEs0[22222222220 >u"^@>u"^@MSysObjects0[88888888886 >u"^@r74@MSysDb1Y@:::......., @>u"^@>u"^@Relationships0[<<<<<<<<<<: >u"^@>u"^@Databases0[44444444442 >u"^@>u"^@Tables0[.........., D YN Y Y  Y Y Y ColumnNameComplexID&ComplexTypeObjectID"ConceptualTableIDFlatTableIDeIOeOeItiYYY(IdxConceptualTableIDIdxFlatTableID IdxIDv1@ -fYm^QJkmNY  ValuedvfYm^QJkmNY  ValuedvfYm^QJkmNY  ValuedvfYm^QJkmNY  ValuedvfYm^QJkmN  Y  ValuedvfYm^QJkmN""Y  ValuedvfYm^QJkmN$$Y ValuedvfYm^QJkmN&& Y  ValuedvaYN(( Y Y  Y Y  Y  Y FileDataFileFlagsFileNameFileTimeStampFileTypeFileURL((((Hv1b8LjL.z\  Z  ` B $  t * i   o * xN0b D|^@G/h>`(ca [Loan Officers].BranchLocation= gicaLoan Officers+++ icaLoan Applicants/// ca Gca Gica ca G naD@ * g naD@ * g na[Loan Officers].Salary5 g na[Loan Officers].Name3 g naoan Officers].OfficerID8 gnaLoan OfficersLoan Applicantsn@ *UI+ naCostPerApplicantD@ *=11 onaD@* gna[Loan Officers].Salary5 gna[Loan Officers].Name3 gnaoan Officers].OfficerID8 ganaLoan Applicants/// anaLoan Officers+++ na Gna Gana na G>=2@* '=2Loan OfficersLoan Applicantsn@*UI+ =2[Loan Applicants].LoanType9 g=2 [Loan Officers].BranchLocation= g=2"[Loan Applicants].AmountApproved? g=2[Loan Applicants].Name5 g>=2Loan Applicants/// >=2Loan Officers+++ =2 G=2 G>=2 =2 Gica@* 'ca[Loan Officers].[Bi-lingual]; gcaD@* gca[Loan Officers].Name3 gcaoan Officers].OfficerID8 gicaLoan Officers+++ ca Gca Gica ca G ca [Loan Officers].BranchLocation= gcaLoan OfficersLoan Applicantsn@*UI+ caAvgOfIncomeAvg([Loan Applicants].Income)R'' oca [Loan Officers].BranchLocation= gicaLoan Officers+++ icaLoan Applicants/// ca Gca Gica ca GL@* 'Loan OfficersLoan Applicantsn@*UI+ B@* g[Loan Applicants].Income7 g[Loan Applicants].Name5 g"[Loan Applicants].[Applicant ID]? gLoan Officers+++ Loan Applicants///  G G  GaneLoan Applicants///  ne Gane ne GLoan Applicants///   G  G LVALPR 6 n * x 4 0  `NB h[Loan Officers].OfficerID = [Loan Applicants].OfficerIDSum([Loan Applicants].AmountApproved)((([Loan Officers].Salary)>=75000)) OR (((Sum([Loan Applicants].AmountApproved))>=500000))[Loan Officers].OfficerID = [Loan Applicants].OfficerIDSum([Loan Applicants].AmountApproved)((([Loan Officers].NumberOfApplicants)>2))[Loan Officers].OfficerID = [Loan Applicants].OfficerID[Loan Officers].NumberOfApplicants((([Loan Officers].DateHired) Not Like "*200*"))[Loan Officers].OfficerID = [Loan Applicants].OfficerID[AmountApproved]*([InterestRate]/100)/12((([Loan Officers].BranchLocation) Like "*Hills"))[Loan Officers].OfficerID = [Loan Applicants].OfficerID((([Loan Applicants].AmountApproved)>100000) AND (([Loan Applicants].CreditScore)<680))[Loan Officers].OfficerID = [Loan Applicants].OfficerIDCount([Loan Officers].NumberOfApplicants)([Salary]/12)/[NumberOfApplicants][Loan Officers].NumberOfApplicants[Loan Officers].OfficerID = [Loan Applicants].OfficerID([Salary]/12)/[NumberOfApplicants][Loan Officers].NumberOfApplicants((([Loan Officers].BranchLocation)="Granada Hills") AND (([Loan Applicants].LoanType)="Commercial"))[Loan Officers].OfficerID = [Loan Applicants].OfficerID((([Loan Officers].NumberOfApplicants)>=2)) OR ((([Loan Officers].[Bi-lingual])="YES"))[Loan Officers].NumberOfApplicants[Loan Officers].OfficerID = [Loan Applicants].OfficerID((([Loan Applicants].Income)>=100000))[Loan Officers].OfficerID = [Loan Applicants].OfficerID[Loan Applicants].AmountRequestedOR P \  WW#zF  *S#@*S#@MSysNavPaneGroupsMSysNavPaneGroupToObjects1Y4MR2KeepLocal  Tvvvvvvvt @*S#@*S#@MSysNavPaneGroupCategoriesMSysNavPaneGroups1Y4MR2KeepLocal  Txxxxxxxv @Ɂ@Ɂ@Loan OfficersLoan Applicants1YZZZZZZZZZZX c5E@`#@AVG Income by Branch1Y@@bVVJJJJJJJH @@@~sq_fLoan Applicants1Y4MR2KeepLocal TJJJJJJJH @ ( Oa@U@AccessLayout1Y4MR2KeepLocal T@zz:::::::8 @r@Σ@SUM of Loans Per Each Officer1Y@@thh\\\\\\\Z @F0^@^@Salary >=75000 OR AmountApproved >=5000001Ys@@tttttttr @He@e@Officers with MORE than 2 Applicants1Y@@vvjjjjjjjh @pM@N@Officers Hired Before Year 20001Y@|@xll```````^ @9B@g@ MSysResources1Y<<<<<<<<<<: #@#@ MSysNavPaneObjectIDs1Y4MR2KeepLocal  TJJJJJJJH @*S#@l @ MSysNavPaneGroupToObjects1Y4MR2KeepLocal  TTTTTTTTR @*S#@l @ MSysNavPaneGroups1Y4MR2KeepLocal  TDDDDDDDB @*S#@l @ MSysNavPaneGroupCategories1Y4MR2KeepLocal  TVVVVVVVT @rZ0@Z0@ MSysNameMap1Y4MR2KeepLocal  Txxx88888886 @mHe@He@MSysAccessXML1Y4MR2KeepLocal  T|||<<<<<<<: @@]@]@ MSysAccessStorage1YDDDDDDDDDDB :l0>`@l @Loan Officers1Y@HHH<<<<<<<: @4Pa@?,@Loan Applicants1YZ @LLL@@@@@@@> @(@ i@Interest Revenue Calculated Field1Y@@|ppdddddddb @v@v@Income Comparison Between Granada Hills and Woodland Hills1Y@@ @-oH@T@ f_F442BB1A37614C0B98735963931C0174_Data1Yppppppppppn -G@WG@Credit Score <680 AND Loan Amount >100K1Y@|@||pppppppn @(@ߘ)@COUNT Number of Applicants by Branch Location1Y:@@|||||||z @9FBD j q S 5 w  l B $  V 8Ms;qG) [b|^"e#2)SumOfAmountApprovedJ@*C77 o2)[Loan Officers].Salary5 g2)[Loan Officers].Name3 g2)oan Officers].OfficerID8 g>2)Loan Officers+++ >2)Loan Applicants/// 2) G2) G>2) 2) G "*T@* '"*Loan OfficersLoan Applicantsn@*UI+ "*D@* g"* [Loan Officers].BranchLocation= g"*[Loan Officers].Name3 g"*oan Officers].OfficerID8 g "*Loan Applicants///  "*Loan Officers+++ "* G"* G "* "* Ghmx`@* 'mxoan Officers].DateHired8 gmx[Loan Officers].Name3 gmxoan Officers].OfficerID8 ghmxLoan Officers+++ mx Gmx Ghmx mx G "Loan OfficersLoan Applicantsn@*UI+  "[Loan Applicants].OfficerID: g "InterestRevenueGeneratedP@*MAA o " [Loan Applicants].InterestRate= g ""[Loan Applicants].AmountApproved? g "[Loan Applicants].Income7 g "[Loan Applicants].Name5 g ""[Loan Applicants].[Applicant ID]? ge "Loan Applicants/// e "Loan Officers+++  " G " Ge "  " G Cd@* ' C [Loan Officers].BranchLocation= gCLoan OfficersLoan Applicantsn@*UI+ CAvgOfIncomeAvg([Loan Applicants].Income)R'' oC [Loan Officers].BranchLocation= gCLoan Applicants/// CLoan Officers+++ C GC GC C Gica@* 'ca[Loan Applicants].CreditScore< gca [Loan Applicants].InterestRate= gca"[Loan Applicants].AmountApproved? gca[Loan Applicants].Name5 gca"[Loan Applicants].[Applicant ID]? gicaLoan Applicants/// ca Gca Gica ca G ca [Loan Officers].BranchLocation= gcaLoan OfficersLoan Applicantsn@*UI+ caCountOfNumberOfApplicantsR@ *OCC o 1YN..Y Y Y  Y Y  Y  Y Y _DataFileDataFileFlagsFileNameFileTimeStampFileTypeFileURL$MSysResources_Datah.1.2.3YYY _Data$IdxFKPrimaryScalar$MSysComplexPKIndex....s v1b LVALP x^Vy41TM%ٙƾd![,!K}Yf_2((˘d )I;{=}s><|6@EYpxB(̈+p~KPN[-_@W@P?;3GMe:d)âf F``Ex=!K?ƓVZ> e.^C.BBhgWhJlPsfUL6@XT72y3&+QDF2ͱTZ֚Yim䶆Xz`P }a6H=* t9J>g㺽9-\~=3/Ǣl(9:9֯隵^ S4r:J=evA -he`I4]BlL@r'&e){R'*v8FhXFjq4#TajV,(iBO䜄j2o:pQ0~f1x ^;|_fiVrE焏b;ZeWFk+'ӇTzWh.[%2/zBc!LcA|` sS(+@Ksl4buЈd=s+^1\R;䍥!ÏY4 0Hhhnߑo!_lJ\Y>: `S_eo]M!FBT %?ٶ>#9{5 !;#ʄ6-my IQV.T,ar/PB]|ȯmm?tbGaaPI`WOؼH?m4XoGNy.[`He1˖kl)׼A"j cN9`wY˰S:lW OufEF#L}q2WNBRޜr~ڋ3X_7*Mx!__}B&@Q,`QyrpXR$~_QI -*49vR$ɜTv]LmR0I@  ]F DgԛSw#YJ R]kNzAě wϦe:>\ˠg1&s ,ҵi^eIdC !a7VY缊 ˓jĢYQWsM%д`CVH<'ig׊⭮Ğ?rvZWw^@ ~m6Jfip7Pu .kZRsd [<\7 ]/=7J[q9 \jҪZ8T@p{1-=ִ`124Ux82> 木^>)FeCpVSI+l $ui{.Qm+ f=02ږΘ T`!psH(\ŵi&"-}SRVZbp-,t?& ~'đݝ3t]K:j4P"lm))͝DQOмɌ*4x)ߞCJ=e{mi&&ŧQ 0IQsE 5V!vfQyV)ʭSrݩ/'{-mI ' zʸvĒႜf/ů5z@:fLY'qw" |oB$\{erZeFM9{^maT8:; u 1b<(=v{ xS\pq_kvb ~)osPuD%mS<\񈖻@Hjuʁgf|$ekQPI*Bك/Sk._&lˁeb^]JbԺyV˃<ic0+x kT{a*{E3ygOSQJaL<l3-A}2`K8Sd5&<63F(}ϣ#x̽ s4 64QեZlYL#ы"BҰ| &1J T'ߊ(TH\ 65+8ztąv4 &ЊV ,7>1b=[ө='ߐ[;~xR N+-1'%؟47oKBK(B_0Vu-)>1000 @/Office Theme.thmxthmxLHH@-0- dSSYMQmWQ`QmW`u0-0^ YN 55  Y d Y dY Y Y  Y d Y  EmployeeIDName IncomeAmountApprovedCreditScoreOfficerIDmanagerIDD57"5859 ?5iYY:YYYApplicant ID8Loan OfficersLoan ApplicantsmanagerIDOfficerIDPrimaryKeyApplicant ID8Loan OfficersLoan ApplicantsmanagerIDOfficerIDPrimaryKeyHv1b@@T4L?  \ 9 x  N  ,N1020Wesley Teague6.75MediumConsumer90041002OIC91+ fx1019Eric Steele5.71FastCommercial90011001MGA5/) ? !1018Alex May5.93MediumMortgage90031006JD>4,& *u! 1017Crystal Powers5.93MediumConsumer90061006PJD:2, 9!1016Kristine Dougherty5.71FastCommercial90011004TNH<60 Il1015Jean Griffin7.29SlowConsumer90021003LF@60* f1014Neal Lawrence6.32SlowConsumer90061002MGA71+ %1013Jerome Wallace6.75SlowMortgage90051001NHB82, ,ו1012Julia Desai5.71FastCommercial90071006MGA5/) -c*1011Beth Woodard5.93FastMortgage90051005LF@60* > 1010Marion Moon5.93MediumConsumer90091004MGA7/) "*1009Sandy Raynor6.1SlowCommercial90071003MGA5/* 8h 1008Francis McNamara5.93MediumConsumer90091002RLF<4. )1007Malcom Wagner5.71MediumMortgage90031001OIC91+ Cw}1006Hazel Bender7.29SlowConsumer9009F@60* J]1005Patrick Song6.32SlowConsumer9010F@60* n75Jx1004Gretchen Hill6.75SlowCommercial9001IC71+ 1003Sherri Melton6.1MediumConsumer9008HB80+ %3e1002Paige Chen5.71FastCommercial9001F@4.( T* 1001Kristina Chung5.93MediumConsumer9006JD:2,D 4@ @ @86686866:6866<6866>6866@6866B6866D6866F6866H686866 86886 868:6 868<6 868>6 868@6868B6868D6868F6868H686:66D 4@ @ @H6686H6686H6686H6686H66:6H66<6H66<6H66>6H66@6 H66@6 H66B6H66B6 H66B6H66D6H66D6 H66F6H66H6H66H6H66H6 H6866D 4@ @ @86686866:6866<6866>6866@6866B6866D6866F6866H686866 86886 868:6 868<6 868>6 868@6868B6868D6868F6868H686:66 WY ?N;;  Y d Y dY Y  Y dY  Y d Y xdOfficerIDNameDateHired SalaryBranchLocation$NumberOfApplicantsLoanSpecialtyBi-lingual..;=;>?;?Y4YYY.rD4NumberOfApplicantsLastYearOfficerIDPrimaryKeyv1@  : YV W  @9010Donna PinkneyNorthridgeMortgageNOEA7+@s49009Adam MercierGranada HillsMortgageNOGC9*4@ %9008Aaron KunzBurbankConsumerYES@;1(4@C89007Roxanne TavarezNorthridgeCommercialNOIE9- @`!9006Philip CastorWoodland HillsConsumerNOIE;+@t9005Jessie BerberichBurbankMortgageNOEA7.B@D-9004Marcie ArciniegaNorthridgeConsumerYESID:.!@e9003Julio WatrousGranada HillsMortgageNOHD:+@59002Lance NaramoreBurbankConsumerNOC?5,@ʚ;9001Kurt WindGranada HillsCommercialNOFB6' : @<<<< <<<<<< :@ @H668<H66:<H66<<H66><H66@<H66B<H66D<H66F<H66H<H686<  :@ @H668<H66:<H66<<H66><H66@<H66B<H66D<H66F<H66H<H686< V Y6r?NAA'('(Y Y Y  Y  Y Y eY eDateCreateDateUpdateIdLvNameParentIdTypeobAjAk?a?..AlYYYIdParentIdIdParentIdNameAAv1b@A@ R 3 x  A \  K CY&:8i*Qr)y$P_@P_@qPROJECTwm>:6$ J_@P_@p@ hdir0,(" J_@P_@ol @ h_VBA_PROJECTB>:" J_@P_@n AcessVBADataNJF. gv@gv@6DataAccessPages<84 wgv@gv@5CustomGroups62. wgv@gv@4ImExSpecs0,( wgv@gv@3MSysDbDirData0PLH8 gv@gv@2Blob1&" wgv@gv@100  wgv@gv@0Databases0,( wgv@gv@/ijPropDataPLH8 gv@gv@.Scripts,($ wgv@gv@-% 0CB0 1CB0 2CB0PropDataCopygc_G gv@gv@,@JDirDataCopyB>:" gv@gv@+% 0CB0 1CB0 3CB0PropData_[WG gv@gv@*"@JDirData:62" gv@K@)BlobDelta%0,( wgv@$@(@JTypeInfo%:62" gv@K@' PropData%GC?/ gv@K@&o`NBlob%2.*" 0p@K@%3  w0p@r@$BlobDelta 0,( w0p@r@#O@JTypeInfo :62" 0p@r@" PropData GC?/ 0p@r@!iYNBlob 2.*" 0p@r@ 1  w0p@@BlobDelta0,( w0p@@O@JTypeInfo:62" 0p@@ PropDataGC?/ 0p@@iRNBlob2.*" 0p@@0  w0p@gv@Reports,($ w0p@0p@Modules,($ w0p@0p@Cmdbars,($ w0p@gv@ 0CB0 1CB0PropData TPL< 0p@gv@N@JDirData :62" 0p@@BlobDelta0,( wi@@1@JTypeInfo:62" i@@ PropDataGC?/ i@@gKNBlob2.*" i@@1   wi@'@BlobDelta 0,( wi@'@1@JTypeInfo :62" i@'@ PropData GC?/ i@'@ gCNBlob 2.*" i@'@ 0   wi@gv@ Forms($  wi@P_@VBA$  wi@P_@VBAProject2.* wc@P_@VBA$  wc@c@MSysAccessStorage_SCRATCHPLH wc@gv@MSysAccessStorage_ROOTJFB wLVALND:u0=5B>a)b*c'e giXj;k L?lf@x %1aEd)52T Loan Applicants Loan Applicants @Calibri 8hhhh h XYL!pL !WL!L!C odXXLetteru !G^o^id`ux]DINU"0lP|&0SMTJ HP LaserJet 4350 PCL 5InputBinAutoRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateOFFOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265HPDocPropResourceDatahpzhlLHN.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSLHNTTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]LVALE4Pd?JDT4182744dPrint driver host for 32bit appsplwow64.exeC:\Windows\splwow64.exeLVALF M:130.166.100.251D/1<FP Ru`W"ė cg4V"$Ru6["LV"Ru6t/Z"C odXXLettert+\u `W"DINU"0lP|&0SMTJ HP LaserJet 4350 PCL 5InputBinAutoRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateOFFOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265HPDocPropResourceDatahpzhlLHN.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSLHNTTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]LVALG4Pd?JDT4182744dPrint driver host for 32bit appsplwow64.exeLVALHC:\Windows\splwow64.exe 6130.166.100.25d2d# " @Calibri#g$h'k*n+opB1q3sBmf= g4i# " @Calibri9h<k>mB?g@nBpHBGqIsB`,8 FormHeaderx XIHO-z` tvBhiAd5U`6<a<br c,d# Label18 Loan Applicantsx :"¹}CsX J<K<L M8`,v  Detailx _BA"v+:d ; tvBh m7UF{`6^ ahbLc,Je "*5 Applicant ID Applicant ID Applicant_IDx ݒ]oj{Fmn_+.J^ /Kh0L1Md5U`6hahb c,J $Applicant ID_Label Applicant ID $Applicant_ID_Labelx ҥTRF>)4>J JhKhL Mm7UF{`6^ a bLc,Je k"*5 Name Namex ibtpB*Ûk+.J^ /K 0L1MVd5U`6ha b c,J Name_Label Namex ئG˰K\­ JhK L MVm7UF{`6^ abLc,Je kLVALI"*5  Income  Income& *$#,##0.00;($#,##0.00)x 27jFgS+.J^ /K0L1MK $L d5U`6hab c,J Income_Label  Incomex -U\9O󘝌 JhKL Mm7UF{`6^ aTbLc,Je k"*5 AmountApproved AmountApproved& *$#,##0.00;($#,##0.00)x YU6:A%*4+.J^ /KT0L1MK $L d5U`6haTb c,J (AmountApproved_Label AmountApprovedx ..GIHH2~ JhKTL Mm J27UF{`6^ ab\c,Xe k"*5 InterestRate InterestRatex  ƵN7CDr+.J^ /K0L'1MP d5U`6hab c,J $InterestRate_Label InterestRatex "A!4A~B4 JhKL MB m7UF{`6^ a bLc,Je k"*5 (LengthOfApprovalTime (LengthOfApprovalTimex Z*k1Dq*Q+.J^ /K 0L1M d5U`6ha b c,J 4LengthOfApprovalTime_Label (LengthOfApprovalTimex Q?cwIDy.z JhK L M m7UF{`6^ al bLc,Je k"*5 LoanType LoanTypex {4I^e}x+.J^ /Kl 0L1M d5U`6hal b c,JLVAL LoanType_Label LoanTypex  ڶuD@~;9 JhKl L M m7UF{`6^ abc,Jek"*5 CreditScore CreditScorex wrK}(Id8+.J^ /K0LX1MZd5U`6hab c,J "CreditScore_Label CreditScorex nBvQL JhKL MZm7UF{`6^ abLc,Je k"*5 OfficerID OfficerIDx Xkx}I2[+.J^ /K0L1Md5U`6hab c,J OfficerID_Label OfficerIDx &Y쁝*G p JhKL M`, FormFooterx @o\ D? tvBhLVAL P  How Credit Score and Loan Amounts Affect the Length of Approval$Loan Applicants1"Loan Applicants$Loan Applicants2How Credit Score and Loan Amounts Affect the Length of ApprovalPInterest Revenue Grouped by Officer IDFInterest Revenue Calculated FieldͬGLO[.GroupHeader0PageHeaderSectionReportHeaderDetailPageFooterSectionGroupFooter1ReportFooterdLabel17dLengthOfApprovalTime_Labeld CreditScore_Labeld AmountApproved_Labeld Income_Labeld Applicant_ID_LabelApplicant ID_Labeld Name_LabeldInterestRate_LabelmLengthOfApprovalTimemCreditScoremAmountApprovedmIncomemApplicant_IDApplicant IDmNamemInterestRatemText14dLabel15mMax_Of_CreditScoreMax Of CreditScoremText18mText19LoanTypeOfficerIDͬ=2ذLH:+rDetailPageFooterSectionReportFooterGroupHeader0ReportHeaderPageHeaderSectiondLabel14dOfficerID_LabeldInterestRevenueGenerated_Labeld AmountApproved_Labeld InterestRate_Labeld Applicant_ID_LabelApplicant ID_Labeld Name_Labeld Income_LabelmOfficerIDmInterestRevenueGeneratedmAmountApprovedmInterestRatemApplicant_IDApplicant IDmNamemIncomemText15mText16ͬ%`yMsOu>6xGroupHeader0PageHeaderSectionReportHeaderDetailReportFooterPageFooterSectiondLabel14dOfficerID_LabeldInterestRevenueGenerated_Labeld AmountApproved_Labeld InterestRate_Labeld Applicant_ID_LabelApplicant ID_Labeld Name_Labeld Income_LabelmOfficerIDmInterestRevenueGeneratedmAmountApprovedmInterestRatemApplicant_IDApplicant IDmNamemIncomemText15mText16$Loan Applicants1"Loan Applicantsͬ07hDu>FormHeaderDetailFormFooterd Label18mApplicant_IDApplicant IDd Applicant_ID_LabelApplicant ID_LabelmNamed Name_LabelmIncomed Income_Labelm AmountApprovedd AmountApproved_Labelm InterestRated InterestRate_LabelmLengthOfApprovalTimed LengthOfApprovalTime_LabelmLoanTyped LoanType_LabelmCreditScored CreditScore_LabelmOfficerIDd OfficerID_Labelͬ#H |FormHeaderDetailFormFooterd Label18mApplicant_IDApplicant IDd Applicant_ID_LabelApplicant ID_LabelmNamed Name_LabelmIncomed Income_Labelm AmountApprovedd AmountApproved_Labelm InterestRated InterestRate_LabelmLengthOfApprovalTimed LengthOfApprovalTime_LabelmLoanTyped LoanType_LabelmCreditScored CreditScore_LabelmOfficerIDd OfficerID_LabelLVALNL:u03=5B>a)b*c'e giXj.k L?lIo@x }+&F7:Oud3 Loan Applicants  Loan Applicants1 @Calibri 8hhhh h XYL!L !WL!L!C odXXLetter !G^o^idp8@DINU"0lP|&0SMTJ HP LaserJet 4350 PCL 5InputBinAutoRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateOFFOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265HPDocPropResourceDatahpzhlLHN.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSLHNTTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]LVALM4Pd?JDT4182744dPrint driver host for 32bit appsplwow64.exeC:\Windows\splwow64.exeLVALN M:130.166.100.251D/1<FP +i W"uBwh$#3wX9V"8["RuP#C odXXLetter["7Rud"d"RuX"8A"CDINU"0lP|&0SMTJ HP LaserJet 4350 PCL 5InputBinAutoRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateOFFOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265HPDocPropResourceDatahpzhlLHN.cabPrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSLHNTTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]LVALO4Pd?JDT4182744dPrint driver host for 32bit appsplwow64.exeLVALPC:\Windows\splwow64.exe 6130.166.100.25d2d# " @Calibri#g$h'k*n+opB1q3sBmf= g4i# " @Calibri9h<k>mB?g@nBpHBGqIsB`,8 FormHeaderx ^kF`LJO&R tvBhiAd5U`6<a<bn c,d# Label18  Loan Applicants1x ]* Na+n J<K<L M8`,v  Detailx Q ;vJ!jmmZd ; tvBh m7UF{`6^ ahbLc,Je "*5 Applicant ID Applicant ID Applicant_IDx ;:^L>I^+.J^ /Kh0L1Md5U`6hahb c,J $Applicant ID_Label Applicant ID $Applicant_ID_Labelx K JhKhL Mm7UF{`6^ a bLc,Je k"*5 Name Namex ;|`Gn]+.J^ /K 0L1MVd5U`6ha b c,J Name_Label Namex |S M4Qg JhK L MVm7UF{`6^ abLc,JeLVALQ k"*5  Income  Income& *$#,##0.00;($#,##0.00)x K OE35+.J^ /K0L1MK $L d5U`6hab c,J Income_Label  Incomex <`'J & JhKL Mm7UF{`6^ aTbLc,Je k"*5 AmountApproved AmountApproved& *$#,##0.00;($#,##0.00)x X @BO鹟[G+.J^ /KT0L1MK $L d5U`6haTb c,J (AmountApproved_Label AmountApprovedx --5|CJ7vBk JhKTL Mm J27UF{`6^ ab\c,Xe k"*5 InterestRate InterestRatex ݜ/OyR+.J^ /K0L'1MP d5U`6hab c,J $InterestRate_Label InterestRatex 쟒9 Ok$q| JhKL MB m7UF{`6^ a bLc,Je k"*5 (LengthOfApprovalTime (LengthOfApprovalTimex 0I[Q@+.J^ /K 0L1M d5U`6ha b c,J 4LengthOfApprovalTime_Label (LengthOfApprovalTimex ! ^N{u@ JhK L M m7UF{`6^ al bLc,Je k"*5 LoanType LoanTypex  =Ar5T+.J^ /Kl 0L1M d5U`6hal b c,JLVAL LoanType_Label LoanTypex l|rlU[Aqw JhKl L M m7UF{`6^ abc,Jek"*5 CreditScore CreditScorex /)-Fȴޠr+.J^ /K0LX1MZd5U`6hab c,J "CreditScore_Label CreditScorex F:a)b*c-e gigj36k L?l@x JE Op/1B BInterest Revenue Calculated Field BInterest Revenue Calculated Field @Calibri 8hhhh h @ !WL!L!Zd !2WC odXXLetterid0BL!o#DINU"TPHG%SMTJHP LaserJet 2200 Series PCL 5InputBinAutoRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateOFFOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265PrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSWN7TTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]LVALT4Pd?YZ7335244dPrint driver host for 32bit appsplwow64.exeC:\LVALUWindows\splwow64.exe M&DDOT4_0011D01<FP  Series PCL 5C odXXLetterDINU"TPHG%SMTJHP LaserJet 2200 Series PCL 5InputBinAutoRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateOFFOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265PrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSWN7TTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]LVALV4Pd?YZ7335244dPrint driver host for 32bit appsplwow64.exLVALWeC:\Windows\splwow64.exe "@DOT4_001 d2d# " @Calibri#g$h'k*n+opB1q3sBmf= g4i# " @Calibri9h<k>mB?g@nBpHBGqIsB OfficerID 0InterestRevenueGenerated AmountApproved InterestRateK`, ReportHeaderx qLCd tvBhiAd`6<a<bc,d# Label14 BInterest Revenue Calculated Fieldx p< n0DjMx? tvBhm5I;F{`6<abc,J"*5  Text15  =Now()& Long Datex  EPJ>l+.J</K0L1M:m5I;F{`6abc,Jk"*5  Text16 H="Page " & [Page] & " of " & [Pages]x Sy%YG_렉+.J/K0L,1M:K`, ReportFooterx 2AdBf Q$ tvBhLVALNZ:u:<=5B>a)b*c-e gigj36k L?l@x @,^F 3 BInterest Revenue Calculated Field BInterest Revenue Calculated Field @Calibri 8hhhh h @ !WL!L!Zd !2WC odXXLetterid`uL!o#DINU"TPHG%SMTJHP LaserJet 2200 Series PCL 5InputBinAutoRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateOFFOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265PrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSWN7TTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]LVAL[4Pd?YZ7335244dPrint driver host for 32bit appsplwow64.exeC:\LVAL\Windows\splwow64.exe M&DDOT4_0011D01<FP  Series PCL 5C odXXLetterDINU"TPHG%SMTJHP LaserJet 2200 Series PCL 5InputBinAutoRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateOFFOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265PrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSWN7TTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]LVAL]4Pd?YZ7335244dPrint driver host for 32bit appsplwow64.exLVAL^eC:\Windows\splwow64.exe "@DOT4_001 d2d# " @Calibri#g$h'k*n+opB1q3sBmf= g4i# " @Calibri9h<k>mB?g@nBpHBGqIsB OfficerID 0InterestRevenueGenerated AmountApproved InterestRateK`, ReportHeaderx iC̛B tvBhiAd`6<a<bc,d# Label14 BInterest Revenue Calculated Fieldx eol)A:a= J<K<LMX`, "PageHeaderSectionx f?.JSH-‚3, tvBhd7`6xa<bc,; OfficerID_Label OfficerID  DetachedLabelx ]dYJϬD/>Xg  JxK<L8Mwd7`6a<bP c,; <InterestRevenueGenerated_Label 0InterestRevenueGenerated  DetachedLabelx dJ f?k  JK<LMwd7`6xa<bc,; (AmountApproved_Label AmountApproved  DetachedLabelx lDCj8& o  JxK<LDMwd7`6a<bc,LVAL_; $InterestRate_Label InterestRate  DetachedLabelx C @\wp  JK<LlMwd7`6a<bc,; $Applicant ID_Label Applicant ID  DetachedLabel $Applicant_ID_Labelx e]4!B:즆  JK<LX Mwd7`6 a<bc,; Name_Label Name  DetachedLabelx sq E}%l):  J K<L$Mwd7`6'a<bc,; Income_Label  Income  DetachedLabelx iŮDzIZVdi  J'K<L,MwK`, GroupHeader0x *LD@K38 ; tvBhm0G5IF{`6xbc,Je"*5 OfficerID OfficerIDx AwY+.Jx0L81MJK`,  Detailx Ϊؐ}AI%uA@ ; tvBhm0G5IF{`6b4c,;e "*5 0InterestRevenueGenerated 0InterestRevenueGenerated& *$#,##0.00;($#,##0.00)x i K _EJ+.J0LL1M;K $m5IF{`6hbdc,Je%k"*5 AmountApproved AmountApproved& *$#,##0.00;($#,##0.00)x o,x_HP|5+.Jh0L1MJK $L m5IF{`6bc,Jek"*5 InterestRate InterestRatex Bƾ[K}~+.J0L1MJm5IFLVAL{`6b c,Je k"*5 Applicant ID Applicant ID Applicant_IDx e݊:~Cр@+.J0L1MJm5IF{`6 brc,;ek"*5 Name Namex 7b~oG,?|x4+.J 0L'1M;m5IF{`6'bc,JeFk"*5  Income  Income& *$#,##0.00;($#,##0.00)x eL}bN~ݯ+.J'0L,1MJK $L `,: "PageFooterSectionx k"/^Do7֬ tvBhm5I;F{`6<abc,J"*5  Text15  =Now()& Long Datex oM\MzT+.J</K0L1M:m5I;F{`6abc,Jk"*5  Text16 H="Page " & [Page] & " of " & [Pages]x N@v+.J/K0L,1M:K`, ReportFooterx  BjL2Hf֊ tvBhLVALNa:u:<=5B>a)b*c@8e giXj:k L?l*Y@x t&;)ڊHo"Z Loan Applicants  Loan Applicants2 @Calibri 8hhhh@8h @ !WL!L!Z0d !2WC odXXLetteridpL!o#DINU"TPHG%SMTJHP LaserJet 2200 Series PCL 5InputBinAutoRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateOFFOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265PrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSWN7TTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]LVALb4Pd?YZ7335244dPrint driver host for 32bit appsplwow64.exeC:\Windows\splwow64.exeLVALc M&DDOT4_0011D01<FP  Series PCL 5C odXXLetterDINU"TPHG%SMTJHP LaserJet 2200 Series PCL 5InputBinAutoRESDLLUniresDLLResolution600dpiOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateOFFOutputBinAutoHPOutputBinOrientationFACEUPStaplingNoneHPStaplingOpposedFalseTextAsBlackFalseGraphicsModeHPGL2MODEHPSmartHubInet_SID_263_BID_514_HID_265PrintQualityGroupPQGroup_1HPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL5HPMaxResolutionPDM_600DPIHPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpmcpdp5.xmlHPSmartDuplexSinglePageJobTrueHPCustomDUplexableRange3x5_8.5x14HPCoversFront_CoverHPDuplicateJobNameOverrideSWFWEnhancedPCL5EnableTrueHPEnableRAWSpoolingTrueJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffPSAlignmentFileHPZLSWN7TTAsBitmapsSettingTTModeOutlinePIUPHdLetter o [none] [none]LVALd4Pd?YZ7335244dPrint driver host for 32bit appsplwow64.exeLVALeC:\Windows\splwow64.exe "@DOT4_001 d2d# " @Calibri#g$h'k*n+opB1q3sBmf= g4i# " @Calibri9h<k>mB?g@nBpHBGqIsB (LengthOfApprovalTime CreditScore AmountApproved  IncomeK`, ReportHeaderx p{2JL`Vs tvBhiAd`6<a<b1 c,d# Label17  Loan Applicants2x ط9>պH_4޼ J<K<Lm MX`, "PageHeaderSectionx *#I\O2Iv狄+.JP0L(#1MJK $L m5IF{`6#bc,Je kLVALg"*5 Applicant ID Applicant ID Applicant_IDx ?B Keط+.J#0LP(1MJm5IF{`6(b c,Jek"*5 Name Namex BC@O n+.J(0L31MJm5IF{`6T3bc,Jek"*5 InterestRate InterestRatex 4MR_}+.JT30L81MJK`, GroupFooter1x OͩEaWA ; tvBhmF{`6hb\+"*5  Text14 B="Summary for " & "'LengthOfApprovalTime' = " & " " & [LengthOfApprovalTime] & " (" & Count(*) & " " & IIf(Count(*) = 1, "detail record", "detail records") & ")"x .OE.q+.Jh0L,1Md`6ha;bc,; Label15 Maxx Ndtt5E,M JhK;LHMvmF{`6a;bc,;k"*5 $Max Of CreditScore &=Max([CreditScore]) $Max_Of_CreditScorex zF\ q+.J/K;0L@ 1Mv`,: "PageFooterSectionx tG$Z/ tvBhm5I;F{`6<abc,J"*5  Text18  =Now()& Long Datex Z0zKna67+.J</K0L1M:m5I;F{`6abc,Jk"*5  Text19 H="Page " & [Page] & " of " & [Pages]x [DA&+.J/K0L,1M:K`, ReportFooterx stdole h%^*\G{0002`0430-C 0046}#2.0#0#C:\Windows\SysWOW64\e2.tlb#OLE Automation0hADO DB> ADOBD.DE1D10-8DAA006D2EA4D1DProgram Files (x86)\Comm on Ptem\@ado\ms21QMicrosoft ActiveX Objec2.1 LibraryKA_VBIDE_VPBI_E_ _2E15"7/00-R5.3/*Shared\VBA6E6EXT.OLB#G Visual Basic forbs Extensibility @!@-"¤th 4 B @ 6666668668686686 86686866:6866:6 866:6866<6866<6866>6 866>6866@6 866B6 866B6866B6: @ @ @ @ @ @ @ @BBBBB B B BBB B B B B BBBBBBBBBBBB B!B"B#B$B%B&B 'B!(B")B#*B$+B%,B&-B'.B(/B)0B*1B+2B,3B-4B.5B/6B0nB=oB>pB?qB@r, @@@@@@@@@@@@@@@BB BBBB.B(/B)0B*4B.5B/6B0BBnB=BqB@roB>pB?  B B  B B  B B B  B B B BBB B%B*B$+B%,B&-B'BBBB !B "B #B $B%&B %'B!%(B"%)B#01B+03B-12B, @@@@@ @ @@ @@@ M`OLJikBMokmd`UidofkB/OJmJJMMQkkfJUQkB0OJmJLJkQkB*Sdi`kBY`QukfQMkB.`dOo^QkB`kvkJMMQkkkmdiJUQ+iddmBfidfOJmJB)iQfdimkBkMiYfmkB(qLJB`kvkJMMQkkkmdiJUQ+kMiJmMWBJMQkkqLJOJmJB=qLJfid[QMmBfid[QMmfid[QMms`B@qLJB+qLJ+fid[QMmB>OYiB? 6B 8B  OYiOJmJB fidfOJmJB L^dLB L^dLOQ^mJB  fidfOJmJB mvfQYbSdB L^dLB L^dLOQ^mJBfidfOJmJB mvfQYbSdB6B8B<BOYiOJmJB$OYiOJmJMdfvB&fidfOJmJB%fidfOJmJMdfvB'L^dLBL^dLOQ^mJBfidfOJmJBmvfQYbSdB L^dLB L^dLOQ^mJB fidfOJmJB mvfQYbSdB%L^dLB %L^dLOQ^mJB#%fidfOJmJB!%mvfQYbSdB"06B+0OYiOJmJB-1L^dLB,S Y?NnnY  Y Y  Y  Y  Y LId LValueObjectGuidObjectNameProperty ValuenonpnqYYYId$ObjectGuidProperty$ObjectNamePropertynHv1b m m mYVNssY Y  Y  Y Y GUIDIdNameNameMapTypesv1  LVALN 0L A@!Jbic]Z0@fԓnLoan OfficersP{@HDn%[籌@LDLoan ApplicantsDI IMՂp` A@!Jbic P0OfficerID:L0 N7* A@!Jbic P0NameNoF D63L A@!Jbic P0BranchLocationV'BG=T A@!JbicP0NumberOfApplicantsDM},hJ? F{@HDn%[ P0OfficerIDrZ : 8 F n 9 i}t&;)ڊHo"ZVHow Credit Score and Loan Amounts Affect the Length of ApprovalN8DxX)3TCost Per ApplicantlNLH<%%FH$@SCOUNT Number of Applicants by Branch LocationPN~r)L~Fꔉ`*RSUM of Loans Per Each OfficerzNb^RCx*BI7QAVG Income by BranchNPL@}+&F7:Oud3PLoan Applicants1NHD8%1aEd)52TILoan ApplicantsNFB6)mI"K>DSalary >=75000 OR AmountApproved >=500000jNzvj p=DFLgCBranch LocationdNFB6@,^F 3BInterest Revenue Grouped by Officer IDNtpdJE Op/1B@Interest Revenue Calculated Field~NjfZ.AW;#?Interest Revenue Calculated Field}NjfZ6r*K@(+Credit Score <680 AND Loan Amount >100K|NvrfEMOlMf!)Bi-Lingual or At Least 2 Applicants{Nnj^׺v I3\ (Income Comparison Between Granada Hills and Woodland HillszN3ᓹ@5Ⱦ <'Officers Hired Before Year 2000&yNfbV{@HDn%[Loan ApplicantsxNFB6 A@!Jbic Loan OfficerswNB>2 No Applicants with Income at least $100K^vNrnbq-MDtniOfficers with MORE than 2 Applicants&tNpl` LVALN 0P{@HDn%[籌@PrLoan ApplicantsL A@!Jbic]Z0@LDLoan OfficersJD!Bs,t1{@HDn%[ P0Applicant ID:J^ N9{@HDn%[ P0Name>j1)M7_{@HDn%[P0IncomePDb4oBxv^{@HDn%[P0AmountRequestedDI IMՂp` A@!Jbic P0OfficerIDDM},hJ? F{@HDn%[ P0OfficerID LVALN 0L A@!Jbic@mZuLoan OfficersP{@HDn%[27@hLoan ApplicantsDI IMՂp` A@!Jbic OfficerID:L0 N7* A@!Jbic /NameDlDS($;N2(F| A@!JbicDateHired>6^Mb A@!JbicnSalaryNoF D63L A@!Jbic BranchLocationV'BG=T A@!JbicNumberOfApplicantsLC8JHHi*] A@!Jbic LoanSpecialtyFAy6MLj1)M7_{@HDn%[JR^IncomeN,U.]VI973{@HDn%[>ݓnAmountApprovedJЧJrC'ϗ{@HDn%[ InterestRateZl༯Ik!{@HDn%[ JR^LengthOfApprovalTimeBJ7tGjd|~/{@HDn%[ LoanTypeH=פCE)yX{@HDn%[\DCreditScoreDM},hJ? F{@HDn%[ OfficerIDLVALN0L A@!Jbic@LiLoan OfficersDI IMՂp` A@!Jbic P0OfficerID:L0 N7* A@!Jbic P0NameDlDS($;N2(F| A@!JbicP0DateHired LVALN 0L A@!Jbic@.Loan OfficersP{@HDn%[ّ@\DLoan ApplicantsHZ[Ae\(saAvgOfIncomeNoF D63L A@!Jbic P0BranchLocation>j1)M7_{@HDn%[P0IncomeDI IMՂp` A@!Jbic P0OfficerIDDM},hJ? F{@HDn%[ P0OfficerIDjLVALNz0L A@!Jbic@Loan OfficersDI IMՂp` A@!Jbic P0OfficerID:L0 N7* A@!Jbic P0NameV'BG=T A@!JbicP0NumberOfApplicantsFAy6MLj1)M7_{@HDn%[/IncomeN,U.]VI973{@HDn%[/AmountApprovedJЧJrC'ϗ{@HDn%[ /InterestRateDM},hJ? F{@HDn%[ /OfficerIDDI IMՂp` A@!Jbic /OfficerIDP LVALN` 0t.AW;# i@8bInterest Revenue Calculated FieldDM},hJ? F.AW;# `DOfficerIDb'Hv[Lig.AW;#`DInterestRevenueGeneratedNX8wM*71F.AW;#`DAmountApprovedJIG0qFVX%.AW;# `DInterestRateJD!Bs,t1.AW;# l(CApplicant ID:J^ N9.AW;# l(CName>j1)M7_.AW;#`DIncomeP LVALN` 0t.AW;# i@8bInterest Revenue Calculated FieldDM},hJ? F.AW;# `DOfficerIDb'Hv[Lig.AW;#`DInterestRevenueGeneratedNX8wM*71F.AW;#`DAmountApprovedJIG0qFVX%.AW;# `DInterestRateJD!Bs,t1.AW;# l(CApplicant ID:J^ N9.AW;# l(CName>j1)M7_.AW;#`DIncome LVALN 0L A@!Jbic@koLoan OfficersP{@HDn%[ّ@DLoan Applicants:J^ N9{@HDn%[ P0NameN,U.]VI973{@HDn%[P0AmountApprovedNoF D63L A@!Jbic P0BranchLocationBJ7tGjd|~/{@HDn%[ P0LoanTypeDI IMՂp` A@!Jbic P0OfficerIDDM},hJ? F{@HDn%[ P0OfficerID LVALN 0P{@HDn%[ّ@Loan ApplicantsL A@!Jbic@6^Mb A@!Jbicj1)M7_{@HDn%[IncomeN,U.]VI973{@HDn%[AmountApprovedJЧJrC'ϗ{@HDn%[ InterestRateZl༯Ik!{@HDn%[ LengthOfApprovalTimeBJ7tGjd|~/{@HDn%[ LoanTypeH=פCE)yX{@HDn%[CreditScoreDM},hJ? F{@HDn%[ OfficerID LVALN 0P{@HDn%[ّ@Loan ApplicantsJD!Bs,t1{@HDn%[ Applicant ID:J^ N9{@HDn%[ Name>j1)M7_{@HDn%[IncomeN,U.]VI973{@HDn%[\(CAmountApprovedJЧJrC'ϗ{@HDn%[ InterestRateZl༯Ik!{@HDn%[ LengthOfApprovalTimeBJ7tGjd|~/{@HDn%[ LoanTypeH=פCE)yX{@HDn%[CreditScoreDM},hJ? F{@HDn%[ OfficerID LVALN 0P{@HDn%[ّ@0Loan ApplicantsL A@!Jbic@DLoan OfficersHSy%i+@OCx*BI7TsaAvgOfIncomeNoF D63L A@!Jbic ~/BranchLocation>j1)M7_{@HDn%[~/IncomeDI IMՂp` A@!Jbic ~/OfficerIDDM},hJ? F{@HDn%[ ~/OfficerIDr LVALN 0P{@HDn%[ّ@0Loan ApplicantsL A@!Jbic@DLoan OfficersX CVC?")L~Fꔉ`*SumOfAmountApprovedDI IMՂp` A@!Jbic ~/OfficerID:L0 N7* A@!Jbic ~/NameNoF D63L A@!Jbic ~/BranchLocationN,U.]VI973{@HDn%[~/AmountApprovedDM},hJ? F{@HDn%[ ~/OfficerID LVALN 0P{@HDn%[ّ@0Loan ApplicantsL A@!Jbic@DLoan Officersd*U$cq@P%%FH$@CountOfNumberOfApplicantsNoF D63L A@!Jbic ~/BranchLocationV'BG=T A@!Jbic~/NumberOfApplicantsDI IMՂp` A@!Jbic ~/OfficerIDDM},hJ? F{@HDn%[ ~/OfficerID LVALN 0L A@!Jbic@0Loan OfficersP{@HDn%[ّ@DLoan ApplicantsR5 {DT`8DxX)3CostPerApplicantDI IMՂp` A@!Jbic ~/OfficerID:L0 N7* A@!Jbic ~/Name>6^Mb A@!Jbic~/SalaryV'BG=T A@!Jbic~/NumberOfApplicantsDM},hJ? F{@HDn%[ ~/OfficerID LVALN 0P{@HDn%[ّ@Loan ApplicantsZl༯Ik!{@HDn%[ LengthOfApprovalTimeH=פCE)yX{@HDn%[0CreditScoreN,U.]VI973{@HDn%[AmountApproved>j1)M7_{@HDn%[ sIncomeJD!Bs,t1{@HDn%[ Applicant ID:J^ N9{@HDn%[ /NameJЧJrC'ϗ{@HDn%[ InterestRateZdɗڻL/᦬t&;)ڊHo"ZtLengthOfApprovalTimeHv$0Jt&;)ڊHo"Z/CreditScoreY?N Y Y dY d Y Y Y dY  Filter FlagsIdNamePosition SelectedObjectIDTypeahciumYY.rBIdv1mCustom ^J v V Y ?N  Y Y Y  Y Y Y Y t FlagsGroupCategoryIDIdName"Object Type GroupObjectIDPositionY.YYYY.rDGroupCategoryIDIdVMSysNavPaneGroupCategoriesMSysNavPaneGroupsv1s yL|O"  : w 4 w  w  w  wCustom Group 162.*  w w w w w w w  @       @      n YAKN??AY Y Y DY  Y Y Y  FlagsGroupIDIconIdNameObjectIDPositionjtsYYYGroupIDIdTMSysNavPaneGroupsMSysNavPaneGroupToObjectsv1@ AyLk> ] 0  | O " n A  ` 3   R % qDc6 U(tGK: oJ4 o I  o H  o G  o F  o E  o D  o C  oB  o@  o>  o = o < o;  o : o 9 o8  o5  o2  o 1 o0  o / o.  o - o, o + o * o) o ( o'  o $ o " o  o o  o  o o  o  o o  o  o o  o  o o  o  o o  o  o  o  o  o r  o m  oh o o o! o o o o o  @ @ @ @ @ @ @ @ ?@ $')+-2567"./        # % ( 0 4          ! & * , 1 3 8 9 ; = > : <  @ @ @ @ @ @ @ @       " $!'"(#)$*%+&,'-(.)/*0+1,2-5.8/90:1;2<3=4>5@6B7C8D9E:F;G<H=I>J?K@RY+NY  Y Y oIdNameTypedv@P_@P_@rB@ hPROJECT840"  YNY Y Y D Y  Y DataExtensionIdNameTypet>YYJData_8B984A823CDF4FEA9CF169581C049D46Idv1@ thmxOffice Themethmx2*= YqS5 | < @ q  (( [Loan Officers].BranchLocation= g (([Loan Officers].Name3 g ((oan Officers].OfficerID8 g((Loan OfficersLoan Applicantsn@*UI+ ((SumOfAmountApprovedJ@*C77 o(( [Loan Officers].BranchLocation= g(([Loan Officers].Name3 g((oan Officers].OfficerID8 g ((Loan Officers+++  ((Loan Applicants/// (( G(( G (( (( G >2)@* ' 2)[Loan Officers].Salary5 g 2)[Loan Officers].Name3 g 2)oan Officers].OfficerID8 g2)Loan OfficersLoan Applicantsn@*UI+ '-DataPvcP=*z @ -  } j C 0  m Z G p]I6#r_^KJ7$s`M1Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y  3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p  0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p  1Y  3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p  0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p  1Y 1Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 0Y  1Y  3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p  0Y  1Y  3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p  0Y  1Y  3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p  0Y  1Y  3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p  0Y  1Y  3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p  0Y 0Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 0Y 1Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y 0\ 0\ 1Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 0Y 0\ 1Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 0Y 0\ 1Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 0Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y 0\ 0\ 1Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 0Y 0\ 1Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 0Y 1Y 0\ 1Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 0Y LVAL>ά&V$0 Loan Applicants Loan OfficersάF= |Loan ApplicantsLoan Applicants&|Loan OfficersLoan OfficersʾLoan OfficersCreate query in Design view^4\LVAL t3{ S |MR2ColumnWidthColumnHiddenAggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLF@[Loan Applicants].[Applicant ID]     GX%Oq2,[Loan Applicants].Name    nMSG hu60[Loan Applicants].Income MR2ColumnWidthColumnHiddenAggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLF@[Loan Applicants].[Applicant ID]     GX%Oq2,[Loan Applicants].Name    nMSG hu60[Loan Applicants].Income F   /@C;G2{.:'HB[Loan Applicants].AmountRequested    nF®d  <         No   , $ U{@HDn%[籌@Loan Applicants A@!Jbic]Z0@Loan OfficersD!Bs,t1{@HDn%[Applicant IDJ^ N9{@HDn%[Namej1)M7_{@HDn%[IncomeDb4oBxv^{@HDn%[AmountRequestedI IMՂp` A@!JbicOfficerIDM},hJ? F{@HDn%[OfficerID MR2lGUIDNameMap"ThemeResourceName&ClusterResourceNameH @,^F 3$ [Use DB Theme]MR2lGUIDNameMap"ThemeResourceName&ClusterResourceNameH JE Op/1B$ [Use DB Theme]MR2lGUIDNameMap"ThemeResourceName&ClusterResourceNameH t&;)ڊHo"Z$ [Use DB Theme]MR2lGUIDNameMap"ThemeResourceName&ClusterResourceNameH }+&F7:Oud3$ [Use DB Theme]MR2lGUIDNameMap"ThemeResourceName&ClusterResourceNameH %1aEd)52T$ [Use DB Theme]MR2( ReplicateProject MR20 Title AuthorCompanyX8 0Loan Applicants Database  JeremyLVALh Tά(50 Loan Officers(Loan Applicantsά#mW0 Loan Officers Loan ApplicantsάsA0 Loan Officersά(5)M.Loan ApplicantsLoan OfficerspLVAL !MR2RAggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOL\2,[Loan Applicants].Name  %mpOmpF@[Loan Applicants].AmountApproved  |CBClB<[Loan Officers].BranchLocation  53K tbd:4[Loan Applicants].LoanType  DΣHSخ  <        p=DFLg     2 * U A@!Jbic@Loan Officers{@HDn%[ّ@Loan ApplicantsJ^ N9{@HDn%[Name,U.]VI973{@HDn%[AmountApprovedoF D63L A@!JbicBranchLocationJ7tGjd|~/{@HDn%[LoanTypeI IMՂp` A@!JbicOfficerIDM},hJ? F{@HDn%[OfficerID MR2RAggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLb82[Loan Officers].OfficerID  d>XHfѳ X.([Loan Officers].Name  кLJJ'ntJD[Loan Officers].NumberOfApplicants  X7ӉD5~.ѳh>8[Loan Officers].[Bi-lingual]  dSmFki&g  <       EMOlMf!     t l U A@!Jbic@Loan OfficersI IMՂp` A@!JbicOfficerIDL0 N7* A@!JbicName'BG=T A@!JbicNumberOfApplicantsAy6ML + *    yfR?,{hUA.~jWDC00Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y 3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y r0Y r3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p r1Y 0Y 3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p 1Y %0Y %3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p %1Y 0Y 3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p 1Y 0Y 3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p 1Y 0Y 3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p 1Y 0Y 3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p 1Y !0Y !3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p !1Y #0Y #3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p #1Y '0Y '3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p '1Y 0Y 3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p 1Y T3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y m3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p m0Y m3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p m1Y @3Jưaq-Fj-D0ωЛQ n!=yWf7ۺ4sm-2M4]n93zgqL ֛IDU}o6p @0Y @3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p @1Y :0Y :3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p :1Y 40Y 43 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 41Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y -0Y -3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p -1Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p 1Y 0Y 3 SNq-F[? (Z3zQ n!=yWf7e;=^V;93zgqL ֛IDU}o6p (LVALh T@ά(50 Loan Officersά0 Loan Officers1 +Loan Applicantsά 0 Loan Officers Loan ApplicantsάQ0 9Loan Applicantsά(50 Loan Applicants Loan OfficersLVALe MR2AggregateTypeGUIDColumnWidthColumnHiddenRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLlB<[Loan Officers].BranchLocation  ӐqGCK~yo[AvgOfIncome    Z[Ae\o  <        ׺v I3\     U A@!Jbic@Loan Officers{@HDn%[ّ@Loan ApplicantsZ[Ae\AvgOfIncomeoF D63L A@!JbicBranchLocationj1)M7_{@HDn%[IncomeI IMՂp` A@!JbicOfficerIDM},hJ? F{@HDn%[OfficerID MR2RAggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLpF@[Loan Applicants].[Applicant ID]  (S;A |=P\2,[Loan Applicants].Name  D?Gm8gpF@[Loan Applicants].AmountApproved  Bl'1CTE2pFlB<[Loan Applicants].InterestRate  UMAPy zj@:[Loan Applicants].CreditScore  mA8c, 3  <       6r*K@(       U{@HDn%[ّ@Loan ApplicantsD!Bs,t1{@HDn%[Applicant IDJ^ N9{@HDn%[Name,U.]VI973{@HDn%[AmountApprovedЧJrC'ϗ{@HDn%[InterestRate=פCE)yX{@HDn%[CreditScore ALVALQMR2AggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLColumnWidthColumnHidden FormatDecimalPlacespF@[Loan Applicants].AmountApproved  X8wM*71FlB<[Loan Applicants].InterestRate  IG0qFVX%60InterestRevenueGenerated  'Hv[Lig  2 *$#,##0.00;($#,##0.00) ?  <       .AW;#       U A@!Jbic@Loan Officers{@HDn%[ّ@Loan Applicants'Hv[Lig.AW;#InterestRevenueGeneratedD!Bs,t1{@HDn%[Applicant IDJ^ N9{@HDn%[Namej1)M7_{@HDn%[Income,U.]VI973{@HDn%[AmountApprovedЧJrC'ϗ{@HDn%[InterestRateM},hJ? F{@HDn%[OfficerIDI IMՂp` A@!JbicOfficerID XF@[Loan Applicants].[Applicant ID] N<6[Loan Applicants].OfficerID D2,[Loan Applicants].Name H60[Loan Applicants].Income PLVALN`MR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionDecimalPlacesGUIDDefaultView8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexIMEModeIMESentenceModeSmartTagsTextAlignAggregateTypeExpressionResultTypeCurrencyLCIDPublishToWeb    U{@HDn%[ّ@Loan ApplicantsD!Bs,t1{@HDn%[Applicant IDJ^ N9{@HDn%[Namej1)M7_{@HDn%[Income,U.]VI973{@HDn%[AmountApprovedЧJrC'ϗ{@HDn%[InterestRatel༯Ik!{@HDn%[LengthOfApprovalTimeJ7tGjd|~/{@HDn%[LoanType=פCE)yX{@HDn%[CreditScoreM},hJ? F{@HDn%[OfficerID  {@HDn%[       B B   B  B ! " +EmployeeID        m  D!Bs,t1 # $ & ' ) *Name       m  J^ N9 # $ & ' ) *LoanType       m  J7tGjd|~/ # $ & ' ) *CreditScore       0  m =פCE)yX & ' ) *OfficerID       m  M},hJ? F # $ & ' ) *.(LengthOfApprovalTime       m  l༯Ik! # $ & ' ) *"AmountApproved ,U.]VI973 %   2 *$#,##0.00;($#,##0.00)   0  & ' ) *  Income j1)M7_ F   2 *$#,##0.00;($#,##0.00)   0  & ' ) * InterestRate ЧJrC'ϗ       m # $  & ' ) *managerID       m # $  & ' ) *LVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionDecimalPlacesGUIDDefaultView8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexIMEModeIMESentenceModeSmartTagsTextAlignAggregateTypeExpressionResultTypeCurrencyLCIDShowDatePicker    U A@!Jbic@Loan Officers{@HDn%[27@Loan ApplicantsI IMՂp` A@!JbicOfficerIDL0 N7* A@!JbicNamelDS($;N2(F| A@!JbicDateHired6^Mb A@!JbicSalaryoF D63L A@!JbicBranchLocation'BG=T A@!JbicNumberOfApplicantsC8JHHi*] A@!JbicLoanSpecialtyAy6ML     8 0 U{@HDn%[ّ@Loan Applicants A@!Jbic@Loan OfficersdPK mh`CFSumOfAmountApprovedI IMՂp` A@!JbicOfficerIDL0 N7* A@!JbicName6^Mb A@!JbicSalary,U.]VI973{@HDn%[AmountApprovedM},hJ? F{@HDn%[OfficerID MR2RAggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLb82[Loan Officers].OfficerID  3w/N7'X.([Loan Officers].Name  z#lJ>P\;D2,[Loan Officers].Salary lB<[Loan Officers].BranchLocation  NcA?Cѫ/wtJD[Loan Officers].NumberOfApplicants  +¹Ne|;|y  <       q-MDtni       U A@!Jbic]Z0@Loan Officers{@HDn%[籌@Loan ApplicantsI IMՂp` A@!JbicOfficerIDL0 N7* A@!JbicNameoF D63L A@!JbicBranchLocation'BG=T A@!JbicNumberOfApplicantsM},hJ? F{@HDn%[OfficerID MR2RAggregateTypeGUIDRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLb82[Loan Officers].OfficerID   F0b=X.([Loan Officers].Name  ;63_xJ~eUb82[Loan Officers].DateHired  h{Idc/Xs  <       3ᓹ@5Ⱦ <     $  U A@!Jbic@Loan OfficersI IMՂp` A@!JbicOfficerIDL0 N7* A@!JbicNamelDS($;N2(F| A@!JbicDateHired $LVALh 8ά0 Loan Applicants Loan Officersά7{[)0 Loan Applicants Loan Officersά&V$0 Loan Officers Loan ApplicantsLVALMR2AccessVersion BuildProjVerNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By>Show Navigation Pane Search Bar&Theme Resource Name6Track Name AutoCorrect Info0Perform Name AutoCorrectHasOfflineListsWebDesignMode 09.50 }              Office Theme  F MR2AccessVersion BuildProjVerNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By>Show Navigation Pane Search Bar&Theme Resource Name6Track Name AutoCorrect Info0Perform Name AutoCorrectHasOfflineListsWebDesignMode 09.50 }              Office Theme  F MR2AggregateTypeGUIDColumnWidthColumnHiddenRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewFilterOnLoadOrderByOnLoadTotalsRowDOLX.([Loan Officers].Name  :HBߌ'V,&SumOfAmountApproved   CVC?"b82[Loan Officers].OfficerID  upxE'.lB<[Loan Officers].BranchLocation  3w J@7fq  <        )L~Fꔉ`*   H @ U{@HDn%[ّ@Loan Applicants A@!Jbic@Loan Officers CVC?")L~Fꔉ`*SumOfAmountApprovedI IMՂp` A@!JbicOfficerIDL0 N7* A@!JbicNameoF D63L A@!JbicBranchLocation,U.]VI973{@HDn%[AmountApprovedM},hJ? F{@HDn%[OfficerID D2,[Loan Officers].Salary \JD[Loan Officers].NumberOfApplicants [4.SumOfNumberOfApplicants   XF@[Loan Applicants].AmountApproved y Od MSysNavPaneGroupsMSysNavPaneGroupToObjectsMSysNavPaneGroupToObjectsGroupIDMSysNavPaneGroupsIdbMSysNavPaneGroupCategoriesMSysNavPaneGroupsMSysNavPaneGroupsGroupCategoryIDMSysNavPaneGroupCategoriesIddLoan OfficersLoan ApplicantsLoan ApplicantsOfficerIDLoan OfficersOfficerIDvdF LVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionDecimalPlacesGUIDDefaultView8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexIMEModeIMESentenceModeSmartTagsTextAlignAggregateTypeExpressionResultTypeCurrencyLCID    U{@HDn%[ّ@Loan ApplicantsD!Bs,t1{@HDn%[Applicant IDJ^ N9{@HDn%[Namej1)M7_{@HDn%[Income,U.]VI973{@HDn%[AmountApprovedЧJrC'ϗ{@HDn%[InterestRatel༯Ik!{@HDn%[LengthOfApprovalTimeJ7tGjd|~/{@HDn%[LoanType=פCE)yX{@HDn%[CreditScoreM},hJ? F{@HDn%[OfficerID  {@HDn%[       B B   B  B ! "EmployeeID        m  D!Bs,t1 # $ & ' ) *Name       m  J^ N9 # $ & ' ) *LoanType       m  J7tGjd|~/ # $ & ' ) *CreditScore       0  m =פCE)yX & ' ) *OfficerID       m  M},hJ? F # $ & ' ) *.(LengthOfApprovalTime       m  l༯Ik! # $ & ' ) *"AmountApproved ,U.]VI973 %   2 *$#,##0.00;($#,##0.00)   0  & ' ) *  Income j1)M7_ F   2 *$#,##0.00;($#,##0.00)   0  & ' ) * InterestRate ЧJrC'ϗ       m # $  & ' ) *u+NL } : L b  e z Ee2r)n?(SUM of Loans Per Each OfficerD@Salary >=75000 OR AmountApproved >=500000\XOfficers with MORE than 2 ApplicantsRNOfficers Hired Before Year 2000HDMSysResources$ MSysNavPaneObjectIDs2.MSysNavPaneGroupToObjects<8MSysNavPaneGroups,(MSysNavPaneGroupCategories>:rMSysNameMap mMSysAccessXML$ @MSysAccessStorage,(:Loan Officers$ 4Loan Applicants($Interest Revenue Calculated FieldLHIncome Comparison Between Granada Hills and Woodland Hills~z-f_F442BB1A37614C0B98735963931C0174_DataXTCredit Score <680 AND Loan Amount >100KXTCOUNT Number of Applicants by Branch Locationd`Cost Per Applicant.*Commercial loans in Granada HillsLHBi-Lingual or At Least 2 ApplicantsPLAVG Income by Branch2.Applicants with Income at least $100KTP Interest Revenue Grouped by Officer IDVR Interest Revenue Calculated FieldLH How Credit Score and Loan Amounts Affect the Length of Approval Loan Applicants1*& Loan Applicants($'MSysComplexType_Attachment>:%MSysComplexType_Text2.#MSysComplexType_Decimal84!MSysComplexType_GUID2.MSysComplexType_IEEEDouble>:MSysComplexType_IEEESingle>:MSysComplexType_Long2.MSysComplexType_Short40MSysComplexType_UnsignedByteB>MSysComplexColumns.*MSysRelationships,(MSysQueries MSysACEsMSysObjects  LVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionDecimalPlacesGUIDDefaultView8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexIMEModeIMESentenceModeSmartTagsTextAlignAggregateTypeExpressionResultTypeCurrencyLCIDPublishToWeb    U{@HDn%[ّ@Loan ApplicantsD!Bs,t1{@HDn%[Applicant IDJ^ N9{@HDn%[Namej1)M7_{@HDn%[Income,U.]VI973{@HDn%[AmountApprovedЧJrC'ϗ{@HDn%[InterestRatel༯Ik!{@HDn%[LengthOfApprovalTimeJ7tGjd|~/{@HDn%[LoanType=פCE)yX{@HDn%[CreditScoreM},hJ? F{@HDn%[OfficerID  {@HDn%[       B B   B  B ! " +EmployeeID        m  D!Bs,t1 # $ & ' ) *Name       m  J^ N9 # $ & ' ) *CreditScore       0  m =פCE)yX & ' ) *OfficerID       m  M},hJ? F # $ & ' ) *.(LengthOfApprovalTime       m  l༯Ik! # $ & ' ) *"AmountApproved ,U.]VI973 %   2 *$#,##0.00;($#,##0.00)   0  & ' ) *  Income j1)M7_ F   2 *$#,##0.00;($#,##0.00)   0  & ' ) * InterestRate ЧJrC'ϗ       m # $  & ' ) *managerID       m # $  & ' ) *LVALm|NMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionDecimalPlacesGUIDDefaultView8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexIMEModeIMESentenceModeSmartTagsTextAlignAggregateTypeExpressionResultTypeCurrencyLCIDPublishToWeb    U{@HDn%[ّ@Loan ApplicantsD!Bs,t1{@HDn%[Applicant IDJ^ N9{@HDn%[Namej1)M7_{@HDn%[Income,U.]VI973{@HDn%[AmountApprovedЧJrC'ϗ{@HDn%[InterestRatel༯Ik!{@HDn%[LengthOfApprovalTimeJ7tGjd|~/{@HDn%[LoanType=פCE)yX{@HDn%[CreditScoreM},hJ? F{@HDn%[OfficerID  {@HDn%[       B B   B  B ! " +EmployeeID        m  D!Bs,t1 # $ & ' ) *Name       m  J^ N9 # $ & ' ) *LoanType       m  J7tGjd|~/ # $ & ' ) *CreditScore       0  m =פCE)yX & ' ) *OfficerID       m  M},hJ? F # $ & ' ) *.(LengthOfApprovalTime       m  l༯Ik! # $ & ' ) *"AmountApproved ,U.]VI973 %   2 *$#,##0.00;($#,##0.00)   0  & ' ) *  Income j1)M7_ F   2 *$#,##0.00;($#,##0.00)   0  & ' ) * InterestRate ЧJrC'ϗ       m # $  & ' ) * LVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionDecimalPlacesGUIDDefaultView8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexIMEModeIMESentenceModeSmartTagsTextAlignAggregateTypeExpressionResultTypeCurrencyLCIDPublishToWeb    U{@HDn%[ّ@Loan ApplicantsD!Bs,t1{@HDn%[Applicant IDJ^ N9{@HDn%[Namej1)M7_{@HDn%[Income,U.]VI973{@HDn%[AmountApprovedЧJrC'ϗ{@HDn%[InterestRatel༯Ik!{@HDn%[LengthOfApprovalTimeJ7tGjd|~/{@HDn%[LoanType=פCE)yX{@HDn%[CreditScoreM},hJ? F{@HDn%[OfficerID  {@HDn%[       B B   B  B ! " +EmployeeID        m  D!Bs,t1 # $ & ' ) *Name       m  J^ N9 # $ & ' ) *CreditScore       0  m =פCE)yX & ' ) *OfficerID       m  M},hJ? F # $ & ' ) *"AmountApproved ,U.]VI973 %   2 *$#,##0.00;($#,##0.00)   0  & ' ) *  Income j1)M7_ F   2 *$#,##0.00;($#,##0.00)   0  & ' ) * InterestRate ЧJrC'ϗ       m # $  & ' ) *managerID       m # $  & ' ) * LVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionDecimalPlacesGUIDDefaultView8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexIMEModeIMESentenceModeSmartTagsTextAlignAggregateTypeExpressionResultTypeCurrencyLCIDPublishToWeb    U{@HDn%[ّ@Loan ApplicantsD!Bs,t1{@HDn%[Applicant IDJ^ N9{@HDn%[Namej1)M7_{@HDn%[Income,U.]VI973{@HDn%[AmountApprovedЧJrC'ϗ{@HDn%[InterestRatel༯Ik!{@HDn%[LengthOfApprovalTimeJ7tGjd|~/{@HDn%[LoanType=פCE)yX{@HDn%[CreditScoreM},hJ? F{@HDn%[OfficerID  {@HDn%[       B B   B  B ! " +EmployeeID        m  D!Bs,t1 # $ & ' ) *Name       m  J^ N9 # $ & ' ) *CreditScore       0  m =פCE)yX & ' ) *OfficerID       m  M},hJ? F # $ & ' ) *"AmountApproved ,U.]VI973 %   2 *$#,##0.00;($#,##0.00)   0  & ' ) *  Income j1)M7_ F   2 *$#,##0.00;($#,##0.00)   0  & ' ) * managerID       m # $  & ' ) * LVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionDecimalPlacesGUIDDefaultView8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexIMEModeIMESentenceModeSmartTagsTextAlignAggregateTypeExpressionResultTypeCurrencyLCIDPublishToWeb    U{@HDn%[ّ@Loan ApplicantsD!Bs,t1{@HDn%[Applicant IDJ^ N9{@HDn%[Namej1)M7_{@HDn%[Income,U.]VI973{@HDn%[AmountApprovedЧJrC'ϗ{@HDn%[InterestRatel༯Ik!{@HDn%[LengthOfApprovalTimeJ7tGjd|~/{@HDn%[LoanType=פCE)yX{@HDn%[CreditScoreM},hJ? F{@HDn%[OfficerID  {@HDn%[       B B   B  B ! " +EmployeeID        m  D!Bs,t1 # $ & ' ) *Name       m  J^ N9 # $ & ' ) *CreditScore       0  m =פCE)yX & ' ) *OfficerID       m  M},hJ? F # $ & ' ) *"AmountApproved ,U.]VI973 %   2 *$#,##0.00;($#,##0.00)   0  & ' ) *  Income j1)M7_ F   2 *$#,##0.00;($#,##0.00)   0  & ' ) * managerID       m # $  & ' ) *LVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControl$UnicodeCompressionDecimalPlacesGUIDDefaultView8DisplayViewsOnSharePointSiteTotalsRowFilterOnLoadOrderByOnLoadHideNewFieldBackTintBackShadeThemeFontIndex8AlternateBackThemeColorIndex"AlternateBackTint$AlternateBackShadeBDatasheetGridlinesThemeColorIndex8DatasheetForeThemeColorIndexIMEModeIMESentenceModeSmartTagsTextAlignAggregateTypeExpressionResultTypeCurrencyLCIDPublishToWeb    U{@HDn%[ّ@Loan ApplicantsD!Bs,t1{@HDn%[Applicant IDJ^ N9{@HDn%[Namej1)M7_{@HDn%[Income,U.]VI973{@HDn%[AmountApprovedЧJrC'ϗ{@HDn%[InterestRatel༯Ik!{@HDn%[LengthOfApprovalTimeJ7tGjd|~/{@HDn%[LoanType=פCE)yX{@HDn%[CreditScoreM},hJ? F{@HDn%[OfficerID  {@HDn%[       B B   B  B ! " +EmployeeID        m  D!Bs,t1 # $ & ' ) *Name       m  J^ N9 # $ & ' ) *CreditScore       0  m =פCE)yX & ' ) *OfficerID       m  M},hJ? F # $ & ' ) *"AmountApproved ,U.]VI973 %   2 *$#,##0.00;($#,##0.00)   0  & ' ) *  Income j1)M7_ F   2 *$#,##0.00;($#,##0.00)   0  & ' ) * managerID       m # $  & ' ) * LVAL MR2AccessVersion BuildProjVerNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By>Show Navigation Pane Search Bar&Theme Resource Name6Track Name AutoCorrect Info0Perform Name AutoCorrectHasOfflineListsWebDesignMode 09.50 }              Office Theme  F MR2AccessVersion BuildProjVerNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By>Show Navigation Pane Search Bar&Theme Resource Name6Track Name AutoCorrect Info0Perform Name AutoCorrectHasOfflineListsWebDesignMode 09.50 }              Office Theme  F