diff options
| -rw-r--r-- | sql/et_tables.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 9a85cf17..886de109 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -287,13 +287,14 @@ CREATE TABLE cusip_universe ( GRANT ALL ON cusip_universe TO et_user; -CREATE VIEW latest_clo_universe AS +CREATE OR REPLACE VIEW latest_clo_universe AS SELECT b.dealname, "Deal Name", Manager, orig_deal_bal, b."Curr Deal Bal", orig_collat_bal, b."Curr Collat Bal", b."Tranche Factor", b."Principal Bal", b."Interest Bal", b."CDO Percentage", b."Defaulted Bal", b."Curr Coupon", deal_issue_date, maturity, reinv_end_date, b."Latest Update", "Deal Cusip List", pay_day, first_pay_date, paid_down FROM (SELECT MAX("Latest Update") AS latestdate, dealname FROM clo_universe GROUP BY dealname) a JOIN clo_universe b ON a.dealname = b.dealname AND a.latestdate= b."Latest Update" + JOIN deal_indicative ON b.dealname = deal_indicative.dealname ORDER BY dealname asc; GRANT ALL ON latest_clo_universe TO et_user; @@ -488,7 +489,7 @@ CREATE OR REPLACE FUNCTION et_cusip_details(p_cusips VARIADIC varchar(10)[]) empty3 unknown, pricingdate date, delta float, duration float, wal float, price float) AS $$ BEGIN RETURN QUERY SELECT a.Orig_Moody, a.Curr_Moody, NULL, b."Deal Name", b.manager, NULL, - a.Spread/100, a.Coupon/100, b."Deal Issue Date", b."Reinv End Date", b.Maturity, + a.Spread/100, a.Coupon/100, b.deal_issue_date, b.reinv_end_date, b.Maturity, e.stalepercentage, greatest(b."CDO Percentage"/100, e.cdopercentage), e.wapbasis, e.dealspread5y, e.dealspread, a.curr_attach/100, (a.curr_detach-a.curr_attach)/100, NULL, d.updatedate, d.delta, d.duration, d.wal, d.price |