DIM_BNK_EFS_ACCOUNT_V
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACCOUNT_DIM_ID | BIGINT | 8 |
| 2 | SOURCE_SYSTEM_CODE | CHARACTER VARYING(12) | 12 |
| 3 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 4 | DATE_CLOSED | TIMESTAMP | 8 |
| 5 | DATE_OPEN | TIMESTAMP | 8 |
| 6 | COMPANY_CODE | CHARACTER VARYING(5) | 5 |
| 7 | BDM_CODE | CHARACTER VARYING(254) | 254 |
| 8 | BDM_NAME | CHARACTER VARYING(256) | 256 |
| 9 | DATE_CLOSED_FINAL | TIMESTAMP | 8 |
| 10 | MIGRATED_STATUS | CHARACTER VARYING(8) | 8 |
| 11 | MIGRATED_DATE | TIMESTAMP | 8 |
| 12 | SOURCE_SYSTEM_GROUP | CHARACTER VARYING(12) | 12 |