INT_ACTUAL_PI_METRICS_POLICY_RISK
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PROTECT_NICHE_SRC | CHARACTER VARYING(1) | 1 |
| 2 | DATA_SOURCE | CHARACTER VARYING(9) | 9 |
| 3 | COMPANY_NUMBER | SMALLINT | 2 |
| 4 | BRAND_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 5 | BRAND_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 6 | BRAND_LEVEL3 | CHARACTER VARYING(255) | 255 |
| 7 | BRAND_LEVEL4 | CHARACTER VARYING(255) | 255 |
| 8 | BRAND_LEVEL5 | CHARACTER VARYING(255) | 255 |
| 9 | CANCEL_REASON1 | CHARACTER VARYING(255) | 255 |
| 10 | CANCEL_REASON2 | CHARACTER VARYING(255) | 255 |
| 11 | CHANNEL_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 12 | CHANNEL_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 13 | CHANNEL_LEVEL3 | CHARACTER VARYING(255) | 255 |
| 14 | CHANNEL_LEVEL4 | CHARACTER VARYING(255) | 255 |
| 15 | CHANNEL_LEVEL5 | CHARACTER VARYING(255) | 255 |
| 16 | CHANNEL_LEVEL6 | CHARACTER VARYING(255) | 255 |
| 17 | PRODUCT_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 18 | PRODUCT_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 19 | PRODUCT_LEVEL3 | CHARACTER VARYING(255) | 255 |
| 20 | PRODUCT_LEVEL4 | CHARACTER VARYING(255) | 255 |
| 21 | PRODUCT_LEVEL5 | CHARACTER VARYING(255) | 255 |
| 22 | PRODUCT_LEVEL6 | CHARACTER VARYING(255) | 255 |
| 23 | PRODUCT_LEVEL7 | CHARACTER VARYING(255) | 255 |
| 24 | POLICYSTAGE_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 25 | POLICYSTAGE_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 26 | POLICYSTAGE_LEVEL3 | CHARACTER VARYING(255) | 255 |
| 27 | POLICYSTAGE_LEVEL4 | CHARACTER VARYING(255) | 255 |
| 28 | POLICYSTAGE_LEVEL5 | CHARACTER VARYING(255) | 255 |
| 29 | TRANSACTION_TYPE | CHARACTER VARYING(255) | 255 |
| 30 | RISK_STATE_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 31 | RISK_STATE_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 32 | VERSION_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 33 | VERSION_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 34 | VERSION_LEVEL3 | CHARACTER VARYING(255) | 255 |
| 35 | RISK_TYPE_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 36 | RISK_TYPE_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 37 | ORIG_CHANNEL_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 38 | ORIG_CHANNEL_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 39 | ORIG_CHANNEL_LEVEL3 | CHARACTER VARYING(255) | 255 |
| 40 | TRAN_CHANNEL_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 41 | TRAN_CHANNEL_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 42 | TRAN_CHANNEL_LEVEL3 | CHARACTER VARYING(255) | 255 |
| 43 | CRC_FLAG | CHARACTER VARYING(255) | 255 |
| 44 | CRC_OPTION | CHARACTER VARYING(255) | 255 |
| 45 | FLOOD_OPTOUT_STATUS | CHARACTER VARYING(255) | 255 |
| 46 | HIRE_CAR_FLAG | CHARACTER VARYING(255) | 255 |
| 47 | ROAD_ASST_FLAG | CHARACTER VARYING(255) | 255 |
| 48 | WINDSCREEN_FLAG | CHARACTER VARYING(255) | 255 |
| 49 | LATE_PAYMENT_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 50 | LATE_PAYMENT_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 51 | END_OPT_FLAG | CHARACTER VARYING(255) | 255 |
| 52 | QUOTE_STATUS | CHARACTER VARYING(255) | 255 |
| 53 | UNPAID_NEW_BUSINESS_STATUS | CHARACTER VARYING(255) | 255 |
| 54 | QUOTE_TYPE | CHARACTER VARYING(255) | 255 |
| 55 | INSTALL_FREQ_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 56 | INSTALL_FREQ_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 57 | ITEM_TYPE_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 58 | ITEM_TYPE_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 59 | RISK_POSTCODE_LEVEL1 | CHARACTER VARYING(255) | 255 |
| 60 | RISK_POSTCODE_LEVEL2 | CHARACTER VARYING(255) | 255 |
| 61 | RISK_POSTCODE_LEVEL3 | CHARACTER VARYING(255) | 255 |
| 62 | RISK_POSTCODE | CHARACTER VARYING(255) | 255 |
| 63 | TRAN_DATE | CHARACTER(10) | 10 |
| 64 | WEEK_ENDING | CHARACTER(10) | 10 |
| 65 | FIN_MONTH_ABBR | CHARACTER(7) | 7 |
| 66 | FIN_MONTH_NUMBER | INTEGER | 4 |
| 67 | FIN_QTR_TEXT | CHARACTER VARYING(13) | 13 |
| 68 | FIN_QTR_NUMBER | INTEGER | 4 |
| 69 | FIN_HALF_YEARLY | CHARACTER VARYING(13) | 13 |
| 70 | FIN_YEAR | CHARACTER VARYING(25) | 25 |
| 71 | CAL_MONTH_ABBR_TEXT | CHARACTER(7) | 7 |
| 72 | CAL_MONTH_NUMBER | SMALLINT | 2 |
| 73 | CALENDAR_QUARTER | CHARACTER VARYING(7) | 7 |
| 74 | CAL_QTR_NUMBER | SMALLINT | 2 |
| 75 | CALENDAR_HALF_YEAR | CHARACTER VARYING(7) | 7 |
| 76 | CAL_YEAR | SMALLINT | 2 |
| 77 | GWP | NUMERIC(38,2) | 19 |
| 78 | RISKCOUNT | NUMERIC(38,12) | 19 |
| 79 | ITEM_COUNT | NUMERIC(38,6) | 19 |
| 80 | TRANSACTION_COUNT | NUMERIC(38,0) | 19 |
| 81 | PRORATA_COUNT | NUMERIC(38,6) | 19 |