SDW_TSDWR_OF_TRANS_HDR

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..FINRPTLGY_SDW_TSDWR_OF_TRANS_HDR

SDSNZP02_BANK..UBAR_SDW_TSDWR_OF_TRANS_HDR

SDSNZP05_BANK..CBP_SDW_TSDWR_OF_TRANS_HDR

Columns
# Name Data Type Length
1 HEADER_ID BIGINT 8
2 ISRT_RUN_AUDT_ID BIGINT 8
3 UDT_RUN_AUDT_ID BIGINT 8
4 LOOKUP_TYPE CHARACTER VARYING(50) 50
5 MODULE CHARACTER VARYING(50) 50
6 ORGANISATION CHARACTER VARYING(50) 50
7 DESCRIPTION CHARACTER VARYING(250) 250
8 CREATION_DATE TIMESTAMP 8
9 CREATED_BY BIGINT 8
10 LAST_UPDATED_BY BIGINT 8
11 LAST_UPDATE_DATE TIMESTAMP 8
12 LAST_UPDATE_LOGIN BIGINT 8
13 COLUMN_DESCRIPTION CHARACTER VARYING(2000) 2000
14 DST_SEGMENT_NAME1 CHARACTER VARYING(30) 30
15 DST_SEGMENT_NAME2 CHARACTER VARYING(30) 30
16 DST_SEGMENT_NAME3 CHARACTER VARYING(30) 30
17 DST_SEGMENT_NAME4 CHARACTER VARYING(30) 30
18 DST_SEGMENT_NAME5 CHARACTER VARYING(30) 30
19 DST_SEGMENT_NAME6 CHARACTER VARYING(30) 30
20 DST_SEGMENT_NAME7 CHARACTER VARYING(30) 30
21 DST_SEGMENT_NAME8 CHARACTER VARYING(30) 30
22 DST_SEGMENT_NAME9 CHARACTER VARYING(30) 30
23 DST_SEGMENT_NAME10 CHARACTER VARYING(30) 30
24 DST_SEGMENT_NAME11 CHARACTER VARYING(30) 30
25 SRC_SEGMENT_NAME1 CHARACTER VARYING(30) 30
26 SRC_SEGMENT_NAME2 CHARACTER VARYING(30) 30
27 SRC_SEGMENT_NAME3 CHARACTER VARYING(30) 30
28 SRC_SEGMENT_NAME4 CHARACTER VARYING(30) 30
29 SRC_SEGMENT_NAME5 CHARACTER VARYING(30) 30
30 SRC_SEGMENT_NAME6 CHARACTER VARYING(30) 30
31 SRC_SEGMENT_NAME7 CHARACTER VARYING(30) 30
32 SRC_SEGMENT_NAME8 CHARACTER VARYING(30) 30
33 EFFECTIVE_DATE TIMESTAMP 8
34 END_DATE TIMESTAMP 8
35 CURRENT_FLAG CHARACTER VARYING(1) 1
36 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
37 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
38 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
39 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8