Employee File Format for LSES

This screen will allow you to create an extract file that lists employees saved on your wage report. Click

Download button for the same. You can edit this file in a spreadsheet program (e.g. Microsoft Excel) and then

upload the file once it contains just the affected employees. You MUST save the file as CSV (Comma Delimited)(*.csv).

To do this,select File -> Save As and then ensure the Save As Type selection is CSV. Failure to do this will

change the file format and you will no longer be able to upload the file into the system.

File Format:

First Row - Header Record

1 - Employer Account Number

2 - Location

3 - Layoff Begin Date (YYYYMMDD)

4 - Recall Date (YYYYMMDD)

4 - Contact Person Name

5 - Contact Person Phone Number

6 - Contact Person Email

7 - Contact Person Fax

8 - Number of Employees (This number should match the total number of employees listed in the file)

Second Row Contains the Employee Detail's column headings.

Third Row and Later:

1 - Employee SSN (999999999/999-99-9999)

2 - Last Name (No Special Characters)

3 - First Name (No Special Characters)

4 - Middle Initial (No Special Characters)

5 - Severance Pay (MUST be some amount or Zero. This should be entered only if 'Severance pay weeks' field is entered)

6 - Number of weeks for Severance Pay (MUST be a number between 0 - 53. This should be entered only if 'Severance pay' field is entered)

7 - Vacation Pay (MUST be some amount or Zero. This should be entered only if 'Vacation pay weeks' field is entered)

8 - Number of weeks for Vacation Pay (MUST be a number between 0 - 53. This should be entered only if 'Vacation pay' field is entered)

9 - Holiday Pay (MUST be some amount or Zero. This should be entered only if 'Holiday pay days' field is entered)

10 - Number of days for Holiday Pay (MUST be a number between 0 - 30. This should be entered only if 'Holiday pay' field is entered)