36CREATE TABLE &LIBREF..COLLATERAL (
37 REPORTING_DT DATE label =
'Reporting Date' FORMAT = &DTFMT.,
38 INSTID VARCHAR(64) label =
'Instrument Identifier',
39 ENTITY_ID VARCHAR(32) label =
'Entity ID',
40 WORKGROUP VARCHAR(32) label =
'Workgroup',
41 INSTTYPE VARCHAR(32) label =
'Instrument Type',
42 COUNTERPARTYID VARCHAR(32) label =
'Counterparty Id',
43 POOL_FLG VARCHAR(5) label =
'Data Pool Flag',
44 EXPOSURE_KEY_SPREADTYPE VARCHAR(16) label =
'Exposure Spread Type',
45 EXPOSURE_KEY_DISCOUNTTYPE VARCHAR(16) label =
'Exposure Discounting Method',
46 GUARANTEE_VALUE NUMERIC(8) label =
'Guarantee Value',
47 PHYSICAL_ASSET_VALUE NUMERIC(8) label =
'Physical Asset Value',
48 MITIGANT NUMERIC(8) label =
'Mitigant Flag',
49 COLLATERAL NUMERIC(8) label =
'Collateral Flag',
50 RANDOMSEED NUMERIC(8) label =
'Random Seed Number',
51 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, ENTITY_ID, INSTID)