CREATE TABLE public.cams_ds_rmsm_summary_daily ( rn double precision ENCODE raw, scheme_code character varying(200) ENCODE lzo, scheme_mode character varying(200) ENCODE lzo, ops_code character varying(200) ENCODE lzo, sub_fund_code character varying(200) ENCODE lzo, brh_code character varying(200) ENCODE lzo, scheme_nature character varying(200) ENCODE lzo, scheme_option character varying(200) ENCODE lzo, scheme_type character varying(200) ENCODE lzo, asset_class character varying(200) ENCODE lzo, asset_category character varying(200) ENCODE lzo, inv_seg_name character varying(200) ENCODE lzo, inv_seg_group character varying(200) ENCODE lzo, cons_code character varying(200) ENCODE lzo, euin character varying(200) ENCODE lzo, ae_code character varying(200) ENCODE lzo, sub_broker character varying(200) ENCODE lzo, brok_dlr_code character varying(200) ENCODE lzo, brok_dlr_catg character varying(200) ENCODE lzo, broker_dlr_group character varying(200) ENCODE lzo, isc character varying(200) ENCODE lzo, business_center character varying(200) ENCODE lzo, mis_location character varying(200) ENCODE lzo, mis_location_category character varying(200) ENCODE lzo, ter_location character varying(200) ENCODE lzo, rm_code character varying(200) ENCODE lzo, sub_rm_code character varying(200) ENCODE lzo, amc_region character varying(200) ENCODE lzo, tax_status_summary character varying(200) ENCODE lzo, city character varying(200) ENCODE lzo, state character varying(200) ENCODE lzo, region_name character varying(200) ENCODE lzo, region_head character varying(200) ENCODE lzo, cluster_name character varying(200) ENCODE lzo, cluster_head character varying(200) ENCODE lzo, deputy_zone_name character varying(200) ENCODE lzo, deputy_zone_head character varying(200) ENCODE lzo, zone_name character varying(200) ENCODE lzo, zone_head character varying(200) ENCODE lzo, sales_name character varying(200) ENCODE lzo, sales_head character varying(200) ENCODE lzo, l_aum double precision ENCODE raw, l_wgt_aum double precision ENCODE raw, l_aum_avg_age double precision ENCODE raw, l_avg_age double precision ENCODE raw, l_avg_aum double precision ENCODE raw, l_wgt_avg_aum double precision ENCODE raw, l_live_account double precision ENCODE raw, dr_count double precision ENCODE raw, dr_amount double precision ENCODE raw, fp_count double precision ENCODE raw, fp_amount double precision ENCODE raw, p_count double precision ENCODE raw, p_amount double precision ENCODE raw, r_count double precision ENCODE raw, r_amount double precision ENCODE raw, si_count double precision ENCODE raw, si_amount double precision ENCODE raw, so_count double precision ENCODE raw, so_amount double precision ENCODE raw, inter_scheme_si_count double precision ENCODE raw, inter_scheme_si_amount double precision ENCODE raw, inter_scheme_so_count double precision ENCODE raw, inter_scheme_so_amount double precision ENCODE raw, intra_scheme_si_count double precision ENCODE raw, intra_scheme_si_amount double precision ENCODE raw, intra_scheme_so_count double precision ENCODE raw, intra_scheme_so_amount double precision ENCODE raw, inflow_gs_count double precision ENCODE raw, inflow_gs_amount double precision ENCODE raw, inflow_inc_dr_count double precision ENCODE raw, inflow_inc_dr_amount double precision ENCODE raw, wgt_inflows double precision ENCODE raw, outflows_count double precision ENCODE raw, outflows_amount double precision ENCODE raw, wgt_outflows double precision ENCODE raw, net_switch double precision ENCODE raw, netsales_count double precision ENCODE raw, netsales_amount double precision ENCODE raw, netsales_inc_dr_count double precision ENCODE raw, netsales_inc_dr_amount double precision ENCODE raw, wgt_netsales double precision ENCODE raw, transaction_count double precision ENCODE raw, l_aum_0m_1m double precision ENCODE raw, l_aum_1m_3m double precision ENCODE raw, l_aum_3m_6m double precision ENCODE raw, l_aum_6m_9m double precision ENCODE raw, l_aum_9m_12m double precision ENCODE raw, l_aum_12m_15m double precision ENCODE raw, l_aum_15m_18m double precision ENCODE raw, l_aum_18m_21m double precision ENCODE raw, l_aum_21m_24m double precision ENCODE raw, l_aum_24m_36m double precision ENCODE raw, l_aum_36m_48m double precision ENCODE raw, l_aum_48m_60m double precision ENCODE raw, l_aum_above_60m double precision ENCODE raw, l_wgt_aum_0m_1m double precision ENCODE raw, l_wgt_aum_1m_3m double precision ENCODE raw, l_wgt_aum_3m_6m double precision ENCODE raw, l_wgt_aum_6m_9m double precision ENCODE raw, l_wgt_aum_9m_12m double precision ENCODE raw, l_wgt_aum_12m_15m double precision ENCODE raw, l_wgt_aum_15m_18m double precision ENCODE raw, l_wgt_aum_18m_21m double precision ENCODE raw, l_wgt_aum_21m_24m double precision ENCODE raw, l_wgt_aum_24m_36m double precision ENCODE raw, l_wgt_aum_36m_48m double precision ENCODE raw, l_wgt_aum_48m_60m double precision ENCODE raw, l_wgt_aum_above_60m double precision ENCODE raw, l_outflows_0m_1m double precision ENCODE raw, l_outflows_1m_3m double precision ENCODE raw, l_outflows_3m_6m double precision ENCODE raw, l_outflows_6m_9m double precision ENCODE raw, l_outflows_9m_12m double precision ENCODE raw, l_outflows_12m_15m double precision ENCODE raw, l_outflows_15m_18m double precision ENCODE raw, l_outflows_18m_21m double precision ENCODE raw, l_outflows_21m_24m double precision ENCODE raw, l_outflows_24m_36m double precision ENCODE raw, l_outflows_36m_48m double precision ENCODE raw, l_outflows_48m_60m double precision ENCODE raw, l_outflows_above_60m double precision ENCODE raw, month_id character varying(200) ENCODE lzo, run_date timestamp without time zone ENCODE az64, seq_no double precision ENCODE raw ) DISTSTYLE AUTO;