OPIC_OTCP

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 DEALNO CHARACTER VARYING(8) 8
3 SEQ CHARACTER VARYING(4) 4
4 PRODUCT CHARACTER VARYING(6) 6
5 PRODTYPE CHARACTER VARYING(2) 2
6 OTCTYPE CHARACTER VARYING(2) 2
7 DELTA_8 NUMERIC(18,8) 19
8 THETA_8 NUMERIC(18,8) 19
9 GAMMA_8 NUMERIC(18,8) 19
10 VEGA_8 NUMERIC(18,8) 19
11 MKTPREMAMT NUMERIC(19,4) 19
12 MKTPREMPERC_8 NUMERIC(18,8) 19
13 VOLATILITY_8 NUMERIC(18,8) 19
14 UAPRICE_8 NUMERIC(18,8) 19
15 INTERFACENUM CHARACTER VARYING(15) 15
16 RHO_8 NUMERIC(18,8) 19
17 VANNA_8 NUMERIC(18,8) 19
18 PHI_8 NUMERIC(18,8) 19
19 HEDGE NUMERIC(19,4) 19
20 FORWARD_8 NUMERIC(18,8) 19
21 DEPO_8 NUMERIC(18,8) 19
22 CTRDEPO_8 NUMERIC(18,8) 19
23 HISTSPOT_8 NUMERIC(18,8) 19
24 HISTFORWARD_8 NUMERIC(18,8) 19
25 MKTPREMVAL NUMERIC(19,4) 19
26 PROFIT NUMERIC(19,4) 19
27 TEXT1 CHARACTER VARYING(20) 20
28 TEXT2 CHARACTER VARYING(20) 20
29 TEXT3 CHARACTER VARYING(40) 40
30 RATE1_8 NUMERIC(18,8) 19
31 RATE2_8 NUMERIC(18,8) 19
32 RATE3_8 NUMERIC(18,8) 19
33 AMT1 NUMERIC(19,4) 19
34 AMT2 NUMERIC(19,4) 19
35 DATE1 TIMESTAMP 8
36 DATE2 TIMESTAMP 8
37 IMPLIEDQTY NUMERIC(19,4) 19
38 MARKETPREMAMT NUMERIC(19,4) 19
39 YSTMKTPREMAMT NUMERIC(19,4) 19
40 TDYINTRINSICVAL NUMERIC(19,4) 19
41 YSTINTRINSICVAL NUMERIC(19,4) 19
42 CCYDELTAAMT NUMERIC(19,4) 19
43 CTRDELTAAMT NUMERIC(19,4) 19
44 BASEMKTPREMAMT NUMERIC(19,4) 19
45 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
46 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
47 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
48 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8