Before an employee is written to Viewpoint Spectrum, the sync checks the employee's Employee Type and Hire Date, and, only for employees who are terminated or deceased, the Termination Reason and Termination Date. If any of these checks fail, that employee is not sent to Spectrum for this run. No field on that employee is written, not just the field that failed.

The Employee Type and Hire Date checks run for every employee, every time. The two termination checks only run when the employee's Employee Type resolves to one of the codes Spectrum uses for Terminated or Deceased. An active employee, or any employee whose Employee Type resolves to something other than those two codes, will never see either termination message. None of these checks stop the others from running, so one employee can show more than one of these messages in the same run.

Error Messages

Employee Type accepts two formats: a plain code by itself (for example T), or a code followed by a dash and a description (for example T-Terminated). Only the part before the first dash is used as the code. This matches what the message text says, and it is why a value that is only a description with no code, or a value that starts with a dash, is treated as missing.

The two termination messages are gated entirely by Employee Type. If Employee Type is blank or does not resolve to a usable code, only the Employee Type message can fire for that reason; the termination checks are skipped for that employee in that run because there is no resolved code to compare against Terminated or Deceased. Once Employee Type does resolve to Terminated or Deceased, Termination Reason and Termination Date are checked independently of each other, so both can fire together on the same employee. Hire Date is checked independently of Employee Type and status entirely, so it can appear on its own, alongside the Employee Type message, or alongside either termination message, all on the same employee in the same run.

Confirming the Error

1. Open the sync history for the connector and find the sync execution for the run in question.
2. Open the step for the Viewpoint Spectrum connector.
3. Find the affected employee row. A non-zero count in the Errors column for that employee row means one or more of these checks failed. Check the Warnings, Information, and Failures columns too, since those are separate counts and do not indicate this family of issues by themselves. The Added, Updated, and Unchanged columns will show no change for that employee, since the record was skipped.
4. Open the employee row and review the errors list. Match on the fixed part of each sentence (for example, Hire Date is required or is missing or in an invalid format), not on any quoted or substituted value, since the substituted part is always the same fixed code list and never employee-specific data.
5. Read the full errors list for that employee before fixing anything. It is common to see more than one of these messages on the same employee in the same run, for example, a missing Hire Date together with a missing Termination Reason.

Resolving the Error

Employee Type Is Missing or in an Invalid Format

1. Open the employee's record in Arcoro and locate the Employee Type field.
2. Have them enter a valid code, either alone or as Code-Description (for example, T-Terminated).
3. Save the record.

Missing Hire Date

1. Open the employee's record in Arcoro and locate the Hire Date field.
2. Have them enter the employee's hire date.
3. Save the record.

Missing Termination Reason or Termination Date

1. Confirm the employee's Employee Type is set to Terminated or Deceased. If it is not, and you still expect these fields to be required, escalate rather than continuing here.
2. Open the employee's termination information in Arcoro.
3. Have them enter a Termination Reason, a Termination Date, or both, depending on which message appeared.
4. Save the record.

After the correction is saved in Arcoro, run the sync again. Confirm the fix by reopening the sync history for the new run and checking that the employee row now shows the record processed (an entry in Added or Updated) with no entry in Errors for that employee.

When to Escalate

If any of the following occur, you may need to reach out to Arcoro support for additional assistance.

• Employee Type, Hire Date, Termination Reason, and Termination Date all look correct on the employee record in Arcoro, but the same message still appears after a fresh sync run.
• The errors list shows a message with this same wording but referencing a field not covered in this article.
• You cannot find or edit the Termination Reason field on the employee's termination information in Arcoro.
• The employee's Employee Type looks correct, but the sync still treats it as Terminated or Deceased when you expect an active status, or the opposite.