Skills

The skills that an employee is capable of performing are listed in the EMP_SKILL field. The skills are listed in sequence separated by a tilde (~) symbol.

For example: 

SKILL1~SKILL2~SKILL3……

The number of skills an employee can have using the Employee Import process is limited to a string size of 200 characters. Therefore, shorter skill names allow for more skills to be listed for an employee.

The skill type associated to the skill are listed in the EMP_SKILL_TYPE field. They are listed in sequence separated by a tilde (~) symbol.

For example: 

SKILLTYPE1~SKILLTYPE2~SKILLTYPE3……

The number of skill types an employee can have using the Employee Import process is limited to a string size of 200 characters. Therefore, shorter skill type names allow for more skill types to be listed for an employee. Since each skill type must have a corresponding skill specified, the number of skills must match the number of skill types; otherwise, the record is rejected.

The skill weight associated to the skill are listed in the EMP_SKILL_WEIGHT field. The skill weights are listed in sequence separated by a tilde (~) symbol.

For example: 

SKILLWEIGHT1~SKILLWEIGHT2~SKILLWEIGHT3……

The number of skill weights an employee can have using the Employee Import process is limited to a string size of 40 integers. Therefore, shorter skill weight numbers allow for more skill weights to be listed for an employee. A default value of 0 is used if skill weights are not specified. If they are provided, since each skill weight must have a corresponding skill and skill type specified, the number of skills and skill types must match the number of skill weights; otherwise, the record is rejected.

For situations where there is a need to only load skills for employees, an interface layout named EMPLOYEE SKILL is available. The layout is based on the Employee Import process. The layout streamlines the skills loading process without the need for other fields. The layout has these fields:

  • OVR_START_DATE
  • OVR_END_DATE
  • EMP_NAME
  • EMP_SKILL
  • EMP_SKILL_TYPE
  • EMP_SKILL_WEIGHT

For more information about these fields, see Employee data element definitions.