DIM_SDW_TSDMD_ACCOUNT_STATUS_MOVEMENT

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_STATUS_MOVEMENT_DIM_ID BIGINT 8
2 LOAD_STATUS_FLAG CHARACTER VARYING(1) 1
3 INSERT_RUN_AUDIT_ID NUMERIC(38,0) 19
4 UPDATE_RUN_AUDIT_ID NUMERIC(38,0) 19
5 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
6 OPENING_ACCOUNT_STATUS_CODE CHARACTER VARYING(24) 24
7 CLOSING_ACCOUNT_STATUS_CODE CHARACTER VARYING(24) 24
8 OPENING_STD_CL_CODE CHARACTER VARYING(6) 6
9 OPENING_SHORT_NAME CHARACTER VARYING(256) 256
10 OPENING_NAME CHARACTER VARYING(256) 256
11 OPENING_DESCRIPTION CHARACTER VARYING(256) 256
12 OPENING_HIER_PARENT_NAME CHARACTER VARYING(256) 256
13 OPENING_HIER_GPARENT_NAME CHARACTER VARYING(256) 256
14 OPENING_CL_ID BIGINT 8
15 CLOSING_STD_CL_CODE CHARACTER VARYING(6) 6
16 CLOSING_SHORT_NAME CHARACTER VARYING(256) 256
17 CLOSING_NAME CHARACTER VARYING(256) 256
18 CLOSING_DESCRIPTION CHARACTER VARYING(256) 256
19 CLOSING_HIER_PARENT_NAME CHARACTER VARYING(256) 256
20 CLOSING_HIER_GPARENT_NAME CHARACTER VARYING(256) 256
21 CLOSING_CL_ID BIGINT 8
22 OPENING_INFORM_ACCOUNT_ST_DSC CHARACTER VARYING(48) 48
23 CLOSING_INFORM_ACCOUNT_ST_DSC CHARACTER VARYING(48) 48
24 INFORM_ACCOUNT_STATUS_MV_DSC CHARACTER VARYING(48) 48
25 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
26 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
27 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
28 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8