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

Use this template to validate imported employee and employee contract of employment details. Running this template is mandatory if you have imported employee data using any of the following Republic of South Africa import/export templates:
 You must run this import/export template (SAEMPCTR) after the following templates have been run – see below.
  • 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
  • SAEMPCTR1 - Republic of South Africa employee contract details
  • 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
This template validates and reports upon errors in the format of data imported into the database tables associated with employee and contract of employment records. You must run it as the final step in the import process when importing employee data from any third party payroll product into Sage X3.
To validate your employee and employee contract of employment records you must carry out the following steps:
  1. Export this template
  2. Import this template
  3. Check the report for any errors
  4. Correct the data in the import file, if necessary
  5. Rerun the appropriate import template (or all of the templates), if neccesary
  6. Export this template
  7. Import this template
  8. Check the report for any errors

Prerequisites

Each of the following import/export templates must be run before this template when importing employee data from any third party payroll product into Sage X3:

  • 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
  • SAEMPCTR1 - Republic of South Africa employee contract details
  • 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

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

ACCES [ACC]

Access by user

ATABDIV [ADI]

Miscellaneous tables

EMPLOCTR [CTR]

Contract

EMPLOCTRCPT [CPR]

Contract accounting information

EMPLOCTRFRA [CTRFRA]

Additional France fields

EMPLOCTRPEN [CPN]

Position hazardous cond in cont

EMPLOCTRSA [CTRSA]

Additional RSA fields

EMPLOCUM [EPC]

Totals

EMPLOELC [ELC]

Electoral lists

EMPLOID [ID]

Civil status

EMPLOSAL [SAL]

Salary trend

FACILITY [FCY]

Sites

JOBTYP [JOT]

Standard jobs

JOBTYPDEF [JOD]

Job type default values

PLANTYP [PLN]

Reference plannings

POSTE [POT]

Position

POSTEDEF [POD]

Item default value

PRESTATION [PSN]

Service provision

SITEPAYE [SIT]

Sites

TABCOUAFF [TCA]

Sequence No assignments

TABCOUNTRY [TCY]

Countries

TIMEMP [TIP]

Tracked times

VALEMP [VEP]

Employee values