OPIC_OTDT

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 AVGRATE_8 NUMERIC(18,8) 19
7 AVGSTKE_8 NUMERIC(18,8) 19
8 AVGSTKEEDATE TIMESTAMP 8
9 AVGSTKESDATE TIMESTAMP 8
10 CCYPREMBAMT NUMERIC(19,4) 19
11 BINARY NUMERIC(19,4) 19
12 BROK CHARACTER VARYING(11) 11
13 CCY CHARACTER VARYING(3) 3
14 CCYCP CHARACTER VARYING(4) 4
15 CCYPREM NUMERIC(19,4) 19
16 CCYPREMAMT NUMERIC(19,4) 19
17 CCYREVALAMT NUMERIC(19,4) 19
18 CCYPREMRATE_8 NUMERIC(18,8) 19
19 CCYPRIN NUMERIC(19,4) 19
20 CONTSIZE NUMERIC(19,4) 19
21 COST CHARACTER VARYING(10) 10
22 CTRCCY CHARACTER VARYING(3) 3
23 CTRCP CHARACTER VARYING(4) 4
24 CTRPREM NUMERIC(19,4) 19
25 CTRPREMAMT NUMERIC(19,4) 19
26 CTRREVALAMT NUMERIC(19,4) 19
27 CTRPREMRATE_8 NUMERIC(18,8) 19
28 CTRPRIN NUMERIC(19,4) 19
29 CNO CHARACTER VARYING(10) 10
30 CUTOFF CHARACTER VARYING(20) 20
31 DEALDATE TIMESTAMP 8
32 DEALVDATE TIMESTAMP 8
33 DEALTEXT CHARACTER VARYING(70) 70
34 DELIVERY CHARACTER VARYING(1) 1
35 DELTA_8 NUMERIC(18,8) 19
36 DKITRIG1_8 NUMERIC(18,8) 19
37 DKITRIG2_8 NUMERIC(18,8) 19
38 DKOTRIG1_8 NUMERIC(18,8) 19
39 DKOTRIG2_8 NUMERIC(18,8) 19
40 EXERDATE TIMESTAMP 8
41 EXERIND CHARACTER VARYING(1) 1
42 EXOTIC CHARACTER VARYING(18) 18
43 EXPDATE TIMESTAMP 8
44 FEEAMT NUMERIC(19,4) 19
45 FEECCY CHARACTER VARYING(3) 3
46 INPUTDATE TIMESTAMP 8
47 INPUTTIME CHARACTER VARYING(8) 8
48 IOPER CHARACTER VARYING(4) 4
49 KITRIG_8 NUMERIC(18,8) 19
50 KOTRIG_8 NUMERIC(18,8) 19
51 LINKDEALNO CHARACTER VARYING(8) 8
52 LINKPRODUCT CHARACTER VARYING(6) 6
53 LINKPRODTYPE CHARACTER VARYING(2) 2
54 LSTMNTDATE TIMESTAMP 8
55 OTCTYPE CHARACTER VARYING(2) 2
56 PREMAUTHDTE TIMESTAMP 8
57 PREMAUTHIND CHARACTER VARYING(1) 1
58 PREMAUTHOPER CHARACTER VARYING(4) 4
59 PREMSMEANS CHARACTER VARYING(7) 7
60 PREMSACCT CHARACTER VARYING(15) 15
61 PREMSOPER CHARACTER VARYING(4) 4
62 PLMETHOD CHARACTER VARYING(1) 1
63 PORT CHARACTER VARYING(4) 4
64 PS CHARACTER VARYING(1) 1
65 QTY NUMERIC(19,4) 19
66 QUANTO_8 NUMERIC(18,8) 19
67 REVDATE TIMESTAMP 8
68 REVREASON CHARACTER VARYING(2) 2
69 REVTEXT CHARACTER VARYING(70) 70
70 SECID CHARACTER VARYING(20) 20
71 SETTLEDTE TIMESTAMP 8
72 SHPEROPT CHARACTER VARYING(10) 10
73 SIIND CHARACTER VARYING(1) 1
74 STRIKE_8 NUMERIC(18,8) 19
75 STYLE CHARACTER VARYING(4) 4
76 SYMBOL CHARACTER VARYING(14) 14
77 TENOR CHARACTER VARYING(2) 2
78 TERMS CHARACTER VARYING(1) 1
79 TRAD CHARACTER VARYING(4) 4
80 UNIT CHARACTER VARYING(3) 3
81 VERDATE TIMESTAMP 8
82 VERIND CHARACTER VARYING(1) 1
83 VOLATILITY_8 NUMERIC(18,8) 19
84 VOPER CHARACTER VARYING(4) 4
85 DEALSRCE CHARACTER VARYING(10) 10
86 FINCNTR1 CHARACTER VARYING(10) 10
87 FINCNTR2 CHARACTER VARYING(10) 10
88 UNDTENOR CHARACTER VARYING(2) 2
89 UNDACCTNGTYPE CHARACTER VARYING(10) 10
90 STARTDATE TIMESTAMP 8
91 ENDDATE TIMESTAMP 8
92 SPOTRATE_8 NUMERIC(18,8) 19
93 CCYBRATE_8 NUMERIC(18,8) 19
94 CCYBTERMS CHARACTER VARYING(1) 1
95 CTRBRATE_8 NUMERIC(18,8) 19
96 CTRBTERMS CHARACTER VARYING(1) 1
97 CCYINTRATE_8 NUMERIC(18,8) 19
98 CTRINTRATE_8 NUMERIC(18,8) 19
99 PREMCCY CHARACTER VARYING(3) 3
100 PREMAMT NUMERIC(19,4) 19
101 PREMRATE_8 NUMERIC(18,8) 19
102 REVIND CHARACTER VARYING(1) 1
103 BINARYCCY CHARACTER VARYING(3) 3
104 UNDSEQ CHARACTER VARYING(4) 4
105 INTERFACENUM CHARACTER VARYING(15) 15
106 CONTEXT CHARACTER VARYING(20) 20
107 CONTEXT1 CHARACTER VARYING(8) 8
108 CONTEXT2 CHARACTER VARYING(8) 8
109 LOCATION CHARACTER VARYING(20) 20
110 FREQUENCY CHARACTER VARYING(2) 2
111 SOURCE CHARACTER VARYING(20) 20
112 REVALSOURCE CHARACTER VARYING(1) 1
113 PHONCI CHARACTER VARYING(1) 1
114 PHONECDATE TIMESTAMP 8
115 PHONETEXT CHARACTER VARYING(70) 70
116 TEXT1 CHARACTER VARYING(20) 20
117 MASTERAGREEMENT CHARACTER VARYING(20) 20
118 TEXT3 CHARACTER VARYING(40) 40
119 RATE1_8 NUMERIC(18,8) 19
120 RATE2_8 NUMERIC(18,8) 19
121 RATE3_8 NUMERIC(18,8) 19
122 AMT1 NUMERIC(19,4) 19
123 AMT2 NUMERIC(19,4) 19
124 DATE1 TIMESTAMP 8
125 DATE2 TIMESTAMP 8
126 SALESCREDAMT NUMERIC(19,4) 19
127 SALESCREDCCY CHARACTER VARYING(3) 3
128 TRIGIND CHARACTER VARYING(1) 1
129 TRIGDATE TIMESTAMP 8
130 TRIGOPER CHARACTER VARYING(4) 4
131 REBATEAMT NUMERIC(19,4) 19
132 CLOSINGRATE_8 NUMERIC(18,8) 19
133 FEENO CHARACTER VARYING(8) 8
134 FEESEQ CHARACTER VARYING(4) 4
135 CASHSETTLEIND CHARACTER VARYING(1) 1
136 EXEROPER CHARACTER VARYING(4) 4
137 UNDERLYINGIND CHARACTER VARYING(1) 1
138 AMENDDATE TIMESTAMP 8
139 PSDEALNO CHARACTER VARYING(8) 8
140 PSSEQ CHARACTER VARYING(4) 4
141 PSOPER CHARACTER VARYING(4) 4
142 PSDATE TIMESTAMP 8
143 PSIND CHARACTER VARYING(1) 1
144 REVPSDATE TIMESTAMP 8
145 REVQTY NUMERIC(19,4) 19
146 REVPREM NUMERIC(19,4) 19
147 REVPRINCIPAL NUMERIC(19,4) 19
148 MARKETVALIND CHARACTER VARYING(1) 1
149 UNDPRICE_8 NUMERIC(18,8) 19
150 CAPPRICE_8 NUMERIC(18,8) 19
151 DISCPRICE_8 NUMERIC(18,8) 19
152 PARTICPER_8 NUMERIC(18,8) 19
153 LINKPRINAMT NUMERIC(19,4) 19
154 EXPONENT NUMERIC(18,8) 19
155 DISCPER_8 NUMERIC(18,8) 19
156 UPDATECOUNTER BIGINT 8
157 TRIGSTARTDATE TIMESTAMP 8
158 TRIGENDDATE TIMESTAMP 8
159 ORIGPRINCIPAL NUMERIC(19,4) 19
160 ORIGQTY NUMERIC(19,4) 19
161 REPORATECODE CHARACTER VARYING(20) 20
162 AVGMETHOD CHARACTER VARYING(1) 1
163 MATHSOURCE CHARACTER VARYING(20) 20
164 MODEL CHARACTER VARYING(20) 20
165 SWIFTMATCHIND CHARACTER VARYING(1) 1
166 CUSTCDATE TIMESTAMP 8
167 ORIGPREMAMT NUMERIC(19,4) 19
168 ORIGPREMRATE_8 NUMERIC(18,8) 19
169 BRPRCINDTE TIMESTAMP 8
170 SALESCREDITIND CHARACTER VARYING(1) 1
171 ALLOCATEIND CHARACTER VARYING(1) 1
172 ALLOCATEDATE TIMESTAMP 8
173 ASSIGNIND CHARACTER VARYING(1) 1
174 ASSIGNCNO CHARACTER VARYING(10) 10
175 CUSTSTATUS CHARACTER VARYING(20) 20
176 ASSIGNDEALNO CHARACTER VARYING(8) 8
177 ASSIGNDATE TIMESTAMP 8
178 ASSIGNDEALNOSEQ CHARACTER VARYING(4) 4
179 ASSIGNCUSTSTATUS CHARACTER VARYING(20) 20
180 SCHEDID BIGINT 8
181 BASKETID BIGINT 8
182 WTAXAMT NUMERIC(19,4) 19
183 TAXNETPREMAMT NUMERIC(19,4) 19
184 TAXSTATUS CHARACTER VARYING(2) 2
185 CALCAGENT CHARACTER VARYING(1) 1
186 CORPTRAD CHARACTER VARYING(4) 4
187 CORPPORT CHARACTER VARYING(4) 4
188 CORPCOST CHARACTER VARYING(10) 10
189 CORPSPREAD_8 NUMERIC(18,8) 19
190 CORPSPREADAMT NUMERIC(19,4) 19
191 CCYYIELDCURVE CHARACTER VARYING(8) 8
192 CTRYIELDCURVE CHARACTER VARYING(8) 8
193 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
194 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
195 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
196 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8