14.1 Index of Table Names

Here is a list of all the tables if you find this easier to navigate:

Page:

14.1 Database Spec ServiceOptimizer Tables sp563
Page:

14.1 sp013_non_working_days
Page:

14.1 sp014_travel_overrides
Page:

14.1 sp064_overrides
Page:

14.1 sp065_local_knowledge
Page:

14.1 sp066_knowledge_ranges
Page:

14.1 sp067_knowledge_sets
Page:

14.1 sp070_activity_standards
Page:

14.1 sp071_job_categories
Page:

14.1 sp072_job_category_parameters
Page:

14.1 sp073_restriction_types
Page:

14.1 sp082_ru_setting_categories
Page:

14.1 sp083_system_parameters
Page:

14.1 sp084_user_profiles
Page:

14.1 sp085_users
Page:

14.1 sp086_user_preferences
Page:

14.1 sp087_user_derestrictions
Page:

14.1 sp088_user_units
Page:

14.1 sp089_user_categories
Page:

14.1 sp094_travel_times
Page:

14.1 sp099_sa_travel_modes
Page:

14.1 sp100_activities
Page:

14.1 sp101_activity_categories
Page:

14.1 sp102_activity_conflicts
Page:

14.1 sp103_activity_permissions
Page:

14.1 sp104_activity_status
Page:

14.1 sp105_activity_types
Page:

14.1 sp106_holiday_specifications
Page:

14.1 sp107_holidays
Page:

14.1 sp108_job_details
Page:

14.1 sp110_job_equipment
Page:

14.1 sp111_jobs
Page:

14.1 sp112_postings
Page:

14.1 sp113_shift_assignments
Page:

14.1 sp114_shift_specifications
Page:

14.1 sp115_shifts
Page:

14.1 sp116_break_specifications
Page:

14.1 sp117_status_descriptions
Page:

14.1 sp118_work_locations
Page:

14.1 sp120_scale_factors
Page:

14.1 sp122_work_patterns
Page:

14.1 sp123_work_pattern_days
Page:

14.1 sp124_LK_range_patterns
Page:

14.1 sp125_region_LK_patterns
Page:

14.1 sp126_LK_range_overrides
Page:

14.1 sp127_region_LK_overrides
Page:

14.1 sp128_break_patterns
Page:

14.1 sp130_gantt_timescales
Page:

14.1 sp140_job_serv_hours_patterns
Page:

14.1 sp141_job_serv_hours_pattern_days
Page:

14.1 sp142_predef_sh_patterns
Page:

14.1 sp143_predef_sh_pattern_days
Page:

14.1 sp144_job_acc_hours_patterns
Page:

14.1 sp145_acc_hours_pattern_days
Page:

14.1 sp146_job_aho_decodes
Page:

14.1 sp147_job_acc_hours_overrides
Page:

14.1 sp148_job_aho_periods
Page:

14.1 sp149_job_serv_hours_overrides
Page:

14.1 sp150_std_act_categories
Page:

14.1 sp151_std_act_cat_types
Page:

14.1 sp152_job_sho_periods
Page:

14.1 sp153_job_more_notes
Page:

14.1 sp154_confirmation_timebands
Page:

14.1 sp155_confirmation_types
Page:

14.1 sp156_job_dependency_groups
Page:

14.1 sp157_job_time_dependencies
Page:

14.1 sp158_job_oper_dependencies
Page:

14.1 sp159_dependency_cost_category
Page:

14.1 sp202_trigger_values
Page:

14.1 sp203_holiday_assignments
Page:

14.1 sp206_capabilities
Page:

14.1 sp207_dispatch_messages
Page:

14.1 sp208_dispatch_breaks
Page:

14.1 sp209_peak_travel_times
Page:

14.1 sp210_employees
Page:

14.1 sp211_resources
Page:

14.1 sp213_scheduler_parameters
Page:

14.1 sp214_application_permissions
Page:

14.1 sp215_resource_requirements
Page:

14.1 sp218_booking_locations
Page:

14.1 sp228_fixed_reasons
Page:

14.1 sp230_ext_data
Page:

14.1 sp231_ext_data_types
Page:

14.1 sp232_ext_data_value_types
Page:

14.1 sp233_ext_data_emp_attr_types
Page:

14.1 sp234_ext_data_objects
Page:

14.1 sp235_ext_data_attr_changes
Page:

14.1 sp236_ext_data_state_changes
Page:

14.1 sp237_ext_data_validation
Page:

14.1 sp238_ext_data_valid_defns
Page:

14.1 sp239_ext_data_display
Page:

14.1 sp240_ext_data_display_defns
Page:

14.1 sp241_ext_data_list_text
Page:

14.1 sp242_ru_ext_data_objects
Page:

14.1 sp245_id_configuration
Page:

14.1 sp254_team_unavailability
Page:

14.1 sp255_user_teams
Page:

14.1 sp256_promise_set_descriptions
Page:

14.1 sp257_band_lists
Page:

14.1 sp258_band_types
Page:

14.1 sp259_time_bands
Page:

14.1 sp260_task_categories
Page:

14.1 sp261_task_mapping
Page:

14.1 sp263_journey_types
Page:

14.1 sp264_job_skills
Page:

14.1 sp272_knowledge
Page:

14.1 sp274_boolean
Page:

14.1 sp275_ranges
Page:

14.1 sp276_knowledge_set_names
Page:

14.1 sp279_range_defaults
Page:

14.1 sp285_job_status
Page:

14.1 sp286_posting_types
Page:

14.1 sp287_dispatch_statuses
Page:

14.1 sp290_dispatch_types
Page:

14.1 sp291_employee_types
Page:

14.1 sp292_current_hht
Page:

14.1 sp293_resource_types
Page:

14.1 sp294_team_unav_reasons
Page:

14.1 sp295_user_codes
Page:

14.1 sp296_employee_status
Page:

14.1 sp298_booking_types
Page:

14.1 sp299_appointment_status
Page:

14.1 sp300_decode_tables
Page:

14.1 sp301_overdue_desc
Page:

14.1 sp302_MIS_activity_types
Page:

14.1 sp303_task_attributes
Page:

14.1 sp308_req_emp_types
Page:

14.1 sp309_spare_substitutes
Page:

14.1 sp313_overdue_tolerance
Page:

14.1 sp314_gantt_colours
Page:

14.1 sp315_custom_number_keyword
Page:

14.1 sp316_custom_number_emp_value
Page:

14.1 sp320_dbtidy_schedule
Page:

14.1 sp350_capacity_categories
Page:

14.1 sp351_capacity_patterns
Page:

14.1 sp352_capacity_pattern_levels
Page:

14.1 sp353_fru_cap_assignments
Page:

14.1 sp354_fru_capacity_overrides
Page:

14.1 sp355_team_cap_assignments
Page:

14.1 sp356_team_capacity_overrides
Page:

14.1 sp370_operative_days
Page:

14.1 sp371_opday_capacity
Page:

14.1 sp372_op_day_breaks
Page:

14.1 sp373_list_operative_emptype
Page:

14.1 sp400_components
Page:

14.1 sp401_component_hierarchy
Page:

14.1 sp402_component_states
Page:

14.1 sp403_component_states_audit
Page:

14.1 sp404_component_status_decodes
Page:

14.1 sp405_component_types
Page:

14.1 sp406_monitors
Page:

14.1 sp407_monitor_state_decodes
Page:

14.1 sp408_monitor_audit
Page:

14.1 sp409_component_ports
Page:

14.1 sp410_component_alerts
Page:

14.1 sp411_component_port_types
Page:

14.1 sp412_trace_masks
Page:

14.1 sp413_alert_arguments
Page:

14.1 sp414_assigned_ports
Page:

14.1 sp415_assigned_ports_audit
Page:

14.1 sp416_host_machines
Page:

14.1 sp417_system_state
Page:

14.1 sp418_system_state_audit
Page:

14.1 sp419_event_audit
Page:

14.1 sp420_trace_levels
Page:

14.1 sp430_client_types
Page:

14.1 sp431_client_server_map
Page:

14.1 sp500_gantt_audit
Page:

14.1 sp501_gantt_actions
Page:

14.1 sp502_rsched_lookup_tables
Page:

14.1 sp503_api_audit
Page:

14.1 sp507_audit_sp100
Page:

14.1 sp508_audit_sp108
Page:

14.1 sp509_audit_sp111
Page:

14.1 sp511_audit_sp206
Page:

14.1 sp530_optimizer_runs
Page:

14.1 sp531_optimizer_statistics
Page:

14.1 sp532_optimizer_costs
Page:

14.1 sp533_optimizer_solution_types
Page:

14.1 sp534_optimizer_cost_types
Page:

14.1 sp550_script_audit
Page:

14.1 sp560_travel_status_history
Page:

14.1 sp561_geofence_location_types
Page:

14.1 sp562_gps_travel_status
Page:

14.1 sp590_audit_reason_codes
Page:

14.1 sp591_audit_reason_ops
Page:

14.1 sp592_audit_reason_op_config
Page:

14.1 sp593_audit_op_reason_mapping
Page:

14.1 sp598_system_actions
Page:

14.1 sp599_transaction_audit
Page:

14.1 sp600_report_data_categories
Page:

14.1 sp601_report_date_ranges
Page:

14.1 sp610_rpt_priority_grouping
Page:

14.1 sp611_rpt_jeopardy_conditions
Page:

14.1 sp614_rpt_groupby_skill
Page:

14.1 sp620_special_periods
Page:

14.1 sp621_special_periods_history
Page:

14.1 sp641_break_overrides
Page:

14.1 sp660_notification_messages
Page:

14.1 sp800_user_roles
Page:

14.1 sp801_role_permissions
Page:

14.1 sp802_permission
Page:

14.1 sp803_auth_actual_parameters
Page:

14.1 sp804_permission_parameters
Page:

14.1 sp805_auth_parameter_types
Page:

14.1 sp806_applications
Page:

14.1 sp807_assignment_param_ops
Page:

14.1 sp808_role_definition
Page:

14.1 sp809_friendly_names_map
Page:

14.1 sp810_perm_param_seq
Page:

14.1 sp820_smaudit_category_types
Page:

14.1 sp821_smaudit_operation_types
Page:

14.1 sp822_smaudit
Page:

14.1 sp823_smaudit_empattr
Page:

14.1 sp824_smaudit_empskill
Page:

14.1 sp825_smaudit_empshiftass
Page:

14.1 sp826_smaudit_empholiday
Page:

14.1 sp827_smaudit_empteamposting
Page:

14.1 sp828_smaudit_emplkrange
Page:

14.1 sp829_smaudit_emplkregion
Page:

14.1 sp830_smaudit_emppattlocs
Page:

14.1 sp831_smaudit_empact
Page:

14.1 sp832_smaudit_empoverride
Page:

14.1 sp840_planner_map_text
Page:

14.1 sp841_inspection_targets
Page:

14.1 sp842_extra_skills
Page:

14.1 sp900_language_translation
Page:

14.1 sp901_language_codes
Page:

14.1 sp930_cancelled_jobs
Page:

14.1 spaudit_sp083
Page:

14.1 spaudit_sp213
Page:

Database Spec ServiceOptimizer Tables sp563
Page:

sp013_non_working_days
Page:

sp014_travel_overrides
Page:

sp046_postcode_patterns
Page:

sp047_postcodes
Page:

sp051_brus
Page:

sp053_drus
Page:

sp055_dru_frus
Page:

sp056_time_zones
Page:

sp057_regions
Page:

sp058_responsibility_units
Page:

sp059_ru_regions
Page:

sp060_ru_postcode_patterns
Page:

sp064_overrides
Page:

sp065_local_knowledge
Page:

sp066_knowledge_ranges
Page:

sp067_knowledge_sets
Page:

sp070_activity_standards
Page:

sp071_job_categories

ServiceScheduling 14.1

14.1 Index of Table Names

Analytics

Related content