CI_POT_DIM_PROF_MERGED_COGEN_GIO_FINAL_AGGREGATE

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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