How to update Employee Supervisor using HSDL

We've tried updating Employee supervisor using HSDL. The columns we added are Effective Start Date, Type, Assignment Number, Supervisor Person Number, New Supervisor Person Number, New Supervisor Type. While importing, it gave us an error "You must enter a valid value for the ManagerId field". So we checked the Manager ID in the backend using query. Upon adding ManagerID, it gave us an error "You need to enter a valid value for the ManagerAssignmentId attribute" (There is no Manager Assignment ID in the HSDL fields though). We checked the manager assignment ID from the query and used it in the