About Bundle-Track
Home Solutions Products About Us About Us

 

  Bundle-Track Main Menu
 
  What's New
 
  Solutions
 
  For the Factory
 
  Reports
  Integration
  Requirements
  Support
 
   

Integration: Employee Masterfile Data Import
(Network Edition only)

Bundle-Track requires employee master data (such as employee name, ID, home department and job, shift, etc.) in its database. If you are already managing that data within a net payroll or HR package, then you can avoid redundant data processing by adding an Employee Masterfile import to your system.

Typically, the Bundle-Track Employee Masterfile Interface validates the data from three export files created by the source system:

  • Employee Master Records
  • Employee-Specific Overrides to Hourly Pay Rates
  • Employee-Specific Overrides to Base Rates

It then updates the corresponding records in the Bundle-Track database. Bundle-Track provides thorough reporting on import results to help you troubleshoot validation problems.

Please let us know if you are interested in adding an Employee Masterfile interface to your system. Additional licensing charges will apply. It is also highly likely that some amount of custom engineering charges would apply. The first thing we'll need from you is a set of sample Data Files from your source system. Please contact us with inquiries.

Specifications common to all three soruce files

While a conventional field delimiter (such as a comma) is always preferred, any string will do (if used properly).

The file name may be any Windows-compatible file name. Long filenames and spaces are permitted.

After the import is complete, the file is no longer needed. The source system may overwrite the file daily.

Specifications for the Employee Master Record File

The Employee Master Record Data File contains basic employee information such as name, clock number and home department.

The file produced by the source system must conform to the following field specifications:

Field Description Type Width Required

Clock Number String Up to 15 Yes
Badge Number String Up to 15 No
Home Department String Up to 15 Yes
Home Job String Up to 15 Yes
Pay Session String Up to 15 No
Last Name String Up to 30 Yes
First Name String Up to 30 Yes
Middle Name String Up to 30 No
Social Security # String Up to 30 No
Hire Date Date DD/MM/YYYY No
Home Job Hourly Rate Value Decimal 9999.9999 No
Shift String Up to 15 No
Team String Up to 15 No

Specifications for the Employee-Specific Hourly Rates File

This file contains records detailing any employee-specific overrides to pay rate values.

The file produced by the source system must conform to the following field specifications:

Field Description Type Width Required

Clock Number String Up to 15 Yes
Hourly Rate Code String Up to 15 No
Hourly Rate Value Decimal 9999.9999 No

Specifications for the Employee-Specific Base Rates File

This file contains records detailing any employee-specific overrides to pay rate values.

The file produced by the source system must conform to the following field specifications:

Field Description Type Width Required

Clock Number String Up to 15 Yes

Base Rate Code

String Up to 15 No
Base Rate Value Decimal 9999.9999 No
 

top