sp264_job_skills

This table is used to define the set of skills required by a specified job.

HouseKeeping

This table is tidied by sp_dbtidy's Job group.

Table Definition

Field	Type	Default	Nullable
job_no	number(9)
skill_no	number(9)
skill_level	number(2)

primary key (job_no, skill_no)
foreign key (skill_no) references sp211_resources (resource_no)

Field	Description
job_no	Job identifier.
skill_no	Resource identifier of the required skill.
skill_level	The required skill level for the employee to be assigned the task.