diff options
Diffstat (limited to 'sql/et_tables.sql')
| -rw-r--r-- | sql/et_tables.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index c7e720e5..430f0ff6 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -224,6 +224,7 @@ CREATE TABLE clo_universe ( "Latest Update" date, "Deal Cusip List" text[], PaidDown date, + "Pay Day" date, PRIMARY KEY (dealname, "Latest Update") ); @@ -278,7 +279,7 @@ CREATE OR REPLACE FUNCTION historical_clo_universe(p_dealname varchar(10), p_dat "Principal Bal" float, "Interest Bal" float, "CDO Percentage" float, "Defaulted Bal" float, "Curr Coupon" float, "Deal Issue Date" date, maturity date, "Deal Next Pay Date" date, "Reinv End Date" date, - "Latest Update" date, "Deal Cusip List" text[], paiddown date) AS $$ + "Latest Update" date, "Deal Cusip List" text[], paiddown date, "Pay Day" date) AS $$ DECLARE latestdate date; BEGIN SELECT max(clo_universe."Latest Update") INTO latestdate FROM clo_universe |