File Specifications and Submission Method

Workforce Intelligence has created an automated submission method for your company to submit data each data due date. Below is an outline of the file specifications you are required to use in order to submit your data using this method. The Payroll data file needs to be submitted each period. If you are a multi-concept operator we ask for a separate set of exports for each concept. A sample file is available for download at the bottom of this article.

Payroll Data File

File Name:
‘payroll_yyyy-mm-dd.dat’. Where yyyy-mm-dd is the ending date of the payroll period.

File Structure:
This is a tab-delimited file. It will contain field headings on the first row and each employee’s data on a separate row beneath this as follows:

UnitID
UnitAddress1
UnitAddress2
UnitCity
UnitState
UnitZipCode
EmployeeID
PositionID
EmployeeZipCode
EmployeeGender
EmployeeRace
EmployeeDOB
EmployeeType
EmployeeStatusDate
EmployeeGrossPay
EmployeeAnnualSalary
EmployeeGrossBonus
EmployeeHoursWorked
EmployeeEducation
EmployeeSource
EmployeeRating
TermDate
EmployeeHRStatus
HourlyPayRate