CI_POT_FCT_PROFITABILITY_RETENTION_COMBINED_AAMI_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(4) 4
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(4) 4
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 GIPE_EXPECTED_CLAIMS NUMERIC(38,6) 19
26 GIPE_PREMIUMBASE NUMERIC(38,6) 19
27 GWP DOUBLE PRECISION 8
28 ICAGROUP CHARACTER VARYING(200) 200
29 ITR_CALC DOUBLE PRECISION 8
30 LIAB_SUMINS_BAND CHARACTER VARYING(200) 200
31 LIAB_TURNOVER_BAND CHARACTER VARYING(200) 200
32 LSP_FLAG CHARACTER VARYING(1) 1
33 MGT_SUMINS_BAND CHARACTER VARYING(200) 200
34 NN_ULTIMATE_CATASTROPHE DOUBLE PRECISION 8
35 NN_ULTIMATE_LARGE DOUBLE PRECISION 8
36 NN_ULTIMATE_TOTAL DOUBLE PRECISION 8
37 NN_ULTIMATE_WORKING DOUBLE PRECISION 8
38 NNINCURRED DOUBLE PRECISION 8
39 NNINCURRED_CATASTROPHE DOUBLE PRECISION 8
40 NNINCURRED_LARGE DOUBLE PRECISION 8
41 NNINCURRED_TOTAL DOUBLE PRECISION 8
42 NNINCURRED_WORKING DOUBLE PRECISION 8
43 OCCUPATION_GROUPS CHARACTER VARYING(200) 200
44 ORIGINAL_GWP DOUBLE PRECISION 8
45 PACKAGETYPE CHARACTER VARYING(200) 200
46 POSTCODE CHARACTER VARYING(200) 200
47 PRODUCT_TYPE CHARACTER VARYING(200) 200
48 PYRENEW_GWP DOUBLE PRECISION 8
49 PYRENEW_GWP_COUNT NUMERIC(38,0) 19
50 PYTOTAL DOUBLE PRECISION 8
51 PYTOTALGWP DOUBLE PRECISION 8
52 PYTOTALGWP_COUNT NUMERIC(38,0) 19
53 PYTOTALPOLICY DOUBLE PRECISION 8
54 RISK_STATE CHARACTER VARYING(200) 200
55 RISKCOUNT NUMERIC(38,0) 19
56 SALESDISC_NB DOUBLE PRECISION 8
57 SALESDISC_NB_DISC_POLICIES DOUBLE PRECISION 8
58 SALESDISC_NB_POLICIES DOUBLE PRECISION 8
59 SALESDISC_RENEWAL DOUBLE PRECISION 8
60 SALESDISC_RENEWAL_DISC_POLICIES DOUBLE PRECISION 8
61 SALESDISC_RENEWAL_POLICIES DOUBLE PRECISION 8
62 SELECT CHARACTER VARYING(200) 200
63 SI_BURGLARY_BAND CHARACTER VARYING(50) 50
64 SI_MACHINERY_BAND CHARACTER VARYING(200) 200
65 SI_MONEY_BAND CHARACTER VARYING(200) 200
66 SUB_OCCUPATIONS CHARACTER VARYING(200) 200
67 TIER CHARACTER VARYING(200) 200
68 VEHICLE_AGE CHARACTER VARYING(200) 200
69 VIRTUAL_PRODUCT CHARACTER VARYING(200) 200
70 WEIGHT CHARACTER VARYING(200) 200