sp215_resource_requirements

This table specifies the skills and special resources required in order to undertake a standard task (as defined in sp070_activity_standards).

When a job of a given type is booked, details of the skills and resources required for the job type are obtained from this table and copied to tables sp264_job_skills and sp110_job_equipment respectively.

Table Definition

Field	Type	Default
analysis_no	number(6)
resource_no	number(9)
skill_level	number(2)	1

Keys

primary key (analysis_no, resource_no)
foreign key (analysis_no) references sp070_activity_standards (analysis_no)
foreign key (resource_no) references sp211_resources (resource_no)

Column Descriptions

Field	Description
analysis_no	Job analysis (activity standard) identifier.
resource_no	Identifier of resource required. "Resource" may be either a skill or special resource: the type should be obtained from sp211_resources (though it may also be inferred by testing to see whether skill_level is null or not null).
skill_level	Where the resource is a skill, this specifies the required skill level.