DOL OFLC, CW-1 Record Layout FY19.pdf

U.S. Department of Labor Employment and Training Administration Office of Foreign Labor Certification Public Disclosure File: Federal Fiscal Year: Reporting Period: CW-1 2019 May 10, 2019, through September 30, 2019 Important Note: This public disclosure file contains administrative data from employers’ CW-1 Applications for Temporary Labor Certification for Non-Agricultural Workers (ETA Form 9142) and the certification determinations processed by the Department’s Office of Foreign Labor Certification, Employment and Training Administration, where the date of the determination was issued on or after May 10, 2019, and on or before June 30, 2019. FIELD NAME DESCRIPTION CASE_NUMBER DECISION_DATE VISA_CLASS Unique identifier assigned to each application submitted for processing to the ETA National Processing Center. Date on which the last significant event or decision was recorded by the ETA National Processing Center. Type of application submitted for processing.

CW-1 refers to applications submitted by, or on behalf of, employers seeking certification to employ foreign workers on a temporary basis. SUBMITTED_DATE Date the applications was received at the National Processing Center. CASE_STATUS TYPE_OF_APPLICATION CERTIFICATION_BEGIN_DATE CERTIFICATION_END_DATE Status associated with the last significant event or decision. Valid values include “Certified – Full,” “Certified – Partial,” “Denied”, and “Withdrawn.” Category of requested employment.

Valid values include “New employment” and “renewal of approved employment” Actual date granted to an employer indicating when the need for the foreign workers to perform agricultural services or labor is expected to begin. Actual date granted to an employer indicating when the need for the foreign workers to perform agricultural services or labor is expected to end. EMPLOYER_NAME Name of the employer requesting temporary labor certification. TRADE_NAME_DBA EMPLOYER_ADDRESS1 EMPLOYER_ADDRESS2 EMPLOYER_CITY EMPLOYER_STATE If Applicable, the "doing business as" name of employer submitting labor condition application.

Contact information of the Employer requesting temporary labor certification. FIELD NAME DESCRIPTION EMPLOYER_POSTAL_CODE EMPLOYER_COUNTRY EMPLOYER_PROVINCE EMPLOYER_PHONE EMPLOYER_PHONE_EXT EMPLOYER_REP_BY_ AGENT Contact information of the Employer requesting temporary labor certification. Y = Employer requesting temporary labor condition is represented by an Agent or Attorney; N = Employer requesting temporary labor condition is not represented by an Agent or Attorney. LAWFIRM_NAME Name of the Law Firm filing a CW-1 application on behalf of the employer.

AGENT_ATTORNEY_NAME AGENT_ATTORNEY_CITY AGENT_ATTORNEY_STATE JOB_TITLE SOC_CODE SOC_TITLE NAICS_CODE Name of Agent or Attorney filing a CW-1 application on behalf of the employer. City for the Agent or Attorney filing a CW-1 application on behalf of the employer. State for the Agent or Attorney filing a CW-1 application on behalf of the employer. Title of the job.

Occupational code associated with the job being requested for temporary labor certification, as classified by the Standard Occupational Classification (SOC) System. Occupational name associated with the SOC_CODE. Industry code associated with the employer requesting permanent labor certification, as classified by the North American Industrial Classification System (NAICS). NBR_WORKERS_REQUESTED Total number of foreign workers requested by the Employer(s).

NBR_WORKERS_CERTIFIED Total number of foreign workers certified by the ETA National Processing Center. TOTAL_NUMBER_OF_HOURS Total work hours offered each week. HOURLY_WORK_SCHEDULE_AM Proposed Work Schedule Start Time. HOURLY_WORK_SCHEDULE_PM Proposed Work Schedule End Time.

BASIC_RATE_OF_PAY Rate of pay offered. FIELD NAME DESCRIPTION OVERTIME_RATE_FROM Overtime Rate Starting Amount (if applicable). OVERTIME_RATE_TO Overtime Rate Ending Amount (if applicable). PAY_RANGE_UNIT Unit of pay.

Valid values include “Hour,” “Week,” “Bi-Weekly,” “Month,” “Year,” or “Piece Rate.” SUPERVISE_OTHER_EMP Y = Supervisory Position; N = Not a Supervisory Position. SUPERVISE_HOW_MANY Number of Employees to Supervise (if applicable). EDUCATION_LEVEL Minimum level of education required for position. Variables include "None", "High School/GED", "Associates", "Bachelor's", "Master's", "Doctorate (PhD)", or "Other Degree (JD, MD, etc.)." NUM_MONTHS_TRAINING If Additional Training Required, Number of Hours Needed.

EMP_EXP_NUM_MONTHS If Job-Related Experience Required, Number of Month Needed. WORKSITE_CITY City information of the foreign worker's intended area of employment. WORKSITE_STATE State information of the foreign worker's intended area of employment. WORKSITE_POSTAL_CODE Zip Code information of the foreign worker's intended area of employment.

OTHER_WORKSITE_LOCATION Y = Additional Worksite Locations; N = No additional Worksite Location. Page 3