OPIC_YCRT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 CCY CHARACTER VARYING(3) 3
3 CONTRIBRATE CHARACTER VARYING(8) 8
4 MTYSTART CHARACTER VARYING(5) 5
5 MTYEND CHARACTER VARYING(5) 5
6 BIDRATE_8 NUMERIC(18,8) 19
7 BIDPRICE_8 NUMERIC(18,8) 19
8 BIDSPREAD_8 NUMERIC(18,8) 19
9 MIDRATE_8 NUMERIC(18,8) 19
10 MIDPRICE_8 NUMERIC(18,8) 19
11 MIDSPREAD_8 NUMERIC(18,8) 19
12 OFFERRATE_8 NUMERIC(18,8) 19
13 OFFERPRICE_8 NUMERIC(18,8) 19
14 OFFERSPREAD_8 NUMERIC(18,8) 19
15 SECID CHARACTER VARYING(20) 20
16 LSTMNTDTE TIMESTAMP 8
17 BIDSOURCE_DDE CHARACTER VARYING(50) 50
18 MIDSOURCE_DDE CHARACTER VARYING(50) 50
19 OFFERSOURCE_DDE CHARACTER VARYING(50) 50
20 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
21 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
22 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
23 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8