Stored Procedures


sp_download_error_message.sql	12367	Procedure	BOI_Capture
sp_get_record_counts.sql	12365	Procedure	BOI_Capture
sp_initialise_download.sql	12361	Procedure	BOI_Capture
sp_match_contract_keys.sql	12358	Procedure	BOI_Capture
sp_save_tmp_commodity.sql	12359	Procedure	BOI_Capture
sp_save_tmp_contract.sql	12358	Procedure	BOI_Capture


ets_bo_addstrips.sql	d	t	CE_Convert
ets_bo_calcsettle_summary.sql	d	t	CE_Convert
ets_bo_change_trading_date.sql	d	t	CE_Convert
ets_bo_check_load_errors.sql			CE_Convert
ets_bo_cnvrt_open_interest.sql			CE_Convert
ets_bo_cnvrt_price_limit.sql			CE_Convert
ets_bo_cnvrt_series_data.sql			CE_Convert
ets_bo_cnvrt_settlement_price.sql			CE_Convert
ets_bo_commodity_list.sql			CE_Convert
ets_bo_commodity_load.sql			CE_Convert
ets_bo_contract_disable.sql			CE_Convert
ets_bo_contract_month_load.sql			CE_Convert
ets_bo_contract_month_update.sql			CE_Convert
ets_bo_convert_data.sql			CE_Convert
ets_bo_convert_prices.sql			CE_Convert
ets_bo_convert_tmp_table.sql			CE_Convert
ets_bo_fill_volatilities.sql			CE_Convert
ets_bo_get_download_date.sql			CE_Convert
ets_bo_get_system_date.sql			CE_Convert
ets_bo_load_all_series.sql			CE_Convert
ets_bo_month_load.sql			CE_Convert
ets_bo_notional_settlements.sql			CE_Convert
ets_bo_oi_and_vf_save.sql			CE_Convert
ets_bo_roll_db.sql			CE_Convert
ets_bo_series_load.sql			CE_Convert
ets_bo_series_save.sql			CE_Convert
ets_bo_series_update.sql			CE_Convert
ets_bo_settlement_price_save.sql			CE_Convert
ets_bo_set_next_trading_day.sql			CE_Convert
ets_tmp_commodity_list_update.sql			CE_Convert
ets_tmp_contract_list_update.sql		Final	CE_Convert


ets_mt_char_convert_off.sql		d		t	CE_Support
ets_mt_char_convert_on.sql					CE_Support
ets_mt_clearer_list.sql		d		t	CE_Support
ets_mt_clearing_member.sql					CE_Support
ets_mt_clearing_status_list.sql		d		t	CE_Support
ets_mt_contract.sql					CE_Support
ets_mt_contract_check_list.sql		d		t	CE_Support
ets_mt_contract_month.sql					CE_Support
ets_mt_contract_month_list.sql		d		t	CE_Support
ets_mt_contract_month_save.sql					CE_Support
ets_mt_contract_save.sql		d		t	CE_Support
ets_mt_contract_session.sql					CE_Support
ets_mt_contract_session_list.sql		d		t	CE_Support
ets_mt_contract_session_save.sql					CE_Support
ets_mt_contract_type_list.sql		d		t	CE_Support
ets_mt_decimal_format_list.sql					CE_Support
ets_mt_del_month.sql		d		t	CE_Support
ets_mt_del_month_list.sql					CE_Support
ets_mt_del_month_save.sql		d		t	CE_Support
ets_mt_del_month_year_list.sql					CE_Support
ets_mt_ets_terminal.sql		d		t	CE_Support
ets_mt_ets_terminal_delete.sql					CE_Support
ets_mt_ets_terminal_list.sql		d		t	CE_Support
ets_mt_ets_terminal_save.sql					CE_Support
ets_mt_exchange.sql		d		t	CE_Support
ets_mt_exchange_contract.sql					CE_Support
ets_mt_exchange_list.sql		d		t	CE_Support
ets_mt_exchange_save.sql					CE_Support
ets_mt_gen_contract_type_list.sql		d		t	CE_Support
ets_mt_interest_rate_list.sql					CE_Support
ets_mt_interest_rate_save.sql		d		t	CE_Support
ets_mt_market_type.sql					CE_Support
ets_mt_market_type_cont_delete.sql		d		t	CE_Support
ets_mt_market_type_cont_list.sql					CE_Support
ets_mt_market_type_cont_save.sql		d		t	CE_Support
ets_mt_market_type_list.sql					CE_Support
ets_mt_market_type_save.sql		d		t	CE_Support
ets_mt_member.sql					CE_Support
ets_mt_membership_status_list.sql		d		t	CE_Support
ets_mt_member_list.sql					CE_Support
ets_mt_member_market_rights.sql		d		t	CE_Support
ets_mt_member_mkt_right_save.sql					CE_Support
ets_mt_member_mnemonic.sql		d		t	CE_Support
ets_mt_member_save.sql					CE_Support
ets_mt_member_type_list.sql		d		t	CE_Support
ets_mt_nymex_user_detail.sql					CE_Support
ets_mt_series.sql		d		t	CE_Support
ets_mt_series_limit_list.sql					CE_Support
ets_mt_series_limit_save.sql		d		t	CE_Support
ets_mt_series_list.sql					CE_Support
ets_mt_series_save.sql		d		t	CE_Support
ets_mt_settlement_price.sql					CE_Support
ets_mt_settlement_price_save.sql		d		t	CE_Support
ets_mt_spread_contract.sql					CE_Support
ets_mt_spread_contract_list.sql		d		t	CE_Support
ets_mt_spread_contract_l_list.sql					CE_Support
ets_mt_spread_contract_save.sql		d		t	CE_Support
ets_mt_spread_leg_delete.sql					CE_Support
ets_mt_spread_leg_save.sql		d		t	CE_Support
ets_mt_spread_summary.sql					CE_Support
ets_mt_trader.sql		d		t	CE_Support
ets_mt_trader_contract_rights.sql					CE_Support
ets_mt_trader_contract_right_del.sql		d		t	CE_Support
ets_mt_trader_cont_right_save.sql			CE_Support
ets_mt_trader_list.sql	d	t	CE_Support
ets_mt_trader_market_rights.sql			CE_Support
ets_mt_trader_mkt_right_delete.sql	d	t	CE_Support
ets_mt_trader_mkt_right_save.sql			CE_Support
ets_mt_trader_mnemonic_list.sql	d	t	CE_Support
ets_mt_trader_save.sql			CE_Support
ets_mt_trading_summary.sql	d	t	CE_Support
ets_mt_user_group.sql			CE_Support
ets_mt_user_group_list.sql	d	t	CE_Support
ets_mt_user_group_save.sql			CE_Support
ets_mt_user_list.sql	d	t	CE_Support
ets_mt_user_save.sql			CE_Support


sql_aam.sql	12367	Procedure	TSI_Audit
sql_aasm.sql	12365	Procedure	TSI_Audit
sql_ati.sql	12361	Procedure	TSI_Audit
sql_ua.sql	12358	Procedure	TSI_Audit
sql_uapl.sql	12359	Procedure	TSI_Audit
sql_uar.sql	12358	Procedure	TSI_Audit
sql_ulh.sql			TSI_Audit
sql_uo.sql			TSI_Audit
sql_uod.sql			TSI_Audit
sql_usr.sql			TSI_Audit
sql_uta.sql			TSI_Audit
sql_uti.sql			TSI_Audit
sql_uur.sql			TSI_Audit


cme_get_max_spread_number.sql			CME_Load
cme_get_max_trade_number.sql			CME_Load
cme_get_max_trade_set_id.sql			CME_Load
cme_get_max_transaction_number.sql			CME_Load
cme_load_accounts.sql			CME_Load
cme_load_account_rights.sql			CME_Load
cme_load_acc_pos_limits.sql			CME_Load
cme_load_online_msgs.sql			CME_Load
cme_load_orders.sql	For Today, Two Rows For Spreads, order by:OrderNumber	Procedure	CME_Load
cme_load_settlement_prices.sql			CME_Load
cme_load_spread_series.sql			CME_Load
cme_load_spread_stats.sql			CME_Load
cme_load_trade_allocs.sql			CME_Load
cme_set_orders_inactive.sql			CME_Load
dcc_download_contract_sessions.sql			CME_Load
dcc_download_expires.sql			CME_Load
dcc_get_logical_start_of_day.sql			CME_Load
dcc_load_spreads.sql			CME_Load
dcc_update_session_status.sql			CME_Load
dcc_upload_contract_session.sql			CME_Load
shr_load_ets_trades.sql			CME_Load
ets_spread_trade_insert.sql			CME_Load
ets_spread_trade_load.sql			CME_Load
spread_series_insert_row.sql			CME_Load
spread_series_leg_insert_row.sql			CME_Load


	cs_add_user_right.sql						CS_Load
	cs_delete_user_rights.sql						CS_Load
	cs_expand_trader_rights.sql						CS_Load
	cs_expire_orders.sql						CS_Load
	cs_load_contracts.sql						CS_Load
	cs_load_interest_rate.sql						CS_Load

	cs_load_market_types.sql						CS_Load
	cs_load_market_type_contracts.sql						CS_Load
	cs_load_members.sql						CS_Load
	cs_load_member_clearing_rights.sql						CS_Load
	cs_load_member_mnemonics.sql						CS_Load
	cs_load_member_trading_rights.sql						CS_Load
	cs_load_orderstyles.sql						CS_Load
	cs_load_order_action_limit.sql						CS_Load
	cs_load_series.sql						CS_Load
	cs_load_spreads.sql						CS_Load
	cs_load_spread_legs.sql						CS_Load
	cs_load_system_dates.sql						CS_Load
	cs_load_terminals.sql						CS_Load
	cs_load_traders.sql						CS_Load
	cs_load_trader_mnemonics.sql						CS_Load
	cs_load_trader_rights.sql						CS_Load
	cs_load_tsi_systems.sql						CS_Load
	cs_load_users.sql						CS_Load
	cs_load_user_groups.sql						CS_Load
	cs_load_user_messages.sql						CS_Load
	cs_load_user_reasonability.sql						CS_Load
	cs_load_user_rights.sql						CS_Load
	cs_update_password.sql						CS_Load
	cs_update_user_message.sql						CS_Load
	cs_update_user_status.sql						CS_Load
	cs_upload_open_interest.sql						CS_Load
	cs_load_margin_rates.sql						CS_Load


	add_daily_stats.sql						General
	add_month_pos_to_stats.sql						General
	ats_load_permissions.sql						General
	boil_download_settlements.sql						General
	boil_download_trade_limits.sql						General
	carry_orders_forward.sql						General
	cdl_get_last_audit_msg_no.sql						General
	contract_expiry.sql						General
	contract_session_start_of_day.sql						General
	copy_stats_to_today.sql						General
	del_vdata.sql						General
	ets_check_db.sql						General
	exchange_list_contract.sql						General
	get_audit_message_with_subs.sql						General
	get_date_int_today.sql						General
	ipe_business_days.sql						General
	ipe_force_system_date.sql						General
	ipe_get_date.sql						General
	mark_spread_trade_as_zapped.sql						General
	mark_trade_as_confirmed.sql						General
	mark_trade_as_zapped.sql						General
	member_get_trading_rights.sql						General
	sql_clear_closing_prices.sql						General
	sql_get_max_audit_number.sql						General
	sql_set_contract_inactive.sql						General
	sql_update_settlement_prices.sql						General
	sql_update_spread_stats.sql						General
	sql_update_trade_limits.sql						General
	sql_update_zap_spread_stats.sql						General
	update_daily_settlement_prices.sql						General
	update_daily_stats_for_ask.sql						General
	update_daily_stats_for_bid.sql						General
	update_daily_stats_for_cross.sql						General
	update_daily_stats_for_efp.sql						General
	update_daily_stats_for_high.sql						General
	update_daily_stats_for_last.sql						General
	update_daily_stats_for_low.sql						General
	update_daily_stats_for_trade.sql						General
	update_daily_stats_for_volume.sql						General
	update_tscs_sequence.sql						General