INT_PI_REN_EFF_DATE
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 | END_FLAG_KEY | INTEGER | 4 |
| 10 | LATE_PAYMENT_KEY | INTEGER | 4 |
| 11 | PREV_POLICY_STAGE | CHARACTER VARYING(2) | 2 |
| 12 | GWP | NUMERIC(38,2) | 19 |
| 13 | RENEWAL_RISK_COUNT | NUMERIC(38,12) | 19 |