SDW_TSDWX_IP_X_ADDR

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 IP_X_ADDR_ID BIGINT 8
2 IP_ID BIGINT 8
3 ADDR_TP_ID BIGINT 8
4 EFF_DT TIMESTAMP 8
5 LOAD_ST_F CHARACTER VARYING(1) 1
6 ISRT_RUN_AUDT_ID BIGINT 8
7 UDT_RUN_AUDT_ID BIGINT 8
8 END_DT TIMESTAMP 8
9 PRIM_ELC_ADDR_F CHARACTER VARYING(1) 1
10 ELC_ADDR_DTLS CHARACTER VARYING(320) 320
11 DPID CHARACTER VARYING(9) 9
12 ADDR_LN_1 CHARACTER VARYING(50) 50
13 ADDR_LN_2 CHARACTER VARYING(50) 50
14 ADDR_LN_3 CHARACTER VARYING(50) 50
15 ADDR_LN_4 CHARACTER VARYING(50) 50
16 ADDR_LN_5 CHARACTER VARYING(50) 50
17 SUBURB_OR_CITY CHARACTER VARYING(40) 40
18 STE CHARACTER VARYING(30) 30
19 PST_CODE CHARACTER VARYING(10) 10
20 CTY_CODE_TP_ID BIGINT 8
21 SCRBBED_TP_ID BIGINT 8
22 SRC_CRT_BY_USR_CODE CHARACTER VARYING(10) 10
23 SRC_EFF_DT TIMESTAMP 8
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