DOL OFLC, PW Record Layout FY16.pdf

U.S. Department of Labor Employment and Training Administration Office of Foreign Labor Certification Public Disclosure File: Federal Fiscal Year: Reporting Period: Prevailing Wage Program 2016 October 1, 2015 through March 31, 2016 Important Note: This public disclosure file contains administrative data from employer applications for prevailing wage determinations (ETA Form 9141) processed by the Department’s Office of Foreign Labor Certification, Employment and Training Administration, where the date of either the initial prevailing wage determination or redetermination was issued on or after October 1, 2015, and on or before March 31, 2016. All data were extracted from the Office of Foreign Labor Certification’s iCERT Visa Portal System; an electronic filing and application processing system of employer requests for prevailing wage determinations.

FIELD NAME DESCRIPTION

Unique identifier generated by the iCERT Visa Portal System and assigned to each employer application for a prevailing wage determination (ETA Form 9141) submitted for processing. Case numbers appear in the following format: [Visa Program Designation]-[3-digit Visa ID]-[5-digit Julian Date]-[6-digit Random Number] Example: G-100-12345-123456 Visa program designations include the following values: G = PERM Application I = Labor Condition Application H = H-2A and H-2B Applications P = Prevailing Wage Applications 3-digit visa IDs (000) include the following values: 100 = Basic PERM Application 101 = PERM Application for Professional Athletes 200 = H-1B 201 = H-1B1 Chile 202 = H-1B1 Singapore 203 = E-3 Australian 300 = H-2A 400 = H-2B Date request for wage was submitted Identifies the date on which the OFLC National Prevailing Wage Center issued a prevailing wage determination on the employer application. Field is located on the ETA Form 9141, Section E, Item 8. Identifies the date on which the OFLC National Prevailing Wage Center issued a decision on the employer’s request for a redetermination of the originally issued prevailing wage determination.

Identifies the date on which the employer’s request for a withdrawal was processed. Status associated with the last significant event or decision. Valid values include “Determination Issued,” “Redetermination Review – Overturned- Modified,” “Redetermination - Affirmed”, and “Withdrawn” Type of visa classification supported by the employer request for a prevailing wage determination. Valid values include “H-2B,” “H-1B,” “H- 1B1 Chile,” “H-1B1 Singapore,” “E-3 Australian,” and “PERM”.

Field is CASE_NUMBER SUBMIT_DATE DETERMINATION_DATE REDETERMINATION_DATE WITHDRAWAL_DATE CASE_STATUS VISA_CLASS FIELD NAME DESCRIPTION BUSINESS_NAME TRADE__NAME EMPLOYER_ADDRESS_1 EMPLOYER_ADDRESS_2 EMPLOYER_CITY EMPLOYER_STATE EMPLOYER_POSTAL_CODE EMPLOYER_COUNTRY EMPLOYER_PROVINCE EMPLOYER_PHONE EMPLOYER_EXTENSION NAICS_CODE JOB_TITLE SUGGESTED_SOC_CODE SUGGESTED_SOC_TITLE WORK_HOUR_NUM_BASIC WORK_HOUR_NUM_OVERTIME SUPERVISOR_JOB_TITLE SUPERVISE_OTHER_EMP SUPERVISE_HOW_MANY SUPERVISE_LEVEL TRAVEL_REQUIRED PRIMARY_EDUCATION_LEVEL OTHER_EDUCATION MAJOR located on the ETA Form 9141, Section A, Item 1. Legal name of the business, person, association, firm, corporation, or organization filing the ETA Form 9141. Field is located on the ETA Form 9141, Section C, Item 1. Trade name or “Doing Business As” (DBA) name, if applicable, of the business, person, association, firm, corporation, or organization filing the ETA Form 9141.

Field is located on the ETA Form 9141, Section C, Item 2. Address information of the employer filing the ETA Form 9141. Fields are located on the ETA Form 9141, Section C, Items 3 through 7. Industry code associated with the employer requesting permanent labor certification, as classified by the North American Industrial Classification System (NAICS).

Field is located on the ETA Form 9141, Section C, Item 13. Title of the employer’s job opportunity. Field is located on the ETA Form 9141, Section D.a, Item 1. Identifies suggested six or eight-digit Standard Occupational Classification (SOC)/Occupational Network (O*NET) code for the occupation, which most clearly describes the work to be performed.

Identifies the suggested occupational title associated with the SOC/O*NET (OES) code. Identifies the number of regular working hours Identifies the number of authorized overtime hours Identifies the title of the supervisor who will be supervising the work of the foreign worker(s), if applicable. Identifies whether the employer’s job opportunity supervises the work of other employees. Y = Yes; N = No. Field is located on the ETA Form 9141, Section D.a, Item 5.

Identifies the total number of employees the job opportunity will supervise. Section E, 4a Indicate the level of the employee(s) to be supervised as either subordinate, and/or peers. Section E, 4b Identifies whether travel is required in order for the duties of the employer’s job opportunity to be performed. Y = Yes; N = No. Field is located on the ETA Form 9141, Section D.a, Item 7.

Identifies the minimum U.S. diploma or degree required by the employer for the job opportunity. Valid values include “None,” “High School/GED,” “Associate’s,” “Bachelor’s,” “Master’s,” “Doctorate (PhD),” and “Other degree (JD, MD, etc.)”. Field is located on the ETA Form 9141, Section D.b, Item 1. If “Other” in question 1, enter the specific U.S. diploma or degree required.

Identifies the major(s) and/or field(s) of study required by the employer for the job opportunity FIELD NAME DESCRIPTION SECOND_DIPLOMA SECOND_DIPLOMA_MAJOR TRAINING_REQUIRED NUMBER_OF_MONTHS_TRAINING NAME_REQUIRED_TRAINING EMP_EXPERIENCE_REQUIRED EMP_EXPERIENCE_MONTHS OCCUPATION_REQUIRED PRIMARY_WORKSITE_CITY PRIMARY_WORKSITE_COUNTY PRIMARY_WORKSITE_STATE PRIMARY_WORKSITE_POSTAL_CODE OTHER_WORKSITE_LOCATION WORKSITE_COUNTS PWD_SOC_CODE PWD_SOC_TITLE PWD_WAGE_RATE PWD_UNIT_OF_PAY PWD_WAGE_LEVEL REQUESTED_WAGE_SOURCE PWD_WAGE_SOURCE PWD_WAGE_EXPIRATION_DATE SURVEY_NAME SURVEY_PUBLICATION_DATE Identifies if there is an alternate major(s) and/or field(s) of study required by the employer for the job opportunity. Y= Yes, N=No Identifies the second major(s) and/or field(s) of study required by the employer for the job opportunity Identifies whether the employer is requiring training for the job opportunity. Y = Yes; N = No. Field is located on the ETA Form 9141, Section D.b, Item 3. Identifies the number of months required for training Identifies type of required training Identifies whether the employer is requiring employment experience for the job opportunity.

Y = Yes; N = No. Field is located on the ETA Form 9141, Section D.b, Item 4. Where employment experience is required, identifies the number of months of employment experience the employer is requiring for the job opportunity. Field is located on the ETA Form 9141, Section D.b, Item 4a. Identifies the occupation if previous employment is required Address information of the primary worksite or area of intended employment for the job opportunity.

Fields are located on the ETA Form 9141, Section D.c, Items 3 through 6. Identifies if work will be performed in location(s) in addition to the address listed in questions 1-6 Identifies the number of different worksites Occupational code associated with the prevailing wage determination issued by the OFLC National Prevailing Wage Center, as classified by the Standard Occupational Classification (SOC) System. Field is located on the ETA Form 9141, Section E, Item 3. Occupational title associated with the SOC code.

Field is located on the ETA Form 9141, Section E, Item 3a. Prevailing wage rate issued by the OFLC National Prevailing Wage Center. Field is located on the ETA Form 9141, Section E, Item 4. Unit of pay associated with the prevailing wage rate.

Valid values include “Hour”, “Week,” “Bi-Weekly,” “Month,” “Year,” and “Piece Rate.” Field is located on the ETA Form 9141, Section E, Item 5. Level of the prevailing wage determination. Valid values include “Level I,” “Level II,” “Level III,” “Level IV”, and “N/A.” Field is located on the ETA Form 9141, Section E, Item 4a. Identifies the Requested Wage Source by the Employer Name of the source used by the OFLC National Prevailing Wage Center to issue the wage determination.

Valid values include “OES”, “CBA,” “DBA,” “SCA,” and “Other/Alternate Survey.” Identifies the date on which the prevailing wage issued by the OFLC National Prevailing Wage Center will expire. Field is located on the ETA Form 9141, Section E, Item 9. Identifies the name of the survey under which the employer is requesting a determination. Identifies the date of publication of the survey under which the employer is requesting a determination.

Page 3