CI_POT_DIM_PROF_MERGED_VERO_FINAL_AGGREGATE

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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