MARKETING_NZ_CODE_V6_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 BRAND CHARACTER VARYING(255) 255
2 PRODUCT_LVL3 CHARACTER VARYING(255) 255
3 RISK_TYPE CHARACTER VARYING(255) 255
4 POLICYSTAGE_LVL1 CHARACTER VARYING(255) 255
5 POLICYSTAGE_LVL2 CHARACTER VARYING(255) 255
6 QUOTE_STATUS CHARACTER VARYING(255) 255
7 RISK_POSTCODE CHARACTER VARYING(255) 255
8 STATELVL1 CHARACTER VARYING(255) 255
9 CHANNEL CHARACTER VARYING(255) 255
10 FIN_MONTH_TEXT CHARACTER(9) 9
11 FIN_YEAR CHARACTER VARYING(25) 25
12 FIN_MONTH_NUMBER INTEGER 4
13 TRAN_DATE CHARACTER(10) 10
14 GWP NUMERIC(38,2) 19
15 COVER_COUNT NUMERIC(38,6) 19
16 RISK_COUNT NUMERIC(38,12) 19