67CREATE TABLE &LIBREF..MARKET_DAY_ECONOMIC_SIM (
68 REPORTING_DT DATE label =
'Reporting Date' FORMAT = &DTFMT.,
69 _date_ DATE label =
'Date' FORMAT = &DTFMT.,
70 simulationreplication NUMERIC(8) label =
'Simulation Identifier',
71 simulationtime NUMERIC(8) label =
'Horizon Identifier',
72 USD_CAD NUMERIC(8) label =
'USD to CAD Exchange Rate',
73 USD_JPY NUMERIC(8) label =
'USD to JPY Exchange Rate',
74 USD_EUR NUMERIC(8) label =
'USD to EUR Exchange Rate',
75 USD_BRL NUMERIC(8) label =
'USD to BRL Exchange Rate',
76 USD_CNH NUMERIC(8) label =
'USD to CNH Exchange Rate',
77 USD_KRW NUMERIC(8) label =
'USD to KRW Exchange Rate',
78 USD_TWD NUMERIC(8) label =
'USD to TWD Exchange Rate',
79 USD_AUD NUMERIC(8) label =
'USD to AUD Exchange Rate',
80 USD_HKD NUMERIC(8) label =
'USD to HKD Exchange Rate',
81 EUR_USD NUMERIC(8) label =
'EUR to USD Exchange Rate',
82 equity_440_hk NUMERIC(8) label =
'Equity 440 HK',
83 equity_173_hk NUMERIC(8) label =
'Equity 173 HK',
84 usd1mlib NUMERIC(8) label =
'USD 1 Month LIBOR Rate',
85 usd3mlib NUMERIC(8) label =
'USD 3 Month LIBOR Rate',
86 usd6mlib NUMERIC(8) label =
'USD 6 Month LIBOR Rate',
87 usd1ylib NUMERIC(8) label =
'USD 1 Year LIBOR Rate',
88 usd2ylib NUMERIC(8) label =
'USD 2 Year LIBOR Rate',
89 usd3ylib NUMERIC(8) label =
'USD 3 Year LIBOR Rate',
90 usd5ylib NUMERIC(8) label =
'USD 5 Year LIBOR Rate',
91 usd10ylib NUMERIC(8) label =
'USD 10 Year LIBOR Rate',
92 usd15ylib NUMERIC(8) label =
'USD 15 Year LIBOR Rate',
93 usd20ylib NUMERIC(8) label =
'USD 20 Year LIBOR Rate',
94 usd30ylib NUMERIC(8) label =
'USD 30 Year LIBOR Rate',
95 jpy1mlib NUMERIC(8) label =
'JPY 1 Month LIBOR Rate',
96 jpy3mlib NUMERIC(8) label =
'JPY 3 Month LIBOR Rate',
97 jpy6mlib NUMERIC(8) label =
'JPY 6 Month LIBOR Rate',
98 jpy1ylib NUMERIC(8) label =
'JPY 1 Year LIBOR Rate',
99 jpy2ylib NUMERIC(8) label =
'JPY 2 Year LIBOR Rate',
100 jpy3ylib NUMERIC(8) label =
'JPY 3 Year LIBOR Rate',
101 jpy5ylib NUMERIC(8) label =
'JPY 5 Year LIBOR Rate',
102 jpy10ylib NUMERIC(8) label =
'JPY 10 Year LIBOR Rate',
103 jpy15ylib NUMERIC(8) label =
'JPY 15 Year LIBOR Rate',
104 jpy20ylib NUMERIC(8) label =
'JPY 20 Year LIBOR Rate',
105 jpy30ylib NUMERIC(8) label =
'JPY 30 Year LIBOR Rate',
106 eur1mlib NUMERIC(8) label =
'EUR 1 Month LIBOR Rate',
107 eur3mlib NUMERIC(8) label =
'EUR 3 Month LIBOR Rate',
108 eur6mlib NUMERIC(8) label =
'EUR 6 Month LIBOR Rate',
109 eur1ylib NUMERIC(8) label =
'EUR 1 Year LIBOR Rate',
110 eur2ylib NUMERIC(8) label =
'EUR 2 Year LIBOR Rate',
111 eur3ylib NUMERIC(8) label =
'EUR 3 Year LIBOR Rate',
112 eur5ylib NUMERIC(8) label =
'EUR 5 Year LIBOR Rate',
113 eur10ylib NUMERIC(8) label =
'EUR 10 Year LIBOR Rate',
114 eur15ylib NUMERIC(8) label =
'EUR 15 Year LIBOR Rate',
115 eur20ylib NUMERIC(8) label =
'EUR 20 Year LIBOR Rate',
116 eur30ylib NUMERIC(8) label =
'EUR 30 Year LIBOR Rate',
117 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, _DATE_, SIMULATIONREPLICATION, SIMULATIONTIME)