Document toolboxDocument toolbox

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

Â