FCT_PI_POLICY_RIF_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_NO SMALLINT 2
2 MONTH_END_DATE DATE 4
3 MONTH_END_DATE_KEY INTEGER 4
4 PRODUCT_KEY INTEGER 4
5 RISK_TYPE_KEY INTEGER 4
6 RISK_STATE_KEY INTEGER 4
7 RISK_POSTCODE_KEY INTEGER 4
8 POLICYSTAGE_KEY INTEGER 4
9 TRANSACTION_CHANNEL_KEY INTEGER 4
10 INSTALL_FREQ_KEY INTEGER 4
11 BRAND_KEY INTEGER 4
12 END_FLAG_KEY INTEGER 4
13 LATE_PAYMENT_KEY INTEGER 4
14 CHANNEL_PARTNER_KEY INTEGER 4
15 VERSION_KEY INTEGER 4
16 RISK_IN_FORCE NUMERIC(38,12) 19
17 R12MTH_GWP NUMERIC(38,2) 19