INT_PROF_MERGED_GEP_COGEN

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(30) 30
4 BI_SUMINS_BAND CHARACTER VARYING(40) 40
5 BRAND CHARACTER VARYING(30) 30
6 CANC_FT_CNT DOUBLE PRECISION 8
7 CANC_MT_CNT DOUBLE PRECISION 8
8 CLASS CHARACTER(3) 3
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(5) 5
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(24) 24
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 DOUBLE PRECISION 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(22) 22
35 LSP_FLAG CHARACTER VARYING(25) 25
36 MGT_SUMINS_BAND CHARACTER VARYING(1) 1
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 NUMERIC(9,0) 19
45 VEHAGE SMALLINT 2
46 SPCODE CHARACTER(2) 2
47 BDM_NAME CHARACTER VARYING(36) 36
48 BDM_STATE CHARACTER VARYING(23) 23
49 BROKERS CHARACTER VARYING(62) 62
50 CLUSTER CHARACTER VARYING(46) 46
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(23) 23
57 SUB_OCCUPATIONS CHARACTER VARYING(122) 122
58 TIER CHARACTER VARYING(26) 26
59 TYPE CHARACTER VARYING(1) 1
60 VIRTUAL_PRODUCT CHARACTER VARYING(22) 22
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(21) 21
70 PRODUCT_TYPE CHARACTER VARYING(80) 80
71 PRVPOLREF CHARACTER VARYING(14) 14
72 RISKSTATE CHARACTER VARYING(1) 1
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(40) 40
83 SI_GENPROP_BAND CHARACTER VARYING(35) 35
84 SI_GLASS_BAND CHARACTER VARYING(35) 35
85 SI_MACHINERY_BAND CHARACTER VARYING(40) 40
86 SI_MONEY_BAND CHARACTER VARYING(40) 40
87 SI_MOTOR_BAND CHARACTER VARYING(80) 80
88 SI_PERSONACC_BAND CHARACTER VARYING(35) 35
89 SI_TAX_BAND CHARACTER VARYING(35) 35
90 STATE CHARACTER VARYING(23) 23
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