28CREATE TABLE &LIBREF..MITIGATION (
29 REPORTING_DT DATE label =
'Reporting Date' FORMAT = &DTFMT.,
30 EXPOSUREID VARCHAR(64) label =
'Exposure Identifier',
31 MITIGANTID VARCHAR(64) label =
'Collateral Identifier',
32 MITIGATIONTYPE VARCHAR(32) label =
'Mitigation Type',
33 LEGAL_PROTECTION_AMT NUMERIC(8) label =
'Legal Protection Amount',
34 EXPOSURE_RANK NUMERIC(8) label =
'Exposure Rank',
35 MITIGATION_RANK NUMERIC(8) label =
'Mitigation Rank',
36 MITIGATION_HAIRCUT_FACTOR NUMERIC(8) label =
'Haircut Mitigation Factor',
37 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, EXPOSUREID, MITIGANTID)