INT_CI_WEEKLY_SNAPSHOT_DRILLTHRU_VIEW1

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_NAME CHARACTER VARYING(256) 256
6 CLAIM_STATE_NAME CHARACTER VARYING(256) 256
7 EXPOSURE_ID BIGINT 8
8 ASSIGNEDBYUSERID BIGINT 8
9 ASSIGNEDGROUPID BIGINT 8
10 POLICYTYPE_ID BIGINT 8
11 BRAND_ID BIGINT 8
12 POLICY_NUMBER CHARACTER VARYING(40) 40
13 CLAIM_ID BIGINT 8
14 SIESCALATESIU BIGINT 8
15 CATASTROPHE_ID BIGINT 8
16 LITIGATION_MATTER CHARACTER VARYING(6) 6
17 RECOVERY_STATUS CHARACTER VARYING(14) 14
18 EXCESS_RECOVERY_STATUS CHARACTER VARYING(14) 14
19 SALVAGE_RECOVERY_STATUS CHARACTER VARYING(14) 14
20 DEBT_RECOVERY_STATUS CHARACTER VARYING(14) 14
21 SETTLEMENT_FLAG CHARACTER VARYING(3) 3
22 CLAIM_ORDER BIGINT 8
23 CLAIMNUMBER CHARACTER VARYING(40) 40
24 EXPOSURE_CREATE_TIME TIMESTAMP 8
25 EXPOSURE_ASSIGNMENT_DATE TIMESTAMP 8
26 EXPOSURE_CREATE_USER_ID BIGINT 8
27 EXPOSURE_ASSIGNED_USER_ID BIGINT 8
28 EXPOSURE_DECISION_EXT BIGINT 8
29 EXPOSURE_SEGMENT BIGINT 8
30 DAY_OF_THE_WEEK CHARACTER VARYING(9) 9
31 CLAIM_LOSS_DATE TIMESTAMP 8
32 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17
33 STATUS CHARACTER VARYING(16) 16
34 WEEK_ID INTEGER 4