Tidied Tables

Job Group

• sp100_activities (Jobs)
• sp104_activity_status
• sp108_job_details
• sp110_job_equipment
• sp111_jobs
• sp140_job_serv_hours_patterns
• sp141_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
• sp207_dispatch_messages
• sp264_job_skills
• sp309_spare_substitutes

Audit Group

• sp403_component_states_audit
• sp408_monitor_audit
• sp415_assigned_ports_audit
• sp418_system_state_audit
• sp419_event_audit
• sp500_gantt_audit
• sp503_api_audit
• sp507_audit_sp100
• sp508_audit_sp108
• sp509_audit_sp111
• sp511_audit_sp206
• sp530_optimizer_runs
• sp531_optimizer_statistics
• sp532_optimizer_costs
• sp599_transaction_audit
• sp822_smaudit
• sp823_smaudit_empattr
• sp824_smaudit_empskill
• sp825_smaudit_empshiftass
• sp826_smaudit_empholiday
• sp827_smaudit_empteamposting
• sp828_smaudit_emplkrange
• sp829_smaudit_emplkregion
• sp830_smaudit_emppattlocs
• sp831_smaudit_empact
• sp832_smaudit_empoverride
• spaudit_sp083
• spaudit_sp213

Global Group

• sp064_overrides
• sp065_local_knowledge
• sp095_ru_unavailability
• sp100_activities (Standard Activities)
• sp112_postings
• sp113_shift_assignments
• sp206_capabilities
• sp207_dispatch_messages
• sp208_dispatch_breaks
• sp216_contractors
• sp126_lk_range_overrides
• sp127_lk_region_overrides
• sp252_team_locations
• sp253_ru_teams
• sp254_team_unavailability
• sp353_fru_cap_assignments
• sp354_fru_capacity_overrides
• sp355_team_cap_assignments
• sp356_team_capacity_overrides
• sp370_operative_days
• sp371_opday_capacity
• sp372_opday_breaks
• sp560_travel_status_history 
• sp641_break_overrides
• sp660_notification_messages