INT_OBP_COLLECTION_OUTSOURCED_PERSON_CONTACTS
Description
Source Object (CTAS)
SDSNZP05_BANK..INT_OBP_COLLECTION_OUTSOURCED_PERSON_CONTACTS_V
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 2 | PERSON_ID | CHARACTER(10) | 10 |
| 3 | ACCOUNT_RELATION_TYPE_CD | CHARACTER(8) | 8 |
| 4 | CUSTOEMR_RELATION | CHARACTER VARYING(60) | 60 |
| 5 | MAIN_CUSTOMER | CHARACTER(1) | 1 |
| 6 | FULL_NAME | CHARACTER VARYING(250) | 250 |
| 7 | PER_SEQ | BIGINT | 8 |
| 8 | CUSTOMER_NUMBER | CHARACTER VARYING(40) | 40 |
| 9 | CUSTOMER_NAME_1 | CHARACTER VARYING(50) | 50 |
| 10 | CUSTOMER_NAME_2 | CHARACTER VARYING(101) | 101 |
| 11 | CUSTOMER_NAME_3 | CHARACTER VARYING(50) | 50 |
| 12 | HOME_ADDRESS_LINE1 | CHARACTER VARYING(120) | 120 |
| 13 | HOME_ADDRESS_LINE2 | CHARACTER VARYING(120) | 120 |
| 14 | HOME_ADDRESS_LINE3 | CHARACTER VARYING(120) | 120 |
| 15 | HOME_ADDRESS_LINE4 | CHARACTER VARYING(120) | 120 |
| 16 | HOME_CITY | CHARACTER VARYING(30) | 30 |
| 17 | HOME_STATE | CHARACTER VARYING(6) | 6 |
| 18 | HOME_COUNTY | CHARACTER VARYING(30) | 30 |
| 19 | HOME_COUNTRY | CHARACTER VARYING(3) | 3 |
| 20 | HOME_POSTAL | CHARACTER VARYING(12) | 12 |
| 21 | COMMNICATION_ADDRESS_LINE1 | CHARACTER VARYING(120) | 120 |
| 22 | COMMNICATION_ADDRESS_LINE2 | CHARACTER VARYING(120) | 120 |
| 23 | COMMNICATION_ADDRESS_LINE3 | CHARACTER VARYING(120) | 120 |
| 24 | COMMNICATION_ADDRESS_LINE4 | CHARACTER VARYING(120) | 120 |
| 25 | COMM_CITY | CHARACTER VARYING(30) | 30 |
| 26 | COMM_STATE | CHARACTER VARYING(6) | 6 |
| 27 | COMM_COUNTY | CHARACTER VARYING(30) | 30 |
| 28 | COMM_COUNTRY | CHARACTER VARYING(3) | 3 |
| 29 | COMM_POSTAL | CHARACTER VARYING(12) | 12 |
| 30 | BIRTH_DATE | TIMESTAMP | 8 |
| 31 | GENDER | CHARACTER(4) | 4 |
| 32 | PHONE_NUMBER_1 | CHARACTER(6) | 6 |
| 33 | PHONE_NUMBER_2 | CHARACTER(4) | 4 |
| 34 | EMAIL_ID | CHARACTER VARYING(120) | 120 |
| 35 | MARITAL_STATUS | CHARACTER(3) | 3 |
| 36 | BANKRUPT | CHARACTER(1) | 1 |
| 37 | DECEASED | CHARACTER VARYING(1) | 1 |
| 38 | CUST_PHONE_HOME | CHARACTER VARYING(20) | 20 |
| 39 | CUST_PHONE_WORK | CHARACTER VARYING(400) | 400 |
| 40 | CUST_FAX_PERS | CHARACTER VARYING(400) | 400 |
| 41 | CUST_PHONE_MOBILE | CHARACTER VARYING(400) | 400 |
| 42 | CUST_EMAIL | CHARACTER VARYING(400) | 400 |