INT_PI_REN_TRN_DATE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY_NO INTEGER 4
2 CHANNEL_PARTNER_KEY INTEGER 4
3 WEEK_ENDING_DATE DATE 4
4 BRAND_KEY INTEGER 4
5 PRODUCT_KEY INTEGER 4
6 RISK_STATE_KEY INTEGER 4
7 RISK_TYPE_KEY INTEGER 4
8 INSTALL_FREQ_KEY INTEGER 4
9 PREV_POLICY_STAGE CHARACTER VARYING(2) 2
10 END_FLAG_KEY INTEGER 4
11 LATE_PAYMENT_KEY INTEGER 4
12 WEEK_NO BIGINT 8
13 GWP NUMERIC(38,2) 19
14 RISK_COUNT NUMERIC(38,12) 19
15 RENEWAL_RISK_COUNT NUMERIC(38,12) 19