Data Flow for Onboarding
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 |
