FCT_CI_WEEKLY_SNAPSHOT_DRILLTHRU

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 EXPOSURE_ID BIGINT 8
2 EXPOSURE_NUMBER BIGINT 8
3 CLAIM_NUMBER CHARACTER VARYING(40) 40
4 DAY_OF_THE_WEEK CHARACTER VARYING(9) 9
5 BRAND_ID BIGINT 8
6 POLICY_NUMBER CHARACTER VARYING(40) 40
7 BRAND_NAME CHARACTER VARYING(256) 256
8 POLICYTYPE_ID BIGINT 8
9 POLICY_NAME CHARACTER VARYING(256) 256
10 TEAM_NAME CHARACTER VARYING(100) 100
11 SI_ESCALATE_SIU BIGINT 8
12 SIESCALATESIU_DESCRIPTION CHARACTER VARYING(256) 256
13 CATASTROPHE_ID BIGINT 8
14 CATASTROPHE_DESCRIPTION CHARACTER VARYING(60) 60
15 LITIGATION_INDICATOR CHARACTER VARYING(3) 3
16 RECOVERY_STATUS CHARACTER VARYING(14) 14
17 EXCESS_RECOVERY_STATUS CHARACTER VARYING(14) 14
18 SALVAGE_RECOVERY_STATUS CHARACTER VARYING(14) 14
19 DEBT_RECOVERY_STATUS CHARACTER VARYING(14) 14
20 SETTLEMENT_FLAG CHARACTER VARYING(3) 3
21 STATUS CHARACTER VARYING(16) 16
22 EXPOSURE_CREATE_DATE TIMESTAMP 8
23 INCIDENT_LODGEMENT_DATE TIMESTAMP 8
24 EXPOSURE_UPDATE_TIME TIMESTAMP 8
25 EXPOSURE_ASSIGNMENT_DATE TIMESTAMP 8
26 CLAIM_STATE CHARACTER VARYING(6) 6
27 EXPOSURE_STATE CHARACTER VARYING(6) 6
28 EXPOSURE_CREATE_USER_ID BIGINT 8
29 EXPOSURE_CREATE_USER_NAME CHARACTER VARYING(181) 181
30 EXPOSURE_ASSIGNED_USER_ID BIGINT 8
31 EXPOSURE_ASSIGNED_USER_NAME CHARACTER VARYING(181) 181
32 EXPOSURE_CLOSE_DATE TIMESTAMP 8
33 EXPOSURE_REOPENED_DATE TIMESTAMP 8
34 EXPOSURE_DECISION_EXT BIGINT 8
35 EXPOSURE_DECISION_NAME CHARACTER VARYING(256) 256
36 EXPOSURE_SEGMENT BIGINT 8
37 EXPOSURE_SEGMENT_NAME CHARACTER VARYING(256) 256
38 ASSIGNED_BY_USER_ID BIGINT 8
39 ASSIGNED_GROUP_ID BIGINT 8
40 CLAIM_ID BIGINT 8
41 LITIGATION_MATTER CHARACTER VARYING(6) 6
42 EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
43 CLAIM_LOSS_DATE TIMESTAMP 8
44 CLAIM_LOSS_DATE_ID BIGINT 8
45 CLAIM_LOSS_DATE_DAY CHARACTER VARYING(9) 9
46 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17
47 WEEK_ID BIGINT 8