FCT_BNK_CDIHUB_CUSTOMER_INSIGHT
Description
OBP Daily Individual and Organisation customer extract for CDIHUB
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CUSTOMERPRODUCTSYSTEMID | CHARACTER VARYING(3) | 3 |
| 2 | CUSTOMERPRODUCTSYSTEMCUSTOMERID | CHARACTER VARYING(30) | 30 |
| 3 | CUSTOMERBRANDCODE | CHARACTER VARYING(7) | 7 |
| 4 | CUSTOMERENTITYTYPE | CHARACTER VARYING(3) | 3 |
| 5 | CUSTOMERNAME | CHARACTER VARYING(133) | 133 |
| 6 | INDIVIDUALGENDER | CHARACTER VARYING(1) | 1 |
| 7 | INDIVIDUALTITLE | CHARACTER VARYING(15) | 15 |
| 8 | INDIVIDUALFIRSTNAME | CHARACTER VARYING(30) | 30 |
| 9 | INDIVIDUALMIDDLENAME | CHARACTER VARYING(50) | 50 |
| 10 | INDIVIDUALLASTNAME | CHARACTER VARYING(40) | 40 |
| 11 | INDIVIDUALNAMESUFFIX | CHARACTER VARYING(10) | 10 |
| 12 | INDIVIDUALDATEOFBIRTH | CHARACTER VARYING(200) | 200 |
| 13 | INDIVIDUALDECEASEDFLAG | CHARACTER VARYING(1) | 1 |
| 14 | INDIVIDUALDECEASEDDATE | CHARACTER VARYING(200) | 200 |
| 15 | INDIVIDUALOCCUPATIONCODE | CHARACTER VARYING(30) | 30 |
| 16 | INDIVIDUALDRIVERSLICENCE | CHARACTER VARYING(20) | 20 |
| 17 | INDIVIDUALDRIVERSLICENCESTATE | CHARACTER VARYING(10) | 10 |
| 18 | INDIVIDUALDRIVERSLICENCECOUNTRYCODE | CHARACTER VARYING(2) | 2 |
| 19 | ORGANISATIONNAME | CHARACTER VARYING(100) | 100 |
| 20 | CUSTOMERABN | CHARACTER VARYING(11) | 11 |
| 21 | ORGANISATIONACNORARBN | CHARACTER VARYING(30) | 30 |
| 22 | INDUSTRYCODE | CHARACTER VARYING(30) | 30 |
| 23 | PHONETYPE1 | CHARACTER VARYING(1) | 1 |
| 24 | PHONEDETAIL1 | CHARACTER VARYING(20) | 20 |
| 25 | PHONETYPE2 | CHARACTER VARYING(1) | 1 |
| 26 | PHONEDETAIL2 | CHARACTER VARYING(20) | 20 |
| 27 | PHONETYPE3 | CHARACTER VARYING(1) | 1 |
| 28 | PHONEDETAIL3 | CHARACTER VARYING(20) | 20 |
| 29 | PHONETYPE4 | CHARACTER VARYING(1) | 1 |
| 30 | PHONEDETAIL4 | CHARACTER VARYING(20) | 20 |
| 31 | PHONETYPE5 | CHARACTER VARYING(1) | 1 |
| 32 | PHONEDETAIL5 | CHARACTER VARYING(20) | 20 |
| 33 | EMAILADDRESS1 | CHARACTER VARYING(100) | 100 |
| 34 | EMAILADDRESS2 | CHARACTER VARYING(50) | 50 |
| 35 | ADDRESS1TYPE | CHARACTER VARYING(1) | 1 |
| 36 | ADDRESS1LINE1 | CHARACTER VARYING(75) | 75 |
| 37 | ADDRESS1LINE2 | CHARACTER VARYING(75) | 75 |
| 38 | ADDRESS1LINE3 | CHARACTER VARYING(75) | 75 |
| 39 | ADDRESS1LINE4 | CHARACTER VARYING(75) | 75 |
| 40 | ADDRESS1LOCALITY | CHARACTER VARYING(50) | 50 |
| 41 | ADDRESS1POSTCODE | CHARACTER VARYING(10) | 10 |
| 42 | ADDRESS1STATE | CHARACTER VARYING(15) | 15 |
| 43 | ADDRESS1COUNTRYCODE | CHARACTER VARYING(2) | 2 |
| 44 | ADDRESS1OVERSEASINDICATOR | CHARACTER VARYING(1) | 1 |
| 45 | ADDRESS1RETURNEDMAILFLAG | CHARACTER VARYING(1) | 1 |
| 46 | ADDRESS2TYPE | CHARACTER VARYING(1) | 1 |
| 47 | ADDRESS2LINE1 | CHARACTER VARYING(75) | 75 |
| 48 | ADDRESS2LINE2 | CHARACTER VARYING(75) | 75 |
| 49 | ADDRESS2LINE3 | CHARACTER VARYING(75) | 75 |
| 50 | ADDRESS2LINE4 | CHARACTER VARYING(100) | 100 |
| 51 | ADDRESS2LOCALITY | CHARACTER VARYING(50) | 50 |
| 52 | ADDRESS2POSTCODE | CHARACTER VARYING(10) | 10 |
| 53 | ADDRESS2STATE | CHARACTER VARYING(15) | 15 |
| 54 | ADDRESS2COUNTRYCODE | CHARACTER VARYING(2) | 2 |
| 55 | ADDRESS2OVERSEASINDICATOR | CHARACTER VARYING(1) | 1 |
| 56 | ADDRESS2RETURNEDMAILFLAG | CHARACTER VARYING(30) | 30 |
| 57 | EMPLOYEEID | CHARACTER VARYING(1) | 1 |
| 58 | CUSTOMERDATEINSERTED | CHARACTER VARYING(40) | 40 |
| 59 | CUSTOMERDATEUPDATED | CHARACTER VARYING(40) | 40 |
| 60 | ORGANISATIONCONTACTNAME | CHARACTER VARYING(1) | 1 |
| 61 | ORGANISATIONCONTACTPOSITION | CHARACTER VARYING(1) | 1 |
| 62 | CUSTOMERRELATIONSHIPMANAGERID | CHARACTER VARYING(15) | 15 |
| 63 | PREFERREDNAME | CHARACTER VARYING(1) | 1 |