INT_XAMP_VERO_PROF_MERGED

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT1 CHARACTER VARYING(30) 30
2 BDM_NAME CHARACTER VARYING(70) 70
3 BDM_STATE CHARACTER VARYING(50) 50
4 BI_SUMINS_BAND CHARACTER VARYING(40) 40
5 BRAND CHARACTER VARYING(30) 30
6 BROKERS CHARACTER VARYING(220) 220
7 CANC_FT_CNT DOUBLE PRECISION 8
8 CANC_MT_CNT DOUBLE PRECISION 8
9 CLAIMNUMBER CHARACTER VARYING(12) 12
10 CLASS CHARACTER VARYING(23) 23
11 CLOSE_ACCT CHARACTER VARYING(30) 30
12 CLUSTER CHARACTER VARYING(46) 46
13 COMPANY INTEGER 4
14 COVCHGEXPDATE DATE 4
15 COVERAGECHGEFFECTDATE DATE 4
16 COVERAGECHGEXPIRYDATE DATE 4
17 COVERAGEKEY DOUBLE PRECISION 8
18 COVERAGERENEWEDDATE DATE 4
19 COVRENEWEDDATE DATE 4
20 DATEOCCURRED DATE 4
21 DISC DOUBLE PRECISION 8
22 DISC_GWP DOUBLE PRECISION 8
23 DRIVERS_AGE CHARACTER VARYING(80) 80
24 EXCESS DOUBLE PRECISION 8
25 FIRE_SUMINS_BAND CHARACTER VARYING(40) 40
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 INSTALFRQ CHARACTER VARYING(21) 21
32 INFORCEINCDATE DATE 4
33 INFORCEEXPDATE DATE 4
34 ITEMNO BIGINT 8
35 LARGE_THRESHHOLD DOUBLE PRECISION 8
36 LIAB_SUMINS_BAND CHARACTER VARYING(40) 40
37 LIAB_TURNOVER_BAND CHARACTER VARYING(40) 40
38 LOB CHARACTER VARYING(22) 22
39 LSP_FLAG CHARACTER VARYING(25) 25
40 MGT_SUMINS_BAND CHARACTER VARYING(40) 40
41 NNINCURRED DOUBLE PRECISION 8
42 NNINCURRED_CAP DOUBLE PRECISION 8
43 NNINCURRED_XOL DOUBLE PRECISION 8
44 OCCUPATION CHARACTER VARYING(100) 100
45 OCCUPATION_GROUPS CHARACTER VARYING(67) 67
46 ORIGINAL_GWP DOUBLE PRECISION 8
47 POLICY_COUNT DOUBLE PRECISION 8
48 POLICYEFFECTIVEDATE DATE 4
49 POLICYINCEPTDATE DATE 4
50 POLICYNUMBER CHARACTER VARYING(32) 32
51 POST_CODE DOUBLE PRECISION 8
52 POSTCODE DOUBLE PRECISION 8
53 PRINTTYPE CHARACTER VARYING(21) 21
54 PRODUCT_TYPE CHARACTER VARYING(80) 80
55 PRVPOLREF CHARACTER VARYING(34) 34
56 RISK_STATE CHARACTER VARYING(32) 32
57 RISKCOUNT DOUBLE PRECISION 8
58 RISKCOUNTRP DOUBLE PRECISION 8
59 RISKSTATE CHARACTER VARYING(22) 22
60 SALES_STATE CHARACTER VARYING(23) 23
61 SALESMGR CHARACTER VARYING(70) 70
62 SELECT CHARACTER VARYING(23) 23
63 SI_BURGLARY_BAND CHARACTER VARYING(40) 40
64 SI_GENPROP_BAND CHARACTER VARYING(35) 35
65 SI_GLASS_BAND CHARACTER VARYING(35) 35
66 SI_MACHINERY_BAND CHARACTER VARYING(40) 40
67 SI_MONEY_BAND CHARACTER VARYING(40) 40
68 SI_MOTOR_BAND CHARACTER VARYING(80) 80
69 SI_PERSONACC_BAND CHARACTER VARYING(35) 35
70 SI_TAX_BAND CHARACTER VARYING(35) 35
71 SPCODE CHARACTER(2) 2
72 STATE CHARACTER VARYING(23) 23
73 SUB_OCCUPATIONS CHARACTER VARYING(122) 122
74 SUBCLASS CHARACTER VARYING(23) 23
75 TIER CHARACTER VARYING(26) 26
76 TYPE CHARACTER VARYING(31) 31
77 TOTAL_RISKCOUNT DOUBLE PRECISION 8
78 VEHAGE SMALLINT 2
79 VEHICLE_AGE CHARACTER VARYING(80) 80
80 VIRTUAL_PRODUCT CHARACTER VARYING(61) 61
81 WEIGHT CHARACTER VARYING(21) 21
82 ORIGINALPOLICY_FLAG DOUBLE PRECISION 8