INT_PROF_MERGED_GEP_AAMI

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TARGET_MONTH DATE 4
2 DAY_COUNT INTEGER 4
3 ACCOUNT1 CHARACTER VARYING(1) 1
4 BI_SUMINS_BAND CHARACTER VARYING(40) 40
5 BRAND CHARACTER VARYING(4) 4
6 CANC_FT_CNT DOUBLE PRECISION 8
7 CANC_MT_CNT DOUBLE PRECISION 8
8 CLASS CHARACTER VARYING(23) 23
9 CLOSE_ACCT CHARACTER VARYING(1) 1
10 COMPANY CHARACTER VARYING(3) 3
11 COVERAGECHGEXPIRYDATE DATE 4
12 COVERAGERENEWEDDATE DATE 4
13 DATASET CHARACTER VARYING(4) 4
14 DATEOCCURRED DATE 4
15 DATAPROVIDEDDATE DATE 4
16 DISC DOUBLE PRECISION 8
17 DISC_GWP DOUBLE PRECISION 8
18 DRIVERS_AGE CHARACTER VARYING(80) 80
19 EXCESS DOUBLE PRECISION 8
20 FIRE_SUMINS_BAND CHARACTER VARYING(40) 40
21 FL_NEWRENEW CHARACTER VARYING(28) 28
22 GIO_CHANNELS CHARACTER VARYING(1) 1
23 GIPE_EXPECTED_CLAIMS NUMERIC(25,6) 19
24 GIPE_MINIMUM_PREMIUM_FLAG INTEGER 4
25 GIPE_PREMIUMBASE NUMERIC(20,6) 19
26 GWP DOUBLE PRECISION 8
27 GEP DOUBLE PRECISION 8
28 INCIDENTCODE CHARACTER(3) 3
29 INSTALFRQ CHARACTER VARYING(21) 21
30 LARGE_THRESHHOLD BIGINT 8
31 LATEST_POLICY_FLAG BOOLEAN 1
32 LIAB_SUMINS_BAND CHARACTER VARYING(40) 40
33 LIAB_TURNOVER_BAND CHARACTER VARYING(40) 40
34 LOB CHARACTER VARYING(1) 1
35 LSP_FLAG CHARACTER VARYING(1) 1
36 MGT_SUMINS_BAND CHARACTER VARYING(40) 40
37 COVERAGECHGEFFECTDATE DATE 4
38 NNINCURRED DOUBLE PRECISION 8
39 NNINCURRED_CAP DOUBLE PRECISION 8
40 NNINCURRED_XOL DOUBLE PRECISION 8
41 CLAIMNUMBER CHARACTER VARYING(12) 12
42 POLICYNUMBER CHARACTER VARYING(32) 32
43 COVERAGEKEY DOUBLE PRECISION 8
44 ITEMNO INTEGER 4
45 VEHAGE SMALLINT 2
46 SPCODE CHARACTER(2) 2
47 BDM_NAME CHARACTER VARYING(1) 1
48 BDM_STATE CHARACTER VARYING(1) 1
49 BROKERS CHARACTER VARYING(1) 1
50 CLUSTER CHARACTER VARYING(1) 1
51 ICAGROUP CHARACTER VARYING(53) 53
52 OCCUPATION_GROUPS CHARACTER VARYING(67) 67
53 POSTCODE DOUBLE PRECISION 8
54 RISKCOUNT DOUBLE PRECISION 8
55 EARNEDUNITS DOUBLE PRECISION 8
56 SELECT CHARACTER VARYING(1) 1
57 SUB_OCCUPATIONS CHARACTER VARYING(80) 80
58 TIER CHARACTER VARYING(1) 1
59 TYPE CHARACTER VARYING(45) 45
60 VIRTUAL_PRODUCT CHARACTER VARYING(28) 28
61 OCCUPATION CHARACTER VARYING(100) 100
62 ORIGINAL_GEP DOUBLE PRECISION 8
63 ORIGINAL_GWP DOUBLE PRECISION 8
64 ORIGINALPOLICY_FLAG BOOLEAN 1
65 PACKAGETYPE CHARACTER VARYING(15) 15
66 PERIL_TYPE CHARACTER VARYING(12) 12
67 POLICY_COUNT DOUBLE PRECISION 8
68 POLICYINCEPTDATE DATE 4
69 PRINTTYPE CHARACTER VARYING(1) 1
70 PRODUCT_TYPE CHARACTER VARYING(65) 65
71 PRVPOLREF CHARACTER VARYING(14) 14
72 RISKSTATE CHARACTER VARYING(22) 22
73 RISK_STATE CHARACTER VARYING(32) 32
74 SALESDISC_NB DOUBLE PRECISION 8
75 SALESDISC_NB_DISC_POLICIES DOUBLE PRECISION 8
76 SALESDISC_NB_POLICIES DOUBLE PRECISION 8
77 SALESDISC_RENEWAL DOUBLE PRECISION 8
78 SALESDISC_RENEWAL_DISC_POLICIES DOUBLE PRECISION 8
79 SALESDISC_RENEWAL_POLICIES DOUBLE PRECISION 8
80 SALESMGR CHARACTER VARYING(1) 1
81 SALES_STATE CHARACTER VARYING(23) 23
82 SI_BURGLARY_BAND CHARACTER VARYING(35) 35
83 SI_GENPROP_BAND CHARACTER VARYING(35) 35
84 SI_GLASS_BAND CHARACTER VARYING(1) 1
85 SI_MACHINERY_BAND CHARACTER VARYING(35) 35
86 SI_MONEY_BAND CHARACTER VARYING(35) 35
87 SI_MOTOR_BAND CHARACTER VARYING(80) 80
88 SI_PERSONACC_BAND CHARACTER VARYING(1) 1
89 SI_TAX_BAND CHARACTER VARYING(35) 35
90 STATE CHARACTER(3) 3
91 VEHICLE_AGE CHARACTER VARYING(80) 80
92 WEIGHT CHARACTER VARYING(21) 21
93 DAY_RATIO NUMERIC(21,10) 19
94 POLICYPERIOD_MONTH BIGINT 8
95 ORIGINAL_FLAG BOOLEAN 1