OPIC_SPDH

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 ASSIGNSEQ CHARACTER VARYING(3) 3
5 FIXINCIND CHARACTER VARYING(1) 1
6 AMENDDATE TIMESTAMP 8
7 AMENDTIME CHARACTER VARYING(8) 8
8 ACCOUNTIND CHARACTER VARYING(1) 1
9 AETRAD CHARACTER VARYING(4) 4
10 ASSIGNIND CHARACTER VARYING(1) 1
11 BVAMORTAMT NUMERIC(19,4) 19
12 BVINTAMT NUMERIC(19,4) 19
13 BRPRCINDTE TIMESTAMP 8
14 BROK CHARACTER VARYING(11) 11
15 BROKFEEAMT NUMERIC(19,4) 19
16 BROKFEECCY CHARACTER VARYING(3) 3
17 CHARGEAMT NUMERIC(19,4) 19
18 CLEARDATE TIMESTAMP 8
19 CLEARINPUTDATE TIMESTAMP 8
20 CLEAROPER CHARACTER VARYING(4) 4
21 COMMAMT NUMERIC(19,4) 19
22 COMMRATE_8 NUMERIC(18,8) 19
23 COMREFNO CHARACTER VARYING(16) 16
24 CONFDATE TIMESTAMP 8
25 CONFOPER CHARACTER VARYING(4) 4
26 COST CHARACTER VARYING(10) 10
27 COUPONNO CHARACTER VARYING(7) 7
28 CCYAUTHDATE TIMESTAMP 8
29 CCYAUTHIND CHARACTER VARYING(1) 1
30 CCYAUTHOPER CHARACTER VARYING(4) 4
31 CCY CHARACTER VARYING(3) 3
32 CNO CHARACTER VARYING(10) 10
33 CUSTCONFDATE TIMESTAMP 8
34 CUSTREFNO CHARACTER VARYING(16) 16
35 DEALDATE TIMESTAMP 8
36 DEALSRCE CHARACTER VARYING(10) 10
37 DEALTEXT CHARACTER VARYING(70) 70
38 DEALTIME CHARACTER VARYING(8) 8
39 DISCAMT NUMERIC(19,4) 19
40 DISCRATE_8 NUMERIC(18,8) 19
41 DISPRICE_8 NUMERIC(18,8) 19
42 FACEAMT NUMERIC(19,4) 19
43 FAILDATE TIMESTAMP 8
44 FAILINPUTDATE TIMESTAMP 8
45 FAILOPER CHARACTER VARYING(4) 4
46 FAILINTAMT NUMERIC(19,4) 19
47 FEEAMT NUMERIC(19,4) 19
48 GAINAMT NUMERIC(19,4) 19
49 INPUTDATE TIMESTAMP 8
50 IOPER CHARACTER VARYING(4) 4
51 INPUTTIME CHARACTER VARYING(8) 8
52 INVTYPE CHARACTER VARYING(1) 1
53 LINKORDERNO CHARACTER VARYING(8) 8
54 LINKSEQ CHARACTER VARYING(4) 4
55 LOSSAMT NUMERIC(19,4) 19
56 MUTFUNDIND CHARACTER VARYING(1) 1
57 ORIGAMT NUMERIC(19,4) 19
58 ORIGQTY NUMERIC(19,4) 19
59 PORT CHARACTER VARYING(4) 4
60 PREMAMT NUMERIC(19,4) 19
61 PRICE_8 NUMERIC(18,8) 19
62 PRINAMT NUMERIC(19,4) 19
63 PRINAGIND CHARACTER VARYING(1) 1
64 PROCEEDAMT NUMERIC(19,4) 19
65 PRODUCT CHARACTER VARYING(6) 6
66 PRODTYPE CHARACTER VARYING(2) 2
67 PS CHARACTER VARYING(1) 1
68 PURCHINTAMT NUMERIC(19,4) 19
69 QTY NUMERIC(19,4) 19
70 REVDATE TIMESTAMP 8
71 REVOPER CHARACTER VARYING(4) 4
72 REVREASON CHARACTER VARYING(2) 2
73 REVTEXT CHARACTER VARYING(70) 70
74 REVTIME CHARACTER VARYING(8) 8
75 SECSACCT CHARACTER VARYING(15) 15
76 SECAUTHDATE TIMESTAMP 8
77 SECAUTHIND CHARACTER VARYING(1) 1
78 SECAUTHOPER CHARACTER VARYING(4) 4
79 SECID CHARACTER VARYING(20) 20
80 SERIES CHARACTER VARYING(5) 5
81 CCYSACCT CHARACTER VARYING(15) 15
82 SETTDATE TIMESTAMP 8
83 CCYSMEANS CHARACTER VARYING(7) 7
84 SPREADRATE_8 NUMERIC(18,8) 19
85 SUPPCONFIND CHARACTER VARYING(1) 1
86 SYMBOLID CHARACTER VARYING(8) 8
87 VATAMT NUMERIC(19,4) 19
88 TRAD CHARACTER VARYING(4) 4
89 VERIND CHARACTER VARYING(1) 1
90 VERDATE TIMESTAMP 8
91 VOPER CHARACTER VARYING(4) 4
92 WHENISSIND CHARACTER VARYING(1) 1
93 YIELD_8 NUMERIC(18,8) 19
94 EXCHCNO CHARACTER VARYING(11) 11
95 EXCHCOMMAMT NUMERIC(19,4) 19
96 EXCHCCY CHARACTER VARYING(3) 3
97 CNARR CHARACTER VARYING(70) 70
98 FROMDAYS CHARACTER VARYING(4) 4
99 TODAYS CHARACTER VARYING(4) 4
100 DELAYDELIVIND CHARACTER VARYING(1) 1
101 ISSUER CHARACTER VARYING(11) 11
102 RATCNO CHARACTER VARYING(11) 11
103 CRATING CHARACTER VARYING(10) 10
104 RATECODE CHARACTER VARYING(7) 7
105 AGENCY CHARACTER VARYING(11) 11
106 WHTAMT NUMERIC(19,4) 19
107 EXCHIND CHARACTER VARYING(1) 1
108 OFFASSAMT NUMERIC(19,4) 19
109 ESTAMT NUMERIC(19,4) 19
110 ASSIGNEDQTY NUMERIC(19,4) 19
111 CONVINTAMT NUMERIC(19,4) 19
112 CONVINTBAMT NUMERIC(19,4) 19
113 SETTAMT NUMERIC(19,4) 19
114 SETTBASEAMT NUMERIC(19,4) 19
115 COSTAMT NUMERIC(19,4) 19
116 COSTBAMT NUMERIC(19,4) 19
117 INTCCY CHARACTER VARYING(3) 3
118 SETTCCY CHARACTER VARYING(3) 3
119 SETTPROCEXCHRATE_8 NUMERIC(18,8) 19
120 SETTPROCTERMS CHARACTER VARYING(1) 1
121 SETTPROCPREMDISC_8 NUMERIC(18,8) 19
122 INTSETTEXCHRATE_8 NUMERIC(18,8) 19
123 INTSETTTERMS CHARACTER VARYING(1) 1
124 INTSETTPREMDISC_8 NUMERIC(18,8) 19
125 SETTBASEEXCHRATE_8 NUMERIC(18,8) 19
126 SETTBASETERMS CHARACTER VARYING(1) 1
127 SETTBASEPREMDISC_8 NUMERIC(18,8) 19
128 INTBASEEXCHRATE_8 NUMERIC(18,8) 19
129 INTBASETERMS CHARACTER VARYING(1) 1
130 INTBASEPREMDISC_8 NUMERIC(18,8) 19
131 INTERNALYIELD_8 NUMERIC(18,8) 19
132 INTERNALDISCRATE_8 NUMERIC(18,8) 19
133 INTERNALPRICE_8 NUMERIC(18,8) 19
134 INTERNALPROCEEDAMT NUMERIC(19,4) 19
135 INTERNALSPREADRATE_8 NUMERIC(18,8) 19
136 MARKUPCOMMAMT NUMERIC(19,4) 19
137 AMORTYIELD_8 NUMERIC(18,8) 19
138 AMORTIND CHARACTER VARYING(1) 1
139 PLEDGEID CHARACTER VARYING(30) 30
140 PAIREDFACEAMT NUMERIC(19,4) 19
141 PAIREDAMT NUMERIC(19,4) 19
142 PAIREDIND CHARACTER VARYING(1) 1
143 CURRSPLITSEQ CHARACTER VARYING(4) 4
144 UPDATECOUNTER BIGINT 8
145 BTBDEALNO CHARACTER VARYING(8) 8
146 BTBPORT CHARACTER VARYING(4) 4
147 USUALID CHARACTER VARYING(15) 15
148 LINKDEALNO CHARACTER VARYING(8) 8
149 LINKIND CHARACTER VARYING(1) 1
150 BLOCKIND CHARACTER VARYING(1) 1
151 SPLITIND CHARACTER VARYING(1) 1
152 INDEXRATIO_8 NUMERIC(18,8) 19
153 SWIFTBOTHIND CHARACTER VARYING(1) 1
154 NEWISSUEIND CHARACTER VARYING(1) 1
155 CCPIND CHARACTER VARYING(1) 1
156 EXTCOMPARE CHARACTER VARYING(1) 1
157 NOVFACEAMT NUMERIC(19,4) 19
158 PAYMENTHOLDIND CHARACTER VARYING(1) 1
159 CONVIND CHARACTER VARYING(1) 1
160 EXTBSKTID CHARACTER VARYING(20) 20
161 EXTCONVID CHARACTER VARYING(15) 15
162 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
163 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
164 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
165 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
166 EXCISEAMT NUMERIC(19,4) 19