FCT_PI_HOME_CLAIM_MANAGEMENT_PORTAL_INSIGHT_TWB_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 MEASURE CHARACTER VARYING(22) 22
2 REPORT_TYPE CHARACTER VARYING(9) 9
3 REPORT_TIMING CHARACTER VARYING(214) 214
4 REPORT_GROUP CHARACTER VARYING(60) 60
5 REPORT_GROUP1 CHARACTER VARYING(100) 100
6 REPORT_GROUP2 CHARACTER VARYING(100) 100
7 BRAND CHARACTER VARYING(256) 256
8 RISK_STATE_NAME CHARACTER VARYING(256) 256
9 LOSSCAUSE_MGMT CHARACTER VARYING(256) 256
10 OP_LOB CHARACTER VARYING(256) 256
11 LOSS_GROUP CHARACTER VARYING(50) 50
12 MAX_COMMIT_TIMESTAMP DATE 4
13 START_MONTH CHARACTER VARYING(200) 200
14 END_MONTH CHARACTER VARYING(200) 200
15 NEW_CLAIM_COUNT NUMERIC(38,25) 19
16 PCP_NEW_CLAIM_COUNT NUMERIC(38,21) 19
17 OP_NET_INCURRED_EX_GST NUMERIC(38,25) 19
18 OP_NET_INCURRED_EX_GST_1 NUMERIC(38,6) 19
19 PCP_OP_NET_INCURRED_EX_GST NUMERIC(38,25) 19
20 PCP_OP_NET_INCURRED_EX_GST_1 NUMERIC(38,6) 19
21 NET_MOVEMENT_COUNT NUMERIC(38,0) 19
22 FIN_NET_INCURRED_EX_GST NUMERIC(38,4) 19
23 PCP_NET_MOVEMENT_COUNT NUMERIC(38,19) 19
24 NET_INCURRED_EX_GST NUMERIC(38,6) 19
25 PCP_NET_INCURRED_EX_GST NUMERIC(38,6) 19
26 PCP_FIN_NET_INCURRED_EX_GST NUMERIC(38,4) 19
27 FULFILLED_CLAIM_LIFE NUMERIC(38,0) 19
28 FULFILLED_CLAIM_COUNT NUMERIC(38,0) 19
29 PCP_FULFILLED_CLAIM_COUNT NUMERIC(38,6) 19
30 PCP_FULFILLED_CLAIM_LIFE NUMERIC(38,6) 19
31 PRIOR_NEW_CLAIM_COUNT NUMERIC(38,25) 19
32 PRIOR_OP_NET_INCURRED_EX_GST NUMERIC(38,25) 19
33 PRIOR_NET_MOVEMENT_COUNT NUMERIC(38,6) 19
34 PRIOR_NET_INCURRED_EX_GST NUMERIC(38,6) 19
35 PRIOR_FULFILLED_CLAIM_COUNT NUMERIC(38,6) 19
36 PRIOR_FULFILLED_CLAIM_LIFE NUMERIC(38,6) 19
37 PRIOR_FIN_NET_INCURRED_EX_GST NUMERIC(38,4) 19