diff options
| -rw-r--r-- | sql/dawn.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index fda00375..f1afc40c 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3596,13 +3596,13 @@ AS SELECT tranche_risk.date, LEFT JOIN cds ON tranche_risk.tranche_id = cds.id FULL JOIN ( SELECT COALESCE(init_trader_notes, init_fix_id) AS fix_id, - tid AS admin_id, + init_order_id AS admin_id, period_end_date, sum(total_acc_int) AS admin_accrued, sum(end_mkt_value) AS admin_clean_nav, sum(-position) AS admin_notional FROM isosel_accrued WHERE liqd_date IS NULL - GROUP BY COALESCE(init_trader_notes, init_fix_id), tid , period_end_date) a ON a.fix_id= concat('SCCDS', tranche_risk.tranche_id) AND a.period_end_date = tranche_risk.date + GROUP BY COALESCE(init_trader_notes, init_fix_id), init_order_id , period_end_date) a ON a.fix_id= concat('SCCDS', tranche_risk.tranche_id) AND a.period_end_date = tranche_risk.date LEFT JOIN index_version ON cds.security_id::text = index_version.redindexcode LEFT JOIN external_marks_deriv ON cds.cpty_id = external_marks_deriv.identifier AND external_marks_deriv.date = tranche_risk.date WHERE cds.fund = 'ISOSEL'::fund |