The following tables illustrate how data flows between Onboarding and Spectrum.
An asterisk (*) indicates a required field. Onboarding fields will differ based on whether you have set a company's country to the United States or Canada.
Data Flow: Company's country set to United States
| Onboarding Field | Data Flow | Spectrum Field | Notes |
|---|---|---|---|
| *First Name |  |
*First Name | |
| Middle Name | |
Middle | |
| *Last Name | |
*Last Name | |
| Other Phone | |
Personal telephone | |
| *Date of Birth | |
Date of birth | |
| *Social Security Number | |
Social security number | |
| Gender | |
Sex | |
| Race | |
Race | |
| Disability Status | |
Flags the Disability checkbox | |
| Veteran Status | |
Veteran Status | |
| *Filing Status | |
Filing Status | |
| *Dependent Amount | |
Dependents claimed annually (step 3) | |
| *Other Income | |
Other annual income (step 4a) | |
| *Withholding | |
Extra withholding by pay period (step 4c) | |
| Multiple Jobs | |
Two jobs in total? (step 2c) | |
| Employee Number | |
Employee code | |
| Expected Hire Date | Changes Status | Status | If Hire Date is in the future, Status is set to Inactive; if Hire Date is today or in the past, Status is set to Active. |
| *Company |  |
Company code | |
| *Cost Center | |
Cost center | |
| *Pay Frequency | |
Frequency | |
| *Payroll Department | |
Department | |
| Union Code | |
Union | |
| Wage Code | |
Wage code | |
| *Pay Type | |
Pay type | |
| *Wage | |
Salary rate / Hourly rate | |
| *Resident Tax State | |
Tax code | |
| *Workers Compensation | |
Workers comp code |
Data Flow: Company's country set to Canada
| Onboarding Field | Data Flow | Spectrum Field | Notes |
|---|---|---|---|
| *First Name | |
*First Name | |
| Middle Name | |
Middle | |
| *Last Name | |
*Last Name | |
| Other Phone | |
Personal telephone | |
| *Date of Birth | |
Date of birth | |
| *Social Insurance Number | |
Social Insurance Number | |
| Gender | |
Sex | |
| Race | |
Race | |
| Employee Number | |
Employee code | |
| Expected Hire Date | Changes Status | Status | If Hire Date is in the future, Status is set to Inactive; if Hire Date is today or in the past, Status is set to Active. |
| *Company | |
Company code | |
| *Cost Center | |
Cost center | |
| *Pay Frequency | |
Frequency | |
| *Payroll Department | |
Department | |
| Union Code | |
Union | |
| Wage Code | |
Wage code | |
| *Pay Type | |
Pay type | |
| *Wage | |
Salary rate / Hourly rate | |
| *Workers Compensation | |
Workers comp code | |
| *Federal Tax | |
Tax Code = CAN | |
| *Resident Tax Province | |
Tax Code = Resident Province | |
| Federal Deduction | |
Exempt | |
| Province Deduction | |
Exempt |