Requirements
On This Page:
- Basic Job Requirements
- Dependencies between Jobs
- Available Hours the Business will cover
- Available Hours for the Customer
Related Pages:
- sp108_job_details
- sp110_job_equipment
- sp111_jobs
- sp140_job_serv_hours_patterns
- sp141_job_serv_hours_pattern_days
- sp144_job_acc_hours_patterns
- sp145_acc_hours_pattern_days
- sp147_job_acc_hours_overrides
- sp148_job_aho_periods
- sp149_job_serv_hours_overrides
- sp152_job_sho_periods
- sp153_job_more_notes
- sp156_job_dependency_groups
- sp157_job_time_dependencies
- sp158_job_oper_dependencies
- sp218_booking_locations
- sp264_job_skills
- sp309_spare_substitutes
- sp641_break_overrides
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
Dependencies between Jobs
Available Hours the Business will cover
- sp152_job_sho_periods
- sp149_job_serv_hours_overrides
- sp141_job_serv_hours_pattern_days
- sp140_job_serv_hours_patterns
- sp641_break_overrides
Available Hours for the Customer
- sp148_job_aho_periods
- sp147_job_acc_hours_overrides
- sp145_acc_hours_pattern_days
- sp144_job_acc_hours_patterns