OPIC_DLHR

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 AMENDDATE TIMESTAMP 8
5 AMENDTIME CHARACTER VARYING(8) 8
6 ACCOUNTIND CHARACTER VARYING(1) 1
7 PRODUCT CHARACTER VARYING(6) 6
8 PRODTYPE CHARACTER VARYING(2) 2
9 TRAD CHARACTER VARYING(4) 4
10 VDATE TIMESTAMP 8
11 MDATE TIMESTAMP 8
12 CNO CHARACTER VARYING(10) 10
13 CCY CHARACTER VARYING(3) 3
14 CCYAMT NUMERIC(19,4) 19
15 ORIGOCAMT NUMERIC(19,4) 19
16 AL CHARACTER VARYING(1) 1
17 RATECODE CHARACTER VARYING(7) 7
18 BASIS CHARACTER VARYING(6) 6
19 INTRATE CHARACTER VARYING(16) 16
20 SPREAD_8 NUMERIC(18,8) 19
21 ACRFRSTLST CHARACTER VARYING(1) 1
22 BROK CHARACTER VARYING(11) 11
23 BROKCCY CHARACTER VARYING(3) 3
24 BROKAMT NUMERIC(19,4) 19
25 BROKRATE_8 NUMERIC(18,8) 19
26 PORT CHARACTER VARYING(4) 4
27 COST CHARACTER VARYING(11) 11
28 DEALDATE TIMESTAMP 8
29 DEALTIME CHARACTER VARYING(8) 8
30 IOPER CHARACTER VARYING(4) 4
31 VOPER CHARACTER VARYING(4) 4
32 GUARANTOR CHARACTER VARYING(10) 10
33 CUSTCDATE TIMESTAMP 8
34 VERIND CHARACTER VARYING(1) 1
35 VERDATE TIMESTAMP 8
36 REVREASON CHARACTER VARYING(2) 2
37 REVDATE TIMESTAMP 8
38 REVTEXT CHARACTER VARYING(70) 70
39 PAYAUTHIND CHARACTER VARYING(1) 1
40 PAYOPER CHARACTER VARYING(4) 4
41 PAYAUTHDTE TIMESTAMP 8
42 RECOPER CHARACTER VARYING(4) 4
43 RECAUTHDTE TIMESTAMP 8
44 INPUTDATE TIMESTAMP 8
45 INPUTTIME CHARACTER VARYING(8) 8
46 DEALSRCE CHARACTER VARYING(10) 10
47 ARBDEALNO CHARACTER VARYING(10) 10
48 TRCEDATE TIMESTAMP 8
49 TRACECNT CHARACTER VARYING(3) 3
50 COMMMEANS CHARACTER VARYING(7) 7
51 COMMACCT CHARACTER VARYING(15) 15
52 MATMEANS CHARACTER VARYING(7) 7
53 MATACCT CHARACTER VARYING(15) 15
54 BRPRCINDTE TIMESTAMP 8
55 DEALTEXT CHARACTER VARYING(70) 70
56 LSTMNTDATE TIMESTAMP 8
57 RATEREVDTE TIMESTAMP 8
58 NXTRATEREV TIMESTAMP 8
59 SCHDFLAG CHARACTER VARYING(1) 1
60 NEWDEALNO CHARACTER VARYING(8) 8
61 ORIGDEALNO CHARACTER VARYING(8) 8
62 INTCAPFLAG CHARACTER VARYING(1) 1
63 INTCAPAMT NUMERIC(19,4) 19
64 LIENAMT NUMERIC(19,4) 19
65 LIENOFFCR CHARACTER VARYING(4) 4
66 LIENDATE TIMESTAMP 8
67 PRMDSCAMRTD NUMERIC(19,4) 19
68 EMPENAMT NUMERIC(19,4) 19
69 EMIOPER CHARACTER VARYING(4) 4
70 EMINPUTDATE TIMESTAMP 8
71 ORIGMDATE TIMESTAMP 8
72 TENOR CHARACTER VARYING(2) 2
73 FUNDRATE_8 NUMERIC(18,8) 19
74 FUNDBASIS CHARACTER VARYING(6) 6
75 FUNDCOST CHARACTER VARYING(11) 11
76 DISCRATE_8 NUMERIC(18,8) 19
77 FIRSTDEALNO CHARACTER VARYING(8) 8
78 FIXRULE CHARACTER VARYING(1) 1
79 INTCALCRULE CHARACTER VARYING(1) 1
80 FIRSTIPAYDATE TIMESTAMP 8
81 LASTIPAYDATE TIMESTAMP 8
82 INTPAYCYCLE CHARACTER VARYING(2) 2
83 PRINPAYCYCLE CHARACTER VARYING(2) 2
84 INTPAYDAY CHARACTER VARYING(3) 3
85 PRINPAYDAY CHARACTER VARYING(3) 3
86 YIELD_8 NUMERIC(18,8) 19
87 INTSMEANS CHARACTER VARYING(7) 7
88 FINCAL CHARACTER VARYING(15) 15
89 SIIND CHARACTER VARYING(1) 1
90 INTSETTAUTHIND CHARACTER VARYING(1) 1
91 INTAUTHOPER CHARACTER VARYING(4) 4
92 INTAUTHDATE TIMESTAMP 8
93 SECID CHARACTER VARYING(20) 20
94 CORPTRAD CHARACTER VARYING(4) 4
95 CORPPORT CHARACTER VARYING(4) 4
96 AGENTIND CHARACTER VARYING(1) 1
97 UPDATECOUNTER BIGINT 8
98 TEXT1 CHARACTER VARYING(35) 35
99 TEXT2 CHARACTER VARYING(35) 35
100 DATE1 TIMESTAMP 8
101 DATE2 TIMESTAMP 8
102 AMOUNT1 NUMERIC(19,4) 19
103 AMOUNT2 NUMERIC(19,4) 19
104 MATSTATUS CHARACTER VARYING(15) 15
105 REVDEALNO CHARACTER VARYING(8) 8
106 BTBDEALNO CHARACTER VARYING(8) 8
107 CUSTREFNO CHARACTER VARYING(35) 35
108 INTRATE_8 NUMERIC(18,8) 19
109 REVOPER CHARACTER VARYING(4) 4
110 PAYAUTHOPER CHARACTER VARYING(4) 4
111 RECAUTHOPER CHARACTER VARYING(4) 4
112 BTBTRAD CHARACTER VARYING(4) 4
113 BTBPORT CHARACTER VARYING(4) 4
114 BTBCOST CHARACTER VARYING(10) 10
115 LINKDEALNO CHARACTER VARYING(8) 8
116 LINKPRODUCT CHARACTER VARYING(6) 6
117 LINKPRODTYPE CHARACTER VARYING(2) 2
118 LINKSEQ CHARACTER VARYING(4) 4
119 SIPAYIND CHARACTER VARYING(1) 1
120 SWIFTMATCHIND CHARACTER VARYING(1) 1
121 INTSACCT CHARACTER VARYING(15) 15
122 COMMUSUALID CHARACTER VARYING(15) 15
123 MATUSUALID CHARACTER VARYING(15) 15
124 COMMTYPECODE CHARACTER VARYING(1) 1
125 MATTYPECODE CHARACTER VARYING(1) 1
126 SCHEDULETYPE CHARACTER VARYING(2) 2
127 PRINDATERULE CHARACTER VARYING(3) 3
128 PRINDATEDIR CHARACTER VARYING(2) 2
129 PRINTOTPAYMENTS NUMERIC(19,4) 19
130 INTDATERULE CHARACTER VARYING(3) 3
131 INTDATEDIR CHARACTER VARYING(2) 2
132 LASTAMOUNT NUMERIC(19,4) 19
133 BTBIND CHARACTER VARYING(1) 1
134 BTBBRANCH CHARACTER VARYING(2) 2
135 BTBSEQ CHARACTER VARYING(4) 4
136 BTBPRODUCT CHARACTER VARYING(6) 6
137 BTBPRODTYPE CHARACTER VARYING(2) 2
138 BTBFUNDCENTER CHARACTER VARYING(10) 10
139 DELAYEDINTIND CHARACTER VARYING(1) 1
140 DELAYEDINTDATE TIMESTAMP 8
141 EARLYMATIND CHARACTER VARYING(1) 1
142 BROKEXCHRATE_8 NUMERIC(18,8) 19
143 PRINSIPAYIND CHARACTER VARYING(1) 1
144 PRINSIRECIND CHARACTER VARYING(1) 1
145 INTSIPAYIND CHARACTER VARYING(1) 1
146 INTSIRECIND CHARACTER VARYING(1) 1
147 NETSI CHARACTER VARYING(1) 1
148 NETDEALNO CHARACTER VARYING(8) 8
149 NETSEQ CHARACTER VARYING(4) 4
150 CORPNETIND CHARACTER VARYING(1) 1
151 TAXCHGDESC CHARACTER VARYING(25) 25
152 TAXAMT NUMERIC(19,4) 19
153 TAXAUTHORITY CHARACTER VARYING(10) 10
154 TAXPRODUCT CHARACTER VARYING(6) 6
155 TAXPRODTYPE CHARACTER VARYING(2) 2
156 TAXTYPE CHARACTER VARYING(1) 1
157 ACCTGMETHOD CHARACTER VARYING(1) 1
158 FUNDPORT CHARACTER VARYING(4) 4
159 FUNDTRAD CHARACTER VARYING(4) 4
160 BTBCUSTOMER CHARACTER VARYING(10) 10
161 BTBCOMMUSUALID CHARACTER VARYING(15) 15
162 BTBMATUSUALID CHARACTER VARYING(15) 15
163 CORPDEALNO CHARACTER VARYING(8) 8
164 CORPSEQ CHARACTER VARYING(4) 4
165 STEPUPRATE_8 NUMERIC(18,8) 19
166 FEDEALNO CHARACTER VARYING(15) 15
167 SERVER CHARACTER VARYING(15) 15
168 PROFITRATE_8 NUMERIC(18,8) 19
169 TEMPLATETYPE BIGINT 8
170 ALLOWNEGINT CHARACTER VARYING(1) 1
171 EFFECTIVESTATUSDATE TIMESTAMP 8
172 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
173 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
174 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
175 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8