FCT_PI_POLICY_RISK_INSIGHT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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