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