Employees were loaded via Excel Integration or Cim Load. They were all loaded in Domain USA entity 1000. Half of them need to be assigned to entity 2000. Will modifng only the emp_mstr.emp_entity be enough? I see an EMPLOYEE record which links to the company. Does this record also need to be updated? Any others? This is needed for Factivity to work properly. Do you know where this can be seen by QAD menus? We see it in Progress Editor and custom browse by entity.
Your guess is right. You need also update the company_id in the Employee table to link it to the correct entity, you can find the correct company_id by searching the company table.