diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/et_tables.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index d3f01ffc..ead2f1fd 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -449,14 +449,14 @@ ALTER FUNCTION et_aggdealinfo_historical(varchar(10), date) CREATE OR REPLACE FUNCTION et_cusip_details(p_cusips VARIADIC varchar(10)[]) RETURNS TABLE(orig_moody text, curr_moody text, empty1 unknown, issuer text, - manager text, empty2 unknown, spread float, issuedate date, + manager text, empty2 unknown, spread float, coupon float, issuedate date, reinvenddate date, maturity date, stale_percentage float, cdo_percentage float, wap_basis float, portfolio_spread_5y float, portfolio_spread float, subordination float, thickness float, 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, 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.subordination, a.thickness, NULL, d.updatedate, d.delta, d.duration, d.wal, d.price |