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 |
|