diff options
| -rw-r--r-- | sql/dawn.sql | 39 |
1 files changed, 28 insertions, 11 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index e172c649..3d5e2441 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1209,17 +1209,34 @@ CREATE TYPE portfolio AS ENUM('CASH', 'CLO', 'CURVE', 'GFS_HELPER_BUSINESS_UNIT' CREATE TYPE fund AS ENUM('SERCGLLC', 'SERCGLTD', 'SERCGMAST', 'SER_TEST') -CREATE TYPE strategy AS ENUM('CLOCDSCSH', 'CLO_AAA', 'CLO_BB20', 'CLO_BBB', 'CSH_CASH', - 'CSH_EXP', 'CSOCDSCSH', 'CSO_TRANCH', 'GFS_TRANSFER_HELPER', - 'HEDGE_CLO', 'HEDGE_CSO', 'HEDGE_MAC', 'HEDGE_MBS', 'HYCURVE', 'HYEQY', 'HYINX', - 'HYMEZ', 'HYSNR', 'IGCDSCSH', 'IGCURVE', 'IGCVECSH', 'IGEQY', 'IGINX', - 'IGMEZ', 'IGOPTDEL', 'IGPAYER', 'IGSNR', 'IGTCDSCSH', 'LQD_TRANCH', - 'MACCDSCSH', 'MBSCDS', 'MBSCDSCSH', 'MTG_B4PR', 'MTG_FP', 'MTG_GOOD', - 'MTG_IO', 'MTG_LMG', 'MTG_PR', 'MTG_RW', 'MTG_SD', 'MTG_THRU', - 'SERCGLLC__SERCGLLC', 'SERCGLTD__SERCGLTD', 'SERCGLTD__SERLTD_EXP', - 'SER_TEST__SER_TEST', 'STR_MAV', 'STR_MEZZ', 'HYOPTDEL', 'HYPAYER', 'HYREC', - 'HYCDSCSH', 'ITRXCURVE', 'ITRXCVCSH', 'IR', 'IR_CSH', 'IGREC', 'STEEP', 'FLAT', - 'MTG_CRT_SD') +CREATE TYPE strategy AS ENUM( +-- CLO portfolio +'CLOCDSCSH', 'CLO_AAA', 'CLO_BB20', 'CLO_BBB', 'HEDGE_CLO', +-- TRANCHE portfolio +'HYEQY', 'HYMEZ', 'HYSNR', 'HYINX', 'IGEQY', 'IGMEZ', 'IGSNR', 'IGINX', +-- CURVE portfolio +'IGCURVE', 'IGCVECSH', 'ITRXCURVE', 'ITRXCVCSH', 'HYCURVE', +-- OPTIONS portfolio +'IGOPTDEL', 'IGPAYER', 'IGREC', 'HYOPTDEL', 'HYPAYER', 'HYREC', 'IGCDSCSH', 'HYCDSCSH', +-- IR portfolio +'IR', 'IRDEVCSH', 'STEEP', 'FLAT', +-- STRUCTURED portfolio +'STR_MAV', 'STR_MEZZ', 'HEDGE_CSO', 'CSO_TRANCH', 'CSOCDSCSH', +-- MORTGAGES portfolio +'HEDGE_MBS', 'MTG_B4PR', 'MTG_FP', 'MTG_GOOD', 'MTG_IO', 'MTG_LMG', +'MTG_PR', 'MTG_RW', 'MTG_SD', 'MTG_THRU', 'MTG_CRT_SD', 'MBSCDS', 'MBSCDSCSH', +-- IG portfolio (deprecated) +'IGTCDSCSH', 'IGCURVE', 'IGEQY', 'IGINX', 'IGMEZ', 'IGSNR', +-- HY portfolio (deprecated) +'HYCDSCSH', 'HYCURVE', 'HYEQY', 'HYINX', 'HYMEZ', 'HYSNR', +-- HEDGE_MAC portfolio +'HEDGE_MAC', 'MACCDSCSH', +-- CASH portfolio +'M_CSH_CASH', 'M_CSH_EXP', +-- GFS_HELPER_BUSINESS_UNIT portfolio +'GFS_TRANSFER_HELPER', +-- LQD_TRANCH (deprecated) +'LQD_TRANCH') CREATE TABLE valuation_reports( custacctname text, |