38CREATE TABLE &LIBREF..COUNTERPARTY (
39 REPORTING_DT DATE label =
'Reporting Date' FORMAT = &DTFMT.,
40 COUNTERPARTYID VARCHAR(32) label =
'Counterparty Id',
41 COUNTERPARTYTYPE VARCHAR(100) label =
'Counterparty Type',
42 SECTOR_DESC VARCHAR(100) label =
'Sector Description',
43 DEBT_TO_INCOME_RT NUMERIC(8) label =
'Debt-To-Income Ratio',
44 DELINQUENCY_FLG VARCHAR(3) label =
'Delinquency Flag',
45 EVER_DELINQUENT_FLG VARCHAR(3) label =
'Ever Delinquent Flag',
46 MOST_RECENT_DELINQUENCY_DT DATE label =
'Most Recent Delinquency Date' FORMAT = &DTFMT.,
47 FINANCIAL_DIFFICULTIES_FLG VARCHAR(3) label =
'Financial Difficulties Flag',
48 RATING_AGENCY VARCHAR(32) label =
'Rating Agency',
49 RATING_GRADE VARCHAR(32) label =
'Rating Grade',
50 STD_RATING_GRADE VARCHAR(32) label =
'Standardised Rating Grade',
51 TTC_PD NUMERIC(8) label =
'TTC PD',
52 PIT_PD NUMERIC(8) label =
'PIT PD',
53 CORPORATE_Mf_MODEL_ID VARCHAR(32) label =
'Multi-Factor Structure Model ID',
54 CORPORATE_RES_MODEL_ID VARCHAR(32) label =
'Multi-Factor Residual Model ID',
55 NO_OF_STATES NUMERIC(8) label =
'State Number for EC SimBased Model',
56 MOD_PARMS_ADJ NUMERIC(8) label =
'Multi-Factor Standardization Constant',
57 POOL_FLG VARCHAR(5) label =
'Data Pool Flag',
58 RANDOMSEED NUMERIC(8) label =
'Random Seed Number',
59 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, COUNTERPARTYID)