CI_POT_FCT_PROFITABILITY_RETENTION_COMBINED_AAMI

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_TABLE CHARACTER VARYING(17) 17
2 BDM_NAME CHARACTER VARYING(200) 200
3 BDM_STATE CHARACTER VARYING(200) 200
4 BI_SUMINS_BAND CHARACTER VARYING(200) 200
6 BROKERS CHARACTER VARYING(200) 200
7 CLUSTER CHARACTER VARYING(200) 200
8 COVERAGECHGEFFECTDATE TIMESTAMP 8
9 DATASET CHARACTER VARYING(4) 4
10 DRIVERS_AGE CHARACTER VARYING(200) 200
11 EXCESS CHARACTER VARYING(200) 200
12 FIRE_SUMINS_BAND CHARACTER VARYING(200) 200
13 GIO_CHANNELS CHARACTER VARYING(200) 200
14 GIPE_MINIMUM_PREMIUM_FLAG CHARACTER VARYING(200) 200
15 ICAGROUP CHARACTER VARYING(200) 200
16 LIAB_SUMINS_BAND CHARACTER VARYING(200) 200
17 LIAB_TURNOVER_BAND CHARACTER VARYING(200) 200
18 LSP_FLAG CHARACTER VARYING(1) 1
19 MGT_SUMINS_BAND CHARACTER VARYING(200) 200
20 OCCUPATION_GROUPS CHARACTER VARYING(200) 200
21 PACKAGETYPE CHARACTER VARYING(200) 200
22 POSTCODE CHARACTER VARYING(200) 200
23 PRODUCT_TYPE CHARACTER VARYING(200) 200
24 RISK_STATE CHARACTER VARYING(200) 200
25 RISKCOUNT CHARACTER VARYING(200) 200
26 SELECT CHARACTER VARYING(200) 200
27 SI_MACHINERY_BAND CHARACTER VARYING(200) 200
28 SI_MONEY_BAND CHARACTER VARYING(200) 200
29 SUB_OCCUPATIONS CHARACTER VARYING(200) 200
30 TIER CHARACTER VARYING(200) 200
31 VEHICLE_AGE CHARACTER VARYING(200) 200
32 VIRTUAL_PRODUCT CHARACTER VARYING(200) 200
33 WEIGHT CHARACTER VARYING(200) 200
34 CLAIM_SIZE CHARACTER VARYING(50) 50
35 CLAIM_SIZE_CATASTROPHE INTEGER 4
36 CLAIM_SIZE_LARGE INTEGER 4
37 CLAIM_SIZE_WORKING INTEGER 4
38 CLAIMNUMBER CHARACTER VARYING(50) 50
39 COMPANY CHARACTER VARYING(50) 50
40 DISC DOUBLE PRECISION 8
41 DISC_GWP DOUBLE PRECISION 8
42 EARNEDUNITS DOUBLE PRECISION 8
43 FL_NEWRENEW CHARACTER VARYING(50) 50
44 GEP DOUBLE PRECISION 8
45 GIPE_EXPECTED_CLAIMS NUMERIC(38,6) 19
46 GIPE_PREMIUMBASE NUMERIC(38,6) 19
47 GWP DOUBLE PRECISION 8
48 ITR_CALC DOUBLE PRECISION 8
49 NN_ULTIMATE_CATASTROPHE DOUBLE PRECISION 8
50 NN_ULTIMATE_LARGE DOUBLE PRECISION 8
51 NN_ULTIMATE_TOTAL DOUBLE PRECISION 8
52 NN_ULTIMATE_WORKING DOUBLE PRECISION 8
53 NNINCURRED DOUBLE PRECISION 8
54 NNINCURRED_CAP DOUBLE PRECISION 8
55 NNINCURRED_CATASTROPHE DOUBLE PRECISION 8
56 NNINCURRED_LARGE DOUBLE PRECISION 8
57 NNINCURRED_TOTAL DOUBLE PRECISION 8
58 NNINCURRED_WORKING DOUBLE PRECISION 8
59 OCCUPATION CHARACTER VARYING(100) 100
60 ORIGINAL_GEP DOUBLE PRECISION 8
61 ORIGINAL_GWP DOUBLE PRECISION 8
62 PERIL_TYPE CHARACTER VARYING(50) 50
63 SALESDISC_NB DOUBLE PRECISION 8
64 SALESDISC_NB_DISC_POLICIES DOUBLE PRECISION 8
65 SALESDISC_NB_POLICIES DOUBLE PRECISION 8
66 SALESDISC_RENEWAL DOUBLE PRECISION 8
67 SALESDISC_RENEWAL_DISC_POLICIES DOUBLE PRECISION 8
68 SALESDISC_RENEWAL_POLICIES DOUBLE PRECISION 8
69 SI_BURGLARY_BAND CHARACTER VARYING(50) 50
70 CANCELLEDPOLICIES_TOTAL DOUBLE PRECISION 8
71 CY_RENEWEDPOLICYCNT DOUBLE PRECISION 8
72 CYCANC_POL_NB DOUBLE PRECISION 8
73 CYCANC_POL_RENEW DOUBLE PRECISION 8
74 CYNEW_GWP DOUBLE PRECISION 8
75 CYPOLICYRENEWAL DOUBLE PRECISION 8
76 CYRENEW DOUBLE PRECISION 8
77 CYRENEW_GWP DOUBLE PRECISION 8
78 CYTOTALGWP DOUBLE PRECISION 8
79 CYTOTALPOLICY DOUBLE PRECISION 8
80 CYTOTALRISKCOUNT DOUBLE PRECISION 8
81 MONTH BIGINT 8
82 PYPOLICY_NEW DOUBLE PRECISION 8
83 PYPOLICY_RENEW DOUBLE PRECISION 8
84 PYRENEW_GWP DOUBLE PRECISION 8
85 PYTOTAL DOUBLE PRECISION 8
86 PYTOTALGWP DOUBLE PRECISION 8
87 PYTOTALPOLICY DOUBLE PRECISION 8
88 SALESMGR CHARACTER VARYING(200) 200
89 STATE CHARACTER VARYING(200) 200
90 YEAR BIGINT 8