IFP003 Select Employee Status error during timecard interfacing

Issue/Symptom/Question

We received the below error when trying to process an interface file.

An error has been detected in a SQL Statement.

IFP003 -2112 SQL-02112:SELECT..INTO returns too many rows

select employee status

Applies To

PENTA for Windows

Interfaces > Processing > Initiate Batch Interface Request

Resolution/Fix/Answer

The interface file included a record with an inactive employee. Once the user updated the employee status, they were able to pick up the interface process.