Philadelphia Regional DOL Tracker
- Thread starter usnycus
- Start date
PainfulGC123
Registered Users (C)
Updated both Excel spreadsheet as well as Access database tracker with ApAp's info and added few more summary queries in the DB. Check them out.
Last edited by a moderator:
how about asking for opinion first?
good idea/effort from your part mvinays...
BUT it would have been best i think if you had asked the opinions of other people on this tread before doing this...unless you had asked or others had agreed, and i just missed it somehow.
you could also have posted both the spreadsheet and the access file: to give everyone a choice. i don't think it should be assumed that everyone on this tread either has access or know how to use access.
you may want to add to the access file a consolidated report that provide all the data in one single place as it used to be in the spreadsheet.
on top of it i can't find my case in any of your reports...it used to be in the spreadsheet.
just my thoughts....
mvinays said:
good idea/effort from your part mvinays...
BUT it would have been best i think if you had asked the opinions of other people on this tread before doing this...unless you had asked or others had agreed, and i just missed it somehow.
you could also have posted both the spreadsheet and the access file: to give everyone a choice. i don't think it should be assumed that everyone on this tread either has access or know how to use access.
you may want to add to the access file a consolidated report that provide all the data in one single place as it used to be in the spreadsheet.
on top of it i can't find my case in any of your reports...it used to be in the spreadsheet.
just my thoughts....
PainfulGC123
Registered Users (C)
foret1 said:
Sorry for not asking everyone's opinion.
Actually, I just updated both the Access and Excel and I uploaded both formats in my previous posting. That way people have the choice of downloading which ever format they want. I personally prefer Access since it can easily give us many statistical reports that we need. It also keeps data clean (E.g. Entry of illegitimate date values are not permitted). Also, we can export from Access to Excel easily.
I just queried your case and it exists in both of them.
Last edited by a moderator:
srkotturu said:
Bad news SRK, your LC becomes invalid and you will need to start all over again. But you should confirm with a lawyer, this is what I have been told.
Basic premise of this process is that you are being hired for the position that the Labor Certification is approved for, if your designation or work profile changes your labor certification approval becomes invalid.
If you look deeper, YES you are right, it means your career cannot grow while you are in this process. And as we all know that means a good 4 to 5 years if we are lucky (or are we really???) - I mean can you call it lucky if you can't be promoted because of this stupid technicality?????
Whats more, technically since your GC is based on the labor certification, one could make an argument in a court of law anytime in your life that if you were to change a job OR were as much as promoted (OR demoted) your GC becomes invalid. But we all know these things dont happen - thats basically because INS doesn't keep tabs on you once you've got your GC.
Ok, so please note I am not a lawyer or expert, this is how I interpret it.
sameer2730
Registered Users (C)
Promotion Issues
What my lawyer told me is that as long as your job duties dont change promotions are okay. For example if you are Software Enginner 2 and you become Software Engineer 3 thats okay as long as the company can show that these two titles dont change job descriptions.
Even a complete Change in Titles like "Senior Software Engineer" to say "Software Architect" doesnt matter as long as the job descriptions of those two positions is close.
So maybe you could get an RFE where your company has to stand by you. Again you might want to consult a qualified attorney to be sure whats your particular case about.
Sameer
What my lawyer told me is that as long as your job duties dont change promotions are okay. For example if you are Software Enginner 2 and you become Software Engineer 3 thats okay as long as the company can show that these two titles dont change job descriptions.
Even a complete Change in Titles like "Senior Software Engineer" to say "Software Architect" doesnt matter as long as the job descriptions of those two positions is close.
So maybe you could get an RFE where your company has to stand by you. Again you might want to consult a qualified attorney to be sure whats your particular case about.
Sameer
PainfulGC123
Registered Users (C)
Updated VA_GC9's info.
Added gc4long...
Added gc4long...
Last edited by a moderator:
spidey said:
srkotturu is there any way you can get the promotion and yet get your HR not to change anything in your lc application?
my title and my job description have both changed several times. i have even changed departments...changes were due to layoff and department closings.... my hr is aware of my situation and has promised to leave things as they are with lc application. they will let the application go on as is without chaging anything or notifying the powers to be.
PainfulGC123
Registered Users (C)
gc4long said:
Thanks! The Excel spreadsheet is sorted by DOL Reciept Date (ascending). The Access DB gives us the freedom to sort the data anyway we want it. There is a stored VIEW (query) in the Access DB where I have sorted the data by Priority Date (SWA Receipt Date). Hope this helps!
PainfulGC123
Registered Users (C)
sunkav said:
Added sunkav to the tracker.
Also, added new queries and upgraded a few existing queries to include percentages in the summaries. Check it out.
Last edited by a moderator:
About 45 letter response
Thanks the shared information here. Does anyone know if it is ok to response the letter twice? My lawyer response by fax. What is the risk rate the fax is lost? my company receive a letter too, can we response it in the mail again?
thanks for answer.
PD 4/29/2003
11/28/2003 to Philly DOL
2/7/2005 receive 45 letter
Thanks the shared information here. Does anyone know if it is ok to response the letter twice? My lawyer response by fax. What is the risk rate the fax is lost? my company receive a letter too, can we response it in the mail again?
thanks for answer.
PD 4/29/2003
11/28/2003 to Philly DOL
2/7/2005 receive 45 letter
yours_sincerely
Registered Users (C)
Do not respond twice
The text of the letter specifically says that you should NOT respond twice. Usually, lawyers suggest that you fedex or post the package to DOL but I guess your lawyer didn't use common sense (no offense). I guess, you should ask your lawyer to call DOL to find out if they received it.
The text of the letter specifically says that you should NOT respond twice. Usually, lawyers suggest that you fedex or post the package to DOL but I guess your lawyer didn't use common sense (no offense). I guess, you should ask your lawyer to call DOL to find out if they received it.
angelene said:Thanks the shared information here. Does anyone know if it is ok to response the letter twice? My lawyer response by fax. What is the risk rate the fax is lost? my company receive a letter too, can we response it in the mail again?
thanks for answer.
PD 4/29/2003
11/28/2003 to Philly DOL
2/7/2005 receive 45 letter
Wrong info --> yours_sincerely
I disagree. The text of the letter does not state that you should not respond twice. Actually DOL has clarified that if the attorney reponds and after that Employer responds then the PD for the case will the date the Employer responds. Also DOL has given a fax number to fax it back, thus it is not neccessary to Fedex or post the package
yours_sincerely said:
I disagree. The text of the letter does not state that you should not respond twice. Actually DOL has clarified that if the attorney reponds and after that Employer responds then the PD for the case will the date the Employer responds. Also DOL has given a fax number to fax it back, thus it is not neccessary to Fedex or post the package