33create table &libref..CAPITAL_ADEQUACY_SUMMARY(
34 ANALYSIS_RUN_ID NUMERIC(8) label =
"Analysis Run Id",
35 ANALYSIS_RUN_NAME VARCHAR(150) label =
"Analysis Run Name",
36 LOAD_ID VARCHAR(32) label =
'Load Id',
37 ENTITY_ID VARCHAR(32) label =
'Entity',
38 WORKGROUP VARCHAR(32) label =
'Workgroup',
39 PROJECT_NAME VARCHAR(64) label =
'Project Name',
40 RISK_TYPE VARCHAR(50) label =
'Risk Type',
41 REPORTING_DT DATE label =
"Reporting Date" FORMAT = yymmddd10.,
42 SCENARIO_NAME VARCHAR(512) label =
'Scenario Name',
43 FORECAST_PERIOD VARCHAR(32) label =
'Forecast Period',
44 MEASURE_TYPE VARCHAR(32) label =
'Measure Type',
45 MEASURE_VALUE NUMERIC(8) label =
'Measure Value' FORMAT = comma25.2,
46 REG_CAP_VALUE NUMERIC(8) label =
'Regulatory Capital (Own Capital) Value' FORMAT = comma25.2,
47 CAP_REQ_STD_VALUE NUMERIC(8) label =
'Capital Required (Standardized) Value' FORMAT = comma25.2,
48 SORT_ORDER NUMERIC(8) label =
'Sort Order'