OPC_HST_SWDS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_SWDS

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACCRINT NUMERIC(19,4) 19
3 BASIS CHARACTER VARYING(6) 6
4 BR CHARACTER VARYING(2) 2
5 BRPRCINDTE CHARACTER VARYING(10) 10
6 CALCRULE CHARACTER VARYING(3) 3
7 COLLARIND CHARACTER VARYING(1) 1
8 COMPOUND CHARACTER VARYING(1) 1
9 CORPSPREAD_8 NUMERIC(18,8) 19
10 CORPSPREADAMT NUMERIC(19,4) 19
11 DEALIND CHARACTER VARYING(1) 1
12 DEALNO CHARACTER VARYING(8) 8
13 EXCHAMT NUMERIC(19,4) 19
14 EXCHRATE_8 NUMERIC(18,8) 19
15 EXCHRATEREVDATE CHARACTER VARYING(10) 10
16 EXCHTERMS CHARACTER VARYING(1) 1
17 FACTOR_12 NUMERIC(18,12) 19
18 FACTORDATE CHARACTER VARYING(10) 10
19 FACTORFIXDATE CHARACTER VARYING(10) 10
20 FACTORREVDATE CHARACTER VARYING(10) 10
21 FIXEDINTAMT NUMERIC(19,4) 19
22 FIXFLOATIND CHARACTER VARYING(1) 1
23 FLATINTCOMPAMT NUMERIC(19,4) 19
24 IMPLINTAMT NUMERIC(19,4) 19
25 IMPLINTRATE_8 NUMERIC(18,8) 19
26 INDEX_8 NUMERIC(18,8) 19
27 INTAMT NUMERIC(19,4) 19
28 INTCCY CHARACTER VARYING(3) 3
29 INTDEAL CHARACTER VARYING(1) 1
30 INTENDDTE CHARACTER VARYING(10) 10
31 INTRATE_8 NUMERIC(18,8) 19
32 INTRATECAP_8 NUMERIC(18,8) 19
33 INTRATEFLOOR_8 NUMERIC(18,8) 19
34 INTSACCT CHARACTER VARYING(15) 15
35 INTSMEANS CHARACTER VARYING(7) 7
36 INTSTRTDTE CHARACTER VARYING(10) 10
37 IPAYDATE CHARACTER VARYING(10) 10
38 LASTCOUPONDATE CHARACTER VARYING(10) 10
39 LSTMNTDTE CHARACTER VARYING(10) 10
40 NETIPAY NUMERIC(19,4) 19
41 PAYRECIND CHARACTER VARYING(1) 1
42 POSNINTAMT NUMERIC(19,4) 19
43 PPAYAMT NUMERIC(19,4) 19
44 PPAYAUTHDTE CHARACTER VARYING(10) 10
45 PPAYAUTHIND CHARACTER VARYING(1) 1
46 PPAYAUTHOPER CHARACTER VARYING(4) 4
47 PPAYCCY CHARACTER VARYING(3) 3
48 PPAYDATE CHARACTER VARYING(10) 10
49 PRINADJAMT NUMERIC(19,4) 19
50 PRINAMT NUMERIC(19,4) 19
51 PRINCCY CHARACTER VARYING(3) 3
52 PRINCCYINTAMT NUMERIC(19,4) 19
53 PRINRATECODE CHARACTER VARYING(7) 7
54 PRINSETTACCT CHARACTER VARYING(15) 15
55 PRINSETTMEANS CHARACTER VARYING(7) 7
56 PRODTYPE CHARACTER VARYING(2) 2
57 PRODUCT CHARACTER VARYING(6) 6
58 PS CHARACTER VARYING(1) 1
59 PVAMT NUMERIC(19,4) 19
60 PVBAMT NUMERIC(19,4) 19
61 RATECODE CHARACTER VARYING(7) 7
62 RATEFIXDTE CHARACTER VARYING(10) 10
63 REMAININGPAY NUMERIC(19,4) 19
64 REVDATE CHARACTER VARYING(10) 10
65 SCHDSEQ CHARACTER VARYING(3) 3
66 SCHDTYPE CHARACTER VARYING(1) 1
67 SEQ CHARACTER VARYING(4) 4
68 SETTLE CHARACTER VARYING(1) 1
69 SPREAD_8 NUMERIC(18,8) 19
70 SPREADAMT NUMERIC(19,4) 19
71 STEPRATE_8 NUMERIC(18,8) 19
72 STRIKE_8 NUMERIC(18,8) 19
73 MATDATE CHARACTER VARYING(10) 10
74 COST CHARACTER VARYING(10) 10
75 NOTCCY CHARACTER VARYING(3) 3
76 CNO CHARACTER VARYING(11) 11
77 SETTLEDATE CHARACTER VARYING(10) 10
78 PORTFOLIO_DATE CHARACTER VARYING(10) 10
79 INTERNALRATE_8 NUMERIC(18,8) 19
80 RATEREVDTE CHARACTER VARYING(10) 10
81 RATEREVFRSTLST CHARACTER VARYING(1) 1
82 VERDATE CHARACTER VARYING(10) 10
83 AMOUNT1 NUMERIC(19,4) 19
84 AMOUNT2 NUMERIC(19,4) 19
85 AMOUNT3 NUMERIC(19,4) 19
86 AMOUNT4 NUMERIC(19,4) 19
87 AMOUNT5 NUMERIC(19,4) 19
88 BREAKDATE CHARACTER VARYING(10) 10
89 CCYTAX CHARACTER VARYING(3) 3
90 CHAR1 CHARACTER VARYING(20) 20
91 CHAR2 CHARACTER VARYING(20) 20
92 CHAR3 CHARACTER VARYING(20) 20
93 CONVPRICE_12 NUMERIC(22,12) 19
94 DATE1 CHARACTER VARYING(10) 10
95 DATE2 CHARACTER VARYING(10) 10
96 DATE3 CHARACTER VARYING(10) 10
97 DATE4 CHARACTER VARYING(10) 10
98 DIVMKTMKTAMT NUMERIC(19,4) 19
99 DIVPAYAMT NUMERIC(19,4) 19
100 DIVPAYDATEIND CHARACTER VARYING(2) 2
101 DIVPERCENT_8 NUMERIC(18,8) 19
102 EQUITYTYPE CHARACTER VARYING(2) 2
103 FIXINGOVERRIDE BIGINT 8
104 FLAG2 CHARACTER VARYING(1) 1
105 FLAG3 CHARACTER VARYING(1) 1
106 FORMULAID BIGINT 8
107 FORMULAIND CHARACTER VARYING(1) 1
108 GROUPID BIGINT 8
109 INTAUTHDATE CHARACTER VARYING(10) 10
110 INTAUTHIND CHARACTER VARYING(1) 1
111 INTAUTHOPER CHARACTER VARYING(4) 4
112 INTEXCHRATE_8 NUMERIC(18,8) 19
113 INTEXCHTERMS CHARACTER VARYING(1) 1
114 INTNEGAUTHDTE CHARACTER VARYING(10) 10
115 INTNEGAUTHIND CHARACTER VARYING(1) 1
116 INTNEGAUTHOPER CHARACTER VARYING(4) 4
117 INTNEGSACCT CHARACTER VARYING(15) 15
118 INTNEGSMEANS CHARACTER VARYING(7) 7
119 MBSPAYDAY CHARACTER VARYING(2) 2
120 PARTICPERC_8 NUMERIC(18,8) 19
121 PPAYEXCHRATE_8 NUMERIC(18,8) 19
122 PPAYEXCHTERMS CHARACTER VARYING(1) 1
123 PPAYVERDATE CHARACTER VARYING(10) 10
124 PRICE_12 NUMERIC(22,12) 19
125 PRICEEXCHRATE_8 NUMERIC(18,8) 19
126 PRICEEXCHTERMS CHARACTER VARYING(1) 1
127 RATE1_8 NUMERIC(18,8) 19
128 RATE2_8 NUMERIC(18,8) 19
129 RATE3_8 NUMERIC(18,8) 19
130 RATE4_8 NUMERIC(18,8) 19
131 RATEOFRETURN_12 NUMERIC(18,12) 19
132 REPRICEDATE CHARACTER VARYING(10) 10
133 SHAREADJACCROPTIND CHARACTER VARYING(1) 1
134 SHAREADJRATE_8 NUMERIC(18,8) 19
135 SUMCOMPOUNDAMT NUMERIC(19,4) 19
136 TAXAMT NUMERIC(19,4) 19
137 TAXDDEALNO CHARACTER VARYING(8) 8
138 TAXDPRODTYPE CHARACTER VARYING(2) 2
139 TAXDPRODUCT CHARACTER VARYING(6) 6
140 TAXDSEQ CHARACTER VARYING(4) 4
141 UNADJINTENDDTE CHARACTER VARYING(10) 10
142 UNADJINTSTRTDTE CHARACTER VARYING(10) 10
143 UNDINTPAYAMT NUMERIC(19,4) 19
144 DELTA_TYPE CHARACTER VARYING(1) 1
145 EFFECTIVE_STRT_DT TIMESTAMP 8
146 EFFECTIVE_END_DT TIMESTAMP 8
147 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
148 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
149 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
150 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8