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 |