OPIC_PORT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(10) 10
2 PORTFOLIO CHARACTER VARYING(4) 4
3 PORTDESC CHARACTER VARYING(70) 70
4 LSTMNTDTE TIMESTAMP 8
5 COST CHARACTER VARYING(10) 10
6 TEXT1 CHARACTER VARYING(35) 35
7 TEXT2 CHARACTER VARYING(35) 35
8 DATE1 TIMESTAMP 8
9 DATE2 TIMESTAMP 8
10 AMOUNT1 NUMERIC(19,4) 19
11 AMOUNT2 NUMERIC(19,4) 19
12 UPDATECOUNTER BIGINT 8
13 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
15 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
16 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8