Employees Skills Table Formats (EMSkills)

Follow Vision specifications for preparing a file containing employees skill data.

Field Name Data Type Length Notes

Employee

varchar 20 Employee number; primary key; must exist in EM

Skill

varchar 10 Unique internal identifier for the employee skill; primary key; must exist in CFGEMSkill (Code/Description)

SkillLevel

smallint 2 Unique internal identifier for the employee skill level; must exist in CFGEMSkillLevel

PrimaryInd

varchar 1 Flag indicating whether this is the employee's primary skill; valid options are Y (Yes) or N (No); default is N