OPIC_SPSH_FATCA

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

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