Column Headers Accepted in Lattice's SFTP Process
This article is meant as a guide to let you know the values we accept in the SFTP
process that would correspond to fields within Lattice. First, we'll go over "Status"
as there are names we will accept as the column headers, as well as the
corresponding fields. For columns with more than one word, Lattice will accept an underscore in between (Ex. Preferred_Name).
Status
For column headers we will accept:
- Status
- Active
- Active Status
For our "Active" state within Lattice we will accept:
- active
- on leave
- leave
- leave of absence*
Note: Active columns must have a response value of either Yes or No.
*This field may be interpreted differently by Lattice depending on the system the SFTP is linked to.
For our "Terminated" state within Lattice we accept:
- deceased
- inactive
- terminated
- suspended
For the following sections, the heading is the Lattice field and the list following is
the column headers that we will recognize for that given field
Name
- Name
- Full name
- First name
- Preferred first name
- Last name
- Surname
- Preferred last name
Preferred Name (will only be updated if field is blank in Lattice, otherwise users control their own display name)
- Preferred name
- Preferred first name
Email
- Email address
Title
- Title
- Business title
- Job title
Start Date
- Start date
- Start date
- Start date YYYY/MM/DD
- Hire date
- Started At
Phone Number
- Phone
- Phone Number
Gender
- Gender
Birthdate
- Birthdate
- Birth date
- Birth date YYYY/MM/DD
- Birthday
- Date of birth
*We only accept dates between 1900-01-01 and 2100-01-01*
Department
- Department
External user ID
- External user ID
- Employee ID
- Empl ID
*We only create external IDs currently, and do not support updating them*
Manager
- Manager
- Manager email
- Supervisor email
- Manager email address
- Managers email
- Manager ID (the manager can be set using the manager's external ID)
*If you are using Manager ID to set manager assignments, the column header must say Manager ID. If you are using email addresses to set manager assignments, the column header can be any of the other options.
Timezone
- The values for timezones will need to input the values for tz database names
Latticegroups
- The values for groups created in Lattice
Job function
- Job function
Job type
- Job type
Job level
- Job level
Finally, please note that you can include custom fields in the SFTP process so long as they have already created in Lattice prior to upload. The formatting in the column header must exactly match what you have set as the name of the attribute in Lattice.