The file that we typically receive have the following specs.
File Format
The file is typically a comma delimited file with double quoted values. Each associate is on a single line. The file must contain the following fields:
Associate ID — This is unique identifier of time. It can also be what they use to login with.
Login ID — If you want something other than the Associate ID
First Name
Middle Name (Optional)
Last Name
Job Code — This is a look up value for their job in the company. We can also take a job code feed from you if this is changing often.
Location Code — This is a look up value for the
Hire Date — Date if Hire
Status — This is usually Active or Terminated. You can send us other values, but they would be boiled down to active or terminated.
Division — If you have multiple divisions. We can talk about if this even applies to you. Sometimes this can be Corporate/Stores/Warehouse.
We can also have as many additional fields as you see fit. Here are some common fields that we get from other customers. The most common fields are bolded.
Department
Hourly/Salary
Salary Grade
Salary Plan
FullTime/PartTime
Exempt/Non-Exempt
Age
...
– This is usually translated into age categories like 16-17, 18-21.
Education Level - (Diploma, Associates, Bachelors …. Etc).
FLSA Type (Important in California, New York, Connecticut, Illinois)
isSupervisor
AssociateType
WorkGroup
Comp Group
Cost Center
Expense Center
Job Family — These can be better than job codes sometimes.
Job Sub Family
Success Level
Functional Area
Onboarding Stage (Week 1, Week 2, Week 3, Week 4, Week 5).
...
Payroll Department
HR Department
Temp/Regular
Leave of Absence
File Name
The file can be named anything, we just ask that the file is always named the same.
File Contents
The file typically contains all active associates and all terminated associates for 90 days. We can do Delta files only, but we prefer full files to ensure data integrity.
Frequency
All of our customers send us an import daily. This is typically processed between 12 AM and 6 AM.
File Transfer and Security
We have a secure SFTP server where the files can be deposited. Alternatively, we can retrieve the file from a server you host. Also, most of our customers encrypt the file with our PGP key so that the file is encrypted both in transfer and at rest at all times.