14.1 Sequences and Identity Columns

Many tables within the database require unique numbers to be generated for use as the Primary key within the table, or just as sequences for other purposes. In Oracle this is achieved by use of Oracle Sequences. In SQL Server, these fields are identity columns.

In the below table all min/max values are 1 and 999999999, and cycle by 1, except where stated otherwise

Oracle Sequence Name	min/max values	SQL Server Identity Column Name	Table	Used to...
`activity_no`		`activity_no`	`14.1 sp100_activities`	Used in packages `SPDB_TRIGGERS` and `SPDB_RESETSEQUENCES`.
`analysis_no`	`maxvalue 999999`	`analysis_no`	`14.1 sp070_activity_standards`	Used in `SPDB_RESETSEQUENCES` and `JobTypeDBImpl.cpp`. `DbTidy` also uses this sequence.
`assigned_ports_audit`		`sequence_no`	`sp415_assigned_ports_audit`	Used in server code `MonitorDBImpl.cpp` and `processInfo.cpp`.
`audit_no`		`sequence`	`sp507_audit_sp100` `sp508_audit_sp108` `sp509_audit_sp111` `sp511_audit_sp206`	Used to generate unique identifiers for audit operations. Used in `SPDB_AUDIT` database package.
`audit_sequence_no`		`audit_seq_no`	`sp822_smaudit`
`audit_transaction_id`		`transaction_id`	`sp599_transaction_audit`	Used in `TransactionDBImpl.cpp`.
`break_spec_id`		`break_spec_id`	`sp128_break_patterns`
`bru_no`	`maxvalue 9999`	`bru_no`	`/wiki/spaces/SCH141/pages/27067042`
`capacity_pattern_no`		`capacity_pattern_no`	`14.1 sp351_capacity_patterns`
`component_no`		`component_no`	`14.1 sp400_components`
`component_states_audit`		`sequence_no`	`sp403_component_states_audit`
`dependency_group_no`		`dependency_group_no`	`14.1 sp156_job_dependency_groups`	Used in `JobDependencyGroupDBImpl.cpp`.
`dru_no`	`maxvalue 9999`	`dru_no`	`/wiki/spaces/SCH141/pages/26970293`
`employee_no`		`employee_no`	`14.1 sp210_employees`
`ganttaudit`		`sequence`	`sp500_gantt_audit`
`holiday_spec`	`maxvalue 9999`	`holiday_spec`	`14.1 sp106_holiday_specifications`
`job_no`		`job_no`	`14.1 sp111_jobs`
`location_no`	`maxvalue 9999`	`location_no`	`14.1 sp118_work_locations`
`mapping_no`	`maxvalue 9999`	`mapping_no`	`14.1 sp261_task_mapping`
`message_no`		`message_no`	`14.1 sp207_dispatch_messages`
`monitor_audit`		`sequence_no`	`14.1 sp408_monitor_audit`
`optimizer_run_no`		`optimizer_run_no`	`sp530_optimizer_runs`	Used in `OptimizerStatisticsDBImpl.cpp`.
`region_no`		`region_no`	`/wiki/spaces/SCH141/pages/27068047`
`resource_no`		`resource_no`	`14.1 sp211_resources`
`resp_unit_no`	`maxvalue 9999`	`resp_unit_no`	`/wiki/spaces/SCH141/pages/27099986`
`shift_spec`	`maxvalue 9999`	`shift_spec`	`14.1 sp114_shift_specifications`
`sp073_restrictions_seq`		restriction_no	`sp073_restriction_types`
`sp150_category_id`		`category_id`	`14.1 sp150_std_act_categories`
`sp263_journey_type`	`minvalue 256`	`journey_type`	`14.1 sp263_journey_types`
`sp350_capacity_categories_seq`		`capacity_category_no`	`14.1 sp350_capacity_categories`
`sp419_sequence-no`		`sequence_no`	`sp419_event_audit`
`sp503_sequence_no`		`sequence_no`	`sp503_api_audit`
`sp560_sequence_no`		`sequence_no`	`14.1 sp560_travel_status_history`
`sp802_permission_id`		`permission_id`	`14.1 sp802_permission`	Used in DB Load.
`sp808_role_id`		`role_id`	`14.1 sp808_role_definition`
`sp810_param_seq_no`		`permission_parameter`	`14.1 sp810_perm_param_seq`	Used to generate unique identifiers for use by both `14.1 sp803_auth_actual_parameters` and `14.1 sp804_permission_parameters`.
`specialperiod_no`		`period_id`	`14.1 sp620_special_periods`
`system_state_audit`		`sequence_no`	`sp418_system_state_audit`
`team_no`		`team_no`	`/wiki/spaces/SCH141/pages/27001323`	Used to generate unique identifiers for teams (`sp250`).
~~user_category~~				~~Used to generate unique identifiers for user categories (`sp89`).~~ this sequence is no longer valid and will be removed from future versions of this spec.