CI_POT_DIM_PROF_MERGED_VERO_FINAL
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 3 | ACCOUNT1 | CHARACTER VARYING(30) | 30 |
| 5 | BRAND | CHARACTER VARYING(30) | 30 |
| 9 | CLOSE_ACCT | CHARACTER VARYING(30) | 30 |
| 22 | GIO_CHANNELS | CHARACTER VARYING(24) | 24 |
| 26 | GWP | NUMERIC(20,6) | 19 |
| 30 | LARGE_THRESHHOLD | DOUBLE PRECISION | 8 |
| 34 | LOB | CHARACTER VARYING(22) | 22 |
| 35 | LSP_FLAG | CHARACTER VARYING(25) | 25 |
| 44 | ITEMNO | BIGINT | 8 |
| 47 | BDM_NAME | CHARACTER VARYING(70) | 70 |
| 48 | BDM_STATE | CHARACTER VARYING(50) | 50 |
| 49 | BROKERS | CHARACTER VARYING(220) | 220 |
| 50 | CLUSTER | CHARACTER VARYING(46) | 46 |
| 56 | SELECT | CHARACTER VARYING(23) | 23 |
| 57 | SUB_OCCUPATIONS | CHARACTER VARYING(122) | 122 |
| 58 | TIER | CHARACTER VARYING(26) | 26 |
| 59 | TYPE | CHARACTER VARYING(31) | 31 |
| 60 | VIRTUAL_PRODUCT | CHARACTER VARYING(61) | 61 |
| 69 | PRINTTYPE | CHARACTER VARYING(21) | 21 |
| 70 | PRODUCT_TYPE | CHARACTER VARYING(80) | 80 |
| 71 | PRVPOLREF | CHARACTER VARYING(34) | 34 |
| 75 | SALESDISC_NB_DISC_POLICIES | NUMERIC(20,6) | 19 |
| 78 | SALESDISC_RENEWAL_DISC_POLICIES | NUMERIC(20,6) | 19 |
| 80 | SALESMGR | CHARACTER VARYING(70) | 70 |
| 82 | SI_BURGLARY_BAND | CHARACTER VARYING(40) | 40 |
| 84 | SI_GLASS_BAND | CHARACTER VARYING(35) | 35 |
| 85 | SI_MACHINERY_BAND | CHARACTER VARYING(40) | 40 |
| 86 | SI_MONEY_BAND | CHARACTER VARYING(40) | 40 |
| 88 | SI_PERSONACC_BAND | CHARACTER VARYING(35) | 35 |
| 90 | STATE | CHARACTER VARYING(23) | 23 |