SDW_TSDWM_IP_SHDW

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_SDW_TSDWM_IP_SHDW

Columns
# Name Data Type Length
1 IP_ID BIGINT 8
2 SHDW_RCRD_TP_ID BIGINT 8
3 SHDW_DT TIMESTAMP 8
4 IP_RL_TP_ID BIGINT 8
5 SRC_STM_ID BIGINT 8
6 SRC_CODE CHARACTER VARYING(20) 20
7 LOAD_ST_F CHARACTER VARYING(1) 1
8 ISRT_RUN_AUDT_ID BIGINT 8
9 UDT_RUN_AUDT_ID BIGINT 8
10 UNQ_ID_SRC_STM CHARACTER VARYING(32) 32
11 IP_TP_ID BIGINT 8
12 SRC_EFF_DT TIMESTAMP 8
13 SRC_END_DT TIMESTAMP 8
14 SRC_LAST_MNT_DT TIMESTAMP 8
15 NM CHARACTER VARYING(256) 256
16 IP_GVN_NM CHARACTER VARYING(80) 80
17 IP_FAM_NM CHARACTER VARYING(80) 80
18 BRTH_DT TIMESTAMP 8
19 DEATH_DT TIMESTAMP 8
20 IDY_CL_ID BIGINT 8
21 IDV_OCP_TP_ID BIGINT 8
22 IDV_MAR_ST_TP_ID BIGINT 8
23 IDV_GND_ID BIGINT 8
24 BNKR_DT TIMESTAMP 8
25 INF_VERF_IND CHARACTER VARYING(2) 2
26 BR_OU_IP_ID BIGINT 8
27 CNSLD_BRWR_CODE CHARACTER VARYING(20) 20
28 BKR_GRP_CODE CHARACTER VARYING(1) 1
29 SRC_STRT_DT TIMESTAMP 8
30 CST_TP_ID BIGINT 8
31 BSN_CST_TP_ID BIGINT 8
32 ABN_CODE CHARACTER VARYING(20) 20
33 TTL_CL_ID BIGINT 8
34 GRP_IP_ID BIGINT 8
35 TR_TP_ID BIGINT 8
36 MGN_OU_IP_ID BIGINT 8
37 IP_LCS_TP_ID BIGINT 8
38 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
39 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
40 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
41 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8