Other Changes

All identity fields and triggers should be marked as "Not for replication".

Check constraints have been added to the database for all enumerated fields or integers that are otherwise limited to a specific range of values. These are:

• attr - data_type, attr_grp, entry_type

• system_attr – edit_type

• audit_trail – change_type

• user_name - auth_method

• priv – edit_type

• message – category, priority

• mgr_data_config – rep_type, view_level

• graphics – format

• doc_type – edit_level, down_level, view_level, print_level

• item_reas_grp – reas_grp_type

• job_exec – auto_seq_start_option, auto_job_start_option, auto_job_end_option

• std_oper_step – action_type, complete_cond

• process – process_level, process_status

• item_process_link – status

• item_cons – transaction_type

• oper_step_grp - repeatability

• oper_step – action_type, complete_cond

• job_step_grp – repeatability

• job_step – action_type, complete_cond

• item_rule – basis, relational_op

• oper_alloc_rule – basis, relational_op

• job_alloc_rule – basis, relational_op

• oper_prod_rule – basis, relational_op

• job_prod_rule – basis, relational_op

• spec – data_type

• storage_exec – status

• transfer_list – transfer_type

• dx_sched – sched_type, trigger_option, data_type, format_option, transport_option, post_update_option, post_action_option, last_result

• dx_query – type

• dx_log – status

• dx_queue – activity_type

• fc_namesp_tag – data_type

• fc_bridge – status, ext_driver

• fc_log – event_type

• fc_ext_driver_status – status

• data_log_grp – trigger_type

• data_log_value – value_type, meaning

• dnc_exec – device

• so – state_cd

• po- state_cd

• spc_char – int_trigger

• spc_char_job – int_trigger

• spc_rule – test1, test2

• gage_config – parity, stop_bits, fs_mode

• form – contentfile_type
  script – context, script_type

• kpi_state – state_cd

• data_entry_sched – key_type, trigger_type

• data_entry_log – key_type

Change the following constraint names to keep them within 30 characters maximum, or to conform them with the conventions used for names of other constraints of the same type:

• Check constraints

• From cert_oper_link_cert_lvl_chk to CHK_cert_oper_link_cert_level

• From cert_oper_stp_lnk_cert_lvl_chk to CK_cert_oper_step_link_cert_lv

• Default constraints

• From DF_cert_std_oper_link_cert_level to DF_cert_std_oper_link_cert_lev

• From DF_cert_std_oper_step_link_cert_level to DF_csosl_cert_level

• From DF_cert_type_up_to_experimental to DF_cert_type_up_to_xperimental

• From DF_cert_type_down_to_experimental to DF_cert_type_dn_to_xperimental

• From DF__job_spec1__step___002D5665 to DF_job_spec_step_no

• From DF_spc_char_std_oper_link_step_no to DF_scsol_step_no

• From DF_spc_char_std_oper_link_grp_seq to DF_scsol_grp_seq

• From DF_std_oper_ent_link_batch_size to DF_std_oper_ent_link_batch_sz

• From DF_std_oper_spec_ver_preferred_ver to DF_std_oper_spec_ver_pref_ver

• From DF_std_oper_step_grp_repeatability to DF_sosg_repeatability

• Foreign key constraints

• From FK_cert_std_oper_link_cert_type to FK_csol_cert_type

• From FK_cert_std_oper_link_std_oper to FK_csol_std_oper

• From FK_cert_std_oper_step_link_cert_type to FK_csosl_cert_type

• From FK_cert_std_oper_step_link_std_oper_step to FK_csosl_std_oper_step

• From FK_data_log_grp_std_oper_link_data_log_grp to FK_dlgsol_data_log_grp

• From FK_data_log_grp_std_oper_link_std_oper to FK_dlgsol_std_oper

• From FK_spc_char_std_oper_link_spc_char to FK_scsol_spc_char

• From FK_spc_char_std_oper_link_std_oper to FK_scsol_std_oper

• From FK_std_oper_ent_link_job_sched_exec to FK_soel_job_sched_exec

• From FK_std_oper_ent_spec_std_oper_ent_link to FK_soes_std_oper_ent_link

• From FK_std_oper_ent_spec_std_oper_spec_ver to FK_soes_std_oper_spec_ver

• From FK_std_oper_step_std_oper_step_grp to FK_std_op_step_std_op_step_grp

• From FK_std_oper_step_ent_exc_job_sched_exec to FK_sosee_job_sched_exec

• From FK_std_oper_step_ent_exc_std_oper_step to FK_sosee_std_oper_step

• From FK_std_oper_step_file_std_oper_step to FK_sosf_std_oper_step

• Indexes

• From FK_item_transfer_item_X to FK_it_item_X

• From FK_item_transfer_storage_exec_from_X to FK_it_storage_exec_from_X

• From FK_item_transfer_storage_exec_to_X to FK_it_storage_exec_to_X