1 files changed, 13 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 8f67bd0f..f98dfdf2 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -4910,6 +4910,19 @@ AS SELECT
   GROUP BY vr.invccy, vr.invid, vr.fund, vr.port, vr.strat, vr.periodenddate, vr.custacctname
  HAVING vr.invid = ANY (ARRAY['EUR'::text, 'USD'::text]) ORDER BY periodenddate DESC, fund;
 
+CREATE OR REPLACE VIEW citco_cash_valuations
+AS SELECT cr.period_end_date AS periodenddate,
+    cr.fund,
+    cr.symbol AS invid,
+    cr.trade_ccy AS invccy,
+    'CASH'::text AS port,
+    'CSH_CASH'::text AS strat,
+    cr."prime_broker/clearing_broker" AS custacctname,
+    sum(cr."quantity(end)") AS endlocalmv
+   FROM citco_reports cr
+  GROUP BY cr.period_end_date, cr.fund, cr.symbol, cr.trade_ccy, cr."prime_broker/clearing_broker"
+ HAVING cr.symbol = ANY (ARRAY['EUR Cash Balance'::text, 'USD Cash Balance'::text]) ORDER BY period_end_date DESC, fund;
+
 
 CREATE VIEW eur_fx_valuations AS
 SELECT periodenddate, fund, port, forward_valuations, otc_valuations, cash_valuations