The data available for the Permanent Labor Certification Program is for applications
that have been received and entered into the Department of Labor tracking system.
The data are available for download by fiscal year (October to September) in Microsoft
Access format. To speed up the download process the data are in ZIP files.however
the files are still very large, and can take up to 30 minutes or more to download using
a dial-up connection. A ZIP file utility is necessary to extract the files.
How to view Zip files.
|
Field Name |
Description |
|
Case_Type |
PERM = Permanent Labor Certification Program |
|
Case_Num |
Regional Office case number |
|
State_Case_Num |
State case number |
|
Rec_Local_Office
|
Date received by local office |
|
Rec_State_Office |
Date received by state office |
|
Rec_Regional_Office |
Date received by regional office |
|
Last_Sig_Event |
Description of last significant event |
|
Last_Event_Date |
Date of last significant event |
|
Region_ID |
1= Boston Regional Office
2= New York Regional Office
3= Philadelphia Regional Office
4= Atlanta Regional Office
5= Chicago Regional Office
6= Dallas Regional Office
7= Kansas City Regional Office
8= Denver Regional Office
9= San Francisco Regional Office
10= Seattle Regional Office |
|
Work_State |
Work state - location of the job opening |
|
Occ_Code |
Dictionary of Occupational Titles (DOT) occupation code |
|
Occ_Title |
Occupational title |
|
Salary |
Proposed Salary |
|
Unit_of_Pay |
Unit of pay for proposed salary
A=Annual, M=Monthly, W=Weekly, H=Hourly
|
|
Prevail_Wage |
Prevailing wage rate |
|
Unit_of_Pay_Prev |
Unit of pay for proposed prevailing wage
A=Annual, M=Monthly, W=Weekly, H=Hourly |
|
Reduction_In_Recruit |
Reduction in recruitment (RIR) status
0=false, -1=true |
|
Emp_Name |
Employer name |
|
Emp_City |
Employer city |
|
Emp_State |
Employer state |
|
Contact_Last |
Contact last name |
|
Contact_First |
Contact first name |
|
Attorney_Firm_Name |
Attorney firm name |
|
Att_Last |
Attorney last name |
|
Att_First |
Attorney first name |
|
Att_City |
Attorney city |
|
Att_State |
Attorney state |