INT_AML_HIST_OBP_CUST_CDD_V
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | OBP_PARTY_ID | CHARACTER VARYING(40) | 40 |
| 2 | CUSTOMER_SOURCE_UNIQUE_ID | BIGINT | 8 |
| 3 | GCIS_PARTY_ID | CHARACTER VARYING(400) | 400 |
| 4 | ANZSIC_CODE | CHARACTER VARYING(5) | 5 |
| 5 | CUSTOMER_ID | BIGINT | 8 |
| 6 | HUB_CUSTOMER_ID | BIGINT | 8 |
| 7 | CLASSIFICATION_ID | BIGINT | 8 |
| 8 | CLASSIFICATION_DESC | CHARACTER VARYING(100) | 100 |
| 9 | KYC_STATUS | CHARACTER VARYING(1) | 1 |
| 10 | ACTIVE_STATUS | CHARACTER VARYING(10) | 10 |
| 11 | EFFECTIVE_START_TIMESTAMP | TIMESTAMP | 8 |
| 12 | EFFECTIVE_END_TIMESTAMP | TIMESTAMP | 8 |
| 13 | EOD_RNK | BIGINT | 8 |
| 14 | ALL_RNK | BIGINT | 8 |