INT_AAMI_PROF_MERGED

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BI_SUMINS_BAND CHARACTER VARYING(40) 40
2 CANC_FT_CNT DOUBLE PRECISION 8
3 CANC_MT_CNT DOUBLE PRECISION 8
4 CLAIMNUMBER CHARACTER VARYING(12) 12
5 CLASS CHARACTER VARYING(23) 23
6 COMPANY INTEGER 4
7 COVCHGEFFDATE DATE 4
8 COVCHGEXPDATE DATE 4
9 COVERAGEKEY DOUBLE PRECISION 8
10 COVRENEWEDDATE DATE 4
11 DATEOCCURRED DATE 4
12 DISC DOUBLE PRECISION 8
13 DISC_GWP DOUBLE PRECISION 8
14 DRIVERS_AGE CHARACTER VARYING(80) 80
15 EXCESS DOUBLE PRECISION 8
16 FIRE_SUMINS_BAND CHARACTER VARYING(40) 40
17 FL_NEWRENEW CHARACTER VARYING(28) 28
18 GWP DOUBLE PRECISION 8
19 ICAGROUP CHARACTER VARYING(53) 53
20 INCIDENTCODE CHARACTER(3) 3
21 INFORCEEXPDATE DATE 4
22 INFORCEINCDATE DATE 4
23 INSTALFRQ CHARACTER VARYING(21) 21
24 ITEMNO INTEGER 4
25 LSP_FLAG CHARACTER VARYING(1) 1
26 LARGE_THRESHHOLD BIGINT 8
27 LIAB_SUMINS_BAND CHARACTER VARYING(40) 40
28 LIAB_TURNOVER_BAND CHARACTER VARYING(40) 40
29 MGT_SUMINS_BAND CHARACTER VARYING(40) 40
30 NNINCURRED DOUBLE PRECISION 8
31 NNINCURRED_CAP DOUBLE PRECISION 8
32 NNINCURRED_XOL DOUBLE PRECISION 8
33 OCCUPATION CHARACTER VARYING(100) 100
34 OCCUPATION_GROUPS CHARACTER VARYING(67) 67
35 ORIGINAL_GWP DOUBLE PRECISION 8
36 POLICY_COUNT DOUBLE PRECISION 8
37 POLICYINCEPTDATE DATE 4
38 POLICYNUMBER CHARACTER VARYING(32) 32
39 POST_CODE DOUBLE PRECISION 8
40 POSTCODE DOUBLE PRECISION 8
41 PRODUCT CHARACTER VARYING(23) 23
42 PRODUCT_TYPE CHARACTER VARYING(65) 65
43 PRVPOLREF CHARACTER VARYING(14) 14
44 RISK_STATE CHARACTER VARYING(32) 32
45 RISKCOUNT DOUBLE PRECISION 8
46 RISKCOUNTRP DOUBLE PRECISION 8
47 RISKSTATE CHARACTER VARYING(22) 22
48 SALES_STATE CHARACTER VARYING(23) 23
49 SI_BURGLARY_BAND CHARACTER VARYING(35) 35
50 SI_GENPROP_BAND CHARACTER VARYING(35) 35
51 SI_MACHINERY_BAND CHARACTER VARYING(35) 35
52 SI_MONEY_BAND CHARACTER VARYING(35) 35
53 SI_MOTOR_BAND CHARACTER VARYING(80) 80
54 SI_TAX_BAND CHARACTER VARYING(35) 35
55 SPCODE CHARACTER(2) 2
56 STATE CHARACTER(3) 3
57 SUB_OCCUPATIONS CHARACTER VARYING(80) 80
58 SUBCLASS CHARACTER VARYING(23) 23
59 TOTAL_RISKCOUNT DOUBLE PRECISION 8
60 TYPE CHARACTER VARYING(45) 45
61 VEHAGE SMALLINT 2
62 VEHICLE_AGE CHARACTER VARYING(80) 80
63 WEIGHT CHARACTER VARYING(21) 21
64 ORIGINALPOLICY_FLAG DOUBLE PRECISION 8