| # |
Name |
Data Type |
Length |
| 1 |
COMPANY_NO |
INTEGER |
4 |
| 2 |
WEEK_ENDING_DATE |
DATE |
4 |
| 3 |
TRANSACTION_DATE_KEY |
INTEGER |
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 |
POLICY_STAGE_KEY |
INTEGER |
4 |
| 10 |
END_FLAG_KEY |
INTEGER |
4 |
| 11 |
LATE_PAYMENT_KEY |
INTEGER |
4 |
| 12 |
CHANNEL_PARTNER_KEY |
INTEGER |
4 |
| 13 |
GWP |
NUMERIC(38,2) |
19 |
| 14 |
RENEWAL_RISK_COUNT |
NUMERIC(38,12) |
19 |
| 15 |
DUE_RISK_COUNT |
NUMERIC(38,12) |
19 |
| 16 |
RENEWALS_OFFERED |
NUMERIC(38,12) |
19 |