HILP_PCD_17462

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..QRMCGN_HILP_PCD_17462

SDSNZP02_BANK..UBAR_HILP_PCD_17462

SDSNZP05_BANK..CBP_HILP_PCD_17462

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACTION_CODE CHARACTER VARYING(1) 1
3 PCD_NUMBER INTEGER 4
4 DIVISION_CODE CHARACTER VARYING(5) 5
5 DIVISION_NAME CHARACTER VARYING(40) 40
6 DELTA_TYPE CHARACTER VARYING(1) 1
7 EFFECTIVE_STRT_DT TIMESTAMP 8
8 EFFECTIVE_END_DT TIMESTAMP 8
9 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
10 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
11 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
12 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8