DIM_SDW_TSDMD_TXN_CLASSIFICATION

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 TXN_CLASSIFICATION_DIM_ID BIGINT 8
2 ORIG_INFORM_CLASSIFICATION CHARACTER VARYING(24) 24
3 ORIG_INFORM_CATEGORY CHARACTER VARYING(24) 24
4 ORIG_INFORM_CATEGORY_GROUP CHARACTER VARYING(24) 24
5 ORIG_CPR_CATEGORY_GROUP CHARACTER VARYING(24) 24
6 RECLASS_INFORM_CLASSIFICATION CHARACTER VARYING(24) 24
7 RECLASS_INFORM_CATEGORY CHARACTER VARYING(24) 24
8 RECLASS_INFORM_CATEGORY_GROUP CHARACTER VARYING(24) 24
9 RECLASS_CPR_CATEGORY_GROUP CHARACTER VARYING(24) 24
10 LOAD_STATUS_FLAG CHARACTER VARYING(1) 1
11 INSERT_RUN_AUDIT_ID NUMERIC(38,0) 19
12 UPDATE_RUN_AUDIT_ID NUMERIC(38,0) 19
13 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
15 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
16 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8