OPIC_SODT

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 BROK CHARACTER VARYING(10) 10
7 BROKAMT NUMERIC(19,4) 19
8 BROKCCY CHARACTER VARYING(3) 3
9 BROKCDATE TIMESTAMP 8
10 BROKRATE_8 NUMERIC(18,8) 19
11 BRPRCINDTE TIMESTAMP 8
12 CASHAMT NUMERIC(19,4) 19
13 CASHAUTHDTE TIMESTAMP 8
14 CASHAUTHIND CHARACTER VARYING(1) 1
15 CASHAUTHOPER CHARACTER VARYING(4) 4
16 CASHCCY CHARACTER VARYING(3) 3
17 CASHDATE TIMESTAMP 8
18 CASHIND CHARACTER VARYING(1) 1
19 CASHPR CHARACTER VARYING(1) 1
20 CASHSACCT CHARACTER VARYING(15) 15
21 CASHSMEANS CHARACTER VARYING(7) 7
22 CASHSOPER CHARACTER VARYING(4) 4
23 CNO CHARACTER VARYING(10) 10
24 COST CHARACTER VARYING(10) 10
25 CREDITCODE CHARACTER VARYING(7) 7
26 CUSTCDATE TIMESTAMP 8
27 CUTOFF CHARACTER VARYING(20) 20
28 DEALDATE TIMESTAMP 8
29 DEALLINKNO CHARACTER VARYING(20) 20
30 DEALSRCE CHARACTER VARYING(10) 10
31 DEALTEXT CHARACTER VARYING(70) 70
32 DEALTIME CHARACTER VARYING(8) 8
33 DELTA_8 NUMERIC(18,8) 19
34 ETCCY CHARACTER VARYING(3) 3
35 ETFEENO CHARACTER VARYING(8) 8
36 ETPAYRECIND CHARACTER VARYING(1) 1
37 ETSACCT CHARACTER VARYING(15) 15
38 ETSMEANS CHARACTER VARYING(7) 7
39 EXEROPER CHARACTER VARYING(4) 4
40 EXERACT CHARACTER VARYING(1) 1
41 EXERDATE TIMESTAMP 8
42 EXERIND CHARACTER VARYING(1) 1
43 EXPDATE TIMESTAMP 8
44 FEEIND CHARACTER VARYING(1) 1
45 CASHFEEFINCENT CHARACTER VARYING(15) 15
46 PRFEEFINCENT CHARACTER VARYING(15) 15
47 RATECODE CHARACTER VARYING(7) 7
48 INPUTDATE TIMESTAMP 8
49 INPUTTIME CHARACTER VARYING(8) 8
50 IOPER CHARACTER VARYING(4) 4
51 LSTMNTDTE TIMESTAMP 8
52 NOTAMT NUMERIC(19,4) 19
53 NOTCCY CHARACTER VARYING(3) 3
54 OPTIONTYPE CHARACTER VARYING(1) 1
55 PLMETHOD CHARACTER VARYING(1) 1
56 PORT CHARACTER VARYING(4) 4
57 PRCCY CHARACTER VARYING(3) 3
58 PRFEENO CHARACTER VARYING(8) 8
59 PRPAYRECIND CHARACTER VARYING(1) 1
60 PRSACCT CHARACTER VARYING(15) 15
61 PRSMEANS CHARACTER VARYING(7) 7
62 PS CHARACTER VARYING(1) 1
63 REVDATE TIMESTAMP 8
64 REVOPER CHARACTER VARYING(4) 4
65 REVREASON CHARACTER VARYING(2) 2
66 REVTEXT CHARACTER VARYING(70) 70
67 SEQLEG CHARACTER VARYING(3) 3
68 SOPRODTYPE CHARACTER VARYING(2) 2
69 SOPRODUCT CHARACTER VARYING(6) 6
70 STARTDATE TIMESTAMP 8
71 STRIKE_8 NUMERIC(18,8) 19
72 STYLE CHARACTER VARYING(2) 2
73 TENOR CHARACTER VARYING(2) 2
74 TRAD CHARACTER VARYING(4) 4
75 VERDATE TIMESTAMP 8
76 VERIND CHARACTER VARYING(1) 1
77 VOLATILITY_8 NUMERIC(18,8) 19
78 VOPER CHARACTER VARYING(4) 4
79 YIELDCURVE CHARACTER VARYING(9) 9
80 INTRINSICVALUE NUMERIC(19,4) 19
81 TIMEVALUE NUMERIC(19,4) 19
82 EXERINPUTDATE TIMESTAMP 8
83 CASHFEENO CHARACTER VARYING(8) 8
84 UPDATECOUNTER BIGINT 8
85 CORPTRAD CHARACTER VARYING(4) 4
86 CORPPORT CHARACTER VARYING(4) 4
87 CORPCOST CHARACTER VARYING(10) 10
88 CORPSPREAD_8 NUMERIC(18,8) 19
89 CORPSPREADAMT NUMERIC(19,4) 19
90 ORIGPREMRATE_8 NUMERIC(18,8) 19
91 ORIGPREMAMT NUMERIC(19,4) 19
92 LOSS NUMERIC(19,4) 19
93 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
94 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
95 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
96 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8