Employees Skills Table Formats (EMSkills)

Follow DPS 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