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 |