FCT_SNTA_AML_CUSTOMER_ACCOUNT_LINK_INSIGHT
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACCOUNT_CUST_UNIQUE_ID | CHARACTER VARYING(13) | 13 |
| 2 | ACCOUNT_SOURCE_UNIQUE_ID | CHARACTER VARYING(13) | 13 |
| 3 | CUSTOMER_SOURCE_UNIQUE_ID | BIGINT | 8 |
| 4 | CUSTOMER_ROLE | CHARACTER VARYING(15) | 15 |
| 5 | RELATIONSHIP_FROM_DATE | CHARACTER VARYING(200) | 200 |
| 6 | DATE_CLOSED | CHARACTER VARYING(200) | 200 |
| 7 | SS_RELN_TYPE | CHARACTER VARYING(15) | 15 |
| 8 | SOURCE_SYS_ID | NUMERIC(10,0) | 19 |
| 9 | SOURCE_SYS_CUST_NUM | NUMERIC(10,0) | 19 |
| 10 | SOURCE_SYS_CUST_ROLE | CHARACTER VARYING(15) | 15 |
| 11 | EFFECTIVE_START_TIMESTAMP | TIMESTAMP | 8 |
| 12 | EFFECTIVE_END_TIMESTAMP | TIMESTAMP | 8 |