Project Kashmir:WAC-02 all I485 case status

Originally posted by niladri30
Data for Kashmir om WAC 02-119

WAC Status Date Status Group
...

Question: Although my AVM says that results of FP check were received on 12/11/2002, this scan shows only "Received". Is any follow up required by me?
Click to expand...
Hi, niladri30,
Thanks for your providing the data.

By the way,
can you edit your post to delete actual WAC numbers ?

For your question about fingerprint, I don't think so,
but I'm not a right person to answer it.
-kashmir
 
Re: WAC-02 status table as of 5/11/2003 CSV

Originally posted by kashmir
The format is the same as yesterday's one.
-kashmir
Click to expand...

Kashmir,
Are you planning to post the information(in the same format) periodically . I want to build as User friendly stats out of this. Please let me know

thanks
 
Re: Re: WAC-02 status table as of 5/11/2003 CSV

Originally posted by lareds
Kashmir,
Are you planning to post the information(in the same format) periodically . I want to build as User friendly stats out of this. Please let me know

thanks
Click to expand...
Hi, lareds,

> Are you planning to post the information(in the same format) periodically.

Yes, I will post the status table in CSV everyday or every two days.

> I want to build as User friendly stats out of this.

That would be great.
I'm looking forward to your user friendly tool.
-kashmir
 
WAC-02 approvals since 5/5/2003

It took 17 hours to scan 17,710 cases,
anyway, here is the CSC's activities of the last week.
-kashmir
Code: 
case number*  scanned    status        approval date              previous scanned status
-------------^----------^------------^------------------------^--------------------------
WAC02035$147$ 2003-05-12 approved      2003-05-12              <- 2003-05-07 RFE received
WAC02035$151$ 2003-05-12 approved      2003-05-12              <- 2003-05-07 RFE received
                                         subtotal 2

WAC02034$312$ 2003-05-12 approved      2003-05-09              <- 2002-12-07 RFE received
WAC02035$032$ 2003-05-11 approved      2003-05-09              <- 2003-02-28 transferred
WAC02038$028$ 2003-05-12 approved      2003-05-09              <- 2003-05-07 RFE received
WAC02038$029$ 2003-05-12 approved      2003-05-09              <- 2002-03-27 resumed
WAC02043$125$ 2003-05-13 approved      2003-05-09              <- 2002-11-19 RFE received
WAC02046$413$ 2003-05-13 approved      2003-05-09              <- 2002-11-05 RFE received
WAC02046$418$ 2003-05-13 approved      2003-05-09              <- 2002-04-06 resumed
WAC02183$049$ 2003-05-10 approved      2003-05-09
WAC02183$050$ 2003-05-10 approved      2003-05-09
WAC02183$051$ 2003-05-10 approved      2003-05-09
                                         subtotal 10

WAC02035$165$ 2003-05-11 approved      2003-05-08              <- 2002-11-16 RFE received
WAC02035$171$ 2003-05-11 approved      2003-05-08              <- 2002-04-03 resumed
WAC02035$247$ 2003-05-11 approved      2003-05-08              <- 2003-01-21 RFE received
WAC02035$250$ 2003-05-11 approved      2003-05-08              <- 2002-04-12 resumed
WAC02035$252$ 2003-05-11 approved      2003-05-08              <- 2001-11-09 received
WAC02038$023$ 2003-05-11 approved      2003-05-08              <- 2003-01-08 RFE received
WAC02040$194$ 2003-05-11 approved      2003-05-08              <- 2002-12-20 RFE received
WAC02041$252$ 2003-05-11 approved      2003-05-08              <- 2002-11-08 RFE received
WAC02043$201$ 2003-05-11 approved      2003-05-08              <- 2003-04-24 RFE received
WAC02044$412$ 2003-05-11 approved      2003-05-08              <- 2003-04-22 RFE received
WAC02044$420$ 2003-05-11 approved      2003-05-08              <- 2002-05-22 resumed
WAC02046$488$ 2003-05-11 approved      2003-05-08              <- 2003-02-26 RFE received
WAC02050$001$ 2003-05-08 completed    (2003-05-08..2003-05-06) <- 2002-12-13 RFE received
WAC02057$166$ 2003-05-10 approved      2003-05-08              <- 2003-04-15 RFE sent
WAC02057$170$ 2003-05-10 approved      2003-05-08              <- 2003-04-15 RFE sent
WAC02057$173$ 2003-05-10 approved      2003-05-08              <- 2003-04-15 RFE sent
WAC02057$176$ 2003-05-10 approved      2003-05-08              <- 2003-04-15 RFE sent
WAC02061$046$ 2003-05-10 approved      2003-05-08              <- 2002-04-18 FP received
WAC02061$048$ 2003-05-10 approved      2003-05-08              <- 2003-04-10 RFE sent
WAC02080$080$ 2003-05-10 approved      2003-05-08              <- 2002-12-10 RFE received
WAC02080$081$ 2003-05-10 approved      2003-05-08              <- 2002-07-30 resumed
WAC02080$083$ 2003-05-10 approved      2003-05-08              <- 2002-01-07 received
WAC02111$067$ 2003-05-11 approved      2003-05-08
WAC02156$113$ 2003-05-13 approved      2003-05-08              <- 2002-05-22 resumed
WAC02156$115$ 2003-05-13 approved      2003-05-08              <- 2002-05-22 resumed
WAC02156$119$ 2003-05-13 approved      2003-05-08              <- 2002-05-22 resumed
WAC02156$120$ 2003-05-13 approved      2003-05-08              <- 2002-05-22 resumed
                                         subtotal 27

WAC02275$128$ 2003-05-13 approved      2003-05-07              <- 2002-12-19 transferred
                                         subtotal 1

WAC02033$302$ 2003-05-08 approved      2003-05-06              <- 2002-11-12 RFE received
WAC02034$026$ 2003-05-08 approved      2003-05-06              <- 2002-03-27 resumed
WAC02040$116$ 2003-05-08 approved      2003-05-06              <- 2003-04-30 trans. back
WAC02040$238$ 2003-05-08 approved      2003-05-06              <- 2002-12-07 RFE received
WAC02040$239$ 2003-05-08 approved      2003-05-06              <- 2002-04-23 resumed
WAC02040$246$ 2003-05-08 approved      2003-05-06              <- 2001-11-15 received
WAC02040$258$ 2003-05-08 approved      2003-05-06              <- 2002-01-31 resumed
WAC02040$261$ 2003-05-08 approved      2003-05-06              <- 2003-02-05 RFE received
WAC02041$170$ 2003-05-08 approved      2003-05-06              <- 2002-11-26 RFE received
WAC02044$214$ 2003-05-08 approved      2003-05-06              <- 2003-05-05 trans. back
WAC02046$029$ 2003-05-08 approved      2003-05-06              <- 2003-04-30 trans. back
WAC02046$038$ 2003-05-08 approved      2003-05-06              <- 2003-04-30 trans. back
WAC02046$041$ 2003-05-08 card ordered (2003-05-06..2003-05-06) <- 2003-04-30 trans. back
WAC02046$045$ 2003-05-08 approved      2003-05-06              <- 2003-04-30 trans. back
WAC02046$471$ 2003-05-08 approved      2003-05-06              <- 2002-11-19 RFE received
WAC02047$176$ 2003-05-08 approved      2003-05-06              <- 2003-05-05 trans. back
WAC02049$116$ 2003-05-08 approved      2003-05-06              <- 2002-12-12 RFE received
WAC02049$121$ 2003-05-08 approved      2003-05-06              <- 2002-12-12 RFE received
WAC02050$196$ 2003-05-08 approved      2003-05-06              <- 2002-12-04 RFE received
WAC02050$200$ 2003-05-08 approved      2003-05-06              <- 2002-12-04 RFE received
WAC02121$010$ 2003-05-10 card ordered (2003-05-06..2003-05-06) <- 2003-03-07 FP sent
                                         subtotal 21

WAC02032$116$ 2003-05-06 approved      2003-05-05              <- 2002-12-02 RFE received
WAC02042$066$ 2003-05-06 approved      2003-05-05              <- 2003-04-30 trans. back
                                         subtotal 2
 
WAC-02 touched cases since 5/5/2003

Code: 
case number*  scanned    status        touched date    previous scanned status
-------------^----------^------------^----------------^-----------------------
WAC02042$179$ 2003-05-13 transferred   2003-05-12  <-  2002-03-27  FP sent
WAC02043$176$ 2003-05-13 RFE sent      2003-05-12  <-  2003-02-04  RFE received
WAC02104$032$ 2003-05-13 transferred   2003-05-12  <-  2002-02-05  unknown
                                         subtotal 3

WAC02003$001$ 2003-05-11 transferred   2003-05-09  <-  2002-01-31  resumed
WAC02032$195$ 2003-05-11 transferred   2003-05-09  <-  2002-12-07  RFE received
WAC02032$198$ 2003-05-11 transferred   2003-05-09  <-  2002-01-18  resumed
WAC02032$203$ 2003-05-11 transferred   2003-05-09  <-  2001-11-06  received
WAC02035$047$ 2003-05-11 RFE sent      2003-05-09  <-  2002-01-31  resumed
WAC02041$208$ 2003-05-11 transferred   2003-05-09  <-  2002-02-01  resumed
WAC02041$223$ 2003-05-11 transferred   2003-05-09  <-  2002-02-01  resumed
WAC02041$233$ 2003-05-11 transferred   2003-05-09  <-  2001-11-16  received
WAC02045$088$ 2003-05-11 transferred   2003-05-09  <-  2002-12-02  RFE sent
WAC02046$079$ 2003-05-11 transferred   2003-05-09  <-  2002-02-06  resumed
WAC02046$085$ 2003-05-11 transferred   2003-05-09  <-  2002-02-06  resumed
WAC02046$309$ 2003-05-11 transferred   2003-05-09  <-  2003-05-06  trans. back
WAC02047$189$ 2003-05-11 transferred   2003-05-09  <-  2002-02-27  resumed
WAC02047$194$ 2003-05-11 transferred   2003-05-09  <-  2002-02-02  resumed
WAC02049$243$ 2003-05-11 transferred   2003-05-09  <-  2002-02-06  resumed
WAC02050$114$ 2003-05-11 RFE sent      2003-05-09  <-  2001-11-26  received
WAC02050$126$ 2003-05-11 RFE sent      2003-05-09  <-  2002-01-31  resumed
WAC02053$026$ 2003-05-11 RFE sent      2003-05-09  <-  2002-02-06  resumed
WAC02053$028$ 2003-05-11 RFE sent      2003-05-09  <-  2002-02-02  resumed
WAC02053$030$ 2003-05-11 RFE sent      2003-05-09  <-  2002-02-02  resumed
WAC02068$008$ 2003-05-10 transferred   2003-05-09  <-  2002-01-15  FP sent
                                         subtotal 21

WAC02035$022$ 2003-05-11 transferred   2003-05-08  <-  2002-02-07  FP received
WAC02040$043$ 2003-05-11 RFE sent      2003-05-08  <-  2002-12-10  RFE received
WAC02040$274$ 2003-05-11 RFE sent      2003-05-08  <-  2002-02-06  resumed
WAC02041$179$ 2003-05-11 RFE sent      2003-05-08  <-  2002-01-31  resumed
WAC02041$200$ 2003-05-11 RFE sent      2003-05-08  <-  2002-01-31  resumed
WAC02041$362$ 2003-05-11 RFE sent      2003-05-08  <-  2002-01-31  resumed
WAC02043$168$ 2003-05-11 RFE sent      2003-05-08  <-  2001-11-18  received
WAC02046$080$ 2003-05-11 RFE sent      2003-05-08  <-  2002-12-10  RFE received
WAC02046$123$ 2003-05-11 RFE sent      2003-05-08  <-  2002-04-12  resumed
WAC02046$137$ 2003-05-11 RFE sent      2003-05-08  <-  2002-04-12  resumed
WAC02049$039$ 2003-05-11 RFE sent      2003-05-08  <-  2003-05-01  RFE received
WAC02125$027$ 2003-05-13 RFE sent      2003-05-08  <-  2002-10-18  resumed
WAC02125$031$ 2003-05-13 RFE sent      2003-05-08  <-  2002-06-14  resumed
WAC02125$033$ 2003-05-13 RFE sent      2003-05-08  <-  2002-03-03  received
WAC02125$035$ 2003-05-13 RFE sent      2003-05-08  <-  2002-03-03  received
WAC02125$038$ 2003-05-13 RFE sent      2003-05-08  <-  2002-03-03  received
WAC02180$042$ 2003-05-13 RFE sent      2003-05-08  <-  2002-06-11  resumed
WAC02192$022$ 2003-05-13 RFE sent      2003-05-08  <-  2002-07-17  resumed
                                         subtotal 18

WAC02001$158$ 2003-05-08 transferred   2003-05-07  <-  2002-08-24  resumed
WAC02047$061$ 2003-05-08 RFE sent      2003-05-07  <-  2003-04-24  RFE received
WAC02047$072$ 2003-05-08 RFE sent      2003-05-07  <-  2003-04-24  RFE received
WAC02047$079$ 2003-05-08 RFE sent      2003-05-07  <-  2003-04-24  RFE received
WAC02047$091$ 2003-05-08 RFE sent      2003-05-07  <-  2003-04-24  RFE received
WAC02068$110$ 2003-05-10 transferred   2003-05-07  <-  2003-05-05  RFE received
WAC02068$113$ 2003-05-10 transferred   2003-05-07  <-  2003-04-18  RFE sent
WAC02068$115$ 2003-05-10 transferred   2003-05-07  <-  2003-04-15  RFE sent
WAC02078$076$ 2003-05-10 transferred   2003-05-07  <-  2003-02-18  RFE sent
WAC02078$078$ 2003-05-10 transferred   2003-05-07  <-  2002-03-14  resumed
WAC02078$080$ 2003-05-10 transferred   2003-05-07  <-  2002-03-20  resumed
WAC02078$081$ 2003-05-10 transferred   2003-05-07  <-  2002-03-20  resumed
                                         subtotal 12

WAC02032$009$ 2003-05-08 transferred   2003-05-06  <-  2002-01-18  resumed
WAC02032$031$ 2003-05-08 transferred   2003-05-06  <-  2003-04-29  resumed
WAC02032$034$ 2003-05-08 transferred   2003-05-06  <-  2003-04-29  resumed
WAC02032$037$ 2003-05-08 transferred   2003-05-06  <-  2003-04-29  resumed
WAC02032$039$ 2003-05-08 transferred   2003-05-06  <-  2003-04-29  resumed
WAC02041$133$ 2003-05-08 RFE sent      2003-05-06  <-  2003-04-23  RFE received
WAC02044$423$ 2003-05-08 transferred   2003-05-06  <-  2002-02-01  resumed
WAC02049$191$ 2003-05-08 RFE sent      2003-05-06  <-  2002-02-01  resumed
WAC02279$159$ 2003-05-07 transferred   2003-05-06 
WAC02279$165$ 2003-05-07 transferred   2003-05-06 
WAC02279$167$ 2003-05-07 transferred   2003-05-06 
WAC02279$169$ 2003-05-07 transferred   2003-05-06 
                                         subtotal 12

WAC02034$239$ 2003-05-06 RFE sent      2003-05-05  <-  2003-01-06  RFE received
WAC02040$093$ 2003-05-06 RFE sent      2003-05-05  <-  2002-05-04  resumed
WAC02043$078$ 2003-05-06 RFE sent      2003-05-05  <-  2002-02-01  resumed
WAC02050$030$ 2003-05-06 RFE sent      2003-05-05  <-  2002-05-22  resumed
WAC02054$012$ 2003-05-06 transferred   2003-05-05  <-  2001-11-30  received
WAC02070$145$ 2003-05-06 transferred   2003-05-05  <-  2002-07-30  resumed
WAC02070$148$ 2003-05-06 transferred   2003-05-05  <-  2002-02-08  resumed
WAC02070$151$ 2003-05-06 transferred   2003-05-05  <-  2001-12-21  received
WAC02076$037$ 2003-05-06 transferred   2003-05-05  <-  2002-01-31  FP sent
WAC02076$040$ 2003-05-06 transferred   2003-05-05  <-  2002-01-31  FP sent
WAC02076$043$ 2003-05-06 transferred   2003-05-05  <-  2002-01-31  FP sent
WAC02086$073$ 2003-05-06 transferred   2003-05-05  <-  2002-03-08  resumed
WAC02086$074$ 2003-05-06 transferred   2003-05-05  <-  2002-03-08  resumed
WAC02086$076$ 2003-05-06 transferred   2003-05-05  <-  2002-03-08  resumed
WAC02100$182$ 2003-05-06 RFE sent      2003-05-05  <-  2002-01-31  received
                                         subtotal 15
 
WAC-02 status table as of 5/13/2003 part-1

Code: 
WAC02                                              
  scanned Aprv  Trns   RFE    FP  Rcvd  Othr  Total
---------^-----^-----^-----^-----^-----^-----^-----
001 10/01  231    25    11    16    16     4    303
    05/12  (76%)  (8%)  (4%)  (5%)  (5%)  (1%)
002 10/02   24    13     3     4     1     9     54
    05/12  (44%) (24%)  (6%)  (7%)  (2%) (17%)
003 10/03   17     3     3     6     -     3     32
    05/12  (53%)  (9%)  (9%) (19%)        (9%)
008 10/10    2     -     -     1     -     -      3
    05/12  (67%)             (33%)            
009 10/11   79     4     2    10     3     -     98
    05/12  (81%)  (4%)  (2%) (10%)  (3%)      
010 10/12   90     2     5     5     2     -    104
    05/12  (87%)  (2%)  (5%)  (5%)  (2%)      
014 10/17    2     -     -     1     -     -      3
    05/12  (67%)             (33%)            
015 10/18    -     -     -     -     2     -      2
    05/12                         (100%)      
019 10/22    -     2     -     1     -     -      3
    05/12        (67%)       (33%)            
020 10/23    6     -     -     -     -     -      6
    05/12 (100%)                              
---------^-----^-----^-----^-----^-----^-----^-----
subtotal   451    49    24    44    24    16    608
  10/2001  (74%)  (8%)  (4%)  (7%)  (4%)  (3%)
---------^-----^-----^-----^-----^-----^-----^-----
031 11/05   17    12     6     7     3     -     45
    05/12  (38%) (27%) (13%) (16%)  (7%)      
032 11/06   79    24    17    65    13     5    203
    05/12  (39%) (12%)  (8%) (32%)  (6%)  (2%)
033 11/07  197    20    43    72    24     4    360
    05/12  (55%)  (6%) (12%) (20%)  (7%)  (1%)
034 11/08  152    35    33    70    20     4    314
    05/12  (48%) (11%) (11%) (22%)  (6%)  (1%)
035 11/09  149    39    32    53    22     3    298
    05/12  (50%) (13%) (11%) (18%)  (7%)  (1%)
036 11/10   49    11    29    27    11     1    128
    05/12  (38%)  (9%) (23%) (21%)  (9%)  (1%)
037 11/11   76    13    18    30     7     7    151
    05/12  (50%)  (9%) (12%) (20%)  (5%)  (5%)
038 11/13   27     4     4    11     5     5     56
    05/12  (48%)  (7%)  (7%) (20%)  (9%)  (9%)
039 11/14   40     6     2    12     2     -     62
    05/12  (65%) (10%)  (3%) (19%)  (3%)      
040 11/15  148    20    31    65    23     5    292
    05/12  (51%)  (7%) (11%) (22%)  (8%)  (2%)
041 11/16  207    56    51   167    51     3    535
    05/12  (39%) (10%) (10%) (31%) (10%)  (1%)
042 11/17  156    22    23    73    24     9    307
    05/13  (51%)  (7%)  (7%) (24%)  (8%)  (3%)
043 11/18  114    19    15    72     9     5    234
    05/13  (49%)  (8%)  (6%) (31%)  (4%)  (2%)
044 11/19  287    53    47   172    34     7    600
    05/13  (48%)  (9%)  (8%) (29%)  (6%)  (1%)
045 11/20  217    28    49   119    41     4    458
    05/13  (47%)  (6%) (11%) (26%)  (9%)  (1%)
046 11/21  247    43    36   135    45     7    513
    05/13  (48%)  (8%)  (7%) (26%)  (9%)  (1%)
047 11/23  137    40    41    82    20     3    323
    05/13  (42%) (12%) (13%) (25%)  (6%)  (1%)
048 11/24   18     1     5     6     -     -     30
    05/13  (60%)  (3%) (17%) (20%)            
049 11/25  133    18    31   123    27     5    337
    05/13  (39%)  (5%)  (9%) (36%)  (8%)  (1%)
050 11/26  156    16    18    80    24     5    299
    05/13  (52%)  (5%)  (6%) (27%)  (8%)  (2%)
051 11/27   41    18    22    53    15     7    156
    05/13  (26%) (12%) (14%) (34%) (10%)  (4%)
052 11/28   10    11     2    18    10     1     52
    05/13  (19%) (21%)  (4%) (35%) (19%)  (2%)
053 11/29   30     2     5    23     2     -     62
    05/13  (48%)  (3%)  (8%) (37%)  (3%)      
054 11/30   25     9     9    54    13     3    113
    05/13  (22%)  (8%)  (8%) (48%) (12%)  (3%)
---------^-----^-----^-----^-----^-----^-----^-----
subtotal  2712   520   569  1589   445    93   5928
  11/2001  (46%)  (9%) (10%) (27%)  (8%)  (2%)
---------^-----^-----^-----^-----^-----^-----^-----
055 12/03    8     4     -    66     5     3     86
    05/13   (9%)  (5%)       (77%)  (6%)  (3%)
056 12/04   18     -     1   126    22     -    167
    05/13  (11%)        (1%) (75%) (13%)      
057 12/05   12     5     9   129    30     1    186
    05/13   (6%)  (3%)  (5%) (69%) (16%)  (1%)
058 12/06    5     -     -    36     4     2     47
    05/13  (11%)             (77%)  (9%)  (4%)
059 12/07    1     -     1    59     7     2     70
    05/13   (1%)        (1%) (84%) (10%)  (3%)
061 12/10    3     1     2    71     8     -     85
    05/13   (4%)  (1%)  (2%) (84%)  (9%)      
062 12/11    3     -     7   125    39     6    180
    05/13   (2%)        (4%) (69%) (22%)  (3%)
063 12/12    2    10     -    84    18     -    114
    05/13   (2%)  (9%)       (74%) (16%)      
064 12/13    1     1     2    40    14     -     58
    05/13   (2%)  (2%)  (3%) (69%) (24%)      
065 12/14    9     4     1    69    23     1    107
    05/13   (8%)  (4%)  (1%) (64%) (21%)  (1%)
066 12/17    2     1     4    83    13     1    104
    05/13   (2%)  (1%)  (4%) (80%) (13%)  (1%)
067 12/18    4     5     1    67    17     1     95
    05/13   (4%)  (5%)  (1%) (71%) (18%)  (1%)
068 12/19    6     6     2    83    27     2    126
    05/13   (5%)  (5%)  (2%) (66%) (21%)  (2%)
069 12/20    3     4     -    63    14     1     85
    05/13   (4%)  (5%)       (74%) (16%)  (1%)
070 12/21    9     8     4   106    24     1    152
    05/13   (6%)  (5%)  (3%) (70%) (16%)  (1%)
071 12/26    1     2     8    91    11     -    113
    05/13   (1%)  (2%)  (7%) (81%) (10%)      
072 12/27    3     4     1    85    33     -    126
    05/13   (2%)  (3%)  (1%) (67%) (26%)      
073 12/28    3     1     3    77    16     1    101
    05/13   (3%)  (1%)  (3%) (76%) (16%)  (1%)
074 12/29    -     2     2    93    26     -    123
    05/13         (2%)  (2%) (76%) (21%)      
075 12/30    1     6     -     7     -     -     14
    05/13   (7%) (43%)       (50%)            
---------^-----^-----^-----^-----^-----^-----^-----
subtotal    94    64    48  1560   351    22   2139
  12/2001   (4%)  (3%)  (2%) (73%) (16%)  (1%)
---------^-----^-----^-----^-----^-----^-----^-----
076 01/02    -     3     4    81    16     1    105
    05/13         (3%)  (4%) (77%) (15%)  (1%)
077 01/03    -     5     1    67    15     -     88
    05/13         (6%)  (1%) (76%) (17%)      
078 01/04    3     4     2    57    14     6     86
    05/13   (3%)  (5%)  (2%) (66%) (16%)  (7%)
079 01/05    1     1     -    35    16     3     56
    05/13   (2%)  (2%)       (63%) (29%)  (5%)
080 01/07   15     3     -    75    13     6    112
    05/13  (13%)  (3%)       (67%) (12%)  (5%)
081 01/08    5     -     3    53    16     1     78
    05/13   (6%)        (4%) (68%) (21%)  (1%)
082 01/09    4     2     1    51     5    11     74
    05/13   (5%)  (3%)  (1%) (69%)  (7%) (15%)
083 01/10    -     2     -    78    15     3     98
    05/13         (2%)       (80%) (15%)  (3%)
084 01/11    5     4     1    92    20     1    123
    05/13   (4%)  (3%)  (1%) (75%) (16%)  (1%)
085 01/12    -     -     -    17     1     -     18
    05/13                    (94%)  (6%)      
086 01/14    6     8     2    83    20     8    127
    05/13   (5%)  (6%)  (2%) (65%) (16%)  (6%)
087 01/15    2     1     6   141    32     1    183
    05/13   (1%)  (1%)  (3%) (77%) (17%)  (1%)
088 01/16    4     2     1   105    33     -    145
    05/13   (3%)  (1%)  (1%) (72%) (23%)      
089 01/17    2     2     9   151    43    12    219
    05/13   (1%)  (1%)  (4%) (69%) (20%)  (5%)
090 01/18    3     -     2    31     4     2     42
    05/13   (7%)        (5%) (74%) (10%)  (5%)
091 01/19    -     5     1    40    11     -     57
    05/13         (9%)  (2%) (70%) (19%)      
092 01/22    1     -     1    60    12     -     74
    05/13   (1%)        (1%) (81%) (16%)      
093 01/23   10     -     -    77    41     3    131
    05/13   (8%)             (59%) (31%)  (2%)
094 01/24    5     4     1   140    55     1    206
    05/13   (2%)  (2%)  (0%) (68%) (27%)  (0%)
095 01/25    3     -     -    69    29     2    103
    05/13   (3%)             (67%) (28%)  (2%)
097 01/28    -     -     1    86    62     1    150
    05/13               (1%) (57%) (41%)  (1%)
098 01/29    2     8     5   151    75     7    248
    05/13   (1%)  (3%)  (2%) (61%) (30%)  (3%)
099 01/30    4     1     3    79    45     8    140
    05/13   (3%)  (1%)  (2%) (56%) (32%)  (6%)
100 01/31    7     -     4   132    46     5    194
    05/13   (4%)        (2%) (68%) (24%)  (3%)
---------^-----^-----^-----^-----^-----^-----^-----
subtotal    82    55    48  1951   639    82   2857
  01/2002   (3%)  (2%)  (2%) (68%) (22%)  (3%)
 
WAC-02 status table as of 5/13/2003 part-2

Code: 
WAC02                                              
  scanned Aprv  Trns   RFE    FP  Rcvd  Othr  Total
---------^-----^-----^-----^-----^-----^-----^-----
101 02/01    9     7     4    57     5     9     91
    05/13  (10%)  (8%)  (4%) (63%)  (5%) (10%)
102 02/02    -     1     1    38    11     -     51
    05/13         (2%)  (2%) (75%) (22%)      
103 02/04    5     4     3   133    32     -    177
    05/13   (3%)  (2%)  (2%) (75%) (18%)      
104 02/05    6     6     1    95    12    13    133
    05/13   (5%)  (5%)  (1%) (71%)  (9%) (10%)
105 02/06    6     3     2   153    35    11    210
    05/13   (3%)  (1%)  (1%) (73%) (17%)  (5%)
106 02/07    8     -     3    94    20    16    141
    05/13   (6%)        (2%) (67%) (14%) (11%)
107 02/08    3     5     1   126    29     9    173
    05/13   (2%)  (3%)  (1%) (73%) (17%)  (5%)
109 02/11    -     2     1    39    11     7     60
    05/13         (3%)  (2%) (65%) (18%) (12%)
110 02/12    -     1     -    54    12     -     67
    05/13         (1%)       (81%) (18%)      
111 02/13    1     2     -    74    18     5    100
    05/13   (1%)  (2%)       (74%) (18%)  (5%)
117 02/22    -     7     -   141    34     5    187
    05/13         (4%)       (75%) (18%)  (3%)
118 02/23    -     -     4    51    21     -     76
    05/13               (5%) (67%) (28%)      
121 02/27   10     1     -   148    42     4    205
    05/13   (5%)  (0%)       (72%) (20%)  (2%)
122 02/28    7     2     -    94    34     -    137
    05/13   (5%)  (1%)       (69%) (25%)      
---------^-----^-----^-----^-----^-----^-----^-----
subtotal    55    41    20  1297   316    79   1808
  02/2002   (3%)  (2%)  (1%) (72%) (17%)  (4%)
---------^-----^-----^-----^-----^-----^-----^-----
123 03/01    -     4     -   128    25    11    168
    05/13         (2%)       (76%) (15%)  (7%)
124 03/02    -    10     2   173    73     1    259
    05/13         (4%)  (1%) (67%) (28%)  (0%)
125 03/03    -     2     5    88    28     -    123
    05/13         (2%)  (4%) (72%) (23%)      
126 03/04    2     -     6   119    24     -    151
    05/13   (1%)        (4%) (79%) (16%)      
131 03/09    3     -     -    47     6     -     56
    05/13   (5%)             (84%) (11%)      
135          1     2     1   119    49    16    188
    05/12   (1%)  (1%)  (1%) (63%) (26%)  (9%)
137 03/16    -     -     4    23     5     -     32
    05/13              (13%) (72%) (16%)      
143 03/23    -     -     -    29    18     3     50
    05/13                    (58%) (36%)  (6%)
---------^-----^-----^-----^-----^-----^-----^-----
subtotal     6    18    18   726   228    31   1027
  03/2002   (1%)  (2%)  (2%) (71%) (22%)  (3%)
---------^-----^-----^-----^-----^-----^-----^-----
150 04/02    3     6     6   130    28     5    178
    05/13   (2%)  (3%)  (3%) (73%) (16%)  (3%)
156 04/09    8     4    13   135    49     6    215
    05/13   (4%)  (2%)  (6%) (63%) (23%)  (3%)
165 04/19    2    13     -    81    13     4    113
    05/13   (2%) (12%)       (72%) (12%)  (4%)
---------^-----^-----^-----^-----^-----^-----^-----
subtotal    13    23    19   346    90    15    506
  04/2002   (3%)  (5%)  (4%) (68%) (18%)  (3%)
---------^-----^-----^-----^-----^-----^-----^-----
176 05/03    -     -     3    96    13     -    112
    05/13               (3%) (86%) (12%)      
180 05/08    7     7     2   135    21     3    175
    05/13   (4%)  (4%)  (1%) (77%) (12%)  (2%)
182 05/10    1     7     1   142    23     8    182
    05/13   (1%)  (4%)  (1%) (78%) (13%)  (4%)
183 05/13    3     -     -    66    11     5     85
    05/13   (4%)             (78%) (13%)  (6%)
184 05/14    4     -     -   156    21     9    190
    05/13   (2%)             (82%) (11%)  (5%)
192 05/23    -     2     3    68    13     1     87
    05/13         (2%)  (3%) (78%) (15%)  (1%)
---------^-----^-----^-----^-----^-----^-----^-----
subtotal    15    16     9   663   102    26    831
  05/2002   (2%)  (2%)  (1%) (80%) (12%)  (3%)
---------^-----^-----^-----^-----^-----^-----^-----
200 06/05   15     1     2    44    10     3     75
    05/13  (20%)  (1%)  (3%) (59%) (13%)  (4%)
205 06/11    -     3     1   186    40     8    238
    05/13         (1%)  (0%) (78%) (17%)  (3%)
218 06/26    3     -     1    56    15     -     75
    05/13   (4%)        (1%) (75%) (20%)      
---------^-----^-----^-----^-----^-----^-----^-----
subtotal    18     4     4   286    65    11    388
  06/2002   (5%)  (1%)  (1%) (74%) (17%)  (3%)
---------^-----^-----^-----^-----^-----^-----^-----
225 07/05    -     -     -    91    15     4    110
    05/13                    (83%) (14%)  (4%)
242 07/26    2     -     -    57     7     -     66
    05/13   (3%)             (86%) (11%)      
---------^-----^-----^-----^-----^-----^-----^-----
subtotal     2     -     -   148    22     4    176
  07/2002   (1%)             (84%) (13%)  (2%)
---------^-----^-----^-----^-----^-----^-----^-----
252 08/07    -     7     -    65    17     -     89
    05/13         (8%)       (73%) (19%)      
267 08/28    -     3     -    45     5     -     53
    05/13         (6%)       (85%)  (9%)      
---------^-----^-----^-----^-----^-----^-----^-----
subtotal     -    10     -   110    22     -    142
  08/2002         (7%)       (77%) (15%)      
---------^-----^-----^-----^-----^-----^-----^-----
271 09/04    -     2     2   169    34    21    228
    05/13         (1%)  (1%) (74%) (15%)  (9%)
273 09/06    5     2     -   187    41     4    239
    05/13   (2%)  (1%)       (78%) (17%)  (2%)
275 09/10    5     -     1   151    41    15    213
    05/13   (2%)        (0%) (71%) (19%)  (7%)
276 09/11    -     6     -    95     9     4    114
    05/13         (5%)       (83%)  (8%)  (4%)
279 09/16    -     4     3   130    28     9    174
    05/13         (2%)  (2%) (75%) (16%)  (5%)
284 09/23    -     -     -   164    33     9    206
    05/13                    (80%) (16%)  (4%)
285 09/24    -     3     -    93    19     4    119
    05/13         (3%)       (78%) (16%)  (3%)
289 09/30    -     -     1   163    24     7    195
    05/13               (1%) (84%) (12%)  (4%)
---------^-----^-----^-----^-----^-----^-----^-----
subtotal    10    17     7  1152   229    73   1488
  09/2002   (1%)  (1%)  (0%) (77%) (15%)  (5%)
---------^-----^-----^-----^-----^-----^-----^-----
total     3458   817   766  9872  2533   452  17898
          (19%)  (5%)  (4%) (55%) (14%)  (3%)
 
Anyone figure out a pattern?

I have a theory on the spikes we see in the graphs, although I haven't been able to develop the theory yet to include "touched" cases.

Theory:
Assumption: Since I485 approval is a "inspection of paperwork" for BCIS. I'm asssuming it's manual.

This is the scenario:
There are several officers working on several "batches" of cases at a time. Each batch has been picked up manually (perhaps like a 3 foot high stack!) and assigned to the officers. Each batch contains several days worth of I485 cases. Let us say the following is the distribution:
Officer 1: days 034 - 055
Officer 2: days 055 - 080
Officer 3: days 080 - 119
and so on...

Obviously, we will see spikes in approval for 034/035/036 and 055/056/057 and 080/081/082, while each officer works their way to the end of their stack

Can someone with a pattern recognizing brain (or software), therefore, predict probable dates for WAC 02-XXX, based on Kashmir's data?

At best this is inexact, and I'm not sure it is worth the effort, unless the effort is minimal.

I wish I could do it! How about it, S/W guys?
Apologies in advance if this is a stupid suggestion...I can do without the flames :)

Regards
 
Originally posted by niladri30
Anyone figure out a pattern?


Can someone with a pattern recognizing brain (or software), therefore, predict probable dates for WAC 02-XXX, based on Kashmir's data?
Click to expand...

Hi, S/W experts:

The statistics is a very valuable source. However, there is a gap that you should address somehow (I am not pretty sure that it is possible). You have found the gap. See the thread above.

I have come up with some statements that may or may not lead to a wrong conclusion.

1. I do not believe that the troubles have originated from lack of funding. Look at the other centers. They demonstrate better performance than CSC.
2. I do not believe that the troubles result from “bad guys” in the service. The System would have found a solution. Officers that are more active and who are probably trying to get a promotion would have found a way to pull out the bad ones.
3. I do not believe that the delays happened due to the reorganization. Let us assume that the system has not worked for 6 months of the reorganization. After six months, it starts working with the same speed. The overall delay would have been exactly six months for each case. The statistics says that the speed is not adequate.

Conclusion: The System considers the delays as necessary.

I have learned from your forum how painful the delay might be at this time. Companies disappear; people are laid off, losing their status and their application case. Now, it is simple to tell who an employer is. If the employer has not left the market or has not fired the applicant in these two tough years, the candidate will probably not be standing in line for Social Security benefits. The officers cannot make decisions on a personal basis. It is impossible for them to go through the case and to decide that this guy will be fine, but this might be not. They can check only the availability of necessary documents and the security background.

4. Why is CSC the worst guy? California is the mecca of high-tech. Cleaning the bay area now can help future employment prospects of American made gurus that have been laid off. It would then be accompanied by restrictions on H1’s revocation of I-140 etc to make citizens more marketable.
5. Your statistics say that there are a small percentage of cases through 2002 that keep moving even at this time. I do not believe that there are officers picking up cases out of the pile and going through them during their lunch time to estimate amount of expiring FPs (or to teach new officers). They are the System! My speculation is that they pick cases based on the employer, not the person.

The deficiency of your statistics is associated with this minute segment of fast cases. Who are their employers? Answering this question would help understanding the overall trend. A sophisticated Software will not help you. The spikes are deterministic.

Summary: Your statistics provide a good basis for a preliminary analysis. However, to understand what is going on, you should target these few fast cases to evaluate the trend.

Hopefully, the above is a pure speculation. Otherwise, the trends in the economy will be mirrored by trends in the immigration process and in our prospective very soon.
 
oldman, thats very interesting, but statistically, an equal number of cases have gotten approved from consulting companies (body shoppers), or oracle/microsoft. As a matter of fact, Sun/Motorola have had troubles getting labors approved.

Anyway, I am starting to believe more and more that this JIT and all this crap is farce, and this is really controlled behind the scenes based upon the employment market.
 
I looked all scaned data from the beginging here, my family cases 02-040-5xxx6, xxx8 were not included in the touched data base

However, Online case status of xxx6 was changed as RFE received on March 19, 2003 and FP (Re-do) received and resumed for xxx6 and xxx8 on May 13 2003.

May I know why not in your scaned database? thanks
 
don't get paranoid over delays

All your theories, my fellow 485-waiters, are paranoid (forgive me).
Accumulated statistics indicate, that everything what BCIS said about delays is close to the truth.
1. Huge pileup of cases in summer-fall of 2001 (look at the graph http://www.immigration.gov/graphics/aboutus/statistics/msrfeb03/BENEFIT.HTM). We see it in November 02 series, if we peek into 01-xxx statistics, you'll see how much is still there. This only pileup under normal speed creates about 9 month of extra waiting time (jun, jul, aug, sep, nov of 2001 may have almost tripled the workload).
2. Idling for 3+ month (dec 02 - feb 03) during re-structuring or whatever they wer doing.
3. Extra screening/checking. Again, statistics indicate that series per month approval rate may reach only half of the speed in good times - 30-50 cases vs. 60-100 -(spring-summer 2002).
So, what you expect?
Median approval term under normal conditions is, say, 9 month. (ND, Nov 01 -> AD, Jul 02).
Under current conditions, 9 + (9 + 3)*2 = 33 month!!!!!
(ND, Nov 01 -> AD, Aug 04). Here we are...
Calm down, this is just the worst case scenario :)
Cheer up! Or why y'all came to this blessed land...
 
Last edited by a moderator:
WAC-02 approvals this week

3,373 pending I485 cases of WAC-02-001 thru 054 were scanned this morning.
-kashmir
Code: 
case number*  scanned    status        approval date              previous scanned status
-------------^----------^------------^------------------------^--------------------------
WAC02035$035$ 2003-05-14 completed    (2003-05-14..2003-05-12) <- 2003-05-09 trans. back
WAC02041$250$ 2003-05-14 completed    (2003-05-14..2003-05-12) <- 2001-11-16 received
                                         subtotal 2

WAC02033$168$ 2003-05-14 card ordered (2003-05-13..2003-05-12) <- 2001-11-07 received
WAC02033$180$ 2003-05-14 card ordered (2003-05-13..2003-05-12) <- 2001-11-07 received
                                         subtotal 2

WAC02035$147$ 2003-05-12 approved      2003-05-12              <- 2003-05-07 RFE received
WAC02035$151$ 2003-05-12 approved      2003-05-12              <- 2003-05-07 RFE received
                                         subtotal 2
 
WAC-02 cases touched this week

Code: 
case number*  scanned    status        touched date    previous scanned status
-------------^----------^------------^----------------^-----------------------
WAC02033$132$ 2003-05-14 transferred   2003-05-13  <-  2001-11-07  received
WAC02033$143$ 2003-05-14 transferred   2003-05-13  <-  2002-01-18  resumed
WAC02033$155$ 2003-05-14 transferred   2003-05-13  <-  2002-01-18  resumed
WAC02033$259$ 2003-05-14 transferred   2003-05-13  <-  2002-01-19  resumed
WAC02035$104$ 2003-05-14 RFE sent      2003-05-13  <-  2002-01-23  resumed
WAC02036$102$ 2003-05-14 RFE sent      2003-05-13  <-  2002-02-01  resumed
WAC02036$106$ 2003-05-14 RFE sent      2003-05-13  <-  2002-02-01  resumed
WAC02040$072$ 2003-05-14 transferred   2003-05-13  <-  2002-02-06  resumed
WAC02040$085$ 2003-05-14 RFE sent      2003-05-13  <-  2001-11-15  received
WAC02040$091$ 2003-05-14 RFE sent      2003-05-13  <-  2002-02-06  resumed
WAC02040$098$ 2003-05-14 RFE sent      2003-05-13  <-  2002-02-06  resumed
WAC02040$101$ 2003-05-14 RFE sent      2003-05-13  <-  2002-02-06  resumed
                                         subtotal 12

WAC02042$179$ 2003-05-13 transferred   2003-05-12  <-  2002-03-27  FP sent
WAC02043$176$ 2003-05-13 RFE sent      2003-05-12  <-  2003-02-04  RFE received
WAC02044$555$ 2003-05-14 transferred   2003-05-12  <-  2003-04-08  RFE sent
WAC02045$193$ 2003-05-14 transferred   2003-05-12  <-  2003-04-24  RFE received
WAC02045$197$ 2003-05-14 transferred   2003-05-12  <-  2002-01-31  resumed
WAC02045$207$ 2003-05-14 transferred   2003-05-12  <-  2002-12-31  RFE received
WAC02045$214$ 2003-05-14 transferred   2003-05-12  <-  2002-12-31  RFE received
WAC02049$260$ 2003-05-14 transferred   2003-05-12  <-  2003-01-15  RFE received
WAC02049$264$ 2003-05-14 transferred   2003-05-12  <-  2002-02-12  resumed
WAC02104$032$ 2003-05-13 transferred   2003-05-12  <-  2002-02-05  unknown
                                         subtotal 10
 
Kashmir,
as of the latest csv table, I've noticed some approval count is going backwards. For example, 02-049 series, of 05/08/03, total 337, approved/completed 135 (2d column); of 05/14/03, total 337, card ordered+completed+approved (columns 2:4)=94+5+34 = 133. Why that?
 
Last edited by a moderator:
You must log in or register to reply here.
Top