OPIC_VOLD

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 OPTIONTYPE CHARACTER VARYING(4) 4
3 OPTIONTYPEKEY CHARACTER VARYING(20) 20
4 DESMAT CHARACTER VARYING(4) 4
5 CALLPUT CHARACTER VARYING(1) 1
6 STRIKEPRICE_8 NUMERIC(18,8) 19
7 VOLATILITY_8 NUMERIC(18,8) 19
8 ATMONEYIND CHARACTER VARYING(1) 1
9 TERM CHARACTER VARYING(4) 4
10 VOLSOURCE_DDE CHARACTER VARYING(50) 50
11 BIDVOLATILITY_8 NUMERIC(18,8) 19
12 ASKVOLATILITY_8 NUMERIC(18,8) 19
13 BIDVOLSOURCE_DDE CHARACTER VARYING(50) 50
14 ASKVOLSOURCE_DDE CHARACTER VARYING(50) 50
15 EFFDATE TIMESTAMP 8
16 LSTMNTDATE TIMESTAMP 8
17 RISKREV_8 NUMERIC(18,8) 19
18 STRANGLEMGN_8 NUMERIC(18,8) 19
19 RISKREVSOURCE_DDE CHARACTER VARYING(50) 50
20 STRANGLEMGNSOURCE_DDE CHARACTER VARYING(50) 50
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8