| 1 |
CLAIMNUMBER |
CHARACTER VARYING(40) |
40 |
| 2 |
MATTERID |
BIGINT |
8 |
| 3 |
LEGALSERVICEPROVIDER |
CHARACTER VARYING(64) |
64 |
| 4 |
IMATTER_TYPE_OF_INSTRUCTION |
CHARACTER VARYING(250) |
250 |
| 5 |
IMATTER_MATTER_COMPLEXITY |
CHARACTER VARYING(250) |
250 |
| 6 |
IMATTER_STATUS_REASON |
CHARACTER VARYING(250) |
250 |
| 7 |
RELATED_SETTLEMENT_PARTY |
CHARACTER VARYING(120) |
120 |
| 8 |
RELATED_RECOVERY_PARTY |
CHARACTER VARYING(120) |
120 |
| 9 |
CREATE_MONTH |
TIMESTAMP |
8 |
| 10 |
CREATE_DATE |
DATE |
4 |
| 11 |
CLOSED_DATE |
DATE |
4 |
| 12 |
AVG_AGE |
INTEGER |
4 |
| 13 |
CLOSED_MONTH |
TIMESTAMP |
8 |
| 14 |
LITIGATION_OWNER |
CHARACTER VARYING(181) |
181 |
| 15 |
ORIGINATING_TP |
CHARACTER VARYING(128) |
128 |
| 16 |
TP_SOLICITOR |
CHARACTER VARYING(128) |
128 |
| 17 |
SOLICITOR_ASSOCIATED |
CHARACTER VARYING(181) |
181 |
| 18 |
OUTCOME |
CHARACTER VARYING(256) |
256 |
| 19 |
DEMAND_SOL_AMT |
NUMERIC(38,2) |
19 |
| 20 |
NEGOTIATED_SOL_AMT |
NUMERIC(38,2) |
19 |
| 21 |
FINALISED_DATE |
DATE |
4 |
| 22 |
LOSS_CCR_CC_ADDRESS_REGION_NAME |
CHARACTER VARYING(15) |
15 |
| 23 |
LOSS_TYPE_NAME |
CHARACTER VARYING(256) |
256 |
| 24 |
CCR_CC_POLICY_SC_LINEOFBUSINESS_NAME |
CHARACTER VARYING(256) |
256 |
| 25 |
LEGAL_COSTS |
NUMERIC(38,2) |
19 |
| 26 |
DEMAND_RECEIVED_AMOUNT |
NUMERIC(38,2) |
19 |
| 27 |
SETTLEMENT_AMOUNT |
NUMERIC(38,2) |
19 |
| 28 |
SETTLEMENT_OWNER |
CHARACTER VARYING(181) |
181 |
| 29 |
SETTLEMENT_OWNER_TEAM |
CHARACTER VARYING(100) |
100 |
| 30 |
DEMAND_SENT_AMOUNT |
NUMERIC(38,2) |
19 |
| 31 |
RECOVERY_AMOUNT |
NUMERIC(38,2) |
19 |
| 32 |
INSURED_PAYMENTS |
NUMERIC(38,2) |
19 |
| 33 |
CLAIM_ASSIGNED_TEAM_NAME |
CHARACTER VARYING(100) |
100 |
| 34 |
CLAIM_RECOVERY |
NUMERIC(38,2) |
19 |
| 35 |
REC_RATE |
NUMERIC(38,6) |
19 |
| 36 |
SET_RATE |
NUMERIC(38,6) |
19 |
| 37 |
GROUPNAME |
CHARACTER VARYING(100) |
100 |