All Collections
HR Integration Guide
Syncing your HR Roster via flat file / CSV over SFTP
Syncing your HR Roster via flat file / CSV over SFTP
jawnt can sync your organization's employee roster using standard flat file integrations (CSV files only).
Written by Jeff Stade
Updated over a week ago

Setting up the integration

You will need to contact your jawnt account manager to enable the SFTP integration for your organization. Please first give us a public key (typically provided by your HRIS Provider*), and we will then share with you the username and file directory information.

* NOTE: if you are going to be manually transferring the CSVs to our SFTP, this article provides information on how to generate a public and private key.

Connection details

  • Host Name:

  • Username: provided by jawnt

  • File directory: provided by jawnt

  • File name convention: OrganizationName_TransitBenefits_EmployeeFile_YYYYMMDD.csv (replacing OrganizationName with your organization name and YYYYMMDD with current date)

  • Port: 22

  • Export frequency: Weekly

After the integration is set up, your HR roster will automatically be synced with jawnt going forward.

Data fields

Below are the specifications for the flat file. The report exported from your HRIS Provider can include the following fields:

Data Field







Unique identifier used to track the employee in the HRIS application.





Employee first name





Employee last name





Employee’s email address; used to communicate with the user about benefit enrollment.

Valid email address



Mobile phone number is used to communicate with the user about benefit enrollment.


USA-based phone number with no special characters



Used to determine if an employee is active or inactive. Only active employees can be eligible for benefits.


Either “Active” or “Inactive”



Can be used to indicate when an employee might become active. This might be equivalent with employee start date.


Date in format MM/DD/YYYY



Can be used indicate when an employee will become inactive. This might be equivalent with employee end date.


Date in format MM/DD/YYYY

NOTE: If the field names in your report do not match the field name listed, you will need to provide jawnt with a mapping between the fields.

Should the flat file contain eligible employees only, or the entire roster?

By default, jawnt assumes any active employees included in the flat file are eligible for the SEPTA Key Advantage benefit. jawnt can also help your organization determine employee eligibility. During the onboarding process, your jawnt account manager will work with you to understand how your organization is determining eligibility.

Additional data fields can be included in the flat file (report) such as an employee’s home address or date of birth. If this PII (Personal Identifiable Information) is being shared, original values are not stored in the database. In these cases, data shared with jawnt is processed, re-coded (eg. date of birth is typically recoded as ‘Under 65?’ with true or false values), and the original values are discarded.

Should each subsequent flat file contain the full list of employees or changes only?

Every week, the flat file should contain the full eligible employee roster (or complete roster if jawnt is determining eligibility) even if there are no changes since the last upload.

How does jawnt handle inactive/terminated employees? How long should terminated employees be included on the roster?

jawnt will mark an employee as "Inactive" if the "employee_status" column is set to “Inactive” or if the date in the “benefit_end_date” column (if included) has passed. We recommend using a 30-day rolling approach to terminated employees. That is, an employee should be included in the roster (and listed as "Inactive") for at least 30 days after their termination date so they can be appropriately marked as "Inactive" in jawnt. Afterward, they do not need to be included in the file.

If an employee record is missing from a file and has not previously had a status of “Inactive”, jawnt will assume they are inactive after 90 days.

What flat file formats are supported?

The integration supports CSV files only.

Can I include other data in the flat file?

Please speak with your jawnt account manager if there is additional data that is important to be visible in jawnt (eg. employee location, employee type, etc.) so that we can better understand your needs.

Did this answer your question?