INT_COGEN_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(36) 36
3 BDM_STATE CHARACTER VARYING(23) 23
4 BI_SUMINS_BAND CHARACTER VARYING(40) 40
5 BRAND CHARACTER VARYING(30) 30
6 BROKERS CHARACTER VARYING(62) 62
7 CANC_FT_CNT DOUBLE PRECISION 8
8 CANC_MT_CNT DOUBLE PRECISION 8
9 CLAIMNUMBER CHARACTER VARYING(12) 12
10 CLASS CHARACTER(3) 3
11 CLUSTER_NZ CHARACTER VARYING(46) 46
12 COMPANY CHARACTER VARYING(23) 23
13 COVERAGECHGEFFECTDATE DATE 4
14 COVERAGECHGEXPIRYDATE DATE 4
15 COVERAGEKEY DOUBLE PRECISION 8
16 COVERAGENUMBER CHARACTER VARYING(23) 23
17 COVERAGERENEWEDDATE DATE 4
18 COVRENEWEDDATE DATE 4
19 DATEOCCURRED DATE 4
20 DISC DOUBLE PRECISION 8
21 DISC_GWP DOUBLE PRECISION 8
22 DRIVERS_AGE CHARACTER VARYING(80) 80
23 EXCESS1 DOUBLE PRECISION 8
24 FIRE_SUMINS_BAND CHARACTER VARYING(40) 40
25 FL_NEWRENEW CHARACTER VARYING(28) 28
26 GIO_CHANNELS CHARACTER VARYING(24) 24
27 GWP DOUBLE PRECISION 8
28 ICAGROUP CHARACTER VARYING(53) 53
29 INCIDENTCODE CHARACTER(3) 3
30 INFORCEEXPDATE DATE 4
31 INFORCEINCDATE DATE 4
32 INSTALMENTTYPE CHARACTER VARYING(21) 21
33 ITEMNO NUMERIC(9,0) 19
34 LARGE_THRESHHOLD DOUBLE PRECISION 8
35 LIAB_SUMINS_BAND CHARACTER VARYING(40) 40
36 LIAB_TURNOVER_BAND CHARACTER VARYING(40) 40
37 LOB CHARACTER VARYING(22) 22
38 LSP_FLAG CHARACTER VARYING(25) 25
39 NNINCURRED DOUBLE PRECISION 8
40 NNINCURRED_CAP DOUBLE PRECISION 8
41 NNINCURRED_XOL DOUBLE PRECISION 8
42 OCCUPATION CHARACTER VARYING(100) 100
43 OCCUPATION_GROUPS CHARACTER VARYING(67) 67
44 ORIGINAL_GWP DOUBLE PRECISION 8
45 POLICY_COUNT DOUBLE PRECISION 8
46 POLICYEFFECTIVEDATE DATE 4
47 POLICYINCEPTDATE DATE 4
48 POLICYNUMBER CHARACTER VARYING(32) 32
49 POST_CODE DOUBLE PRECISION 8
50 POSTCODE DOUBLE PRECISION 8
51 PRINTTYPE CHARACTER VARYING(21) 21
52 PRODUCT CHARACTER VARYING(24) 24
53 PRODUCT_OLD CHARACTER VARYING(6) 6
54 PRODUCT_TYPE CHARACTER VARYING(80) 80
55 PRVPOLREF CHARACTER VARYING(14) 14
56 RISK_STATE CHARACTER VARYING(32) 32
57 RISKCOUNT DOUBLE PRECISION 8
58 RISKCOUNTRP DOUBLE PRECISION 8
59 SALES_STATE CHARACTER VARYING(23) 23
60 SELECT_NZ CHARACTER VARYING(23) 23
61 SI_BURGLARY_BAND CHARACTER VARYING(40) 40
62 SI_GENPROP_BAND CHARACTER VARYING(35) 35
63 SI_GLASS_BAND CHARACTER VARYING(35) 35
64 SI_MACHINERY_BAND CHARACTER VARYING(40) 40
65 SI_MONEY_BAND CHARACTER VARYING(40) 40
66 SI_MOTOR_BAND CHARACTER VARYING(80) 80
67 SI_PERSONACC_BAND CHARACTER VARYING(35) 35
68 SI_TAX_BAND CHARACTER VARYING(35) 35
69 SPCODE CHARACTER(2) 2
70 STATE CHARACTER VARYING(23) 23
71 SUB_OCCUPATIONS CHARACTER VARYING(122) 122
72 TIER CHARACTER VARYING(26) 26
73 TOTAL_RISKCOUNT DOUBLE PRECISION 8
74 TRANSACTIONMONTH DATE 4
75 VEHAGE SMALLINT 2
76 VEHICLE_AGE CHARACTER VARYING(80) 80
77 WEIGHT CHARACTER VARYING(21) 21
78 ORIGINALPOLICY_FLAG DOUBLE PRECISION 8