OPC_HST_TYPE

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 PRODCODE CHARACTER VARYING(6) 6
3 TYPE CHARACTER VARYING(2) 2
4 DESCR CHARACTER VARYING(70) 70
5 AL CHARACTER VARYING(1) 1
6 LSTMNTDTE CHARACTER VARYING(10) 10
7 DELTA_TYPE CHARACTER VARYING(1) 1
8 EFFECTIVE_STRT_DT TIMESTAMP 8
9 EFFECTIVE_END_DT TIMESTAMP 8
10 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
11 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
12 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
13 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8