Import/export template > Module Common Data > Import/export template SAEMPCTR1 (SA employee contract) 

Use this template to extract employee contract of employment details. You can use it to import employee contract data from any third party payroll product into Sage X3 and to export from Sage X3.
Imported data is converted into the right format to populate the key employee contract of employment details. These fields are in the header of the employee contract record (function Employment contracts (GESCTR)) and in the Contract tab of the employee record (function Employees (GESEML)). Job, social security and pay detail fields on the following tabs are also populated (function Employment contracts):
  • Contract
  • End
  • Declared
  • Payroll
 Multiple database tables are associated with each individual Sage X3 employee record and their associated contract of employment record. You must, therefore, run each of the following import/export templates in addition to this template to ensure the respective employee database tables are populated:
  • SAEMP1 - Republic of South Africa employee personal details
  • SAEMP2 - Republic of South Africa employee administrative details
  • SAEMP3 - Republic of South Africa employee accounting details
  • SAEMP4 - Republic of South Africa employee payment methods
  • SAEMPCTR3 - Republic of South Africa employee contract accounting details
  • SAEMPCTRSA - Republic of South Africa employee tax details
  • SAEMPSA - Republic of South Africa employee personal identity details
  • SAEMPCTR - Republic of South Africa employee contract details validation – you must run this template last
 You must validate your data after importing data from any third party payroll product into Sage X3. See SAEMPCTR - Republic of South Africa employee contract details validation for further information.

Prerequisites

The following must exist in data to be imported:

  • Employee ID
  • Employment contract ID

Mandatory fields in the template

The mandatory fields are as follows:

  • Employee ID
  • Contract chrono (Employment contract ID)

Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

EMPLOCTR [CTR]

Contract