HILP_PCD_61158

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACTION_CODE CHARACTER VARYING(1) 1
3 PCD_NUMBER INTEGER 4
4 MARGIN_CODE CHARACTER VARYING(3) 3
5 MARGIN_SUB_CODE CHARACTER VARYING(3) 3
6 ENTRY_TYPE CHARACTER VARYING(3) 3
7 MARGIN_CODE_DESC CHARACTER VARYING(40) 40
8 MARGIN_TYPE CHARACTER VARYING(1) 1
9 AUTO_APPLY_OPTION CHARACTER VARYING(1) 1
10 COMMENCE_TXN_CD_N INTEGER 4
11 EXPIRY_TXN_CD_N INTEGER 4
12 DELTA_TYPE CHARACTER VARYING(1) 1
13 EFFECTIVE_STRT_DT TIMESTAMP 8
14 EFFECTIVE_END_DT TIMESTAMP 8
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8