RE: Can we believe on MD SESA processing dates
Hmmm ! interesting results from the previous link I posted. I down-doaded the zip file to my machine
And then loaded it into an Oracle DB
I am running all sorts of queries against it. The results are amazing and shocking. Hope I am not voilating any major laws here by slicing and dicing the labor data.
Sample is as follows (state=MD, date_rso>=Oct-2001, occ like '030%'):
case_status, date_r_so, case_title
*********, *********, *********
Certified,10/9/2001,Programmer Analyst
Certified,10/12/2001,Systems Analyst
Certified,4/10/2002,Software Engineer
Certified,4/10/2002,Software Engineer
Certified,4/10/2002,Software Engineer
Certified,8/22/2001,Programmer Analyst
Certified,8/20/2002,Programmer Analyst
Certified,12/18/2001,Software Engineer
Certified,2/4/2003,Systems Analyst
Certified,2/25/2003,Programmer Analyst
Certified,1/3/2002,Programmer Analyst
Received Regional Office,7/23/2003,Systems Analyst
Received Regional Office,5/22/2003,Computer Programmer
Received Regional Office,6/18/2003,Software Engineer
Received Regional Office,6/19/2003,Software Engineer
Received Regional Office,6/19/2003,Programmer, Engineering And Scientific
Received Regional Office,4/30/2002,Programmer Analyst
Received Regional Office,8/22/2001,Software Engineer
Received Regional Office,8/21/2001,Programmer Analyst
Received Regional Office,8/24/2001,Software Engineer
Received Regional Office,8/21/2001,Programmer Analyst
Received Regional Office,8/24/2001,Software Engineer
Received Regional Office,8/28/2001,Software Engineer
Received Regional Office,7/11/2002,Programmer Analyst
Received Regional Office,9/5/2001,Software Engineer
Received Regional Office,8/28/2001,Software Engineer
Received Regional Office,9/28/2001,Software Engineer
Received Regional Office,9/25/2001,Programmer Analyst
Received Regional Office,9/25/2001,Software Engineer
Received Regional Office,9/25/2001,Systems Analyst
Received Regional Office,10/9/2001,Software Engineer
Received Regional Office,10/9/2001,Programmer Analyst
Received Regional Office,10/4/2001,Systems Analyst
Received Regional Office,10/11/2001,Software Engineer
Received Regional Office,8/22/2001,Software Engineer
Received Regional Office,10/15/2001,Software Engineer
Received Regional Office,10/15/2001,Software Engineer
Received Regional Office,10/15/2001,Software Engineer
Received Regional Office,10/15/2001,Software Engineer
Received Regional Office,10/15/2001,Software Engineer
Received Regional Office,10/15/2001,Software Engineer
Received Regional Office,11/16/2001,Programmer Analyst
Received Regional Office,10/11/2001,Software Engineer
Received Regional Office,10/23/2001,Programmer Analyst
Received Regional Office,9/24/2001,Software Engineer
Received Regional Office,9/25/2001,Software Engineer
Received Regional Office,10/17/2001,Software Engineer
Received Regional Office,10/17/2001,Software Engineer
Received Regional Office,8/28/2001,Programmer Analyst
Received Regional Office,10/24/2001,Software Engineer
Received Regional Office,9/21/2001,Software Engineer
Received Regional Office,10/15/2001,Programmer Analyst
Received Regional Office,10/24/2001,Programmer Analyst
Received Regional Office,10/25/2001,Programmer Analyst
Received Regional Office,10/26/2001,Software Engineer
Received Regional Office,9/20/2001,Software Engineer
Received Regional Office,10/19/2001,Programmer Analyst
Received Regional Office,10/19/2001,Software Engineer
Received Regional Office,10/19/2001,Software Engineer
Received Regional Office,9/18/2001,Programmer Analyst
Received Regional Office,9/28/2001,Software Engineer
Received Regional Office,11/21/2003,Software Engineer