SDW_TSDMD_CUST_X_CUST

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_X_CUST_ID BIGINT 8
2 GCIS_CUSTOMER_ID BIGINT 8
3 CUSTOMER_ID BIGINT 8
4 EFFECTIVE_DATE TIMESTAMP 8
5 EFFECTIVE_END_DATE TIMESTAMP 8
6 BUSINESS_LOAD_DATE TIMESTAMP 8
7 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
8 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
9 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
10 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8