INT_RETENTION_PY_AAMI
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | DATASET | CHARACTER VARYING(4) | 4 |
| 2 | BRAND | CHARACTER VARYING(4) | 4 |
| 3 | LSP_FLAG | CHARACTER VARYING(1) | 1 |
| 4 | YEAR | BIGINT | 8 |
| 5 | MONTH | BIGINT | 8 |
| 6 | WEIGHT | CHARACTER VARYING(200) | 200 |
| 7 | VIRTUAL_PRODUCT | CHARACTER VARYING(200) | 200 |
| 8 | VEHICLE_AGE | CHARACTER VARYING(200) | 200 |
| 9 | TIER | CHARACTER VARYING(200) | 200 |
| 10 | SUB_OCCUPATIONS | CHARACTER VARYING(200) | 200 |
| 11 | STATE | CHARACTER VARYING(200) | 200 |
| 12 | SI_MONEY_BAND | CHARACTER VARYING(200) | 200 |
| 13 | SI_MACHINERY_BAND | CHARACTER VARYING(200) | 200 |
| 14 | SELECT | CHARACTER VARYING(200) | 200 |
| 15 | SALESMGR | CHARACTER VARYING(200) | 200 |
| 16 | RISKCOUNT | CHARACTER VARYING(200) | 200 |
| 17 | RISK_STATE | CHARACTER VARYING(200) | 200 |
| 18 | PRODUCT_TYPE | CHARACTER VARYING(200) | 200 |
| 19 | POSTCODE | CHARACTER VARYING(200) | 200 |
| 20 | PACKAGETYPE | CHARACTER VARYING(200) | 200 |
| 21 | OCCUPATION_GROUPS | CHARACTER VARYING(200) | 200 |
| 22 | MGT_SUMINS_BAND | CHARACTER VARYING(200) | 200 |
| 23 | LIAB_TURNOVER_BAND | CHARACTER VARYING(200) | 200 |
| 24 | LIAB_SUMINS_BAND | CHARACTER VARYING(200) | 200 |
| 25 | ICAGROUP | CHARACTER VARYING(200) | 200 |
| 26 | GIPE_MINIMUM_PREMIUM_FLAG | CHARACTER VARYING(200) | 200 |
| 27 | GIO_CHANNELS | CHARACTER VARYING(200) | 200 |
| 28 | FIRE_SUMINS_BAND | CHARACTER VARYING(200) | 200 |
| 29 | EXCESS | CHARACTER VARYING(200) | 200 |
| 30 | DRIVERS_AGE | CHARACTER VARYING(200) | 200 |
| 31 | CLUSTER | CHARACTER VARYING(200) | 200 |
| 32 | BROKERS | CHARACTER VARYING(200) | 200 |
| 33 | BI_SUMINS_BAND | CHARACTER VARYING(200) | 200 |
| 34 | BDM_STATE | CHARACTER VARYING(200) | 200 |
| 35 | BDM_NAME | CHARACTER VARYING(200) | 200 |
| 36 | CYRENEW | DOUBLE PRECISION | 8 |
| 37 | PYTOTAL | DOUBLE PRECISION | 8 |
| 38 | CYTOTALRISKCOUNT | DOUBLE PRECISION | 8 |
| 39 | CYNEW_GWP | DOUBLE PRECISION | 8 |
| 40 | CYRENEW_GWP | DOUBLE PRECISION | 8 |
| 41 | CYTOTALGWP | DOUBLE PRECISION | 8 |
| 42 | PYRENEW_GWP | DOUBLE PRECISION | 8 |
| 43 | PYTOTALGWP | DOUBLE PRECISION | 8 |
| 44 | CANCELLEDPOLICIES_TOTAL | DOUBLE PRECISION | 8 |
| 45 | CY_RENEWEDPOLICYCNT | DOUBLE PRECISION | 8 |
| 46 | CYPOLICYRENEWAL | DOUBLE PRECISION | 8 |
| 47 | CYTOTALPOLICY | DOUBLE PRECISION | 8 |
| 48 | PYPOLICY_RENEW | DOUBLE PRECISION | 8 |
| 49 | PYPOLICY_NEW | DOUBLE PRECISION | 8 |
| 50 | PYTOTALPOLICY | DOUBLE PRECISION | 8 |
| 51 | CYCANC_POL_NB | DOUBLE PRECISION | 8 |
| 52 | CYCANC_POL_RENEW | DOUBLE PRECISION | 8 |
| 53 | COVERAGECHGEFFECTDATE | TIMESTAMP | 8 |