diff options
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index ca726078..f867bc71 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -2891,7 +2891,7 @@ AS SELECT trades.settle_date, bond_trades.settle_date, bond_trades.fund, bond_trades.cp_code, - 'bond'::text AS asset_class, + 'BOND' AS asset_class, 'Account'::text AS account, 'USD'::currency AS currency, CASE @@ -2906,7 +2906,7 @@ AS SELECT trades.settle_date, cds_trades.settle_date, cds_trades.fund, cds_trades.cp_code, - 'tranche'::text AS asset_class, + 'TRANCHE' AS asset_class, 'Account'::text AS account, cds_trades.currency, cds_trades.upfront AS payment_amount @@ -2917,7 +2917,7 @@ AS SELECT trades.settle_date, swaptions.settle_date, swaptions.fund, swaptions.cp_code, - 'swaption'::text AS asset_class, + 'SWAPTION' AS asset_class, 'Bilateral Trade'::text AS account, 'USD'::currency AS currency, - swaptions.fee AS payment_amount |