Introduction

Sapling’s Sequoia integration allows the creation of new hires and termination of departing employees in Sequoia through the BSwift integration.

This is done by Sapling sending new hire data to Bswift SFTP service, which then populates new hire data in Sequoia. Currently, the integration covers only new hire creation and departing employee terminations, with data changes scheduled to be released in the future.

The integration saves the duplicate data entry of 44 fields of data per new hire, with a complete field map outlined in the appendix of this document.

How does the integration work?

Overview

The integration must be configured by a Sapling team member and is not self-serve by Sapling Admins at this time.

To set-up the integration, the Sapling team needs the following from your Sequoia account manager.

  • Company Name
  • Default Hours Per Week
  • Bswift Hostname
  • Bswift Username
  • Bswift Password

Following set-up, the integration follows the standard Sapling integration + onboarding flow:

  • Admin enters information and onboards a new hire
  • New Hire completed information
  • New Hire info sent to BSwift at completion of onboarding

About the Integration

Once SFTP details are added to Sapling, each night Sapling creates a CSV with the required data validations at 12am PST and sends this to BSwift SFTP service. The data is saved in Sapling’s database and a confirmation email to Sapling internal users.

Details on user experience

Admin set-up

The Admin initiates and new hire onboarding:

Sapling Admin enables Bswift integration

  • Group Number
  • Benefit Class Code
  • Hours Per Week (custom field)
  • Relation
  • Auto-Enroll

Sapling Admin onboards new hire and inputs current data (normally from the ATS)

  • Employment Status
  • Hire Date
  • Job Title
  • Time Status
  • Etc.

New Hire Experience

The New Hire completes their information in the Sapling preboarding portal.

New Hires complete preboarding + completes all new hire information

  • First Name
  • Middle Initial
  • Last Name
  • Date of Birth
  • Social Security Number
  • Etc.

New Hires completes new hire task on benefits

  • Includes logging into Bswift and completing enrollment
  • This would be dependent on new hire data being successfully sent by the SFTP upload (otherwise there would be no information there for the new hire)

Frequently Asked questions

How does the timing work for the information flow to Sequoia for new hires?

Sapling sends the new hire data to Bswift as soon as they complete preboarding. The data is processed overnight (130am PST) and then should appear in Sequoia shortly after.

For terminations, does the information flow the day after I make a change/entry into Sapling or the day after the actual termination date?

The termination information goes to Sequoia the day after the actual termination date. For example:

  • Monday 2pm - Employee terminated in Sapling with last day Thursday
  • Thursday 5pm - Employee termination information sent from Sapling to Sequoia
  • Friday 130am - Employee terminated in Sequoia

Complete field map

Name

Description

Group Number

REQUIRED for all imports. This field can contain Alpha or Numeric Characters; and is used as a Client identifier. This number is entered into the bswift system (Located under company profile) via the user interface. The group number must be unique per client.

UserID

REQUIRED for all standard demographic imports. This field can contain Alpha or Numeric Characters; and is used as the Unique ID Per Person. (i.e. for employee SSN).

Social Security Number

REQUIRED. For employees only on import.

EmployeeID

REQUIRED for all imports. This field can contain Alpha or Numeric Characters; and is used as the Unique Family Grouping Identifier. This field is located in the Employment Information Section of the employee's view/edit information screen. This ID should be the same for an employee and his/her dependent (s).

Payroll ID

REQUIRED. This field can contain Alpha and/or Numeric Characters.

Payroll ID may differ from EmployeeID if HRIS and Payroll systems are separate.

Relation

REQUIRED for all imports. The "Relation" field requires all characters to be selected from the map. The map shows all possible characters; these characters must be inserted into the "Relation" field in all imports, for employees and dependents.

First Name

REQUIRED for all imports. This field can contain Alpha and/or Numeric Characters.

Middle Initial

Optional Field. This field can contain Alpha and/or Numeric Characters.

NOTE: This field is only 1 character and is used as a Initial field only. More than 1 character will cause failure. No periods.

Last Name

REQUIRED for all imports. This field can contain Alpha and/or Numeric Characters.

Employment Status

REQUIRED. The "Employment Status" field requires all characters to be selected from the map.

Setting the Employment Status to 'T' will only update an employee to 'Not Active' and not terminate any benefits. To terminate benefit, please see "Termination Reason."

Benefit Class Code

REQUIRED. This field can contain Alpha and/or Numeric Characters. This field is located on the view/edit page of the benefit class section.

This field drives benefits eligibility.

Benefit Class Date

REQUIRED. This field is located on the view/edit page of the benefit section.

NOTE: Pass Hire Date for initial conversion of data and change date thereafter.

Hire Date

REQUIRED Date Field (for employees only).

Re-hire Date

Optional Field. Only required for rehires

Termination Date

REQUIRED for importing terminations.

Termination Reason

REQUIRED for importing terminations. The "Termination Reason" field requires all characters to be selected from the map.

NOTE: This process will update "Employment Status" to "N" (Not Active), end an employee's benefit elections (based on termination rules set-up in the system), and will disable an employee's login ability.

If an Employment Status Code of 'T' is passed in conjunction with this field, then two 'Not Active' records will be created under the Employment Information History as two separate import processes are being triggered. If only one record is desired, then leaving the Employment Status as 'A' is recommended.

Job Title

REQUIRED.This field can contain Alpha and/or Numeric Characters.

Time Status

REQUIRED. The "Time Status" field requires all characters to be selected from the map.

Salary

REQUIRED. All characters must be numeric. Exception: files can include 1 "." to denote cents.

Salary is required if the Time Status field equals 1,3,6. Providing a salary for an hourly employee (Time Status equal to 2,4,5) will cause the file to fail.

Use numbers and 1 decimal point only. 50000.00 -- no "$" or ",".

Hourly Rate

REQUIRED. All characters must be numeric. Exception: files can include 1 "." to denote cents.

Hourly Rate is required if the Time Status field equals 2,4,5. Providing a hourly rate for a salaried employee (Time Status equal to 1,3,6) will cause the file to fail.

Use numbers and 1 decimal point only. 50000.00 -- no "$" or ",".

This field is used to annualize salary on the Total Compensation Statement if Annual Salary or Benefits Base Salary is not available.

Hours Per Week

REQUIRED (hourly employees only). All characters must be numeric. Exception: Files can include 1 "." to denote fraction of an hour.

Optional field if employee is salary (Time Status equal to 2,4,5).

This field is used to annualize salary on the Total Compensation Statement if Annual Salary or Benefits Base Salary is not available.

Bonus

Optional Field. Never Required. All characters must be numeric. Exception: Files can include 1 "." to denote cents.

Use numbers and 1 decimal point only. 50000.00 -- no "$" or ","

This field can be displayed on the Total Compensation Statement.

Bonus Effective Date

Optional Date Field. Never Required.

Commission

Optional Field. Never Required. All characters must be numeric. Exception: Files can include 1 "." to denote cents.

Use numbers and 1 decimal point only. 50000.00 -- no "$" or ","

This field can be displayed on the Total Compensation Statement.

Commission Effective Date

Optional Date Field. Never Required.

Benefits Base Salary

REQUIRED. This field should be a summation of base salary + bonus and commission. Note that this field will be used to calcluate coverage for all volume based benefits. Without this field, benefit volumes will be based on annual salary only, which does not include bonus or commissions. All characters must be numeric. Exception: Files can include 1 "." to denote cents.

Use numbers and 1 decimal point only. 50000.00 -- no "$" or ","

Compensation Date

REQUIRED. Date Field

This date must be the greater of all the salary effective dates whether it is base salary, bonus, commission, or benefits base salary.

NOTE: Pass Hire Date for initial conversion of data and change date thereafter

Pay Frequency

REQUIRED. The "Pay Frequency" field requires all characters to be selected from the map shown below.

Department Code

Optional Field, Never Required but preferred. This field can contain Alpha and/or Numeric Characters.

This field auto creates the Department Code.

Location Code

Optional Field. Never Required. This field can contain Alpha and/or Numeric Characters.

This field auto creates the Location Code.

Division Code

Optional Field. Never Required. This field can contain Alpha and/or Numeric Characters.

This field auto creates the Division Code.

Date of Birth

REQUIRED Date Field.

Gender

REQUIRED. The "Gender" field requires all characters to be selected from the map.

Home Address1

REQUIRED. This field can contain Alpha and/or Numeric Characters.

Home Address2

REQUIRED. This field can contain Alpha and/or Numeric Characters.

City

REQUIRED. This field can contain Alpha and/or Numeric Characters.

State

REQUIRED. This field can contain 2 letter state code (example: Illinois = IL) -- For Int'l country codes please contact your Sequoia Client Operations Manager.

ZIP

REQUIRED. This field can contain Alpha and/or Numeric Characters. For conversion purposes it is recommended to import address information for dependents as well.

NOTE: Please only provide 5 digit zip codes (i.e. 60661) in order to use the zip/location functionality for plan eligibility.

Home Phone

Optional Field. Never Required. This field can contain Alpha and/or Numeric Characters.

Cell Phone

Optional Field. Never Required. This field can contain Alpha and/or Numeric Characters.

Work e-mail

REQUIRED. This field will be mapped to create usernames for employees. This field can contain Alpha and/or Numeric Characters.

Alternate e-mail

Optional Field. Never Required. This field can contain Alpha and/or Numeric Characters.

User Name

REQUIRED. Work email is the default username. Used for user login to portal.

Auto-Enroll

REQUIRED for only those who should get the Employer Paid Benefits. The "Auto-Enroll" field requires all characters to be selected from the map.

The "auto-enroll" feature will enroll employee's into any "auto-enroll" plan he/she is eligible for.

Did this answer your question?