Dallas Backlog Elimination Center Tracking

gp111 said:
PD Cases
Dec-97 54
Jan-98 22
Feb-98 4
Mar-98 5
Apr-98 1
May-98 1
Jun-98 3
Jul-98 1
Aug-98 3
Sep-98 3
Oct-98 3
Nov-98 1
Dec-98 6
Jan-99 2
Feb-99 3
Mar-99 2
Apr-99 3
May-99 11
Jun-99 6
Jul-99 5
Aug-99 8
Sep-99 8
Oct-99 7
Nov-99 27
Dec-99 25
Jan-00 49
Feb-00 20
Mar-00 18
Apr-00 33
May-00 21
Jun-00 19
Jul-00 24
Aug-00 35
Sep-00 39
Oct-00 48
Nov-00 100
Dec-00 103
Jan-01 120
Feb-01 266
Mar-01 544
Apr-01 11982
May-01 966
Jun-01 1089
Jul-01 1213
Aug-01 1389
Sep-01 1052
Oct-01 1186
Nov-01 799
Dec-01 809
Jan-02 805
Feb-02 935
Mar-02 1352
Apr-02 1614
May-02 1942
Jun-02 1660
Jul-02 1905
Aug-02 1822
Sep-02 1836
Oct-02 1833
Nov-02 1856
Dec-02 2404
Jan-03 2202
Feb-03 2155
Mar-03 2216
Apr-03 2231

Is all this RIR cases made to regional? or SWA inclusive. I saw somewhere in this forum after Apr 2001 next RIR case would be "CA" May 2002. Now i see different numbers.
 
I remember reading that CA RIR cases with RD (not PD) of May 2003 and after were moved to BEC. all earlier cases are processed by SF DOL. Am I right?

shaaka said:
Is all this RIR cases made to regional? or SWA inclusive. I saw somewhere in this forum after Apr 2001 next RIR case would be "CA" May 2002. Now i see different numbers.
 
Last edited by a moderator:
shaaka said:
Is all this RIR cases made to regional? or SWA inclusive. I saw somewhere in this forum after Apr 2001 next RIR case would be "CA" May 2002. Now i see different numbers.

These are # of NON APPROVED RIR Cases in Regional Offices (SWA not Included).. I Don't understand your second Question.
 
gp111 said:
These are # of NON APPROVED RIR Cases in Regional Offices (SWA not Included).. I Don't understand your second Question.


Watch out this post from ZB earlier in this forum. Please read the colored one. How does he got 2000 RIR cases pending from 2000-2001.


Zany_Brainy said:
April 30 2001 was the last date for filing in the 245i clemency petition for illegal immigrants signed by President Clinton (as per what my memory serves me)

It is possible that many of these were RIR cases (though should be a small %)
As per the xl files of cases released by BEC there are around 2000 RIR cases pending from 2000-2001. If we consider the worst and say that all of them need to be processed before we move from 04/2001 on the RIR queue (believing ICARUS) then it should take 2000/90 ~ 23 days (4 1/2 weeks) to go past this point.

BUT

Once we pass this date, RIR queue should be directly jumping to the CA cases filed in May-June 2002 (PD) as these cases were the oldest in the DOL backlog queue (excluding 245i cases)


The problem is the 2 CO's (Certifying Officers) DOL needs to put more CO's there if they want things to move.

my tuppence..

Icarus, your comments will be appreciated...
 
shaaka said:
Watch out this post from ZB earlier in this forum. Please read the colored one. How does he got 2000 RIR cases pending from 2000-2001.

I don't know how he got 2000 RIR for 00-01.. Also California RIR are not the oldest in BEC. There are States like TX, MD, NJ etc has older cases in BEC then CA.

The numbers I got are from the Access Data base.. Also One other member (Sorry I forget the name...The real credit goes to him) has created this worksheet which shows the distribution of RIR & Non RIR cases.. I am attaching the same excel file again.
 
gp111 said:
I don't know how he got 2000 RIR for 00-01.. Also California RIR are not the oldest in BEC. There are States like TX, MD, NJ etc has older cases in BEC then CA.

The numbers I got are from the Access Data base.. Also One other member (Sorry I forget the name...The real credit goes to him) has created this worksheet which shows the distribution of RIR & Non RIR cases.. I am attaching the same excel file again.


May be you guys are right...So 30,000 RIR cases that made to regional are there before Jun 2002 which is my PD...

This will take forever even 200 analysts processes the case...

Approval in few months is a joke...May be i will get my labor approved in couple of years...


Anyway thanks for all your information. This is really a good information.
 
shaaka said:
May be you guys are right...So 30,000 RIR cases that made to regional are there before Jun 2002 which is my PD...

This will take forever even 200 analysts processes the case...

Approval in few months is a joke...May be i will get my labor approved in couple of years...


Anyway thanks for all your information. This is really a good information.

There may be some less cases at BEC then in this File, which are already approved by SF/NY/Boston DOL recently (since they updated this info)..& April-03 RD cases which SF is still processing...I would reduce number by about 5000
 
Last edited by a moderator:
What about Traditional or Non -RIR case?

Hi, all the posting on this forum only talks about RIR cases which have RD. But does any body know about the cases which are in Traditional or Non - RIR and which only have PD not in federal state. :)
 
This Is Wrong

gp111 said:
I don't know how he got 2000 RIR for 00-01.. Also California RIR are not the oldest in BEC. There are States like TX, MD, NJ etc has older cases in BEC then CA.

The numbers I got are from the Access Data base.. Also One other member (Sorry I forget the name...The real credit goes to him) has created this worksheet which shows the distribution of RIR & Non RIR cases.. I am attaching the same excel file again.
 
This Is Wrong

gp111 said:
I don't know how he got 2000 RIR for 00-01.. Also California RIR are not the oldest in BEC. There are States like TX, MD, NJ etc has older cases in BEC then CA.

The numbers I got are from the Access Data base.. Also One other member (Sorry I forget the name...The real credit goes to him) has created this worksheet which shows the distribution of RIR & Non RIR cases.. I am attaching the same excel file again.

Look at the query used

select convert(datetime,convert(varchar, datepart(mm, Rec_local_office))+'/01/'+convert(varchar, datepart(yyyy, Rec_local_office))) as PD,
count(1) as total
from Perm
where (Last_Sig_Event is null
or Last_Sig_Event in
('Received Regional Office',
'NOF Issued',
'Remand Issued to Employer',(REMANDED)
'NOF Rebuttal Received',
'Remand Issued to State', (SWA CASE)
'Reduction in Recruitment Denied', (NON-RIR)
'Returned By Emp after Remand',(SWA CASE)
'NOF Time Extension Granted',(NOT IN QUEUE)
'Returned By State after Remand'))
and Reduction_In_Recruit =1
group by convert(datetime,convert(varchar, datepart(mm, Rec_local_office))+'/01/'+convert(varchar, datepart(yyyy, Rec_local_office)))
order by 1

The Red items are the errors and the blue () are my comments.

Only the fact that the column Reduction_In_Recruit =1 does not make it an RIR case. That column was marked when the case was entered, but the last event is the latest status of the case and all the items in RED are not applicable to the RIR cases.

Thx
ZB
 
Last edited by a moderator:
Good catch!

That's a good catch, Zany_Brainy! You are really brainy :)

gp111, are cases marked red (e.g., Reduction in Recruitment Denied, Returned By Emp after Remand) also forwarded to BEC? If so, will these cases also be processed in the same order (PD)?

Btw, sorry I'm not in the loop here, but which "Access Database" are we talking about here, and how do I get it?

Thanks!

Zany_Brainy said:
Look at the query used

select convert(datetime,convert(varchar, datepart(mm, Rec_local_office))+'/01/'+convert(varchar, datepart(yyyy, Rec_local_office))) as PD,
count(1) as total
from Perm
where (Last_Sig_Event is null
or Last_Sig_Event in
('Received Regional Office',
'NOF Issued',
'Remand Issued to Employer',(REMANDED)
'NOF Rebuttal Received',
'Remand Issued to State', (SWA CASE)
'Reduction in Recruitment Denied', (NON-RIR)
'Returned By Emp after Remand',(SWA CASE)
'NOF Time Extension Granted',(NOT IN QUEUE)
'Returned By State after Remand'))
and Reduction_In_Recruit =1
group by convert(datetime,convert(varchar, datepart(mm, Rec_local_office))+'/01/'+convert(varchar, datepart(yyyy, Rec_local_office)))
order by 1

The Red items are the errors and the blue () are my comments.

Only the fact that the column Reduction_In_Recruit =1 does not make it an RIR case. That column was marked when the case was entered, but the last event is the latest status of the case and all the items in RED are not applicable to the RIR cases.

Thx
ZB
 
All these cases...

GotGC?? said:
That's a good catch, Zany_Brainy! You are really brainy :)

gp111, are cases marked red (e.g., Reduction in Recruitment Denied, Returned By Emp after Remand) also forwarded to BEC? If so, will these cases also be processed in the same order (PD)?

Btw, sorry I'm not in the loop here, but which "Access Database" are we talking about here, and how do I get it?

Thanks!


are now part of the SWA queue..

Thanks
ZB
 
My case was filed both from Chicago, IL. Not sure why there is such difference. Thanks for the info!

tracker_chicago said:
Which state was your case filed from. You might want to check with your attorney. My case has a PD 0f 11/2003 and went to regional on 03/2004.
Got my 45 day letter on mid feb, 05. Also Chicago Regional was working on
case with RD 12/03 when they started shipping the case to BEC.

Anyone in forum with RD 01/04 in Chicago received 45 day letter, please update.
 
I don't even have info about the case #. Was it assigned to you after it got transferred to BEC?

Thanks,

gth999 said:
yap! I can hear you. I am with you in the same boat.
I have a case # around 2 months back and no letter yet.
My case details:
filed in Chicago, IL
EB3
RIR
PD=09/03
RD=04/04
Case# D-050 007 12XXX
no love letter yet.
 
I converted the database to SQL server

Zany_Brainy said:
are now part of the SWA queue..

Thanks
ZB

So look forward to a lot of detailed analysis from me.

Starters...can you believe it has cases from as early as '3/14/1996' in the database.. (I have dumped all the access DBs into one big SQL server database)

More analysis coming soon...

:(
 
Cases are repeated..

Zany_Brainy said:
So look forward to a lot of detailed analysis from me.

Starters...can you believe it has cases from as early as '3/14/1996' in the database.. (I have dumped all the access DBs into one big SQL server database)

More analysis coming soon...

:(

If we assume that the Case_num column is unique, then the data says that maximum number of cases have been repeated more than once in this databases (now one database in my SQL server) Many case numbers have a count of 2 and 3 in the database..

Here is my guess...

Cases, have been repeated as the data is pulled by year and cases which have moved from one status to another have been repeated again in the database of the next Financial Year (FY)

Still looking...

(Seems to explain the absurd numbers gp111 gave today morning)
 
1903 cases

Zany_Brainy said:
If we assume that the Case_num column is unique, then the data says that maximum number of cases have been repeated more than once in this databases (now one database in my SQL server) Many case numbers have a count of 2 and 3 in the database..

Here is my guess...

Cases, have been repeated as the data is pulled by year and cases which have moved from one status to another have been repeated again in the database of the next Financial Year (FY)

Still looking...

(Seems to explain the absurd numbers gp111 gave today morning)

Found 38 cases amongst regional cases which were filed in March/April 1903 can you believe that....!!!! (All are TX regional cases)

Anyway, eliminating them

Thanks
 
Here is the actual analysis..

Zany_Brainy said:
Found 38 cases amongst regional cases which were filed in March/April 1903 can you believe that....!!!! (All are TX regional cases)

Anyway, eliminating them

Thanks

So!! What did the BEC say?
They said, there are ~ 55,000 cases in the Regional queue

Here is what I found
Total Number of RIR cases in QUEUE in the BEC
(as per the databases) = 69367]

Total Number of RIR Cases: 55146

Total Number of NON-RIR cases: 14221

RIR Case Break Down By Year:
1 -- 1900
33 -- 1903
1 -- 1997
11 -- 1998
164 -- 1999
229 -- 2000
9242 -- 2001
16209 -- 2002
23295 -- 2003
5961 -- 2004

NON-RIR Case Break Down by Year:

4 -- 1903
4 -- 1996
105 -- 1997
56 -- 1998
60 -- 1999
132 -- 2000
9426 -- 2001
1114 -- 2002
1745 -- 2003
1575 -- 2004



More analysis coming...

:cool:
 
Last edited by a moderator:
Zany_Brainy said:
So!! What did the BEC say?
They said, there are ~ 55,000 cases in the RIR queue

Here is what I found
Total Number of RIR cases in QUEUE in the BEC
(as per the databases) = 69367

Total Number of RIR Cases: 55146

Total Number of NON-RIR cases: 14221

RIR Case Break Down By Year:
1 -- 1900
33 -- 1903
1 -- 1997
11 -- 1998
164 -- 1999
229 -- 2000
9242 -- 2001
16209 -- 2002
23295 -- 2003
5961 -- 2004

NON-RIR Case Break Down by Year:

4 -- 1903
4 -- 1996
105 -- 1997
56 -- 1998
60 -- 1999
132 -- 2000
9426 -- 2001
1114 -- 2002
1745 -- 2003
1575 -- 2004



More analysis coming...

:cool:

RIR Case Breakdown by month:

Cases--Month--Year
1 -- 1 -- 1900
21 -- 3 -- 1903
5 -- 4 -- 1903
7 -- 5 -- 1903
1 -- 12 -- 1997
1 -- 1 -- 1998
1 -- 4 -- 1998
2 -- 6 -- 1998
1 -- 8 -- 1998
3 -- 9 -- 1998
2 -- 10 -- 1998
1 -- 12 -- 1998
3 -- 2 -- 1999
3 -- 3 -- 1999
2 -- 4 -- 1999
1 -- 5 -- 1999
5 -- 6 -- 1999
1 -- 7 -- 1999
8 -- 8 -- 1999
12 -- 9 -- 1999
25 -- 10 -- 1999
47 -- 11 -- 1999
57 -- 12 -- 1999
24 -- 1 -- 2000
17 -- 2 -- 2000
32 -- 3 -- 2000
12 -- 4 -- 2000
13 -- 5 -- 2000
13 -- 6 -- 2000
14 -- 7 -- 2000
42 -- 8 -- 2000
30 -- 9 -- 2000
14 -- 10 -- 2000
11 -- 11 -- 2000
7 -- 12 -- 2000
15 -- 1 -- 2001
36 -- 2 -- 2001
171 -- 3 -- 2001
6126 -- 4 -- 2001 (the queue is here now)
195 -- 5 -- 2001
288 -- 6 -- 2001
373 -- 7 -- 2001
451 -- 8 -- 2001
366 -- 9 -- 2001
474 -- 10 -- 2001
323 -- 11 -- 2001
424 -- 12 -- 2001
513 -- 1 -- 2002
666 -- 2 -- 2002
1096 -- 3 -- 2002
1401 -- 4 -- 2002
1700 -- 5 -- 2002
1423 -- 6 -- 2002
1642 -- 7 -- 2002
1526 -- 8 -- 2002
1593 -- 9 -- 2002
1465 -- 10 -- 2002
1403 -- 11 -- 2002
1781 -- 12 -- 2002
1941 -- 1 -- 2003
1926 -- 2 -- 2003
1948 -- 3 -- 2003
2122 -- 4 -- 2003
2184 -- 5 -- 2003
2014 -- 6 -- 2003
2151 -- 7 -- 2003
1950 -- 8 -- 2003
2129 -- 9 -- 2003
2007 -- 10 -- 2003
1304 -- 11 -- 2003
1619 -- 12 -- 2003
1250 -- 1 --2004
1061 -- 2 -- 2004
854 -- 3 -- 2004
603 -- 4 -- 2004
530 -- 5 -- 2004
518 -- 6 -- 2004
407 -- 7 -- 2004
684 -- 8 -- 2004
54 -- 9 --2004

Remember this is split between 2 BEC's

I am attching an XL file with BREAKDOWN OF RIR AND NON-RIR CASES by
year-month-state

So you guys can do all the permutations yourself, by using filters


Points to be considered before you guys get all depressed and all

* This data is from Early Sep 2004
* 8 months have passed and San Francisco DOL (as I know) has processed all the cases (except the remand back to state) upto April 2002 PD.
* Similarly other DOLs would have also processed cases
* What I think is the numbers after the huge bump at 4/2001 (6126 cases) are a little inflated till May 2002.
* If you look at the excel spreadsheet you will see that CA DOL has the majority of cases for each month

Overall I think, there are lesser number of cases pending in BEC after April 2001 than is indicated in the data. That would explain the discrepancy between the 55,000 number quoted by BECs against the 69367 that I find in the database.

:eek:

:cool:[
 
Last edited by a moderator:
Top