Default Employee Import File Layout

The data file must be formatted correctly in order to be imported by the TimeForce system. This file format changes based on the customizations you have performed to the program database (such as changes made in Edit Tables, etc.).

The file format that is displayed on the right-hand side of the main “Import Employee” screen is pulled directly from your program database, and will always be correct.

The following table is an example of the default file layout:

 

Column Name

Data Type

Required

Description

Employeeid

Text (50 characters)

Required

The employee's ID.

CardNumber

Number (10 characters)

Optional

The employee's card number.

FirstName

Text (50 characters)

Required

The first name of the employee.

MiddleName

Text (50 characters)

Optional

The middle name of the employee.

LastName

Text (50 characters)

Required

The last name of the employee.

Address1

Text (50 characters)

Optional

The first level of the employee's address.

Address2

Text (50 characters)

Optional

The second level of the employee's address.

City

Text (50 characters)

Optional

The city of the employee's address.

State

Text (50 characters)

Optional

The state of the employee's address.

Zip

Text (50 characters)

Optional

The zip code of the employee's address.

Homephone

Text (50 characters)

Optional

The employee's home phone number.

Workphone

Text (50 characters)

Optional

The employee's work phone number.

Workext

Text (50 characters)

Optional

The extension to the employee's work phone number.

Gender_id

Number (1 character)

Optional

Employee's gender.
1=Male, 2=Female, 3=Not Specified

GovernmentID

Text (50 characters)

Optional

The employee's Social Security Number.

Hire_dt

Date

Required

The date on which the employee was hired.

DepartmentNumber

Number (10 characters)

Optional

The employee's home department number.

effective_dt

Date

Required

The date on which pay becomes active.  Required if importing pay information.

paytype_id

Number (10 characters)

Optional

Employee's pay type.
1=Hourly, 2=Salary

payrate

Number (10 characters)

Optional

The employee's rate of pay.

payunits_id

Number (10 characters)

Optional

1=Hourly, 2=Weekly, 3=BiWeekly, 4=Semi-Monthly, 5=Monthly, 6=Annually

promotionreason_id

Number (10 characters)

Optional

1=Promotion, 2=Hire, 3=Layoff, 4=Rehire, 5=Release, 6=Resigned, 7=Terminated, 8=Transfer, 9=Demotion

jobtitle_id

Number (10 characters)

Optional

464=Salaried Worker, 465=Supervisor, 466=CEO, 467=Technical, 468=Clerical, 469=Hourly Worker, 470=Manager, 471=Manufacturing, 472=Sales, 473=Professional

Birthday

Date

Optional

Employee's date of birth.

PayGroupID

Number (10 characters)

Optional

This is the group of pay policies that you would like the imported employees to be assigned to.

active_yn

Number (1 character)

Optional

The status of the employee.
1=Active, 0=Inactive