FCT_PI_POLICY_RISK_WEEKLY_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 STREAM_CODE CHARACTER VARYING(1) 1
2 COMPANY_NO SMALLINT 2
3 PROTECT_NICHE_SRC CHARACTER VARYING(1) 1
4 TRANSACTION_DATE DATE 4
5 TRANSACTION_DATE_KEY INTEGER 4
6 PRODUCT_KEY INTEGER 4
7 BRAND_KEY INTEGER 4
8 RISK_STATE_KEY INTEGER 4
9 CANCEL_REASON_KEY INTEGER 4
10 VERSION_KEY INTEGER 4
11 INSTALL_FREQ_KEY INTEGER 4
12 RISK_TYPE_KEY INTEGER 4
13 ITEM_TYPE_KEY INTEGER 4
14 CHANNEL_KEY INTEGER 4
15 QUOTESTATUS_KEY INTEGER 4
16 COVERNOTE_STATUS_KEY INTEGER 4
17 POLICY_STAGE_KEY INTEGER 4
18 RISK_POSTCODE_KEY INTEGER 4
19 QUOTE_TYPE_KEY INTEGER 4
20 TRANSACTION_CHANNEL_KEY INTEGER 4
21 ORIGINATING_TXN_CHANNEL_KEY INTEGER 4
22 CRC_FLAG_KEY INTEGER 4
23 CRC_OPTION_KEY INTEGER 4
24 FLOOD_OPTOUT_FLAG_KEY INTEGER 4
25 ROAD_ASST_KEY INTEGER 4
26 HOME_ASST_KEY INTEGER 4
27 HIRE_CAR_KEY INTEGER 4
28 WINDSCREEN_KEY INTEGER 4
29 END_FLAG_KEY INTEGER 4
30 LATE_PAYMENT_KEY INTEGER 4
31 USERID CHARACTER VARYING(10) 10
32 GWP NUMERIC(38,2) 19
33 TRANSACTION_COUNT NUMERIC(38,0) 19
34 ITEM_COUNT NUMERIC(38,6) 19
35 PRORATA_COUNT NUMERIC(38,6) 19
36 RISK_COUNT NUMERIC(38,12) 19