INT_PROF_MERGED_AAMI_BASE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DATASET CHARACTER VARYING(4) 4
2 LSP_FLAG CHARACTER VARYING(1) 1
3 PACKAGETYPE CHARACTER VARYING(15) 15
4 ACCOUNT1 CHARACTER VARYING(1) 1
5 BDM_NAME CHARACTER VARYING(1) 1
6 BDM_STATE CHARACTER VARYING(1) 1
7 BI_SUMINS_BAND CHARACTER VARYING(40) 40
8 BRAND CHARACTER VARYING(4) 4
9 BROKERS CHARACTER VARYING(1) 1
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(1) 1
15 CLUSTER CHARACTER VARYING(1) 1
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(1) 1
28 GWP DOUBLE PRECISION 8
29 ICAGROUP CHARACTER VARYING(53) 53
30 INCIDENTCODE CHARACTER(3) 3
31 ITEMNO INTEGER 4
32 LARGE_THRESHHOLD BIGINT 8
33 LIAB_SUMINS_BAND CHARACTER VARYING(40) 40
34 LIAB_TURNOVER_BAND CHARACTER VARYING(40) 40
35 LOB CHARACTER VARYING(1) 1
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(1) 1
47 PRODUCT_TYPE CHARACTER VARYING(65) 65
48 PRVPOLREF CHARACTER VARYING(14) 14
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(1) 1
54 SELECT CHARACTER VARYING(1) 1
55 SI_BURGLARY_BAND CHARACTER VARYING(35) 35
56 SI_GENPROP_BAND CHARACTER VARYING(35) 35
57 SI_GLASS_BAND CHARACTER VARYING(1) 1
58 SI_MACHINERY_BAND CHARACTER VARYING(35) 35
59 SI_MONEY_BAND CHARACTER VARYING(35) 35
60 SI_MOTOR_BAND CHARACTER VARYING(80) 80
61 SI_PERSONACC_BAND CHARACTER VARYING(1) 1
62 SI_TAX_BAND CHARACTER VARYING(35) 35
63 SPCODE CHARACTER(2) 2
64 STATE CHARACTER(3) 3
65 SUB_OCCUPATIONS CHARACTER VARYING(80) 80
66 TIER CHARACTER VARYING(1) 1
67 TYPE CHARACTER VARYING(45) 45
68 VEHAGE SMALLINT 2
69 VEHICLE_AGE CHARACTER VARYING(80) 80
70 VIRTUAL_PRODUCT CHARACTER VARYING(28) 28
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 DOUBLE PRECISION 8
77 SALESDISC_NB_POLICIES DOUBLE PRECISION 8
78 SALESDISC_RENEWAL DOUBLE PRECISION 8
79 SALESDISC_RENEWAL_DISC_POLICIES DOUBLE PRECISION 8
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