INT_PROF_MERGED_VERO_BASE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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