SDW_TSDWM_TRSR_SCR_RI_SHDW

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_SDW_TSDWM_TRSR_SCR_RI_SHDW

Columns
# Name Data Type Length
1 RI_ID BIGINT 8
2 SHDW_RCRD_TP_ID BIGINT 8
3 SHDW_DT TIMESTAMP 8
4 SRC_SCR_ID_CODE CHARACTER VARYING(20) 20
5 LOAD_ST_F CHARACTER VARYING(1) 1
6 ISRT_RUN_AUDT_ID BIGINT 8
7 UDT_RUN_AUDT_ID BIGINT 8
8 SCR_DSC CHARACTER VARYING(256) 256
9 PD_IMT_TP_ID BIGINT 8
10 PD_ID BIGINT 8
11 SRC_PD_TP_CODE CHARACTER VARYING(6) 6
12 SRC_PD_CODE CHARACTER VARYING(6) 6
13 SCR_ISSUR_IP_ID BIGINT 8
14 ISSU_DT TIMESTAMP 8
15 VAL_DT TIMESTAMP 8
16 MAT_DT TIMESTAMP 8
17 LAST_MNT_DT TIMESTAMP 8
18 CCY_TP_ID BIGINT 8
19 INT_CCY_TP_ID BIGINT 8
20 INT_PYMT_CYC_TP_ID BIGINT 8
21 INT_BSS_CODE CHARACTER VARYING(6) 6
22 INT_RATE_ID BIGINT 8
23 REPO_F CHARACTER VARYING(1) 1
24 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
25 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
26 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
27 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8