1 files changed, 0 insertions, 99 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 302edd3d..dfafbae9 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -3455,105 +3455,6 @@ CREATE table isda_agreement_dates(
   CONSTRAINT isda_agreement_dates_key UNIQUE (fund, counterparty, agreement_date),
 )
 
-
-CREATE TABLE citco_stax (
-	"index" text NULL,
-	"fund" text NULL,
-	trader text NULL,
-	"prime_broker/clearing_broker" text NULL,
-	"strategy" text NULL,
-	citco_security_id text NULL,
-	symbol text NULL,
-	cusip text NULL,
-	isin text NULL,
-	sedol text NULL,
-	ric text NULL,
-	bloomberg_code text NULL,
-	"long/short" text NULL,
-	open_trade_date date NULL,
-	open_settle_date date NULL,
-	close_trade_date date NULL,
-	close_settle_date date NULL,
-	opening_aexeo_trade_id text NULL,
-	closing_aexeo_trade_id text NULL,
-	quantity text NULL,
-	base_price text NULL,
-	base_market_value text NULL,
-	base_unit_cost text NULL,
-	base_total_cost text NULL,
-	base_commissions text NULL,
-	base_sec_fees text NULL,
-	"report_date_base_realized_p&l" text NULL,
-	"report_date_base_unrealized_p&l" text NULL,
-	"mtd_base_realized_p&l" text NULL,
-	"mtd_base_unrealized_p&l" text NULL,
-	"ytd_base_realized_p&l" text NULL,
-	"ytd_base_unrealized_p&l" text NULL,
-	base_ccy text NULL,
-	issue_price text NULL,
-	issue_market_value text NULL,
-	issue_unit_cost text NULL,
-	issue_total_cost text NULL,
-	issue_commissions text NULL,
-	issue_sec_fees text NULL,
-	"issue_realized_p&l" text NULL,
-	"issue_unrealized_p&l" text NULL,
-	"mtd_issue_realized_p&l" text NULL,
-	"mtd_issue_unrealized_p&l" text NULL,
-	"ytd_issue_realized_p&l" text NULL,
-	"ytd_issue_unrealized_p&l" text NULL,
-	issue_ccy text NULL,
-	security_description text NULL,
-	security_asset_name text NULL,
-	security_asset_class text NULL,
-	maturity_date date NULL,
-	underlying_citco_security_id text NULL,
-	underlying_symbol text NULL,
-	underlying_cusip text NULL,
-	underlying_isin text NULL,
-	underlying_sedol text NULL,
-	underlying_bloomberg_code text NULL,
-	underlying_security_description text NULL,
-	underlying_security_asset_name text NULL,
-	underlying_security_asset_class text NULL,
-	opening_aexeo_order_id text NULL,
-	closing_aexeo_order_id text NULL,
-	region text NULL,
-	exchange text NULL,
-	exchange_symbol text NULL,
-	country_code text NULL,
-	trade_ccy text NULL,
-	industry text NULL,
-	industry_sector text NULL,
-	issue_trade_acquistion_interest text NULL,
-	base_trade_acquistion_interest text NULL,
-	spot_fx_rate text NULL,
-	standard_strategy text NULL,
-	client_instrument_id text NULL,
-	bond_class text NULL,
-	init_exec_broker text NULL,
-	liqd_exec_broker text NULL,
-	"option_type" text NULL,
-	"option_put/call_flag" text NULL,
-	option_strike_price text NULL,
-	option_expiration_date text NULL,
-	contract_size text NULL,
-	coupon_rate text NULL,
-	bloomberg_real_time_code text NULL,
-	bond_abbrev text NULL,
-	underlying_ric text NULL,
-	occ_code text NULL,
-	underlying_occ_code text NULL,
-	fix_id text NULL,
-	ops_notes text NULL,
-	trader_notes text NULL,
-	orig_date date NULL,
-	period_end_date date NULL,
-	knowledge_date timestamp NULL,
-	"row" int NULL,
-	CONSTRAINT citco_stax_pk PRIMARY KEY (period_end_date, "row")
-);
-
 CREATE OR REPLACE VIEW tranche_risk_isosel
 AS SELECT tranche_risk.date,
     tranche_risk.tranche_id AS trade_id,