INT_CI_WEEKLY_SNAPSHOT_BASE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CREATE_DATE TIMESTAMP 8
2 UPDATE_TIME TIMESTAMP 8
3 LAST_REOPENED_DATE TIMESTAMP 8
4 FINALISED_DATE TIMESTAMP 8
5 EXPOSURE_STATE_ID BIGINT 8
6 CLAIM_STATE_ID BIGINT 8
7 CLAIM_STATE_NAME CHARACTER VARYING(256) 256
8 EXPOSURE_STATE_NAME CHARACTER VARYING(256) 256
9 EXPOSURE_ID BIGINT 8
10 ASSIGNEDBYUSERID BIGINT 8
11 ASSIGNEDGROUPID BIGINT 8
12 CLM_ASSIGNEDGROUPID BIGINT 8
13 POLICYTYPE_ID BIGINT 8
14 BRAND_ID BIGINT 8
15 POLICY_NUMBER CHARACTER VARYING(40) 40
16 CLAIM_ID BIGINT 8
17 SIESCALATESIU BIGINT 8
18 CATASTROPHE_ID BIGINT 8
19 LITIGATION_MATTER CHARACTER VARYING(6) 6
20 CLAIM_ORDER BIGINT 8
21 CLAIMNUMBER CHARACTER VARYING(40) 40
22 EXPOSURE_CREATE_TIME TIMESTAMP 8
23 EXPOSURE_ASSIGNMENT_DATE TIMESTAMP 8
24 EXPOSURE_CREATE_USER_ID BIGINT 8
25 EXPOSURE_ASSIGNED_USER_ID BIGINT 8
26 EXPOSURE_DECISION_EXT BIGINT 8
27 EXPOSURE_SEGMENT BIGINT 8
28 CLAIM_LOSS_DATE TIMESTAMP 8
29 RECOVERY_STATUS CHARACTER VARYING(14) 14
30 SETTLEMENT_FLAG CHARACTER VARYING(3) 3
31 EXCESS_RECOVERY_STATUS CHARACTER VARYING(14) 14
32 SALVAGE_RECOVERY_STATUS CHARACTER VARYING(14) 14
33 DEBT_RECOVERY_STATUS CHARACTER VARYING(14) 14
34 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17
35 DOW_ID BIGINT 8
36 DAY_NAME_NEW CHARACTER VARYING(9) 9
37 DOW_ID_REOPEN BIGINT 8
38 DAY_NAME_REOPEN CHARACTER VARYING(9) 9
39 DOW_ID_CLOSE BIGINT 8
40 DAY_NAME_CLOSE CHARACTER VARYING(9) 9