CI_POT_FCT_PROFITABILITY_RETENTION_COMBINED_COGEN_GIO_AGGREGATE_ROWCOUNT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BDM_NAME CHARACTER VARYING(200) 200
2 BDM_STATE CHARACTER VARYING(200) 200
3 BI_SUMINS_BAND CHARACTER VARYING(200) 200
4 BRAND CHARACTER VARYING(30) 30
5 BROKERS CHARACTER VARYING(200) 200
6 CANCELLEDPOLICIES_TOTAL DOUBLE PRECISION 8
7 CLAIM_SIZE_CATASTROPHE NUMERIC(38,0) 19
8 CLAIM_SIZE_LARGE NUMERIC(38,0) 19
9 CLAIM_SIZE_WORKING NUMERIC(38,0) 19
10 CLAIMNUMBER CHARACTER VARYING(50) 50
11 CLUSTER CHARACTER VARYING(200) 200
12 COMPANY CHARACTER VARYING(50) 50
13 COVERAGECHGEFFECTDATE DATE 4
14 CYPOLICYRENEWAL DOUBLE PRECISION 8
15 CYRENEW DOUBLE PRECISION 8
16 CYRENEW_GWP DOUBLE PRECISION 8
17 CYTOTALRISKCOUNT DOUBLE PRECISION 8
18 DATASET CHARACTER VARYING(5) 5
19 DISC DOUBLE PRECISION 8
20 DRIVERS_AGE CHARACTER VARYING(200) 200
21 EARNEDUNITS DOUBLE PRECISION 8
22 EXCESS CHARACTER VARYING(200) 200
23 FL_NEWRENEW CHARACTER VARYING(50) 50
24 GEP DOUBLE PRECISION 8
25 GIO_CHANNELS CHARACTER VARYING(200) 200
26 GIPE_EXPECTED_CLAIMS NUMERIC(38,6) 19
27 GIPE_PREMIUMBASE NUMERIC(38,6) 19
28 GWP DOUBLE PRECISION 8
29 ICAGROUP CHARACTER VARYING(200) 200
30 ITR_CALC DOUBLE PRECISION 8
31 LIAB_SUMINS_BAND CHARACTER VARYING(200) 200
32 LIAB_TURNOVER_BAND CHARACTER VARYING(200) 200
33 LSP_FLAG CHARACTER VARYING(25) 25
34 MGT_SUMINS_BAND CHARACTER VARYING(200) 200
35 NN_ULTIMATE_CATASTROPHE DOUBLE PRECISION 8
36 NN_ULTIMATE_LARGE DOUBLE PRECISION 8
37 NN_ULTIMATE_TOTAL DOUBLE PRECISION 8
38 NN_ULTIMATE_WORKING DOUBLE PRECISION 8
39 NNINCURRED DOUBLE PRECISION 8
40 NNINCURRED_CATASTROPHE DOUBLE PRECISION 8
41 NNINCURRED_LARGE DOUBLE PRECISION 8
42 NNINCURRED_TOTAL DOUBLE PRECISION 8
43 NNINCURRED_WORKING DOUBLE PRECISION 8
44 OCCUPATION_GROUPS CHARACTER VARYING(200) 200
45 ORIGINAL_GWP DOUBLE PRECISION 8
46 PACKAGETYPE CHARACTER VARYING(200) 200
47 POSTCODE CHARACTER VARYING(200) 200
48 PRODUCT_TYPE CHARACTER VARYING(200) 200
49 PYRENEW_GWP DOUBLE PRECISION 8
50 PYRENEW_GWP_COUNT NUMERIC(38,0) 19
51 PYTOTAL DOUBLE PRECISION 8
52 PYTOTALGWP DOUBLE PRECISION 8
53 PYTOTALGWP_COUNT NUMERIC(38,0) 19
54 PYTOTALPOLICY DOUBLE PRECISION 8
55 RISK_STATE CHARACTER VARYING(200) 200
56 RISKCOUNT NUMERIC(38,0) 19
57 SALESDISC_NB DOUBLE PRECISION 8
58 SALESDISC_NB_DISC_POLICIES DOUBLE PRECISION 8
59 SALESDISC_NB_POLICIES DOUBLE PRECISION 8
60 SALESDISC_RENEWAL DOUBLE PRECISION 8
61 SALESDISC_RENEWAL_DISC_POLICIES DOUBLE PRECISION 8
62 SALESDISC_RENEWAL_POLICIES DOUBLE PRECISION 8
63 SELECT CHARACTER VARYING(200) 200
64 SI_BURGLARY_BAND CHARACTER VARYING(50) 50
65 SI_MACHINERY_BAND CHARACTER VARYING(200) 200
66 SI_MONEY_BAND CHARACTER VARYING(200) 200
67 STATE CHARACTER VARYING(200) 200
68 SUB_OCCUPATIONS CHARACTER VARYING(200) 200
69 TIER CHARACTER VARYING(200) 200
70 VEHICLE_AGE CHARACTER VARYING(200) 200
71 VIRTUAL_PRODUCT CHARACTER VARYING(200) 200
72 WEIGHT CHARACTER VARYING(200) 200