Skip to main content

Column Headers Accepted for SFTP

Jesse
  • Updated

Column Headers Accepted in Lattice's SFTP Process

This article is a guide to let you know the values we accept in the SFTP process that would correspond to fields within Lattice. For columns with more than one word, Lattice will accept an underscore in between (Ex. Preferred_Name).

SFTP column headers

Status

For column headers, we will accept:

  • Status
  • Active
  • Active Status

The values we accept for each column header can be found in the table below.

Column Header Name Active State Terminated
Status
  • Active
  • On leave
  • Leave
  • Leave of absence*
  • Deceased
  • Inactive
  • Terminated
  • Suspended
Active Yes No
Active Status Yes No

* Leave of Absence field may be interpreted differently by Lattice depending on the system the SFTP is linked to.

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 (Note: will only be updated if the field is blank in Lattice, otherwise users control their own display name)

  • Preferred name
  • Preferred first name

Email

  • Email
  • Email address

Title

  • Title
  • Business title
  • Job title

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
Note: We only accept dates between 1900-01-01 and 2100-01-01.
 
Department
  • Department
External user ID
  • External user ID
  • Employee ID
  • Empl ID
Note: 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 (TZ Identifier) for tz database names

Latticegroups

  • The values for groups created in Lattice

Job function

  • Job function

Job type

  • Job type

Job level

  • Job level

Compensation default attributes (for Lattice Compensation only) 

Base pay amount

  • Base pay amount
  • Base pay
  • Salary
  • Annual Salary
  • Yearly amount
  • Pay rate

Currency

  • Currency
  • Pay currency

Pay effective date

  • Pay effective date
  • Pay rate effective date
  • Effective date

Pay type

  • Pay type
  • Comp type

Bonus amount

  • Bonus amount

Variable pay amount

  • Variable pay amount
  • Variable pay
  • Commission amount

Finally, note that you can include custom fields in the SFTP process so long as they have already been 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.

Related articles