EFTA01413017.pdf
📄 Extracted Text (15,755 words)
July-yc
Number Rule Code RuleGroup Customer ID Account Create Date Review State Revi
ew Oper Review Date Random 2nd Review Row Labels Count of Rule Code
46119 RepPersChks Repetitive 42934645 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
19 0.7861386686782987 approved dormant 66 0.10 GETPIVOTDATA("Rule Code",$M$
1,"RuleGroup","dormant")*02=6.60
46146 RepWiresOut Repetitive 44128313 7/2/2013 4:05 Waived CHENYA 7/3/2013 14:
02 0.8797316570747225 approved HubSpoke 11 0.10 GETPIVOTDATA("Rule C
ode",$M$1,"RuleGroup","HubSpoke")*03=1.1
46160 RACS3 RACS3 4.0000440906E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:21 0.9238095514
127043 approved RACS3 15 0.10 GETPIVOTDATA("Rule Code",$M$1,"RuleGroup","RACS3")*0
4=1.50
46161 RACS3 RACS3 4.0000463189E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:21 0.7646338022
438355 approved RACS4 53 0.20 GETPIVOTDATA("Rule Code",$M$1,"RuleGroup","RACS4°)*0
5=10.60
46164 RACS4 RACS4 1.0000213899E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:30 0.8754990593
397902 approved Repetitive 28 0.10 GETPIVOTDATA("Rule Code",$M$1,"RuleGroup","R
epetitive")*06=2.8000000000000003
46180 RACS4 RACS4 4.0000023497E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 15:57 0.8989081458
200237 approved Velocity 17 0.10 GETPIVOTDATA("Rule Code",$M$1,"RuleGroup","V
elocity")*07=1.7000000000000002
46264 dDormntAcct dormant 44110762 7/4/2013 7:45 waived CHENYA 8/1/2013 15:45 0.85
2747938181718 Grand Total 190 SUM(P2:P7)=24.300000000000004
46271 dDormntAcct dormant 140417 7/6/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.8407710962
972186
46279 dDormntAcct dormant 140418 7/9/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.8250814298
204152
46377 dDormntAcct dormant 228501 7/11/2013 4:05 Waived CHENYA 8/1/2013 15:44 0.8152109762
270912
46257 dDormntAcct dormant 37985405 7/3/2013 4:04 Waived CHENYA 8/1/2013 15:45 0.76
4493293798675
46379 dDormntAcct dormant 44124654 7/11/2013 4:05 Waived CHENYA 8/1/2013 15:44 0.76
17600181817528
46265 dDormntAcct dormant 44110770 7/4/2013 7:45 Waived CHENYA 8/1/2013 15:45 0.75
55802775347378
46077 dDormntAcct dormant 44110252 7/2/2013 4:04 Waived CHENYA 7/9/2013 10:38 0.75
24688876494432
46272 dDormntAcct dormant 140419 7/6/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.7454812193
733862
46274 dDormntAcct dormant 140561 7/6/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.7405012057
498683
46263 dDormntAcct dormant 44110754 7/4/2013 7:45 Waived CHENYA 8/1/2013 15:44 0.73
29652835323319
46506 dDormntAcct dormant 140476 7/17/2013 4:04 Waived CHENYA 7/24/2013 11:43 0.7321739233
499036
46742 dDormntAcct dormant 44122122 7/31/2013 4:14 Waived CHENYA 8/1/2013 15:44 0.70
80264267407437
46523 dDormntAcct dormant 631013 7/23/2013 4:11 Waived CHENYA 8/1/2013 15:44 0.7031613813
403088
46516 dDormntAcct dormant 37928515 7/20/2013 4:04 Waived CHENYA 8/1/2013 15:45 0.69
60346318666939
46630 dDormntAcct dormant 15425212 7/30/2013 4:11 Waived CHENYA 7/30/2013 14:11 0.67
33228111199336
46256 dDormntAcct dormant 37985384 7/3/2013 4:04 Waived CHENYA 8/1/2013 15:58 0.66
89598083782053
46260 dDormntAcct dormant 44110711 7/4/2013 7:45 Waived CHENYA 8/1/2013 16:01 0.65
66188934105401
46513 dDormntAcct dormant 35256612 7/19/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.62
95848385391256
46277 dDormntAcct dormant 15436894 7/6/2013 4:04 Waived CHENYA 8/1/2013 16:09 0.62
89537715858491
46515 dDormntAcct dormant 37990108 7/19/2013 4:04 Waived CHENYA 8/1/2013 15:45 0.59
65069379323937
46624 dDormntAcct dormant 35216653 7/27/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.59
14078424722078
46273 dDormntAcct dormant 140420 7/6/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.5811092747
919337
46378 dDormntAcct dormant 44120901 7/11/2013 4:05 Waived CHENYA 8/1/2013 15:44 0.55
1463467333434
46255 dDormntAcct dormant 247507 7/3/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.5418456821
213269
46511 dDormntAcct dormant 37986782 7/18/2013 4:05 Waived CHENYA 8/1/2013 15:45 0.51
66074162535972
46078 dDormntAcct dormant 630312 7/2/2013 4:04 Waived CHENYA 7/2/2013 11:40 0.5140219897
312297
46508 dDormntAcct dormant 342380 7/17/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.5081664046
898793
46387 dDormntAcct dormant 450444 7/13/2013 4:04 Waived CHENYA 8/1/2013 15:45 0.4941223321
503383
EFTA01413017
46507 dDormntAcct dormant 250559 7/17/2013 4:04 Waived CHENYA 8/1/2013 16:23 0.4916090943
9774714
46619 dDormntAcct dormant 42946945 7/26/2013 13:58 Waived CHENYA 8/1/2013 16:37 0.49
02698800340559
46618 dDormntAcct dormant 257360 7/26/2013 13:58 Waived CHENYA 7/30/2013 12:55 0.4768828942
010268
46282 dDormntAcct dormant 680202 7/9/2013 4:04 Waived CHENYA 8/1/2013 15:45 0.4622977510
802513
46382 dDormntAcct dormant 44124806 7/12/2013 4:03 Waived CHENYA 8/1/2013 16:14 0.43
549383829183874
46267 dDormntAcct dormant 44111562 7/4/2013 7:45 Waived CHENYA 8/1/2013 15:44 0.42
95721812462956
46522 dDormntAcct dormant 630035 7/23/2013 4:11 Waived CHENYA 8/1/2013 15:45 0.4237488821
2483874
46611 dDormntAcct dormant 15441044 7/24/2013 4:07 Waived CHENYA 8/1/2013 15:44 0.35
65785521466802
46390 dDormntAcct dormant 250558 7/16/2013 4:05 Waived CHENYA 8/1/2013 15:45 0.3553711312
084087
46510 dDormntAcct dormant 35248997 7/18/2013 4:05 Waived CHENYA 8/1/2013 15:44 0.35
353296337374474
46514 dDormntAcct dormant 35262326 7/19/2013 4:04 Waived CHENYA 8/1/2013 16:28 0.33
43384174127968
46266 dDormntAcct dormant 44111511 7/4/2013 7:45 Waived CHENYA 8/1/2013 15:45 0.27
785767221959556
46254 dDormntAcct dormant 18154235 7/3/2013 4:04 Waived CHENYA 8/1/2013 15:53 0.27
546377497766916
46633 dDormntAcct dormant 42940041 7/30/2013 4:11 Waived CHENYA 8/1/2013 15:45 0.26
10526189237743
46632 dDormntAcct dormant 37982159 7/30/2013 4:11 Waived CHENYA 8/1/2013 15:44 0.24
45990832550058
46617 dDormntAcct dormant 44110631 7/25/2013 4:09 Waived CHENYA 8/1/2013 15:45 0.19
533782807129363
46389 dDormntAcct dormant 243760 7/16/2013 4:05 Waived CHENYA 8/1/2013 15:44 0.1892030731
1004336
46268 dDormntAcct dormant 44111570 7/4/2013 7:45 Waived CHENYA 8/1/2013 15:44 0.17
262829112384814
46521 dDormntAcct dormant 15441028 7/23/2013 4:11 Waived CHENYA 8/1/2013 15:44 0.15
791873351133656
46262 dDormntAcct dormant 44110746 7/4/2013 7:45 Waived CHENYA 8/1/2013 15:44 0.12
084531844066948
46625 dDormntAcct dormant 44123897 7/27/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.12
051207084132454
46517 dDormntAcct dormant 42941909 7/20/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.11
817625750228822
46509 dDormntAcct dormant 35088428 7/17/2013 4:04 Waived CHENYA 8/1/2013 15:45 0.11
036353553968015
46612 dDormntAcct dormant 18191757 7/25/2013 4:09 Waived CHENYA 8/1/2013 16:32 0.10
140472243365806
46276 dDormntAcct dormant 15307849 7/6/2013 4:04 Waived CHENYA 8/1/2013 15:45 0.10
069011609725309
46741 dDormntAcct dormant 44121613 7/31/2013 4:14 Waived CHENYA 8/1/2013 12:08 0.09
002386869177847
46374 dDormntAcct dormant 190824 7/10/2013 4:04 Waived CHENYA 7/22/2013 10:43 0.0710173772
1680612
46375 dDormntAcct dormant 35263775 7/10/2013 4:04 Waived CHENYA 8/1/2013 15:44 0.04
2916870960076015
46615 dDormntAcct dormant 35230965 7/25/2013 4:09 Waived CHENYA 8/1/2013 15:44 0.03
4182022654788646
46512 dDormntAcct dormant 42929483 7/18/2013 4:05 Waived CHENYA 8/1/2013 15:45 0.02
050272487772542
46391 dDormntAcct dormant 44123264 7/16/2013 4:05 Waived CHENYA 8/1/2013 15:44 0.01
0509180264700824
46201 RACS4 RACS4 4.0000475661E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 17:04 0.9985987801
673399 approved
46214 HubMBenM HubSpoke 7/2/2013 4:05 Waived CHENYA 7/5/2013 11:05 0.9402358444
170098
46229 HubMBenLow HubSpoke 7/2/2013 4:05 Waived CHENYA 7/5/2013 12:35 0.9131284965
468724
46224 HubMBenLow HubSpoke 7/2/2013 4:05 Waived CHENYA 7/9/2013 12:38 0.8305615399
046591
46210 HubMBenM HubSpoke 7/2/2013 4:05 Waived CHENYA 7/5/2013 10:16 0.7297672838
758764
46234 HubMBenLow HubSpoke 7/2/2013 4:05 Waived CHENYA 7/5/2013 12:42 0.6877837897
123096
46233 HubMBenLow HubSpoke 7/2/2013 4:05 Waived CHENYA 7/5/2013 12:38 0.4834233333
8252264
46215 HubMBenM HubSpoke 7/2/2013 4:05 Waived CHENYA 7/5/2013 11:51 0.4637426261
676447
46252 HubMOrgLow HubSpoke 7/2/2013 4:05 Waived CHENYA 7/5/2013 12:50 0.1935288316
EFTA01413018
8099577
46222 HubMBenM HubSpoke 7/2/2013 4:05 Waived CHENYA 7/5/2013 11:55 0.1270187409
6702204
46213 HubMBenM HubSpoke 7/2/2013 4:05 Waived CHENYA 7/5/2013 10:47 0.0683175901
4354155
46250 HubMOrgLow HubSpoke 7/2/2013 4:05 Waived CHENYA 7/5/2013 12:45 0.9847840428
301426 approved
46259 dDormntAcct dormant 247706 7/4/2013 7:45 Waived CHENYA 8/1/2013 15:44 0.8904617510
65402 approved
46152 RACS3 RACS3 1.0000457405E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:21 0.7606823201
725295
46154 RACS3 RACS3 1.0000475392E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:21 0.7218505889
51374
46573 RACS3 RACS3 4.0000023497E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 13:36 0.7115780032
973955
46637 RACS3Neg RACS3 99955009 7/30/2013 4:12 Waived CHENYA 7/30/2013 14:54 0.64
90170414512646
46157 RACS3 RACS3 4.0000023497E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:21 0.5888531219
215265
46457 RACS3 RACS3 4.0000004144E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 15:33 0.5699715418
371023
46158 RACS3 RACS3 4.000042244E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 14:12 0.5497163778
27798
46162 RACS3 RACS3 99955009 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:21 0.3338020026
6065874
46456 RACS3 RACS3 1.0000477766E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 15:09 0.2619371498
586638
46150 RACS3 RACS3 1.0000026993E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:21 0.2119503758
2294152
46458 RACS3 RACS3 4.0000023497E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 15:39 0.1891422218
3123197
46156 RACS3 RACS3 4.0000021897E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:21 0.1537150659
126605
46153 RACS3 RACS3 1.0000471608E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:21 0.0578600053
0146129
46261 dDormntAcct dormant 44110738 7/4/2013 7:45 waived CHENYA 8/1/2013 15:44 0.86
07501711726 approved
46269 dDormntAcct dormant 44111706 7/4/2013 7:45 waived CHENYA 8/1/2013 15:44 0.90
05168125421239 approved
46296 VelWireChk Velocity 1.000047161E10 7/9/2013 4:04 Waived CHENYA 7/9/2013 11:
23 0.9668278325296111 approved
46355 RACS4 RACS4 4.0000021022E10 7/9/2013 4:04 Waived CHENYA 7/9/2013 12:27 0.8923425074
123301 approved
46420 VelWireWir Velocity 1.0000229383E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 12
:21 0.9728903357041845 approved
46441 RepiranOut2 Repetitive 631065 7/16/2013 4:05 Waived CHENYA 7/22/2013 14:23 0.95
10876093164333 approved
46462 RACS4 RACS4 1.0000043346E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 15:44 0.8942841821
662662 approved
46503 RACS4 RACS4 4.0000473012E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 17:00 0.8441959787
361006 approved
46504 RACS4 RACS4 4.0000475551E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 17:01 0.8355006727
90662 returned
46585 RACS4 RACS4 4.0000017583E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 14:42 0.9454528703
694285 approved
46590 RACS4 RACS4 4.0000020888E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 14:52 0.9331465963
860222 approved
46175 RACS4 RACS4 4.0000021022E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:30 0.7788009682
72197
46177 RACS4 RACS4 4.0000021113E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 14:49 0.7594645965
804636
46592 RACS4 RACS4 4.0000021022E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 15:08 0.7577718020
042088
46589 RACS4 RACS4 4.0000020886E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 14:51 0.7420555581
496044
46347 RACS4 RACS4 1.0000477766E10 7/9/2013 4:04 Waived CHENYA 7/9/2013 12:18 0.7277091682
495405
46173 RACS4 RACS4 4.0000020888E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:30 0.7207023270
578548
46494 RACS4 RACS4 4.0000422704E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 16:55 0.6894860837
008343
46174 RACS4 RACS4 4.0000020991E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:30 0.6804319709
187612
46178 RACS4 RACS4 4.0000021897E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 15:14 0.6539727373
001116
46084 RACS4Neg RACS4 1.0000471608E10 7/2/2013 4:05 Waived CHENYA 7/30/2013 12:47 0.64
9396242456836
46357 RACS4 RACS4 4.0000022121E10 7/9/2013 4:04 Waived CHENYA 7/9/2013 12:36 0.6435930068
361309
EFTA01413019
46594 RACS4 RACS4 4.0000021093E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 14:53 0.6251470504
350938
46179 RACS4 RACS4 4.000002336E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 15:46 0.6167897001
99105
46170 RACS4 RACS4 1.0000471608E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 14:41 0.6111062204
729931
46582 RACS4 RACS4 4.0000000344E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 13:48 0.5704052115
225149
46351 RACS4 RACS4 4.0000004733E10 7/9/2013 4:04 Waived CHENYA 7/9/2013 12:21 0.5557368400
575269
46609 RACS4 RACS4 4.0000481227E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 15:12 0.5258328618
361889
46195 RACS4 RACS4 4.0000463189E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 16:42 0.4816566666
464359
46192 RACS4 RACS4 4.0000423849E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 16:35 0.4557135289
2359873
46368 RACS4 RACS4 4.0000458912E10 7/9/2013 4:04 Waived CHENYA 7/9/2013 12:54 0.4539461666
4755016
46191 RACS4 RACS4 4.0000422706E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 16:09 0.4444663755
7668955
46736 RACS4 RACS4 4.0000475661E10 7/30/2013 4:12 Waived CHENYA 7/30/2013 16:53 0.4434167460
2409165
46176 RACS4 RACS4 4.0000021092E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:30 0.4266845929
044032
46711 RACS4 RACS4 4.0000004733E10 7/30/2013 4:12 Waived CHENYA 7/30/2013 16:34 0.4215560159
199141
46732 RACS4 RACS4 4.0000471004E10 7/30/2013 4:12 Waived CHENYA 7/30/2013 16:40 0.3226304429
570144
46501 RACS4 RACS4 4.0000463165E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 16:59 0.3185231487
119937
46712 RACS4 RACS4 4.0000012453E10 7/30/2013 4:12 Waived CHENYA 7/30/2013 16:36 0.3156665528
5585976
46203 RACS4 RACS4 99955009 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:30 0.3062910338
674514
46168 RACS4 RACS4 1.0000442731E10 7/2/2013 4:05 Waived CHENYA 8/27/2013 17:12 0.3059682080
427164
46165 RACS4 RACS4 1.0000236057E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 14:16 0.3007885625
974325
46733 RACS4 RACS4 4.0000471174E10 7/30/2013 4:12 Waived CHENYA 7/30/2013 16:44 0.2921269059
764069
46491 RACS4 RACS4 4.0000408598E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 16:45 0.2884449478
11886
46479 RACS4 RACS4 4.0000020181E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 15:51 0.1923814449
3518128
46604 RACS4 RACS4 4.000042244E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 15:09 0.1916856571
4210928
46482 RACS4 RACS4 4.0000021851E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 15:55 0.1876393769
709397
46172 RACS4 RACS4 4.0000020181E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:30 0.1763425034
7855218
46190 RACS4 RACS4 4.000042244E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 16:05 0.1579432836
6570198
46171 RACS4 RACS4 4.0000002505E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:30 0.1488171704
5276766
46498 RACS4 RACS4 4.0000426123E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 16:56 0.1471944792
0939577
46163 RACS4 RACS4 1.0000111105E10 7/2/2013 4:05 Waived CHENYA 7/2/2013 13:30 0.1288945094
363365
46196 RACS4 RACS4 4.0000464138E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 17:02 0.1254479244
8416464
46490 RACS4 RACS4 4.0000407577E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 16:17 0.0739576748
3864191
46593 RACS4 RACS4 4.0000021092E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 14:52 0.9573682702
80079 approved
46616 dDormntAcct dormant 42931401 7/25/2013 4:09 Waived CHENYA 8/1/2013 15:45 0.99
89015819061873 approved
46631 dDormntAcct dormant 192164 7/30/2013 4:11 Waived CHENYA 7/30/2013 14:38 0.8898756581
891993 approved
46325 RepWiresOut Repetitive 18194157 7/9/2013 4:04 Waived CHENYA 7/9/2013 11:
51 0.7835973151553328
46138 RepWiresOut Repetitive 18194157 7/2/2013 4:05 Waived CHENYA 7/3/2013 13:
18 0.6837313091967321
46435 RepPreDebit Repetitive 35250982 7/16/2013 4:05 Waived CHENYA 7/22/2013 13
:58 0.6743222508879851
46444 RepWiresOut Repetitive 18186974 7/16/2013 4:05 Waived CHENYA 9/12/2013 15
:20 0.6378019421446783
46320 RepPreDebit Repetitive 35256508 7/9/2013 4:04 Waived CHENYA 7/9/2013 11:
37 0.6313451720186856
46129 RepiranIn2 Repetitive 244598 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:19 0.62
EFTA01413020
27708501188784
46131 Repiran0ut2 Repetitive 244598 7/2/2013 4:05 waived CHENYA 7/2/2013 12:19 0.62
06756595293204
46141 RepWiresOut Repetitive 41297621 7/2/2013 4:05 Waived CHENYA 7/3/2013 13:
28 0.5933373622382003
46123 RepPreDebit Repetitive 40820206 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
19 0.5621878764665407
46422 RepATMOut Repetitive 15496731 7/16/2013 4:05 Waived CHENYA 7/22/2013 12
:39 0.5492998298574525
46135 RepWiresln Repetitive 42948430 7/2/2013 4:05 Waived CHENYA 7/3/2013 12:
56 0.5110930502544262
46117 RepPersChks Repetitive 42911590 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
19 0.5008158663811013
46556 RepPersChks Repetitive 42946427 7/23/2013 4:12 Waived CHENYA 7/24/2013 12
:57 0.3980902490702294
46132 RepWiresln Repetitive 42940623 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
19 0.38229438270935123
46547 RepATMOut Repetitive 15496467 7/23/2013 4:12 Waived CHENYA 7/24/2013 12
:55 0.35861065400905745
46137 RepWiresln Repetitive 99955009 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
20 0.2927332672993037
46133 RepWiresln Repetitive 42940666 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
19 0.2838891643062347
46562 RepWiresOut Repetitive 18186974 7/23/2013 4:12 Waived CHENYA 7/24/2013 13
:15 0.19087331243389816
46118 RepPersChks Repetitive 42931882 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
19 0.15146684333800353
46149 RepWiresOut Repetitive 99955009 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
20 0.1144291837115341
46142 RepWiresOut Repetitive 42940623 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
19 0.09888290080131146
46112 RepATMOut Repetitive 15428624 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
19 0.09615674278521391
46114 RepATMOut Repetitive 35057322 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
19 0.06258690583043247
46121 RepPersChks Repetitive 42946427 7/2/2013 4:05 Waived CHENYA 7/3/2013 12:
42 0.028681446429990043
46116 RepATMOut Repetitive 35257535 7/2/2013 4:05 Waived CHENYA 7/2/2013 12:
19 0.00753040417637485
46729 RACS4 RACS4 4.0000464138E10 7/30/2013 4:12 Waived CHENYA 7/30/2013 16:37 0.7914216581
215803 approved
46740 dDormntAcct dormant 18190375 7/31/2013 4:14 Waived CHENYA 8/1/2013 14:10 0.91
67792573931983 approved
46295 VelDepWire Velocity 1.0000040853E10 7/9/2013 4:04 Waived CHENYA 7/9/2013 11:
17 0.9566071246664825
46645 VelDepWire Velocity 1.0000043346E10 7/30/2013 4:12 Waived CHENYA 7/30/2013 15
:45 0.9295607738501399
46095 VelWireChk Velocity 1.0000010957E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 11:
40 0.8558880739302125
46093 VelDepWire Velocity 1.0000454019E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 10:
47 0.7361984634310121
46535 VelWireWir Velocity 4.0000471347E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 12
:41 0.6884870288292122
46655 VelWireWir Velocity 1.0000474133E10 7/30/2013 4:12 Waived CHENYA 7/30/2013 16
:21 0.6871751791746785
46400 VelDepPerCk Velocity 1.000047161E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 11
:26 0.5654958032006452
46540 VelWireWir Velocity 1.0000439216E10 7/23/2013 4:12 Waived CHENYA 7/24/2013 12
:30 0.5418157844414386
46651 VelWireWir Velocity 1.0000288062E10 7/30/2013 4:12 Waived CHENYA 7/30/2013 16
:10 0.3626689448853817
46100 VelWireWir Velocity 1.0000416821E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 11:
48 0.3448857640037468
46643 VelDepPerCk Velocity 1.0000104485E10 7/30/2013 4:12 Waived CHENYA 7/30/2013 15
:13 0.2857154587449351
46105 VelWireWir Velocity 1.0000109065E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 12:
18 0.2688237964892739
46104 VelWireWir Velocity 1.0000480813E10 7/2/2013 4:05 Waived CHENYA 7/3/2013 12:
15 0.26839075141591584
46403 VelDepWire Velocity 1.0000023174E10 7/16/2013 4:05 Waived CHENYA 7/22/2013 12
:03 0.25497187342437466
46660 VelWireWir Velocity 1.0000436027E10 7/30/2013 4:12 Waived CHENYA 7/30/2013 16
:32 0.16151311898320841
For internal use only
EFTA01413021
Aug-yc
Number Rule Code Rule Group Customer ID Account Create Date Review State Revi
ew Oper Review Date Random 2nd review Row Labels Count of Rule Code
46754 HubMBenM hubspoke 8/1/2013 4:13 Waived CHENYA 8/5/2013 12:32 0.9591305098
645033 approved dormant 40 0.10 GETPIVOTDATA("Rule Code",$N$1,"Rule Group","dormant"
)*P2=4
46819 RACS4Neg racs4 4.0000440224E10 8/6/2013 4:13 waived CHENYA 9/3/2013 11:23 0.81
72118707956608 approved hubspoke 13 0.10 GETPIVOTDATA("Rule Code",$N$1,"Rule
Group","hubspoke")*P3=1.30
46935 dDormntAcct dormant 44121488 8/13/2013 4:11 waived CHENYA 9/3/2013 11:51 0.99
30139106505667 approved racs3 16 0.10 GETPIVOTDATA("Rule Code",$N$1,"Rule Group","
racs3°)*P4=1.60
46945 RACS4Neg racs4 4.0000472777E10 8/13/2013 4:11 waived CHENYA 9/3/2013 11:23 0.86
88112127559118 approved racs4 60 0.20 GETPIVOTDATA("Rule Code",$N$1,"Rule Group","
racs4")*PS=12
46810 dDormntAcct dormant 35263986 8/3/2013 4:05 Waived CHENYA 9/3/2013 11:51 0.92
80803527384487 repetitive 26 0.10 GETPIVOTDATA("Rule Code",$N$1,"Rule Group","repetiti
ve")*P6=2.60
47240 dDormntAcct dormant 42929854 8/29/2013 4:12 Waived CHENYA 9/23/2013 11:50 0.91
90103378041359 velocity 16 0.10 GETPIVOTDATA("Rule Code",$N$1,"Rule Group","velocity
")*P7=1.60
47247 dDormntAcct dormant 249914 8/30/2013 4:19 Waived CHENYA 9/4/2013 12:39 0.8967191334
538782 Grand Total 171
47021 dDormntAcct dormant 15501123 8/14/2013 4:23 Waived CHENYA 9/3/2013 11:51 0.89
11080693807201
47141 dDormntAcct dormant 44125884 8/24/2013 4:12 Waived CHENYA 8/27/2013 12:17 0.86
62831967895315
46924 dDormntAcct dormant 37990765 8/7/2013 4:16 Waived CHENYA 9/3/2013 11:51 0.85
670262448281
46927 dDormntAcct dormant 631038 8/8/2013 4:22 Waived CHENYA 9/3/2013 11:43 0.7985933708
945252
47133 dDormntAcct dormant 680203 8/21/2013 4:35 Waived CHENYA 8/27/2013 12:02 0.7542932202
470776
47023 dDormntAcct dormant 35249762 8/14/2013 4:23 Waived CHENYA 9/3/2013 11:51 0.74
8687264945537
47146 dDormntAcct dormant 653825 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:21 0.7364902519
641294
47140 dDormntAcct dormant 35247695 8/24/2013 4:12 Waived CHENYA 8/27/2013 12:15 0.69
06459190694716
47245 dDormntAcct dormant 246762 8/30/2013 4:19 Waived CHENYA 9/4/2013 12:38 0.6813512561
01487
46930 dDormntAcct dormant 15434098 8/10/2013 4:04 Waived CHENYA 9/3/2013 11:43 0.67
75633707659046
46812 dDormntAcct dormant 450698 8/3/2013 4:05 Waived CHENYA 9/3/2013 11:51 0.6768303286
701647
46923 dDormntAcct dormant 15432025 8/7/2013 4:16 Waived CHENYA 9/3/2013 11:51 0.67
17398972143371
47144 dDormntAcct dormant 35249025 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:19 0.64
65271323968858
46809 dDormntAcct dormant 35256647 8/3/2013 4:05 Waived CHENYA 9/3/2013 11:51 0.58
88233325975307
47246 dDormntAcct dormant 246788 8/30/2013 4:19 Waived CHENYA 9/4/2013 12:38 0.5306481921
578827
47249 dDormntAcct dormant 44110965 8/30/2013 4:19 Waived CHENYA 10/1/2013 12:59 0.48
87455949960853
47143 dDormntAcct dormant 35231220 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:18 0.43
05339975700049
46744 dDormntAcct dormant 370009 8/1/2013 4:13 Waived CHENYA 9/3/2013 11:43 0.4237420468
219977
47024 dDormntAcct dormant 341505 8/15/2013 4:12 Waived CHENYA 9/3/2013 11:43 0.4095259628
5610543
47032 dDormntAcct dormant 229346 8/20/2013 4:16 Waived CHENYA 9/23/2013 11:35 0.3920347482
311506
47142 dDormntAcct dormant 249798 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:17 0.3691686085
0752675
47241 dDormntAcct dormant 44126385 8/29/2013 4:12 Waived CHENYA 10/7/2013 10:18 0.32
30492169707595
46934 dDormntAcct dormant 15435082 8/13/2013 4:11 Waived CHENYA 9/3/2013 11:43 0.29
096816728891994
47025 dDormntAcct dormant 450829 8/15/2013 4:12 Waived CHENYA 9/3/2013 11:51 0.2423750884
412481
47134 dDormntAcct dormant 680208 8/21/2013 4:35 Waived CHENYA 8/27/2013 12:04 0.2235557098
47437
47244 dDormntAcct dormant 246700 8/30/2013 4:19 Waived CHENYA 9/4/2013 12:38 0.1860200199
8464957
47248 dDormntAcct dormant 341540 8/30/2013 4:19 Waived CHENYA 10/1/2013 12:59 0.1756309161
7258486
47131 dDormntAcct dormant 37990861 8/21/2013 4:35 Waived CHENYA 9/23/2013 11:46 0.17
18766565938179
EFTA01413022
46814 dDormntAcct dormant 330388 8/6/2013 4:13 Waived CHENYA 9/3/2013 11:43 0.1494146868
876527
47239 dDormntAcct dormant 35251651 8/29/2013 4:12 waived CHENYA 10/5/2013 15:30 0.14
016579939412166
47251 dDormntAcct dormant 247707 8/31/2013 4:06 Waived CHENYA 10/1/2013 12:59 0.1107966473
336659
46746 dDormntAcct dormant 653253 8/1/2013 4:13 Waived CHENYA 8/2/2013 15:16 0.0422174479
9003169
46928 dDormntAcct dormant 231965 8/9/2013 4:14 Waived CHENYA 9/3/2013 11:43 0.0031807533
236150043
46948 VelDepPerCk velocity 1.0000454019E10 8/13/2013 4:11 Waived CHENYA 8/14/2013 11
:12 0.782719518992951 approved
46798 HubMOrgLow hubspoke 8/1/2013 4:14 Waived CHENYA 8/2/2013 15:09 0.9452590946
2236
46747 HubMOrgM hubspoke 8/1/2013 4:13 Waived CHENYA 8/2/2013 15:07 0.8615747696
114404
46799 HubMOrgLow hubspoke 8/1/2013 4:14 Waived CHENYA 8/5/2013 14:39 0.8314507095
247239
46791 HubMBenLow hubspoke 8/1/2013 4:14 Waived CHENYA 8/5/2013 14:22 0.7713003083
280985
46772 HubMBenM hubspoke 8/1/2013 4:13 Waived CHENYA 8/5/2013 12:44 0.6714566092
017931
46796 HubMOrgLow hubspoke 8/1/2013 4:14 Waived CHENYA 8/5/2013 14:32 0.6439790863
289767
46789 HubMBenLow hubspoke 8/1/2013 4:14 Waived CHENYA 8/5/2013 13:06 0.4314017511
332713
46788 HubMBenLow hubspoke 8/1/2013 4:14 Waived CHENYA 8/5/2013 13:00 0.3838275084
5873126
46752 HubMBenM hubspoke 8/1/2013 4:13 Waived CHENYA 8/5/2013 14:28 0.2866529051
489226
46751 HubMBenM hubspoke 8/1/2013 4:13 Waived CHENYA 8/12/2013 15:30 0.1880370331
4897113
46767 HubMBenM hubspoke 8/1/2013 4:13 Waived CHENYA 8/5/2013 12:34 0.1168490549
4649978
46787 HubMBenLow hubspoke 8/1/2013 4:14 Waived CHENYA 8/2/2013 15:07 0.0554578940
28015486
47001 RACS4 racs4 4.0000020071E10 8/13/2013 4:11 Waived CHENYA 8/14/2013 13:27 0.8639271480
562274 approved
47019 RACS4 racs4 4.0000484898E10 8/13/2013 4:11 Waived CHENYA 8/14/2013 14:51 0.8739574224
252276 approved
47087 RACS3 racs3 4.0000023497E10 8/20/2013 4:16 Waived CHENYA 8/29/2013 17:43 0.8795920836
904363
46937 RACS3Neg racs3 99955009 8/13/2013 4:11 Waived CHENYA 9/3/2013 11:22 0.84
61687945310787
46986 RACS3 racs3 4.0000440906E10 8/13/2013 4:11 Waived CHENYA 8/14/2013 12:44 0.8129386543
787853
47197 RACS3 racs3 1.0000471608E10 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:40 0.8058820206
121307
46816 RACS3Neg racs3 99955009 8/6/2013 4:13 Waived CHENYA 9/3/2013 11:22 0.75
27810589843842
47035 RACS3Neg racs3 99955009 8/20/2013 4:16 Waived CHENYA 9/3/2013 11:22 0.69
77222679220354
46988 RACS3 racs3 4.0000453887E10 8/13/2013 4:11 Waived CHENYA 8/14/2013 13:04 0.6633356012
95578
47200 RACS3 racs3 4.0000424151E10 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:40 0.6595797991
12592
47201 RACS3 racs3 4.0000453887E10 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:40 0.6185939472
581863
46936 RACS3Neg racs3 4.0000453887E10 8/13/2013 4:11 Waived CHENYA 9/3/2013 11:22 0.59
85589161076152
47202 RACS3 racs3 99955009 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:40 0.4921218073
060656
47148 RACS3Neg racs3 99955009 8/27/2013 6:06 Waived CHENYA 9/3/2013 11:22 0.41
529928757821377
47034 RACS3Neg racs3 1.0000468997E10 8/20/2013 4:16 Waived CHENYA 9/3/2013 11:22 0.18
339187168191629
47147 RACS3Neg racs3 4.0000453887E10 8/27/2013 6:06 Waived CHENYA 9/3/2013 11:22 0.13
556050622994942
47033 RACS3Neg racs3 1.0000464145E10 8/20/2013 4:16 Waived CHENYA 9/3/2013 11:22 0.97
29085886547084 approved
47036 RACS4Neg racs4 4.0000015484E10 8/20/2013 4:16 Waived CHENYA 9/3/2013 11:23 0.95
02065510220401 approved
47040 RACS4Neg racs4 4.0000440224E10 8/20/2013 4:16 Waived CHENYA 9/3/2013 11:23 0.90
28285078167988 approved
47060 RepATMOut repetitive 35249375 8/20/2013 4:16 Waived CHENYA 8/29/2013 12
:00 0.8252878418905836 approved
47098 RACS4 racs4 4.0000002657E10 8/20/2013 4:16 Waived CHENYA 8/30/2013 10:20 0.8902697457
206024 approved
47100 RACS4 racs4 4.0000019367E10 8/20/2013 4:16 Waived CHENYA 8/30/2013 11:01 0.8130553269
EFTA01413023
206158 approved
47132 dDormntAcct dormant 680199 8/21/2013 4:35 Waived CHENYA 8/27/2013 12:04 0.9330839257
354304 approved
47149 RACS4Neg racs4 4.0000418346E10 8/27/2013 6:06 Waived CHENYA 9/3/2013 11:23 0.82
99956634896246 approved
47155 VelWireWir velocity 1.0000417807E10 8/27/2013 6:06 Waived CHENYA 8/29/2013 13
:13 0.9838321741839959 approved
47168 RepATMOut repetitive 15428624 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
:31 0.8793004924808514 approved
47195 RepWiresOut repetitive 99955009 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
:33 0.9211618036381837 approved
47199 RACS3 racs3 4.0000023497E10 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:40 0.9336972747
593606 approved
47014 RACS4 racs4 4.0000450589E10 8/13/2013 4:11 Waived CHENYA 8/14/2013 14:38 0.8093757220
09579
47231 RACS4 racs4 4.000047565E10 8/27/2013 6:06 Waived CHENYA 8/30/2013 12:54 0.8047977381
666671
46906 RACS4 racs4 4.000002336E10 8/6/2013 4:14 Waived CHENYA 8/7/2013 13:29 0.7969102667
830461
47015 RACS4 racs4 4.0000463189E10 8/13/2013 4:11 Waived CHENYA 8/14/2013 14:40 0.7878281370
527571
47128 RACS4 racs4 4.0000485068E10 8/20/2013 4:17 Waived CHENYA 8/30/2013 11:56 0.7655064820
300088
47215 RACS4 racs4 4.0000020181E10 8/27/2013 6:06 Waived CHENYA 8/30/2013 12:06 0.7510133555
317344
47041 RACS4Neg racs4 99955009 8/20/2013 4:16 Waived CHENYA 9/3/2013 11:23 0.74
85059676264703
46902 RACS4 racs4 4.0000021897E10 8/6/2013 4:14 Waived CHENYA 8/7/2013 12:57 0.7483756760
842324
47150 RACS4Neg racs4 4.0000440224E10 8/27/2013 6:06 Waived CHENYA 9/3/2013 11:23 0.73
31288037469985
47232 RACS4 racs4 4.0000475661E10 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:47 0.7117530535
267351
47038 RACS4Neg racs4 4.0000406538E10 8/20/2013 4:16 Waived CHENYA 9/3/2013 11:23 0.69
86922439633372
47233 RACS4 racs4 4.0000481495E10 8/27/2013 6:06 Waived CHENYA 8/30/2013 12:55 0.6467928314
664384
46889 RACS4 racs4 1.000047466E10 8/6/2013 4:14 Waived CHENYA 8/7/2013 11:17 0.6091784880
003017
46941 RACS4Neg racs4 4.0000408598E10 8/13/2013 4:11 Waived CHENYA 9/3/2013 11:23 0.57
76338041097584
47127 RACS4 racs4 4.0000476134E10 8/20/2013 4:17 Waived CHENYA 8/30/2013 11:54 0.5360307398
25047
47223 RACS4 racs4 4.0000408576E10 8/27/2013 6:06 Waived CHENYA 8/30/2013 12:09 0.5347315670
210788
46990 RACS4 racs4 1.0000111105E10 8/13/2013 4:11 Waived CHENYA 8/14/2013 13:12 0.5008652877
834825
47039 RACS4Neg racs4 4.0000408598E10 8/20/2013 4:16 Waived CHENYA 9/3/2013 11:23 0.49
926915834646124
46946 RACS4Neg racs4 99955009 8/13/2013 4:11 Waived CHENYA 9/3/2013 11:23 0.48
717688819689053
47151 RACS4Neg racs4 99955009 8/27/2013 6:06 Waived CHENYA 9/3/2013 11:23 0.46
112927564057316
47104 RACS4 racs4 4.0000021851E10 8/20/2013 4:16 Waived CHENYA 8/30/2013 11:22 0.4603904536
417196
46904 RACS4 racs4 4.0000022121E10 8/6/2013 4:14 Waived CHENYA 8/7/2013 13:21 0.4270855382
632348
46820 RACS4Neg racs4 99955009 8/6/2013 4:13 Waived CHENYA 9/3/2013 11:23 0.40
19665072165477
47126 RACS4 racs4 4.0000472241E10 8/20/2013 4:17 Waived CHENYA 8/30/2013 11:45 0.3910415416
395332
46916 RACS4 racs4 4.000042244E10 8/6/2013 4:14 Waived CHENYA 8/7/2013 13:34 0.3491527445
3644773
47111 RACS4 racs4 4.0000408598E10 8/20/2013 4:16 Waived CHENYA 8/30/2013 11:30 0.3380966061
8506854
46943 RACS4Neg racs4 4.0000440224E10 8/13/2013 4:11 Waived CHENYA 9/3/2013 11:23 0.31
425209402048626
46942 RACS4Neg racs4 4.0000419469E10 8/13/2013 4:11 Waived CHENYA 9/3/2013 11:23 0.28
706180542635895
47224 RACS4 racs4 4.0000410568E10 8/27/2013 6:06 Waived CHENYA 8/30/2013 12:17 0.2643742812
4738993
46899 RACS4 racs4 4.0000019866E10 8/6/2013 4:14 Waived CHENYA 8/7/2013 11:25 0.2608505257
2640954
46900 RACS4 racs4 4.0000020181E10 8/6/2013 4:14 Waived CHENYA 8/7/2013 11:39 0.2578263291
038425
47217 RACS4 racs4 4.0000021022E10 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:46 0.2119416249
0302682
47007 RACS4 racs4 4.0000417477E10 8/13/2013 4:11 Waived CHENYA 8/14/2013 14:37 0.1633930321
8909684
EFTA01413024
47218 RACS4 racs4 4.0000021897E10 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:47 0.1595948745
000122
46940 RACS4Neg racs4 4.0000290402E10 8/13/2013 4:11 Waived CHENYA 9/3/2013 11:23 0.12
878396969167194
47037 RACS4Neg racs4 4.0000022068E10 8/20/2013 4:16 Waived CHENYA 9/3/2013 11:23 0.12
60619433089687
47235 RACS4 racs4 4.0000484898E10 8/27/2013 6:06 Waived CHENYA 8/30/2013 12:58 0.1241738818
4681899
46901 RACS4 racs4 4.0000021022E10 8/6/2013 4:14 Waived CHENYA 8/7/2013 11:52 0.1217750970
2207434
46938 RACS4Neg racs4 1.000045734E10 8/13/2013 4:11 Waived CHENYA 9/3/2013 11:23 0.10
777357161931911
46944 RACS4Neg racs4 4.0000443112E10 8/13/2013 4:11 Waived CHENYA 9/3/2013 11:23 0.10
445367233412761
47221 RACS4 racs4 4.0000023497E10 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:47 0.0857565621
4890381
46907 RACS4 racs4 4.0000023497E10 8/6/2013 4:14 Waived CHENYA 8/7/2013 13:31 0.0814758283
9508072
47101 RACS4 racs4 4.0000019866E10 8/20/2013 4:16 Waived CHENYA 8/30/2013 11:14 0.0328270640
6913238
46939 RACS4Neg racs4 4.0000020071E10 8/13/2013 4:11 Waived CHENYA 9/3/2013 11:23 0.02
447279442847705
47230 RACS4 racs4 4.0000471174E10 8/27/2013 6:06 Waived CHENYA 8/30/2013 12:25 0.0180255105
00408792
47016 RACS4 racs4 4.0000472241E10 8/13/2013 4:11 Waived CHENYA 8/14/2013 14:45 0.0173491090
31438825
47212 RACS4 racs4 4.0000002505E10 8/27/2013 6:06 Waived CHENYA 8/30/2013 12:01 0.0126017471
10161376
46912 RACS4 racs4 4.0000408598E10 8/6/2013 4:14 Waived CHENYA 8/7/2013 13:33 0.0066515894
73135822
47222 RACS4 racs4 4.0000406995E10 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:47 0.9394742815
047712 approved
47228 RACS4 racs4 4.0000463189E10 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:47 0.8187942916
823676 approved
47236 RACS4 racs4 99955009 8/27/2013 6:06 Waived CHENYA 8/27/2013 12:47 0.9219946455
483372 approved
47172 RepATMOut repetitive 35244937 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
:31 0.8077293461373669
47189 RepWiresln repetitive 99955009 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
:33 0.7894508851394904
47177 RepPersChks repetitive 42927306 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
:32 0.7551390420858013
47192 RepWiresOut repetitive 18194472 8/27/2013 6:06 Waived CHENYA 8/29/2013 16
:51 0.7319210151084301
46966 RepATMOut repetitive 35249375 8/13/2013 4:11 Waived CHENYA 8/14/2013 12
:13 0.7249545130382762
47185 RepTranIn2 repetitive 631065 8/27/2013 6:06 waived CHENYA 8/29/2013 15:35 0.72
07280635766722
47182 RepPreDebit repetitive 40820206 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
:32 0.70207134025169
46963 RepATMOut repetitive 15496096 8/13/2013 4:11 Waived CHENYA 8/14/2013 11
:47 0.6418249333292618
47174 RepPersChks repetitive 41297621 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
:31 0.6086034690233451
47193 RepWiresOut repetitive 259933 8/27/2013 6:06 waived CHENYA 8/29/2013 17:12 0.58
53363560212017
47176 RepPersChks repetitive 42927111 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
:32 0.5808970126963873
47058 RepATMOut repetitive 15496096 8/20/2013 4:16 Waived CHENYA 8/29/2013 11
:57 0.5158158475790069
46964 RepATMOut repetitive 15496731 8/13/2013 4:11 Waived CHENYA 8/14/2013 11
:57 0.46403247708923634
47190 RepWiresOut repetitive 18186974 8/27/2013 6:06 Waived CHENYA 8/29/2013 16
:27 0.45272984509761205
46970 RepPersChks repetitive 42811776 8/13/2013 4:11 Waived CHENYA 8/14/2013 12
:29 0.43798362064221696
47072 RepTran0ut2 repetitive 631065 8/20/2013 4:16 waived CHENYA 8/29/2013 13:11 0.41
13006294300159
47170 RepATMOut repetitive 35057322 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
:31 0.40300687729737206
46979 RepTranIn2 repetitive 631065 8/13/2013 4:11 waived CHENYA 8/14/2013 12:37 0.35
21431860029136
47071 RepPreDebit repetitive 42942274 8/20/2013 4:16 Waived CHENYA 8/29/2013 12
:36 0.30301810332194923
47179 RepPersChks repetitive 42934645 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
:32 0.21385365513235777
47183 RepPreDebit repetitive 42938945 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
:32 0.17134264003594613
47175 RepPersChks repetitive 42911590 8/27/2013 6:06 Waived CHENYA 8/27/2013 12
EFTA01413025
:32 0.07055223662614285
47191 RepWiresOut repetitive 18194157 8/27/2013 6:06 Waived CHENYA 8/30/2013 9:
12 0.040285984483419135
47250 dDormntAcct dormant 44111079 8/30/2013 4:19 Waived CHENYA 10/1/2013 12:47 0.94
7416308705173 approved
47253 dDormntAcct dormant 42902539 8/31/2013 4:06 Waived CHENYA 10/1/2013 12:59 0.94
73394405779347 approved
47159 VelWireWir velocity 1.0000417808E10 8/27/2013 6:06 Waived CHENYA 8/29/2013 14
:56 0.7705176372187066
46837 VelWireWir velocity 4.0000454814E10 8/6/2013 4:13 Waived CHENYA 8/7/2013 10:
59 0.6854588421742482
47156 VelWireWir velocity 4.0000410568E10 8/27/2013 6:06 Waived CHENYA 8/29/2013 13
:21 0.6722236317348989
47048 VelWireChk velocity 4.0000002657E10 8/20/2013 4:16 Waived CHENYA 8/29/2013 11
:04 0.6486387857533717
47161 VelWireWir velocity 1.0000417834E10 8/27/2013 6:06 Waived CHENYA 8/29/2013 14
:56 0.576603359973368
46833 VelWireWir velocity 1.0000480813E10 8/6/2013 4:13 Waived CHENYA 8/6/2013 17:
02 0.5289869305107864
47157 VelWireWir velocity 4.0000453089E10 8/27/2013 6:06 Waived CHENYA 8/29/2013 14
:00 0.3987498772107041
47158 VelWireWir velocity 1.0000417835E10 8/27/2013 6:06 Waived CHENYA 8/29/2013 14
:55 0.32859822620911316
46834 VelWireWir velocity 1.0000457304E10 8/6/2013 4:13 Waived CHENYA 8/7/2013 10:
36 0.3090323564351296
47165 VelWireWir velocity 4.0000406305E10 8/27/2013 6:06 Waived CHENYA 8/29/2013 15
:33 0.2799874948762566
47053 VelWireWir velocity 4.0000440622E10 8/20/2013 4:16 Waived CHENYA 8/29/2013 11
:23 0.2132274383296089
46824 VelDepWire velocity 1.0000422711E10 8/6/2013 4:13 Waived CHENYA 8/6/2013 16:
56 0.1933468904746789
46843 VelWireWir velocity 1.0000464394E10 8/6/2013 4:13 Waived CHENYA 8/7/2013 11:
04 0.11419585532954457
47056 VelWireWir velocity 1.000047466E10 8/20/2013 4:16 Waived CHENYA 8/29/2013 11
:46 0.1022182900709716
For internal use only
EFTA01413026
Sep-yc
Number Rule Code Rule Group Customer ID Account Create Date Review State Revi
ew Oper Review Date Random 2nd Review Row Labels Count of Rule Code % I
47280 RepATMOut repetitive 35257535 9/4/2013 4:56 Waived CHENYA 9/17/2013 14
:48 0.9838601483157394 approved dormant 60 0.10 GETPIVOTDATA("Rule Code",$O$
1,"Rule Group","dormant")*Q2=6
47309 RACS3 racs3 4.0000019559E10 9/4/2013 4:56 Waived CHENYA 9/4/2013 13:40 0.9578812836
282833 approved hubspoke 14 0.10 GETPIVOTDATA("Rule Code",$O$1,"Rule Group","
hubspoke")*Q3=1.40
47310 RACS3 racs3 4.0000023497E10 9/4/2013 4:56 Waived CHENYA 9/4/2013 13:40 0.9470263829
261496 approved racs3 35 0.10 GETPIVOTDATA("Rule Code",$O$1,"Rule Group","racs3")*
Q4=3.50
47325 RACS4 racs4 4.0000021897E10 9/4/2013 4:56 Waived CHENYA 9/23/2013 15:02 0.8780963550
68702 approved racs4 77 0.20 GETPIVOTDATA("Rule Code",$O$1,"Rule Group","racs4")*
Q5=15.40
47326 RACS4 racs4 4.0000023219E10 9/4/2013 4:56 Waived CHENYA 9/23/2013 15:36 0.7723085193
244572 approved repetitive 52 0.10 GETPIVOTDATA("Rule Code",$O$1,"Rule Group","
repetitive")*Q6=5.20
47329 RACS4 racs4 4.0000023497E10 9/4/2013 4:56 Waived CHENYA 9/23/2013 16:06 0.7550627175
89496 approved velocity 20 0.10 GETPIVOTDATA("Rule Code",$O$1,"Rule Group","
velocity")*Q7=2
47615 dDormntAcct dormant 15440527 9/18/2013 4:08 Waived CHENYA 10/1/2013 12:59 0.90
92273459717966 Grand Total 258
47395 dDormntAcct dormant 259018 9/6/2013 4:15 Waived CHENYA 10/1/2013 12:47 0.8946279947
057187
47502 dDormntAcct dormant 251470 9/13/2013 4:09 Waived CHENYA 9/17/2013 12:58 0.8927080268
463605
47647 dDormntAcct dormant 630091 9/21/2013 4:07 Waived CHENYA 9/24/2013 12:23 0.8918210205
698884
47515 dDormntAcct dormant 44110367 9/17/2013 8:06 Waived CHENYA 9/17/2013 13:05 0.86
96542629137325
47257 dDormntAcct dormant 450540 9/4/2013 4:56 Waived CHENYA 9/4/2013 12:44 0.8691261151
404133
47747 dDormntAcct dormant 42896474 9/26/2013 5:55 Waived CHENYA 10/1/2013 9:57 0.84
01825626809238
47745 dDormntAcct dormant 35062543 9/25/2013 6:34 Waived CHENYA 10/1/2013 12:59 0.81
21667118109652
47749 dDormntAcct dormant 84592153 9/26/2013 5:55 Waived CHENYA 10/1/2013 9:56 0.80
98146839183267
47504 dDormntAcct dormant 44111300 9/13/2013 4:09 Waived CHENYA 10/1/2013 12:59 0.79
9600841315182
47503 dDormntAcct dormant 259015 9/13/2013 4:09 Waived CHENYA 10/1/2013 12:59 0.7952046433
326077
47743 dDormntAcct dormant 190806 9/25/2013 6:34 Waived CHENYA 10/1/2013 10:07 0.7666433920
433173
47507 dDormntAcct dormant 248907 9/14/2013 4:24 Waived CHENYA 10/1/2013 12:59 0.7637039354
274551
47622 dDormntAcct dormant 42930417 9/19/2013 4:12 Waived CHENYA 10/1/2013 12:59 0.75
94612077769991
47629 dDormntAcct dormant 251806 9/20/2013 4:09 Waived CHENYA 10/1/2013 12:59 0.7507433374
723398
47757 dDormntAcct dormant 246857 9/28/2013 6:34 Waived CHENYA 10/1/2013 9:52 0.7433482377
777629
47634 dDormntAcct dormant 44107424 9/20/2013 4:09 Waived CHENYA 10/1/2013 12:59 0.73
8127842970866
47255 dDormntAcct dormant 251036 9/4/2013 4:56 Waived CHENYA 9/4/2013 12:43 0.7350447402
403617
47501 dDormntAcct dormant 15425626 9/13/2013 4:09 Waived CHENYA 9/17/2013 12:57 0.73
09161844275132
47752 dDormntAcct dormant 42927875 9/27/2013 5:54 Waived CHENYA 10/1/2013 12:59 0.70
66512204238005
47628 dDormntAcct dormant 246935 9/20/2013 4:09 Waived CHENYA 9/24/2013 12:10 0.7044982883
730029
47514 dDormntAcct dormant 18189382 9/17/2013 8:06 Waived CHENYA 9/26/2013 13:20 0.70
20945760677417
47256 dDormntAcct dormant 35242384 9/4/2013 4:56 Waived CHENYA 10/1/2013 12:59 0.68
817276311896
47621 dDormntAcct dormant 652510 9/18/2013 4:08 Waived CHENYA 9/24/2013 12:05 0.6573684433
065348
47624 dDormntAcct dormant 42945969 9/19/2013 4:12 Waived CHENYA 10/1/2013 12:59 0.64
59331677378146
47754 dDormntAcct dormant 44124312 9/27/2013 5:54 Waived CHENYA 10/1/2013 10:01 0.62
81479251326916
47633 dDormntAcct dormant 44105760 9/20/2013 4:09 Waived CHENYA 10/1/2013 12:59 0.59
33932479819308
47500
ℹ️ Document Details
SHA-256
bd6c71709a6435fe658c5e6465d70cfa78fa6dd9f762fa11efafd5561ec8645a
Bates Number
EFTA01413017
Dataset
DataSet-10
Document Type
document
Pages
37