OPIC_RPRH

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(3) 3
4 AETRAD CHARACTER VARYING(4) 4
5 ASSIGNIND CHARACTER VARYING(1) 1
6 ASSGNQTY NUMERIC(19,4) 19
7 BRPRCINDTE TIMESTAMP 8
8 BROK CHARACTER VARYING(11) 11
9 BROKFEEAMT NUMERIC(19,4) 19
10 BROKFEECCY CHARACTER VARYING(3) 3
11 CHARGEAMT NUMERIC(19,4) 19
12 COMAUTHDATE TIMESTAMP 8
13 COMAUTHIND CHARACTER VARYING(1) 1
14 COMAUTHOPER CHARACTER VARYING(4) 4
15 COMCCYSACCT CHARACTER VARYING(15) 15
16 COMCCYSMEANS CHARACTER VARYING(7) 7
17 COMREFNO CHARACTER VARYING(16) 16
18 CONFDATE TIMESTAMP 8
19 CONFOPER CHARACTER VARYING(4) 4
20 CNARR CHARACTER VARYING(70) 70
21 COST CHARACTER VARYING(10) 10
22 CCY CHARACTER VARYING(3) 3
23 CNO CHARACTER VARYING(11) 11
24 CUSTCONFDATE TIMESTAMP 8
25 CUSTREFNO CHARACTER VARYING(16) 16
26 DEALDATE TIMESTAMP 8
27 DEALSCRE CHARACTER VARYING(10) 10
28 DEALTEXT CHARACTER VARYING(70) 70
29 DEALTIME CHARACTER VARYING(8) 8
30 FEEAMT NUMERIC(19,4) 19
31 FINFXRATE_8 NUMERIC(18,8) 19
32 FINTERMS CHARACTER VARYING(1) 1
33 INITFXRATE_8 NUMERIC(18,8) 19
34 INITTERMS CHARACTER VARYING(1) 1
35 INPUTDATE TIMESTAMP 8
36 IOPER CHARACTER VARYING(4) 4
37 INPUTTIME CHARACTER VARYING(8) 8
38 BASIS CHARACTER VARYING(6) 6
39 INTCALCTYPE CHARACTER VARYING(3) 3
40 MARGCALLPCT_8 NUMERIC(18,8) 19
41 MARGINPCT CHARACTER VARYING(5) 5
42 MATAUTHDATE TIMESTAMP 8
43 MATAUTHIND CHARACTER VARYING(1) 1
44 MATAUTHOPER CHARACTER VARYING(4) 4
45 MATDATE TIMESTAMP 8
46 MATCCYSACCT CHARACTER VARYING(15) 15
47 MATCCYSMEANS CHARACTER VARYING(7) 7
48 NOTAMT NUMERIC(19,4) 19
49 NOTCCY CHARACTER VARYING(3) 3
50 NOTTOTLINT NUMERIC(19,4) 19
51 OPENREPOIND CHARACTER VARYING(1) 1
52 PRODUCT CHARACTER VARYING(6) 6
53 PRODTYPE CHARACTER VARYING(2) 2
54 PS CHARACTER VARYING(1) 1
55 MQTY NUMERIC(19,4) 19
56 QUOTQTY NUMERIC(19,4) 19
57 REPOAMT NUMERIC(19,4) 19
58 REPORATE_8 NUMERIC(18,8) 19
59 REVDATE TIMESTAMP 8
60 REVOPER CHARACTER VARYING(4) 4
61 REVREASON CHARACTER VARYING(2) 2
62 REVTEXT CHARACTER VARYING(70) 70
63 REVTIME CHARACTER VARYING(8) 8
64 SPREADRATE_8 NUMERIC(18,8) 19
65 INDEXRATECODE CHARACTER VARYING(7) 7
66 SUBSTITUTE CHARACTER VARYING(1) 1
67 SUPPCONFIND CHARACTER VARYING(1) 1
68 TENOR CHARACTER VARYING(2) 2
69 TOTALINT NUMERIC(19,4) 19
70 TRAD CHARACTER VARYING(4) 4
71 VDATE TIMESTAMP 8
72 VATAMT NUMERIC(19,4) 19
73 VERIND CHARACTER VARYING(1) 1
74 VERDATE TIMESTAMP 8
75 VOPER CHARACTER VARYING(4) 4
76 WHTAMT NUMERIC(19,4) 19
77 YIELD_8 NUMERIC(18,8) 19
78 SAFEKEEPACCT CHARACTER VARYING(15) 15
79 RPIND CHARACTER VARYING(1) 1
80 TOTPROCDAMT NUMERIC(19,4) 19
81 COMPROCDAMT NUMERIC(19,4) 19
82 MATPROCDAMT NUMERIC(19,4) 19
83 ORIGPROCDAMT NUMERIC(19,4) 19
84 CLOSEREPOIND CHARACTER VARYING(1) 1
85 EMPENAMT NUMERIC(19,4) 19
86 EMIOPER CHARACTER VARYING(4) 4
87 EMINPUTDATE TIMESTAMP 8
88 ORIGMDATE TIMESTAMP 8
89 INTCALCDIND CHARACTER VARYING(1) 1
90 PORT CHARACTER VARYING(4) 4
91 RATECODE CHARACTER VARYING(7) 7
92 COLLATERALCODE CHARACTER VARYING(20) 20
93 COLLUNIT CHARACTER VARYING(3) 3
94 DELIVTYPE CHARACTER VARYING(3) 3
95 COUPREINVEST CHARACTER VARYING(1) 1
96 COUPREINVRATE_8 NUMERIC(18,8) 19
97 CONFCODE CHARACTER VARYING(4) 4
98 INITBASERATE_8 NUMERIC(18,8) 19
99 INITBASETERMS CHARACTER VARYING(1) 1
100 FINBASERATE_8 NUMERIC(18,8) 19
101 FINBASETERMS CHARACTER VARYING(1) 1
102 OPENREPOMATDAYS CHARACTER VARYING(3) 3
103 INITINDEXRATE_8 NUMERIC(18,8) 19
104 FININDEXRATE_8 NUMERIC(18,8) 19
105 FINEXCHRATEFIXDATE TIMESTAMP 8
106 FININDXRATEFIXDATE TIMESTAMP 8
107 INTRATEFIXDATE TIMESTAMP 8
108 FINEXCHRATEENTDATE TIMESTAMP 8
109 FININDXRATEENTDATE TIMESTAMP 8
110 INTRATEENDDATE TIMESTAMP 8
111 UPDATECOUNTER BIGINT 8
112 COMPROCBASEAMT NUMERIC(19,4) 19
113 MATPROCBASEAMT NUMERIC(19,4) 19
114 CONVINTAMT NUMERIC(19,4) 19
115 CONVINTBAMT NUMERIC(19,4) 19
116 ASSIGNDATE TIMESTAMP 8
117 PRINBASERATEFIXDATE TIMESTAMP 8
118 PRINBASERATEENTDATE TIMESTAMP 8
119 OVERRIDEWXTAXIND CHARACTER VARYING(1) 1
120 BORRLENDIND CHARACTER VARYING(1) 1
121 TEXT1 CHARACTER VARYING(35) 35
122 TEXT2 CHARACTER VARYING(35) 35
123 DATE1 TIMESTAMP 8
124 DATE2 TIMESTAMP 8
125 AMOUNT1 NUMERIC(19,4) 19
126 AMOUNT2 NUMERIC(19,4) 19
127 RATE1_8 NUMERIC(18,8) 19
128 RATE2_8 NUMERIC(18,8) 19
129 COMMAMT NUMERIC(19,4) 19
130 EXCHCOMMAMT NUMERIC(19,4) 19
131 STAMPDUTYAMT NUMERIC(19,4) 19
132 EXCHCNO CHARACTER VARYING(11) 11
133 EXCHIND CHARACTER VARYING(1) 1
134 BTBDEALNO CHARACTER VARYING(8) 8
135 COMMUSUALID CHARACTER VARYING(15) 15
136 MATUSUALID CHARACTER VARYING(15) 15
137 SWIFTBOTHIND CHARACTER VARYING(1) 1
138 LINKDEALNO CHARACTER VARYING(8) 8
139 LINKIND CHARACTER VARYING(3) 3
140 BLOCKIND CHARACTER VARYING(1) 1
141 SPLITIND CHARACTER VARYING(1) 1
142 CCPIND CHARACTER VARYING(1) 1
143 EXTCOMPARE CHARACTER VARYING(1) 1
144 VDATENET CHARACTER VARYING(1) 1
145 VDPAYMENTHOLDIND CHARACTER VARYING(1) 1
146 MDPAYMENTHOLDIND CHARACTER VARYING(1) 1
147 NEWDEALNO CHARACTER VARYING(8) 8
148 ORIGDEALNO CHARACTER VARYING(8) 8
149 ROLLIND CHARACTER VARYING(1) 1
150 ROLLINPUTDATE TIMESTAMP 8
151 ROLLCAPINTIND CHARACTER VARYING(1) 1
152 ROLLPRINOUT NUMERIC(19,4) 19
153 ROLLPRININ NUMERIC(19,4) 19
154 ROLLDIFFAMT NUMERIC(19,4) 19
155 ROLLREVDATE TIMESTAMP 8
156 MERGEIND CHARACTER VARYING(1) 1
157 ASSIGNMETHOD CHARACTER VARYING(1) 1
158 AUTOASSIGN CHARACTER VARYING(1) 1
159 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
160 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
161 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
162 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
163 STATEDREPORATE_8 NUMERIC(18,8) 19