INT_VERO_STRIKERATE

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 ACCEPTED_PREMIUM NUMERIC(20,6) 19
5 BDM_NAME CHARACTER VARYING(70) 70
6 BDM_STATE CHARACTER VARYING(50) 50
7 BRAND CHARACTER VARYING(23) 23
8 BROKERS CHARACTER VARYING(220) 220
9 BUSNESSRC CHARACTER VARYING(24) 24
10 BUSNESSRC_DESCRIPTION CHARACTER VARYING(120) 120
11 CHANNEL CHARACTER VARYING(40) 40
12 CLUSTER CHARACTER VARYING(70) 70
13 EFFECTIVE__DATE DATE 4
14 GENERATED_STATE CHARACTER VARYING(50) 50
15 ICAGROUP CHARACTER VARYING(54) 54
16 NB INTEGER 4
17 NB$ NUMERIC(24,6) 19
18 OCCUPATION CHARACTER VARYING(67) 67
19 OCCUPATION_DESCRIPTION CHARACTER VARYING(80) 80
20 POSTCODE NUMERIC(24,6) 19
21 QUOTE_FLAG NUMERIC(24,6) 19
22 QUOTED_PREMIUM NUMERIC(24,6) 19
23 SALES_STATE CHARACTER VARYING(23) 23
24 SELECT CHARACTER VARYING(23) 23
25 STATE CHARACTER VARYING(25) 25
26 TIER CHARACTER VARYING(26) 26
27 WIN CHARACTER VARYING(50) 50
28 NONACC_PREMIUM NUMERIC(24,6) 19
29 GIO_CHANNELS CHARACTER VARYING(50) 50