diff options
| -rw-r--r-- | sql/dawn.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index ee297550..6c54b948 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1144,6 +1144,8 @@ SELECT citco_reports.period_end_date, citco_reports.isin, citco_reports.base_price, citco_reports.base_market_value, + citco_reports.base_bond_accrued_interest, + citco_reports.end_face_value as factored_notional, citco_reports.underlying_currency_code, citco_reports.security_description, citco_reports.security_asset_name, @@ -1151,6 +1153,7 @@ SELECT citco_reports.period_end_date, citco_reports.underlying_symbol, citco_reports.factor, citco_reports.underlying_red, + citco_reports.base_nav_contribution, citco_reports.total_fund_capital FROM citco_reports WHERE citco_reports.subfund = 'ISOSEL_DFLT'::text; |