OPIC_SWDT

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 DEALIND CHARACTER VARYING(1) 1
5 PRODUCT CHARACTER VARYING(6) 6
6 PRODTYPE CHARACTER VARYING(2) 2
7 BASIS CHARACTER VARYING(6) 6
8 CALCRULE CHARACTER VARYING(3) 3
9 COMPOUND CHARACTER VARYING(1) 1
10 FINEXCHAMT NUMERIC(19,4) 19
11 FINEXCHBAMT NUMERIC(19,4) 19
12 FINEXCHAUTHDTE TIMESTAMP 8
13 FINEXCHAUTHIND CHARACTER VARYING(1) 1
14 FINEXCHCCY CHARACTER VARYING(3) 3
15 FINEXCHDATE TIMESTAMP 8
16 FINEXCHFINCENT CHARACTER VARYING(15) 15
17 FINEXCHOPER CHARACTER VARYING(4) 4
18 FINEXCHSACCT CHARACTER VARYING(15) 15
19 FINEXCHSMEANS CHARACTER VARYING(7) 7
20 FIRSTIPAYDATE TIMESTAMP 8
21 FIXDINTAMT NUMERIC(19,4) 19
22 FIXFLOATIND CHARACTER VARYING(1) 1
23 INITEXCHAMT NUMERIC(19,4) 19
24 INITEXCHBAMT NUMERIC(19,4) 19
25 INITEXCHAUTHDTE TIMESTAMP 8
26 INITEXCHAUTHIND CHARACTER VARYING(1) 1
27 INITEXCHCCY CHARACTER VARYING(3) 3
28 INITEXCHDATE TIMESTAMP 8
29 INITEXCHFINCENT CHARACTER VARYING(15) 15
30 INITEXCHOPER CHARACTER VARYING(4) 4
31 INITEXCHSMEANS CHARACTER VARYING(7) 7
32 INITEXCHSACCT CHARACTER VARYING(15) 15
33 INTAUTHDTE TIMESTAMP 8
34 INTAUTHIND CHARACTER VARYING(1) 1
35 INTAUTHOPER CHARACTER VARYING(4) 4
36 INTCONVDTE TIMESTAMP 8
37 INTCONVRATE_8 NUMERIC(18,8) 19
38 INTCCY CHARACTER VARYING(3) 3
39 INTEXCHRATE_8 NUMERIC(18,8) 19
40 INTEXCHTERMS CHARACTER VARYING(1) 1
41 INTPAYADJUST CHARACTER VARYING(1) 1
42 INTPAYCYCLE CHARACTER VARYING(3) 3
43 INTPAYDAY CHARACTER VARYING(2) 2
44 INTPAYFINCENT CHARACTER VARYING(15) 15
45 INTPAYPAYRULE CHARACTER VARYING(3) 3
46 INTRATE_8 NUMERIC(18,8) 19
47 INTRATECAP_8 NUMERIC(18,8) 19
48 INTRATEFLOOR_8 NUMERIC(18,8) 19
49 INTSACCT CHARACTER VARYING(15) 15
50 INTSMEANS CHARACTER VARYING(7) 7
51 LASTIPAYDATE TIMESTAMP 8
52 MATDATE TIMESTAMP 8
53 NOTCCY CHARACTER VARYING(3) 3
54 NOTCCYAMT NUMERIC(19,4) 19
55 NPVAMT NUMERIC(19,4) 19
56 NXTRATEREV TIMESTAMP 8
57 PAYRECIND CHARACTER VARYING(1) 1
58 RATECODE CHARACTER VARYING(7) 7
59 RATEREVCYCLE CHARACTER VARYING(3) 3
60 RATEREVDAY CHARACTER VARYING(2) 2
61 RATEREVDTE TIMESTAMP 8
62 RATEREVFINCENT CHARACTER VARYING(15) 15
63 RATEREVFRSTLST CHARACTER VARYING(1) 1
64 RATEREVPAYRULE CHARACTER VARYING(3) 3
65 SCHDFLAG CHARACTER VARYING(1) 1
66 SPREAD_8 NUMERIC(18,8) 19
67 STARTDATE TIMESTAMP 8
68 UPFRONTFEENO CHARACTER VARYING(8) 8
69 UPFRONTFEENETTYPE CHARACTER VARYING(1) 1
70 YIELDCURVE CHARACTER VARYING(8) 8
71 ACRFRSTLST CHARACTER VARYING(1) 1
72 NPVAMTINITEXCH NUMERIC(19,4) 19
73 NPVAMTFINEXCH NUMERIC(19,4) 19
74 PS CHARACTER VARYING(1) 1
75 STRIKE_8 NUMERIC(18,8) 19
76 INDEX_8 NUMERIC(18,8) 19
77 PARTICPERC_8 NUMERIC(18,8) 19
78 DELTA_8 NUMERIC(18,8) 19
79 VOLATILITY_8 NUMERIC(18,8) 19
80 SETTFIRST CHARACTER VARYING(1) 1
81 COLLARIND CHARACTER VARYING(1) 1
82 NPVBAMT NUMERIC(19,4) 19
83 TDYACCRINTAMT NUMERIC(19,4) 19
84 TDYACCRINTBAMT NUMERIC(19,4) 19
85 YSTACCRINTAMT NUMERIC(19,4) 19
86 YSTACCRINTBAMT NUMERIC(19,4) 19
87 NPVBAMTINITEXCH NUMERIC(19,4) 19
88 NPVBAMTFINEXCH NUMERIC(19,4) 19
89 UPFRONTFEEFINCENT CHARACTER VARYING(15) 15
90 UPFRONTFEEIND CHARACTER VARYING(1) 1
91 TDYCOMPRATE_8 NUMERIC(18,8) 19
92 TDYCOMPAMT NUMERIC(19,4) 19
93 YSTCOMPRATE_8 NUMERIC(18,8) 19
94 YSTCOMPAMT NUMERIC(19,4) 19
95 EXCHREVDATE TIMESTAMP 8
96 DATEDIRECTION CHARACTER VARYING(2) 2
97 PURCHINT NUMERIC(19,4) 19
98 LASTCOUPONDATE TIMESTAMP 8
99 PREMDISC NUMERIC(19,4) 19
100 EXCHRATEREVDATE TIMESTAMP 8
101 AMOUNT1 NUMERIC(19,4) 19
102 AMOUNT2 NUMERIC(19,4) 19
103 AMOUNT3 NUMERIC(19,4) 19
104 CHAR1 CHARACTER VARYING(20) 20
105 CHAR2 CHARACTER VARYING(20) 20
106 FORMULAIND CHARACTER VARYING(1) 1
107 DATE1 TIMESTAMP 8
108 DATE2 TIMESTAMP 8
109 FLAG1 CHARACTER VARYING(1) 1
110 RATE1_8 NUMERIC(18,8) 19
111 RATE2_8 NUMERIC(18,8) 19
112 USUALID CHARACTER VARYING(15) 15
113 BTBUSUALID CHARACTER VARYING(15) 15
114 MBSLEG CHARACTER VARYING(1) 1
115 SPEED_12 NUMERIC(18,12) 19
116 SERVICING_12 NUMERIC(18,12) 19
117 PREPAYTYPE CHARACTER VARYING(1) 1
118 SETTNOTIONAL CHARACTER VARYING(1) 1
119 FACTOR_12 NUMERIC(18,12) 19
120 FACTORREVDATE TIMESTAMP 8
121 ORIGPRINADJAMT NUMERIC(19,4) 19
122 INTDEAL CHARACTER VARYING(1) 1
123 INTERNALRATE_8 NUMERIC(18,8) 19
124 CORPSPREAD_8 NUMERIC(18,8) 19
125 BCREDITAMT NUMERIC(19,4) 19
126 BMTMAMT NUMERIC(19,4) 19
127 BMKTAMT NUMERIC(19,4) 19
128 EXCHRATE_8 NUMERIC(18,8) 19
129 EXCHTERMS CHARACTER VARYING(1) 1
130 INITBASEAMT NUMERIC(19,4) 19
131 INITFINAMT NUMERIC(19,4) 19
132 INITFINBASEAMT NUMERIC(19,4) 19
133 INITFINEXCHRATE_8 NUMERIC(18,8) 19
134 INITBASEEXCHRATE_8 NUMERIC(18,8) 19
135 INITFINEXCHTERMS CHARACTER VARYING(1) 1
136 INITBASETERMS CHARACTER VARYING(1) 1
137 FLAG2 CHARACTER VARYING(1) 1
138 FLAG3 CHARACTER VARYING(1) 1
139 RATE3_8 NUMERIC(18,8) 19
140 RATE4_8 NUMERIC(18,8) 19
141 DATE3 TIMESTAMP 8
142 DATE4 TIMESTAMP 8
143 AMOUNT4 NUMERIC(19,4) 19
144 AMOUNT5 NUMERIC(19,4) 19
145 CORPSPREADAMT NUMERIC(19,4) 19
146 POSTNOTIONAL CHARACTER VARYING(1) 1
147 BASKETDESCR CHARACTER VARYING(70) 70
148 CONVPRICE_12 NUMERIC(22,12) 19
149 FWDFWDYIELDCURVE CHARACTER VARYING(8) 8
150 EQUITYTYPE CHARACTER VARYING(2) 2
151 INTNEGAUTHDTE TIMESTAMP 8
152 INTNEGAUTHIND CHARACTER VARYING(1) 1
153 INTNEGAUTHOPER CHARACTER VARYING(4) 4
154 INTNEGSACCT CHARACTER VARYING(15) 15
155 INTNEGSMEANS CHARACTER VARYING(7) 7
156 PRICE_12 NUMERIC(22,12) 19
157 PRICEEXCHRATE_8 NUMERIC(18,8) 19
158 PRICEEXCHTERMS CHARACTER VARYING(1) 1
159 REPRICEIND CHARACTER VARYING(1) 1
160 QUANTITY NUMERIC(19,4) 19
161 SECID CHARACTER VARYING(20) 20
162 SETTDAYS CHARACTER VARYING(3) 3
163 SECCCY CHARACTER VARYING(3) 3
164 REPRICEDATE TIMESTAMP 8
165 RATEOFRETURN_12 NUMERIC(18,12) 19
166 DIVPERCENT_8 NUMERIC(18,8) 19
167 DIVPAYDATEIND CHARACTER VARYING(2) 2
168 DIVREINVESTIND CHARACTER VARYING(1) 1
169 DIVPAYCCYIND CHARACTER VARYING(1) 1
170 MULTIPLIER_8 NUMERIC(18,8) 19
171 RETURNTYPE CHARACTER VARYING(1) 1
172 VALUATIONTIME CHARACTER VARYING(8) 8
173 NXTREPRICEDATE TIMESTAMP 8
174 REPRICEDAYS CHARACTER VARYING(3) 3
175 EXTERNALVALIND CHARACTER VARYING(1) 1
176 NOTIFDAYS CHARACTER VARYING(3) 3
177 NOTIFTIME CHARACTER VARYING(8) 8
178 DEALRATE_8 NUMERIC(18,8) 19
179 DEALTERMS CHARACTER VARYING(1) 1
180 FXRATECODE CHARACTER VARYING(7) 7
181 NEXTFXDATE TIMESTAMP 8
182 EXCHMETHOD CHARACTER VARYING(1) 1
183 MULTICCYACCTIND CHARACTER VARYING(1) 1
184 LEGTYPE CHARACTER VARYING(1) 1
185 SCHEDID BIGINT 8
186 PRODID BIGINT 8
187 FORMULAID BIGINT 8
188 ACCRUALCCY CHARACTER VARYING(3) 3
189 MKTVALSOURCE CHARACTER VARYING(15) 15
190 ACCRUALMETHOD CHARACTER VARYING(3) 3
191 GROSSUFPAYRECIND CHARACTER VARYING(1) 1
192 GROSSUFPAYAMT NUMERIC(19,4) 19
193 GROSSUFPAYRATE_8 NUMERIC(18,8) 19
194 SCHDCONV CHARACTER VARYING(5) 5
195 REDEMPTIONCCYIND CHARACTER VARYING(1) 1
196 NEXTFXPRINDATE TIMESTAMP 8
197 DEFFACTOR NUMERIC(18,8) 19
198 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
199 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
200 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
201 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8