| # |
Name |
Data Type |
Length |
| 1 |
FROM_ACCOUNT_DIM_ID |
BIGINT |
8 |
| 2 |
TO_ACCOUNT_DIM_ID |
BIGINT |
8 |
| 3 |
FROM_ACCOUNT_NUMBER |
CHARACTER VARYING(20) |
20 |
| 4 |
TO_ACCOUNT_NUMBER |
CHARACTER VARYING(20) |
20 |
| 5 |
FROM_SOURCE_SYSTEM_CODE |
CHARACTER VARYING(12) |
12 |
| 6 |
TO_SOURCE_SYSTEM_CODE |
CHARACTER VARYING(12) |
12 |
| 7 |
FROM_PRODUCT_CODE |
CHARACTER VARYING(12) |
12 |
| 8 |
TO_PRODUCT_CODE |
CHARACTER VARYING(12) |
12 |
| 9 |
FROM_SUB_PRODUCT_CODE |
CHARACTER VARYING(12) |
12 |
| 10 |
TO_SUB_PRODUCT_CODE |
CHARACTER VARYING(12) |
12 |
| 11 |
LEAD_NUMBER |
BIGINT |
8 |
| 12 |
MIGRATION_DATE |
DATE |
4 |
| 13 |
HOGAN_DAY_FIRST |
DATE |
4 |
| 14 |
START_OF_MIGRATION_MONTH |
DATE |
4 |
| 15 |
LOAD_DATE |
DATE |
4 |
| 16 |
CDC_SOURCE_SYSTEM_CODE |
CHARACTER VARYING(4) |
4 |
| 17 |
CDC_RECORD_TYPE |
CHARACTER VARYING(16) |
16 |