OPIC_SWSH

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