OPIC_OTHR

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