OPIC_SWDS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..BNKFRC_OPIC_SWDS

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