14.1 sp215_resource_requirements
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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 | Nullable |
|---|---|---|---|
| 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 14.1 sp070_activity_standards (analysis_no)
foreign key (resource_no) references 14.1 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. |