MCFD_CLAIM_SETTLEMENT_HOME_PI

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND CHARACTER VARYING(256) 256
2 CLAIMID BIGINT 8
5 POLICYTYPE CHARACTER VARYING(256) 256
6 LOSSTYPE CHARACTER VARYING(256) 256
7 PRODUCT CHARACTER VARYING(256) 256
8 COVERTYPE CHARACTER VARYING(19) 19
9 RISKREGION CHARACTER VARYING(8) 8
10 RISKSTATE CHARACTER VARYING(50) 50
11 ITEMACTION CHARACTER VARYING(21) 21
12 LOSSDATE TIMESTAMP 8
13 LODGEDDATE TIMESTAMP 8
14 ACTUAL_COMPLETION_DATE DATE 4
15 FIRST_CLOSED_DATE TIMESTAMP 8
16 CLOSEDATE TIMESTAMP 8
17 SURVEY_DUE_DATE DATE 4
18 CLAIM_LIFE_LODGE_TO_FIRST_CLOSE INTEGER 4
19 CLAIM_LIFE_LODGE_TO_FULFILLMENT INTEGER 4
20 FULFILLMENT_TO_FIRST_CLOSE INTEGER 4
21 CLAIM_STATUS CHARACTER VARYING(256) 256
22 CATASTROPHE_CODE CHARACTER VARYING(256) 256
23 MAIN_REPAIRER_ID BIGINT 8
24 MAIN_REPAIRER CHARACTER VARYING(181) 181
25 MAIN_REPAIRER_LOCATION CHARACTER VARYING(256) 256
26 MAIN_SUPPLIER_ID BIGINT 8
27 MAIN_SUPPLIER CHARACTER VARYING(181) 181
28 MAIN_SUPPLIER_LOCATION CHARACTER VARYING(256) 256
29 ASSESSOR_ID BIGINT 8
31 ASSESSOR_LOCATION CHARACTER VARYING(256) 256
33 LOSS_SUB_CAUSE CHARACTER VARYING(256) 256
34 GROSS_CLAIMS_COST NUMERIC(18,2) 19
35 CLAIMS_COST_LESS_MANAGEMENT_COST NUMERIC(38,2) 19
36 CLIENT_MANAGER_ID BIGINT 8
37 INSUREDAMOUNT NUMERIC(38,2) 19
38 REOPENED_FLAG CHARACTER VARYING(3) 3
39 HOW_REPORTED CHARACTER VARYING(256) 256
40 CCR_CC_CLAIM_REOPENDATE TIMESTAMP 8
41 MEDIA_SENSITIVITY CHARACTER VARYING(256) 256
42 FATALITY CHARACTER VARYING(256) 256
43 LITIGATION CHARACTER VARYING(256) 256
44 PERSONAL_INJURY CHARACTER VARYING(256) 256
45 SIUSTATUS CHARACTER VARYING(50) 50
46 CLOSED_OUTCOME CHARACTER VARYING(50) 50
47 SC_CLOSED_OUTCOME CHARACTER VARYING(50) 50
48 REPORTONLY CHARACTER VARYING(256) 256
49 CLAIM_STATE CHARACTER VARYING(256) 256
50 CLAIM_CLOSE_REASON CHARACTER VARYING(256) 256
51 CLAIM_DECISION CHARACTER VARYING(50) 50
52 OPEN_RESERVES NUMERIC(18,2) 19
53 CASH_SETTLEMENT_DATE DATE 4
54 REPAIR_COMPLETED_DATE DATE 4
55 SUPPLY_COMPLETED_DATE DATE 4
56 TIMESTAMP TIMESTAMP 8