14.1 Requirements

This group of tables contains all of the data captured about jobs as they are booked. They include a number of tables that hold copies of data from other tables i.e. they hold the actual instantiation of the usage of a job type etc, and hence the actual skill requirement for that job type at the time the related job was booked - this MAY now be different than those currently held elsewhere.

The Tables can be subgrouped as follows:

Basic Job Requirements

• 14.1 sp111_jobs
• 14.1 sp110_job_equipment
• 14.1 sp111_jobs
• 14.1 sp264_job_skills
• 14.1 sp309_spare_substitutes
• 14.1 sp153_job_more_notes

Dependencies between Jobs

• 14.1 sp158_job_oper_dependencies
• 14.1 sp157_job_time_dependencies
• 14.1 sp156_job_dependency_groups

Available Hours the Business will cover

• 14.1 sp152_job_sho_periods
• 14.1 sp149_job_serv_hours_overrides
• 14.1 sp141_job_serv_hours_pattern_days
• 14.1 sp140_job_serv_hours_patterns
• 14.1 sp641_break_overrides

Available Hours for the Customer

• 14.1 sp148_job_aho_periods
• 14.1 sp147_job_acc_hours_overrides
• 14.1 sp145_acc_hours_pattern_days
• 14.1 sp144_job_acc_hours_patterns