Project Kashmir:WAC-02 all I485 case status

[stain]

Kashmir,

I think it's more proper to consider cases "touched" when status changed from Resumed to RFE Sent. We can call it "touched for the first time"
Would be nice to track those cases and see whether BCIS is picking up brand new cases from the shelf and with which NDs.

Could you please give us a favor and sort your Global WAC list by the following fields:

1. Current Status
2. Prev. Status
3. Status Date (Descending)

Then just take out only the chunk that has "RFE Sent <- Resumed" and post the list here?

Thank you.

[kashmir]

Originally posted by stain
Kashmir,

I think it's more proper to consider cases "touched" when status changed from Resumed to RFE Sent. We can call it "touched for the first time"
Would be nice to track those cases and see whether BCIS is picking up brand new cases from the shelf and with which NDs.

Could you please give us a favor and sort your Global WAC list by the following fields:

1. Current Status
2. Prev. Status
3. Status Date (Descending)

Then just take out only the chunk that has "RFE Sent <- Resumed" and post the list here?

Thank you.

Hi, stain,
Thanks for your proposal,
however, my programs are written in Java,
and the tables are created by them and Unix utility commands such as sort and grep, etc.
because I don't have Excel,
so customizing the table is difficult right now.

Instead of that, I can provide CSV file (or TSV or XML)
so that you (or somebody) can create customized table by Excel easily.
How do you think ?
-kashmir

[kashmir]

grasshoper created the nice graph at:
http://boards.immigrationportal.com/...threadid=81656
so I post the data in CSV format.
-kashmir

[stain]

Kashmir,
Actually, I will need another data for each WAC u have.
Something like CSV with the following fields:

WAC, Date, Status, Prev Status

[kashmir]

Attached inlcudes 14,756 records.
status code means:

  // status type
  public static final int STATUS_CARDORDERED = 0;
  public static final int STATUS_COMPLETED   = 1;
  public static final int STATUS_APPROVED    = 2;
  public static final int STATUS_TRANSFERRED = 3;
  public static final int STATUS_RFERECEIVED = 4;
  public static final int STATUS_RFESENT     = 5;
  public static final int STATUS_RESUMED     = 6;
  public static final int STATUS_FPRECEIVED  = 7;
  public static final int STATUS_FPSENT      = 8;
  public static final int STATUS_RECEIVED    = 9;
  public static final int STATUS_DENIED      = 10;
  public static final int STATUS_WITHDRAWN   = 11;
  public static final int STATUS_REJECTED            = 12;
  public static final int STATUS_MAILEDDIRECTLY      = 13;
  public static final int STATUS_UNDELIVERABLE       = 14;
  public static final int STATUS_INSUFFICIENTPAYMENT = 15;
  public static final int STATUS_UNKNOWN             = 16;
  public static final int NUMBER_OF_STATUS_TYPES     = 17;

[kashmir]

5,488 pending I485 cases of WAC-02-001 thru 075 (Oct,Nov,Dec 2001) were scanned this morning.
-kashmir

case number*  scanned    status        approval date              previous scanned status
-------------^----------^------------^------------------------^--------------------------
WAC02034$028$ 2003-05-02 approved      2003-05-01              <- 2002-12-09 RFE received
WAC02034$029$ 2003-05-02 approved      2003-05-01              <- 2002-12-09 RFE received
WAC02043$041$ 2003-05-02 approved      2003-05-01              <- 2003-03-17 RFE received
WAC02043$047$ 2003-05-02 approved      2003-05-01              <- 2003-03-17 RFE received
WAC02043$051$ 2003-05-02 approved      2003-05-01              <- 2003-03-17 RFE received
WAC02044$283$ 2003-05-02 approved      2003-05-01              <- 2002-11-15 RFE sent
WAC02044$346$ 2003-05-02 approved      2003-05-01              <- 2002-12-11 RFE received
WAC02044$352$ 2003-05-02 approved      2003-05-01              <- 2002-12-11 RFE received
WAC02047$259$ 2003-05-02 approved      2003-05-01              <- 2003-04-18 RFE received
WAC02047$262$ 2003-05-02 approved      2003-05-01              <- 2002-01-31 resumed
WAC02047$268$ 2003-05-02 approved      2003-05-01              <- 2001-11-23 received
WAC02047$274$ 2003-05-02 approved      2003-05-01              <- 2001-11-23 received
WAC02050$043$ 2003-05-02 approved      2003-05-01              <- 2003-04-24 RFE received
WAC02057$138$ 2003-05-02 approved      2003-05-01              <- 2003-04-28 RFE received
WAC02057$141$ 2003-05-02 approved      2003-05-01              <- 2003-04-28 RFE received
WAC02057$152$ 2003-05-02 approved      2003-05-01              <- 2003-04-28 RFE received
                                         subtotal 16

[kashmir]

case number*  scanned    status        touched date    previous scanned status
-------------^----------^------------^----------------^-----------------------
WAC02032$062$ 2003-05-02 transferred   2003-05-01  <-  2001-11-06  received
WAC02032$067$ 2003-05-02 transferred   2003-05-01  <-  2002-04-23  resumed
WAC02037$025$ 2003-05-02 transferred   2003-05-01  <-  2002-01-26  resumed
WAC02037$032$ 2003-05-02 transferred   2003-05-01  <-  2002-01-31  resumed
WAC02037$038$ 2003-05-02 transferred   2003-05-01  <-  2002-01-31  resumed
WAC02062$020$ 2003-05-02 RFE sent      2003-05-01  <-  2002-12-31  received
WAC02063$013$ 2003-05-02 transferred   2003-05-01  <-  2002-02-02  resumed
WAC02063$015$ 2003-05-02 transferred   2003-05-01  <-  2003-02-18  RFE received
WAC02063$023$ 2003-05-02 transferred   2003-05-01  <-  2002-02-13  resumed
WAC02064$035$ 2003-05-02 RFE sent      2003-05-01  <-  2002-11-15  RFE received
WAC02072$041$ 2003-05-02 transferred   2003-05-01  <-  2002-03-14  resumed
                                         subtotal 11

[kashmir]

001,229,22,8,3,15,1,20,1,4,303
002,24,13,3,0,4,0,1,0,9,54
003,17,2,1,2,7,0,0,0,3,32
008,2,0,0,0,1,0,0,0,0,3
009,79,3,0,2,10,0,4,0,0,98
010,90,2,3,2,5,0,2,0,0,104
014,2,0,0,0,0,1,0,0,0,3
015,0,0,0,0,0,0,2,0,0,2
019,0,1,0,0,0,1,1,0,0,3
020,6,0,0,0,0,0,0,0,0,6
031,17,9,4,2,9,0,4,0,0,45
032,78,16,18,3,70,2,14,0,2,203
033,196,20,39,7,70,0,26,2,0,360
034,151,32,22,12,69,1,25,0,2,314
035,143,35,26,11,54,2,27,0,1,299
036,50,8,21,8,26,0,14,1,0,128
037,76,13,11,6,29,2,7,0,7,151
038,24,4,2,4,12,0,5,0,5,56
039,40,6,1,0,10,3,2,0,0,62
040,141,18,18,14,66,4,26,5,0,292
041,204,47,29,13,170,11,57,2,2,535
042,154,21,19,5,65,7,27,7,2,307
043,112,18,15,1,69,0,11,3,5,234
044,281,51,42,8,167,7,37,4,3,600
045,215,25,38,12,113,7,44,1,3,458
046,239,34,29,9,131,8,56,0,7,513
047,136,37,25,16,78,5,22,3,1,323
048,18,1,4,1,6,0,0,0,0,30
049,132,17,22,8,117,10,27,1,3,337
050,153,11,12,7,80,2,30,1,3,299
051,42,19,17,5,49,3,15,0,6,156
052,10,10,2,0,17,1,11,0,1,52
053,30,2,2,0,25,1,2,0,0,62
054,25,6,8,2,49,5,16,0,2,113
055,8,4,0,0,63,3,5,0,3,86
056,18,0,0,1,116,10,21,0,1,167
057,8,5,1,11,123,6,30,1,1,186
058,5,0,0,1,34,1,4,0,2,47
059,1,0,1,0,60,0,7,0,1,70
061,1,1,0,3,69,3,8,0,0,85
062,3,0,0,5,122,5,39,0,6,180
063,2,10,0,0,75,9,18,0,0,114
064,1,1,1,1,36,4,14,0,0,58
065,9,4,0,1,68,1,23,0,1,107
066,2,1,0,4,79,4,13,0,1,104
067,4,2,1,0,64,3,20,0,1,95
068,6,0,1,4,74,10,29,0,2,126
069,3,4,0,0,55,8,14,0,1,85
070,9,5,0,5,103,5,25,0,0,152
071,1,2,1,7,82,9,11,0,0,113
072,3,4,0,1,82,3,32,1,0,126
073,3,1,1,3,77,0,16,0,0,101
074,0,2,0,1,92,2,26,0,0,123
075,1,6,0,0,7,0,0,0,0,14
076,0,0,0,2,79,5,18,0,1,105
077,0,5,1,0,67,0,15,0,0,88
078,3,0,1,2,53,7,14,0,6,86
079,1,1,0,0,34,1,16,0,3,56
080,12,3,1,0,72,4,14,1,5,112
081,5,0,0,3,44,9,16,0,1,78
082,4,2,0,1,47,4,5,0,11,74
083,0,2,0,0,78,0,15,0,3,98
084,5,4,0,1,89,3,20,0,1,123
085,0,0,0,0,15,2,1,0,0,18
086,6,5,1,1,83,3,20,1,7,127
087,2,1,0,6,128,13,32,0,1,183
088,4,1,0,1,101,5,33,0,0,145
089,2,2,0,9,147,4,43,0,12,219
090,3,0,1,1,29,2,4,0,2,42
091,0,5,0,1,40,0,11,0,0,57
092,1,0,0,1,60,0,12,0,0,74
093,10,0,0,0,76,0,42,1,2,131
100,7,0,0,3,131,0,48,0,5,194
101,9,7,1,3,57,0,5,0,9,91
102,0,1,0,1,37,1,11,0,0,51
103,5,4,0,3,133,0,32,0,0,177
104,6,5,0,1,83,12,12,0,14,133
105,6,2,0,2,138,16,35,0,11,210
117,0,3,0,0,126,15,38,0,5,187
118,0,0,4,0,51,0,21,0,0,76
121,9,0,0,0,141,8,43,0,4,205
122,7,0,0,0,89,5,36,0,0,137
123,0,4,0,0,111,18,25,0,11,169
124,0,10,0,0,174,1,73,0,1,259
125,0,2,0,0,88,0,33,0,0,123
126,2,0,1,5,114,5,24,0,0,151
131,3,0,0,0,47,0,6,0,0,56
137,0,0,0,4,21,2,5,0,0,32
143,0,0,0,0,29,0,18,0,3,50
150,3,6,0,5,122,9,28,1,4,178
200,15,1,2,0,44,0,10,0,3,75
205,0,3,1,0,184,2,40,0,8,238
267,0,3,0,0,41,4,5,0,0,53
271,0,2,1,1,126,43,34,0,21,228
273,5,2,0,0,121,66,41,0,4,239
275,4,1,1,0,112,39,41,0,15,213
289,0,0,1,0,160,3,24,0,7,195

[hotwinca]

Me and my wife are in WAC 02 -114-xxx serials, could you please add that to your scan,(mine is in wac-02-114-537xx, my wife wac-02-114-538xx)

thanks

[kashmir]

Recently, WAC-02-140 thru 180 cases seem to be active,
but the coverage of my scanning these dates is ver low right now.
Even if using proxies, I can scan only one or two dates per day.
If you're interested in the actual numbers.
I encourage you to scan one of these dates and publish the result by yourself or just send me the result of scan.
I will incorporate your result into my database.

You can get my program from page 18 of this thread:
http://boards.immigrationportal.com/...&pagenumber=18

[kashmir]

You can download J2RE or J2SE at http://java.sun.com/

(example)
C:\kashmir> java -jar kashmir3.zip WAC0208150001 100

For this example, it scans from WAC208150001 through WAC0208150100 for 100 cases
and writes the result of scanned status to the file named WAC0208150001-200304230521.tsv (if it being started at 5:21am on 4/23/2003).

-kashmir

*
please check the following link:
http://www.immigrationportal.com/sho...838#post455838

[gclenahai]

hi kashmir,
I tried and faced the followings error messge:

C:\Kashmir>java -jar kashmir3.zip WAC0209550001 100
Exception in thread "main" java.lang.NullPointerExcep
at kashmir.Kashmir3.<init>(Kashmir3.java:19)
at kashmir.Kashmir3.main(Kashmir3.java:127)

Any Idea?

[kashmir]

Originally posted by gclenahai
hi kashmir,
I tried and faced the followings error messge:

C:\Kashmir>java -jar kashmir3.zip WAC0209550001 100
Exception in thread "main" java.lang.NullPointerExcep
at kashmir.Kashmir3.<init>(Kashmir3.java:19)
at kashmir.Kashmir3.main(Kashmir3.java:127)

Any Idea?

Hi, gclenahai,
You may need to set the proxy server as follows:

C:\Kashmir>java -Dhttps.proxyHost=HH.HH.HH.HH -Dhttps.proxyPort=PP -jar kashmir3.zip WAC0209550001 100

If you scan at the office that has firewall,
don't use that proxy server,
because BCIS Online limits the number of inquiries per IP address.

I recommend you to scan at your home computer.
-kashmir

[kashmir]

WAC-02-094 status as of 05/02/2003
Approved/Completed ...   5 ( 2%)
Transferred ..........   4 ( 2%)
RFE Received .........   1 ( 0%)
Resumed/FP Received .. 135 (66%)
FP Sent ..............   5 ( 2%)
Received .............  55 (27%)
Misc .................   1 ( 0%)
Total ................ 206

8,402 cases had to be scanned for WAC-02-094 and HTTPS proxy servers were not stable yesterday,
so this is only update this morning.
Have a nice weekend.
-kashmir

[h1Cycle]

Thanks Kashmir for scanning 094

[digdugxy]

Hi Kashmire,

Could you let me know what is the difference between 'FP received" and "Received"? Thanks.

[kashmir]

Originally posted by digdugxy
Hi Kashmire,

Could you let me know what is the difference between 'FP received" and "Received"? Thanks.

Hi, digdugxy,
Here is the method to get status from full description.
Basically, these strings should be compatible with off-patience's script.
-kashmir

  public static int getStatusType(String status) {
    if (status.indexOf("This case has been approved") >= 0) {
      return STATUS_APPROVED;
    }
    else if (status.indexOf("after approving your application") >= 0) {
      return STATUS_CARDORDERED;
    }
    else if (status.indexOf("mailed you a receipt") >= 0) {
      return STATUS_RECEIVED;
    }
    else if (status.indexOf("was received here for processing") >= 0) {
      return STATUS_RECEIVED;
    }
    else if (status.indexOf("written decision in this case was mailed") >= 0) {
      return STATUS_DENIED;
    }
    else if (status.indexOf("transferred your I485") >= 0) {
      return STATUS_TRANSFERRED;
    }
    else if (status.indexOf("processing has resumed") >= 0) {
      return STATUS_RESUMED;
    }
    else if (status.indexOf("has been completed") >= 0) {
      return STATUS_COMPLETED;
    }
    else if (status.indexOf("requesting additional evidence") >= 0) {
      return STATUS_RFESENT;
    }
    else if (status.indexOf("received your response to our request for evidence") >= 0) {
      return STATUS_RFERECEIVED;
    }
    else if (status.indexOf("was rejected as improperly filed and was mailed back for correction") >= 0) {
      return STATUS_REJECTED;
    }
    else if (status.indexOf("mailed a notice requesting that you appear for fingerprint") >= 0) {
      return STATUS_FPSENT;
    }
    else if (status.indexOf("were collected and are pending review") >= 0) {
      return STATUS_FPRECEIVED;
    }
    else if (status.indexOf("notice acknowledging withdrawal") >= 0) {
      return STATUS_WITHDRAWN;
    }
    else if (status.indexOf("mailed directly to the person to whom issued") >= 0) {
      return STATUS_MAILEDDIRECTLY;
    }
    else if (status.indexOf("was returned as undeliverable") >= 0) {
      return STATUS_UNDELIVERABLE;
    }
    else if (status.indexOf("insufficient payment") >= 0) {
      return STATUS_INSUFFICIENTPAYMENT;
    }
    else {
      return STATUS_UNKNOWN;
    }
  }

[digdugxy]

Cool. Thanks.

[off-patience]

Originally posted by kashmir

    else if (status.indexOf("mailed you a receipt") >= 0) {
      return STATUS_RECEIVED;
    }
    else if (status.indexOf("was received here for processing") >= 0) {
      return STATUS_RECEIVED;
    }

Kashmir,

I noticed that the second status ("was received here for processing") actually means that a case has been transferred from the local office back to the service center.
In my latest version of the script I just call it "Transferred Back"
This is the last stage before approval or maybe denial.
So far, I observed the following sequence for transferred cases:

Resumed -> Transferred -> Transferred Back -> Approved -> Completed -> Card Ordered

[kashmir]

Originally posted by off-patience
Kashmir,

I noticed that the second status ("was received here for processing") actually means that a case has been transferred from the local office back to the service center.
In my latest version of the script I just call it "Transferred Back"
This is the last stage before approval or maybe denial.
So far, I observed the following sequence for transferred cases:

Resumed -> Transferred -> Transferred Back -> Approved -> Completed -> Card Ordered

Hi, off-patience,
Thanks for your advice.
I will update my program,
and post data with this modification.
-kashmir

[kashmir]

I picked up 4 dates from April and May 2002, and scanned them,
because these dates have less number of cases than other dates.
-kashmir

WAC-02-156 status as of 05/03/2003
Approved/Completed ...   4 ( 2%) ... approved on 7/18/2002
Transferred ..........   4 ( 2%)
RFE Received .........   1 ( 0%)
RFE Sent .............  13 ( 6%)
Resumed/FP Received .. 137 (64%)
FP Sent ..............   2 ( 1%)
Received .............  49 (23%)
Denied/Withdrawn .....   1 ( 0%)
Misc .................   4 ( 2%)
Total ................ 215

WAC-02-165 status as of 05/03/2003
Approved/Completed ...   2 ( 2%)
Transferred ..........  13 (12%)
Resumed/FP Received ..  75 (66%)
FP Sent ..............   6 ( 5%)
Received .............  13 (12%)
Misc .................   4 ( 4%)
Total ................ 113

WAC-02-176 status as of 05/03/2003
RFE Sent .............   3 ( 3%)
Resumed/FP Received ..  94 (84%)
FP Sent ..............   2 ( 2%)
Received .............  13 (12%)
Total ................ 112

WAC-02-182 status as of 05/03/2003
Approved/Completed ...   1 ( 1%) ... approved on 4/25/2003
Transferred Back .....   1 ( 1%)
Transferred ..........   6 ( 3%)
RFE Sent .............   1 ( 1%)
Resumed/FP Received .. 142 (78%)
Received .............  23 (13%)
Misc .................   8 ( 4%)
Total ................ 182

[kashmir]

I also scanned March and April 2002 cases that I had already had.
The followings are found by today's scan.
-kashmir

case number*  scanned    status        touched date    previous scanned status
-------------^----------^------------^----------------^-----------------------
WAC02124$248$ 2003-05-03 RFE sent      2003-05-02  <-  2002-05-22  FP received
WAC02124$254$ 2003-05-03 RFE sent      2003-05-02  <-  2002-05-22  FP received
WAC02156$161$ 2003-05-03 FP sent       2003-05-02 
WAC02176$102$ 2003-05-03 RFE sent      2003-05-02 
WAC02176$104$ 2003-05-03 RFE sent      2003-05-02 
WAC02182$066$ 2003-05-03 RFE sent      2003-05-02 

WAC02150$146$ 2003-05-03 RFE sent      2003-05-01  <-  2002-05-17  FP sent
WAC02176$005$ 2003-05-03 RFE sent      2003-05-01 

WAC02156$125$ 2003-05-03 RFE sent      2003-04-29 
WAC02156$130$ 2003-05-03 RFE sent      2003-04-29 
WAC02156$061$ 2003-05-03 RFE sent      2003-04-24 
WAC02156$140$ 2003-05-03 RFE sent      2003-04-24 
WAC02156$185$ 2003-05-03 RFE sent      2003-04-22 
WAC02156$194$ 2003-05-03 RFE sent      2003-04-22 
WAC02156$201$ 2003-05-03 RFE sent      2003-04-22 
WAC02156$002$ 2003-05-03 RFE sent      2003-04-15 
WAC02156$014$ 2003-05-03 RFE sent      2003-04-10 
WAC02156$016$ 2003-05-03 RFE sent      2003-04-10 
WAC02156$020$ 2003-05-03 RFE sent      2003-04-10 
WAC02156$023$ 2003-05-03 RFE sent      2003-04-10 
WAC02156$080$ 2003-05-03 RFE sent      2003-04-10 
WAC02165$074$ 2003-05-03 transferred   2003-04-07 
WAC02165$076$ 2003-05-03 transferred   2003-04-07 
WAC02165$077$ 2003-05-03 transferred   2003-04-07 
WAC02165$079$ 2003-05-03 transferred   2003-04-07 

WAC02182$041$ 2003-05-03 transferred   2003-03-22 
WAC02182$045$ 2003-05-03 transferred   2003-03-22 
WAC02182$018$ 2003-05-03 transferred   2003-03-21 
WAC02182$023$ 2003-05-03 transferred   2003-03-21 
WAC02165$096$ 2003-05-03 FP sent       2003-03-12 

WAC02156$058$ 2003-05-03 transferred   2003-02-24 
WAC02156$067$ 2003-05-03 transferred   2003-02-24 
WAC02156$071$ 2003-05-03 transferred   2003-02-24 
WAC02156$073$ 2003-05-03 transferred   2003-02-24

[kashmir]

3rd column is "Transferred Back", newly inserted.
-kashmir

001,229,4,22,8,3,15,1,16,1,4,303
002,24,0,13,3,0,4,0,1,0,9,54
003,17,0,2,1,2,7,0,0,0,3,32
008,2,0,0,0,0,1,0,0,0,0,3
009,79,1,3,0,2,10,0,3,0,0,98
010,90,0,2,3,2,5,0,2,0,0,104
014,2,0,0,0,0,0,1,0,0,0,3
015,0,0,0,0,0,0,0,2,0,0,2
019,0,1,1,0,0,0,1,0,0,0,3
020,6,0,0,0,0,0,0,0,0,0,6
031,17,0,9,4,2,9,0,4,0,0,45
032,78,0,16,18,3,70,2,14,0,2,203
033,196,2,20,39,7,70,0,24,2,0,360
034,151,3,32,22,12,69,1,22,0,2,314
035,143,3,35,26,11,54,2,24,0,1,299
036,50,3,8,21,8,26,0,11,1,0,128
037,76,0,13,11,6,29,2,7,0,7,151
038,24,0,4,2,4,12,0,5,0,5,56
039,40,0,6,1,0,10,3,2,0,0,62
040,141,2,18,18,14,66,4,24,5,0,292
041,204,3,47,29,13,170,11,54,2,2,535
042,154,1,21,19,5,65,7,26,7,2,307
043,112,1,18,15,1,69,0,10,3,5,234
044,281,2,51,42,8,167,7,35,4,3,600
045,215,2,25,38,12,113,7,42,1,3,458
046,239,11,34,29,9,131,8,45,0,7,513
047,136,2,37,25,16,78,5,20,3,1,323
048,18,0,1,4,1,6,0,0,0,0,30
049,132,0,17,22,8,117,10,27,1,3,337
050,153,5,11,12,7,80,2,25,1,3,299
051,42,0,19,17,5,49,3,15,0,6,156
052,10,1,10,2,0,17,1,10,0,1,52
053,30,0,2,2,0,25,1,2,0,0,62
054,25,2,6,8,2,49,5,14,0,2,113
055,8,0,4,0,0,63,3,5,0,3,86
056,18,0,0,0,1,116,10,21,0,1,167
057,8,0,5,1,11,123,6,30,1,1,186
058,5,0,0,0,1,34,1,4,0,2,47
059,1,0,0,1,0,60,0,7,0,1,70
061,1,0,1,0,3,69,3,8,0,0,85
062,3,0,0,0,5,122,5,39,0,6,180
063,2,0,10,0,0,75,9,18,0,0,114
064,1,0,1,1,1,36,4,14,0,0,58
065,9,0,4,0,1,68,1,23,0,1,107
066,2,0,1,0,4,79,4,13,0,1,104
067,4,3,2,1,0,64,3,17,0,1,95
068,6,2,0,1,4,74,10,27,0,2,126
069,3,0,4,0,0,55,8,14,0,1,85
070,9,0,5,0,5,103,5,25,0,0,152
071,1,0,2,1,7,82,9,11,0,0,113
072,3,0,4,0,1,82,3,32,1,0,126
073,3,0,1,1,3,77,0,16,0,0,101
074,0,0,2,0,1,92,2,26,0,0,123
075,1,0,6,0,0,7,0,0,0,0,14
076,0,0,0,0,2,79,5,18,0,1,105
077,0,0,5,1,0,67,0,15,0,0,88
078,3,0,0,1,2,53,7,14,0,6,86
079,1,0,1,0,0,34,1,16,0,3,56
080,12,0,3,1,0,72,4,14,1,5,112
081,5,0,0,0,3,44,9,16,0,1,78
082,4,0,2,0,1,47,4,5,0,11,74
083,0,0,2,0,0,78,0,15,0,3,98
084,5,0,4,0,1,89,3,20,0,1,123
085,0,0,0,0,0,15,2,1,0,0,18
086,6,0,5,1,1,83,3,20,1,7,127
087,2,0,1,0,6,128,13,32,0,1,183
088,4,0,1,0,1,101,5,33,0,0,145
089,2,0,2,0,9,147,4,43,0,12,219
090,3,0,0,1,1,29,2,4,0,2,42
091,0,0,5,0,1,40,0,11,0,0,57
092,1,0,0,0,1,60,0,12,0,0,74
093,10,0,0,0,0,76,0,42,1,2,131
094,5,0,4,1,0,135,5,55,0,1,206
100,7,0,0,0,3,131,0,48,0,5,194
101,9,0,7,1,3,57,0,5,0,9,91
102,0,0,1,0,1,37,1,11,0,0,51
103,5,0,4,0,3,133,0,32,0,0,177
104,6,0,5,0,1,83,12,12,0,14,133
105,6,0,2,0,2,138,16,35,0,11,210
117,0,4,3,0,0,126,15,34,0,5,187
118,0,0,0,4,0,51,0,21,0,0,76
121,9,1,0,0,0,141,8,42,0,4,205
122,7,2,0,0,0,89,5,34,0,0,137
123,0,0,4,0,0,112,16,25,0,11,168
124,0,0,10,0,2,172,1,73,0,1,259
125,0,0,2,0,0,88,0,33,0,0,123
126,2,0,0,1,5,114,5,24,0,0,151
131,3,0,0,0,0,47,0,6,0,0,56
137,0,0,0,0,4,21,2,5,0,0,32
143,0,0,0,0,0,29,0,18,0,3,50
150,3,0,6,0,6,122,8,28,1,4,178
156,4,0,4,1,13,137,2,49,1,4,215
165,2,0,13,0,0,75,6,13,0,4,113
176,0,0,0,0,3,94,2,13,0,0,112
182,1,1,6,0,1,142,0,23,0,8,182
200,15,0,1,2,0,44,0,10,0,3,75
205,0,0,3,1,0,184,2,40,0,8,238
267,0,0,3,0,0,41,4,5,0,0,53
271,0,0,2,1,1,126,43,34,0,21,228
273,5,0,2,0,0,121,66,41,0,4,239
275,4,0,1,1,0,112,39,41,0,15,213
289,0,0,0,1,0,160,3,24,0,7,195

[logx]

Kashmir, please explain me why to read the WAC-02-xxx-xxxxx table above
Thanks in advance for your understanding

[kashmir]

WAC02    Aprv  Trns         RFE   RFE    FP    FP  Appl  Dend             
 scanned Cmpl  Back  Trns  Rcvd  Sent  Rcvd  Sent  Rcvd  Wtdr  Misc  Total
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
001       229     4    22     8     3    15     1    16     1     4    303
   05/02  (76%)  (1%)  (7%)  (3%)  (1%)  (5%)  (0%)  (5%)  (0%)  (1%)
002        24     -    13     3     -     4     -     1     -     9     54
   05/02  (44%)       (24%)  (6%)        (7%)        (2%)       (17%)
003        17     -     2     1     2     7     -     -     -     3     32
   05/02  (53%)        (6%)  (3%)  (6%) (22%)                    (9%)
008         2     -     -     -     -     1     -     -     -     -      3
   05/02  (67%)                         (33%)                        
009        79     1     3     -     2    10     -     3     -     -     98
   05/02  (81%)  (1%)  (3%)        (2%) (10%)        (3%)            
010        90     -     2     3     2     5     -     2     -     -    104
   05/02  (87%)        (2%)  (3%)  (2%)  (5%)        (2%)            
014         2     -     -     -     -     -     1     -     -     -      3
   05/02  (67%)                               (33%)                  
015         -     -     -     -     -     -     -     2     -     -      2
   05/02                                           (100%)            
019         -     1     1     -     -     -     1     -     -     -      3
   05/02        (33%) (33%)                   (33%)                  
020         6     -     -     -     -     -     -     -     -     -      6
   04/27 (100%)                                                      
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
subtotal  449     6    43    15     9    42     3    24     1    16    608
 10/2001  (74%)  (1%)  (7%)  (2%)  (1%)  (7%)  (0%)  (4%)  (0%)  (3%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
031        17     -     9     4     2     9     -     4     -     -     45
   05/02  (38%)       (20%)  (9%)  (4%) (20%)        (9%)            
032        78     -    16    18     3    70     2    14     -     2    203
   05/02  (38%)        (8%)  (9%)  (1%) (34%)  (1%)  (7%)        (1%)
033       196     2    20    39     7    70     -    24     2     -    360
   05/02  (54%)  (1%)  (6%) (11%)  (2%) (19%)        (7%)  (1%)      
034       151     3    32    22    12    69     1    22     -     2    314
   05/02  (48%)  (1%) (10%)  (7%)  (4%) (22%)  (0%)  (7%)        (1%)
035       143     3    35    26    11    54     2    24     -     1    299
   05/02  (48%)  (1%) (12%)  (9%)  (4%) (18%)  (1%)  (8%)        (0%)
036        50     3     8    21     8    26     -    11     1     -    128
   05/02  (39%)  (2%)  (6%) (16%)  (6%) (20%)        (9%)  (1%)      
037        76     -    13    11     6    29     2     7     -     7    151
   05/02  (50%)        (9%)  (7%)  (4%) (19%)  (1%)  (5%)        (5%)
038        24     -     4     2     4    12     -     5     -     5     56
   05/02  (43%)        (7%)  (4%)  (7%) (21%)        (9%)        (9%)
039        40     -     6     1     -    10     3     2     -     -     62
   05/02  (65%)       (10%)  (2%)       (16%)  (5%)  (3%)            
040       141     2    18    18    14    66     4    24     5     -    292
   05/02  (48%)  (1%)  (6%)  (6%)  (5%) (23%)  (1%)  (8%)  (2%)      
041       204     3    47    29    13   170    11    54     2     2    535
   05/02  (38%)  (1%)  (9%)  (5%)  (2%) (32%)  (2%) (10%)  (0%)  (0%)
042       154     1    21    19     5    65     7    26     7     2    307
   05/02  (50%)  (0%)  (7%)  (6%)  (2%) (21%)  (2%)  (8%)  (2%)  (1%)
043       112     1    18    15     1    69     -    10     3     5    234
   05/02  (48%)  (0%)  (8%)  (6%)  (0%) (29%)        (4%)  (1%)  (2%)
044       281     2    51    42     8   167     7    35     4     3    600
   05/02  (47%)  (0%)  (9%)  (7%)  (1%) (28%)  (1%)  (6%)  (1%)  (1%)
045       215     2    25    38    12   113     7    42     1     3    458
   05/02  (47%)  (0%)  (5%)  (8%)  (3%) (25%)  (2%)  (9%)  (0%)  (1%)
046       239    11    34    29     9   131     8    45     -     7    513
   05/02  (47%)  (2%)  (7%)  (6%)  (2%) (26%)  (2%)  (9%)        (1%)
047       136     2    37    25    16    78     5    20     3     1    323
   05/02  (42%)  (1%) (11%)  (8%)  (5%) (24%)  (2%)  (6%)  (1%)  (0%)
048        18     -     1     4     1     6     -     -     -     -     30
   05/02  (60%)        (3%) (13%)  (3%) (20%)                        
049       132     -    17    22     8   117    10    27     1     3    337
   05/02  (39%)        (5%)  (7%)  (2%) (35%)  (3%)  (8%)  (0%)  (1%)
050       153     5    11    12     7    80     2    25     1     3    299
   05/02  (51%)  (2%)  (4%)  (4%)  (2%) (27%)  (1%)  (8%)  (0%)  (1%)
051        42     -    19    17     5    49     3    15     -     6    156
   05/02  (27%)       (12%) (11%)  (3%) (31%)  (2%) (10%)        (4%)
052        10     1    10     2     -    17     1    10     -     1     52
   05/02  (19%)  (2%) (19%)  (4%)       (33%)  (2%) (19%)        (2%)
053        30     -     2     2     -    25     1     2     -     -     62
   05/02  (48%)        (3%)  (3%)       (40%)  (2%)  (3%)            
054        25     2     6     8     2    49     5    14     -     2    113
   05/02  (22%)  (2%)  (5%)  (7%)  (2%) (43%)  (4%) (12%)        (2%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
subtotal 2667    43   460   426   154  1551    81   462    30    55   5929
 11/2001  (45%)  (1%)  (8%)  (7%)  (3%) (26%)  (1%)  (8%)  (1%)  (1%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
055         8     -     4     -     -    63     3     5     -     3     86
   05/02   (9%)        (5%)             (73%)  (3%)  (6%)        (3%)
056        18     -     -     -     1   116    10    21     -     1    167
   05/02  (11%)                    (1%) (69%)  (6%) (13%)        (1%)
057         8     -     5     1    11   123     6    30     1     1    186
   05/02   (4%)        (3%)  (1%)  (6%) (66%)  (3%) (16%)  (1%)  (1%)
058         5     -     -     -     1    34     1     4     -     2     47
   05/02  (11%)                    (2%) (72%)  (2%)  (9%)        (4%)
059         1     -     -     1     -    60     -     7     -     1     70
   05/02   (1%)              (1%)       (86%)       (10%)        (1%)
061         1     -     1     -     3    69     3     8     -     -     85
   05/02   (1%)        (1%)        (4%) (81%)  (4%)  (9%)            
062         3     -     -     -     5   122     5    39     -     6    180
   05/02   (2%)                    (3%) (68%)  (3%) (22%)        (3%)
063         2     -    10     -     -    75     9    18     -     -    114
   05/02   (2%)        (9%)             (66%)  (8%) (16%)            
064         1     -     1     1     1    36     4    14     -     -     58
   05/02   (2%)        (2%)  (2%)  (2%) (62%)  (7%) (24%)            
065         9     -     4     -     1    68     1    23     -     1    107
   05/02   (8%)        (4%)        (1%) (64%)  (1%) (21%)        (1%)
066         2     -     1     -     4    79     4    13     -     1    104
   05/02   (2%)        (1%)        (4%) (76%)  (4%) (13%)        (1%)
067         4     3     2     1     -    64     3    17     -     1     95
   05/02   (4%)  (3%)  (2%)  (1%)       (67%)  (3%) (18%)        (1%)
068         6     2     -     1     4    74    10    27     -     2    126
   05/02   (5%)  (2%)        (1%)  (3%) (59%)  (8%) (21%)        (2%)
069         3     -     4     -     -    55     8    14     -     1     85
   05/02   (4%)        (5%)             (65%)  (9%) (16%)        (1%)
070         9     -     5     -     5   103     5    25     -     -    152
   05/02   (6%)        (3%)        (3%) (68%)  (3%) (16%)            
071         1     -     2     1     7    82     9    11     -     -    113
   05/02   (1%)        (2%)  (1%)  (6%) (73%)  (8%) (10%)            
072         3     -     4     -     1    82     3    32     1     -    126
   05/02   (2%)        (3%)        (1%) (65%)  (2%) (25%)  (1%)      
073         3     -     1     1     3    77     -    16     -     -    101
   05/02   (3%)        (1%)  (1%)  (3%) (76%)       (16%)            
074         -     -     2     -     1    92     2    26     -     -    123
   05/02               (2%)        (1%) (75%)  (2%) (21%)            
075         1     -     6     -     -     7     -     -     -     -     14
   05/02   (7%)       (43%)             (50%)                        
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
subtotal   88     5    52     7    48  1481    86   350     2    20   2139
 12/2001   (4%)  (0%)  (2%)  (0%)  (2%) (69%)  (4%) (16%)  (0%)  (1%)

[kashmir]

WAC02    Aprv  Trns         RFE   RFE    FP    FP  Appl  Dend             
 scanned Cmpl  Back  Trns  Rcvd  Sent  Rcvd  Sent  Rcvd  Wtdr  Misc  Total
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
076         -     -     -     -     2    79     5    18     -     1    105
   05/01                           (2%) (75%)  (5%) (17%)        (1%)
077         -     -     5     1     -    67     -    15     -     -     88
   05/01               (6%)  (1%)       (76%)       (17%)            
078         3     -     -     1     2    53     7    14     -     6     86
   05/01   (3%)              (1%)  (2%) (62%)  (8%) (16%)        (7%)
079         1     -     1     -     -    34     1    16     -     3     56
   05/01   (2%)        (2%)             (61%)  (2%) (29%)        (5%)
080        12     -     3     1     -    72     4    14     1     5    112
   05/01  (11%)        (3%)  (1%)       (64%)  (4%) (13%)  (1%)  (4%)
081         5     -     -     -     3    44     9    16     -     1     78
   05/01   (6%)                    (4%) (56%) (12%) (21%)        (1%)
082         4     -     2     -     1    47     4     5     -    11     74
   05/01   (5%)        (3%)        (1%) (64%)  (5%)  (7%)       (15%)
083         -     -     2     -     -    78     -    15     -     3     98
   05/01               (2%)             (80%)       (15%)        (3%)
084         5     -     4     -     1    89     3    20     -     1    123
   05/01   (4%)        (3%)        (1%) (72%)  (2%) (16%)        (1%)
085         -     -     -     -     -    15     2     1     -     -     18
   05/01                                (83%) (11%)  (6%)            
086         6     -     5     1     1    83     3    20     1     7    127
   05/01   (5%)        (4%)  (1%)  (1%) (65%)  (2%) (16%)  (1%)  (6%)
087         2     -     1     -     6   128    13    32     -     1    183
   05/01   (1%)        (1%)        (3%) (70%)  (7%) (17%)        (1%)
088         4     -     1     -     1   101     5    33     -     -    145
   05/01   (3%)        (1%)        (1%) (70%)  (3%) (23%)            
089         2     -     2     -     9   147     4    43     -    12    219
   05/01   (1%)        (1%)        (4%) (67%)  (2%) (20%)        (5%)
090         3     -     -     1     1    29     2     4     -     2     42
   05/01   (7%)              (2%)  (2%) (69%)  (5%) (10%)        (5%)
091         -     -     5     -     1    40     -    11     -     -     57
   05/01               (9%)        (2%) (70%)       (19%)            
092         1     -     -     -     1    60     -    12     -     -     74
   04/30   (1%)                    (1%) (81%)       (16%)            
093        10     -     -     -     -    76     -    42     1     2    131
   04/30   (8%)                         (58%)       (32%)  (1%)  (2%)
094         5     -     4     1     -   135     5    55     -     1    206
   05/02   (2%)        (2%)  (0%)       (66%)  (2%) (27%)        (0%)
100         7     -     -     -     3   131     -    48     -     5    194
   05/01   (4%)                    (2%) (68%)       (25%)        (3%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
subtotal   70     -    35     6    32  1508    67   434     3    61   2216
 01/2002   (3%)        (2%)  (0%)  (1%) (68%)  (3%) (20%)  (0%)  (3%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
101         9     -     7     1     3    57     -     5     -     9     91
   05/01  (10%)        (8%)  (1%)  (3%) (63%)        (5%)       (10%)
102         -     -     1     -     1    37     1    11     -     -     51
   05/01               (2%)        (2%) (73%)  (2%) (22%)            
103         5     -     4     -     3   133     -    32     -     -    177
   05/01   (3%)        (2%)        (2%) (75%)       (18%)            
104         6     -     5     -     1    83    12    12     -    14    133
   05/01   (5%)        (4%)        (1%) (62%)  (9%)  (9%)       (11%)
105         6     -     2     -     2   138    16    35     -    11    210
   05/01   (3%)        (1%)        (1%) (66%)  (8%) (17%)        (5%)
117         -     4     3     -     -   126    15    34     -     5    187
   05/01         (2%)  (2%)             (67%)  (8%) (18%)        (3%)
118         -     -     -     4     -    51     -    21     -     -     76
   05/01                     (5%)       (67%)       (28%)            
121         9     1     -     -     -   141     8    42     -     4    205
   05/01   (4%)  (0%)                   (69%)  (4%) (20%)        (2%)
122         7     2     -     -     -    89     5    34     -     -    137
   05/01   (5%)  (1%)                   (65%)  (4%) (25%)            
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
subtotal   42     7    22     5    10   855    57   226     -    43   1267
 02/2002   (3%)  (1%)  (2%)  (0%)  (1%) (67%)  (4%) (18%)        (3%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
123         -     -     4     -     -   112    16    25     -    11    168
   05/03               (2%)             (67%) (10%) (15%)        (7%)
124         -     -    10     -     2   172     1    73     -     1    259
   05/03               (4%)        (1%) (66%)  (0%) (28%)        (0%)
125         -     -     2     -     -    88     -    33     -     -    123
   05/03               (2%)             (72%)       (27%)            
126         2     -     -     1     5   114     5    24     -     -    151
   05/03   (1%)              (1%)  (3%) (75%)  (3%) (16%)            
131         3     -     -     -     -    47     -     6     -     -     56
   05/03   (5%)                         (84%)       (11%)            
137         -     -     -     -     4    21     2     5     -     -     32
   05/03                          (13%) (66%)  (6%) (16%)            
143         -     -     -     -     -    29     -    18     -     3     50
   05/03                                (58%)       (36%)        (6%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
subtotal    5     -    16     1    11   583    24   184     -    15    839
 03/2002   (1%)        (2%)  (0%)  (1%) (69%)  (3%) (22%)        (2%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
150         3     -     6     -     6   122     8    28     1     4    178
   05/03   (2%)        (3%)        (3%) (69%)  (4%) (16%)  (1%)  (2%)
156         4     -     4     1    13   137     2    49     1     4    215
   05/03   (2%)        (2%)  (0%)  (6%) (64%)  (1%) (23%)  (0%)  (2%)
165         2     -    13     -     -    75     6    13     -     4    113
   05/03   (2%)       (12%)             (66%)  (5%) (12%)        (4%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
subtotal    9     -    23     1    19   334    16    90     2    12    506
 04/2002   (2%)        (5%)  (0%)  (4%) (66%)  (3%) (18%)  (0%)  (2%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
176         -     -     -     -     3    94     2    13     -     -    112
   05/03                           (3%) (84%)  (2%) (12%)            
182         1     1     6     -     1   142     -    23     -     8    182
   05/03   (1%)  (1%)  (3%)        (1%) (78%)       (13%)        (4%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
subtotal    1     1     6     -     4   236     2    36     -     8    294
 05/2002   (0%)  (0%)  (2%)        (1%) (80%)  (1%) (12%)        (3%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
200        15     -     1     2     -    44     -    10     -     3     75
   05/01  (20%)        (1%)  (3%)       (59%)       (13%)        (4%)
205         -     -     3     1     -   184     2    40     -     8    238
   05/01               (1%)  (0%)       (77%)  (1%) (17%)        (3%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
subtotal   15     -     4     3     -   228     2    50     -    11    313
 06/2002   (5%)        (1%)  (1%)       (73%)  (1%) (16%)        (4%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
267         -     -     3     -     -    41     4     5     -     -     53
   05/01               (6%)             (77%)  (8%)  (9%)            
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
subtotal    -     -     3     -     -    41     4     5     -     -     53
 08/2002               (6%)             (77%)  (8%)  (9%)            
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
271         -     -     2     1     1   126    43    34     -    21    228
   05/01               (1%)  (0%)  (0%) (55%) (19%) (15%)        (9%)
273         5     -     2     -     -   121    66    41     -     4    239
   05/01   (2%)        (1%)             (51%) (28%) (17%)        (2%)
275         4     -     1     1     -   112    39    41     -    15    213
   05/01   (2%)        (0%)  (0%)       (53%) (18%) (19%)        (7%)
289         -     -     -     1     -   160     3    24     -     7    195
   05/01                     (1%)       (82%)  (2%) (12%)        (4%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
subtotal    9     -     5     3     1   519   151   140     -    47    875
 09/2002   (1%)        (1%)  (0%)  (0%) (59%) (17%) (16%)        (5%)
--------^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----^-----
total    3355    62   669   467   288  7378   493  2001    38   288  15039
          (22%)  (0%)  (4%)  (3%)  (2%) (49%)  (3%) (13%)  (0%)  (2%)

If the date of your interest is missing, please check http://www.immigrationportal.com/sho...836#post455836 at first.
-kashmir

[kashmir]

Originally posted by logx
Kashmir, please explain me why to read the WAC-02-xxx-xxxxx table above
Thanks in advance for your understanding

Hi, logx,
CSV table corresponds to the above plain text table,
but CSV table has only fields of numbers of each status group.
CSV table is convenient for spreadsheet such as Excel or StarOffice.
-kashmir

[niladri30]

Kashmir,

How about WAC-02-119...?
Tks.

[kashmir]

Originally posted by niladri30
Kashmir,

How about WAC-02-119...?
Tks.

Hi, niladri30,
Thanks for your inquiry, but
check the following link at first.
Regards,
-kashmir

http://www.immigrationportal.com/sho...836#post455836

[kashmir]

WAC-02-192 status as of 05/04/2003
Transferred ..........   2 ( 2%)
RFE Sent .............   2 ( 2%)
Resumed/FP Received ..  69 (79%)
Received .............  13 (15%)
Misc .................   1 ( 1%)
Total ................  87

WAC-02-218 status as of 05/04/2003
Approved/Completed ...   3 ( 4%)
RFE Received .........   1 ( 1%)
Resumed/FP Received ..  55 (73%)
FP Sent ..............   1 ( 1%)
Received .............  15 (20%)
Total ................  75

WAC-02-225 status as of 05/04/2003
Resumed/FP Received ..  90 (82%)
FP Sent ..............   1 ( 1%)
Received .............  15 (14%)
Misc .................   4 ( 4%)
Total ................ 110

WAC-02-242 status as of 05/04/2003
Approved/Completed ...   2 ( 3%) ... 1 case approved on 4/22/2003
Resumed/FP Received ..  55 (83%)
FP Sent ..............   2 ( 3%)
Received .............   7 (11%)
Total ................  66

WAC-02-252 status as of 05/04/2003
Transferred ..........   7 ( 8%)
Resumed/FP Received ..  65 (73%)
Received .............  17 (19%)
Total ................  89