OPIC_HST_SECM

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SECID CHARACTER VARYING(20) 20
2 ACCTNGTYPE CHARACTER VARYING(10) 10
3 CALLDATE TIMESTAMP 8
4 CALLPRICE_8 NUMERIC(18,8) 19
5 CLSGINDXRATE_8 NUMERIC(18,8) 19
6 CONVCOUPRATE_8 NUMERIC(18,8) 19
7 CONVDATE TIMESTAMP 8
8 COUPONNO CHARACTER VARYING(8) 8
9 COUPRATE_8 NUMERIC(18,8) 19
10 COUPENDDATE TIMESTAMP 8
11 CCY CHARACTER VARYING(3) 3
12 DENOM CHARACTER VARYING(15) 15
13 DESCR CHARACTER VARYING(70) 70
14 ENDTIME CHARACTER VARYING(8) 8
15 FIRSTIPAYDATE TIMESTAMP 8
16 FIXCCY CHARACTER VARYING(3) 3
17 GUARANTOR CHARACTER VARYING(10) 10
18 INFRATECODE CHARACTER VARYING(7) 7
19 INITINDEXRATE_8 NUMERIC(18,8) 19
20 BASIS CHARACTER VARYING(6) 6
21 INTCALCRULE CHARACTER VARYING(3) 3
22 INTPAYCYCLE CHARACTER VARYING(4) 4
23 INTPAYRULE CHARACTER VARYING(1) 1
24 RATECODE CHARACTER VARYING(7) 7
25 ISSDATE TIMESTAMP 8
26 ISSUER CHARACTER VARYING(10) 10
27 LASTIPAYDATE TIMESTAMP 8
28 LSTMNTDATE TIMESTAMP 8
29 MARKMAKIND CHARACTER VARYING(1) 1
30 MDATE TIMESTAMP 8
31 MUTFUNDIND CHARACTER VARYING(1) 1
32 NORMCOUPPERIOD CHARACTER VARYING(4) 4
33 PARAMT NUMERIC(19,4) 19
34 PRICEDECS CHARACTER VARYING(8) 8
35 PRICERNDRULE CHARACTER VARYING(1) 1
36 PRODUCT CHARACTER VARYING(6) 6
37 PRODTYPE CHARACTER VARYING(2) 2
38 PUTDATE TIMESTAMP 8
39 PUTPRICE_8 NUMERIC(18,8) 19
40 RATEDECS CHARACTER VARYING(8) 8
41 RATERNDRULE CHARACTER VARYING(1) 1
42 RATETOL CHARACTER VARYING(4) 4
43 REDEMPAMT NUMERIC(19,4) 19
44 REPOCOLLPCT CHARACTER VARYING(5) 5
45 SERIES CHARACTER VARYING(5) 5
46 SETTDAYS CHARACTER VARYING(2) 2
47 SPREADRATE_8 NUMERIC(18,8) 19
48 STARTTIME CHARACTER VARYING(8) 8
49 SYMBOLID CHARACTER VARYING(8) 8
50 TAXIND CHARACTER VARYING(1) 1
51 TENOR CHARACTER VARYING(2) 2
52 TRADSTAT CHARACTER VARYING(1) 1
53 SECUNIT CHARACTER VARYING(3) 3
54 VDATE TIMESTAMP 8
55 EXCHCNO CHARACTER VARYING(11) 11
56 WHACCNO CHARACTER VARYING(15) 15
57 SETTCCY CHARACTER VARYING(3) 3
58 PRICETOL CHARACTER VARYING(4) 4
59 CALLTOPAR TIMESTAMP 8
60 PUTTOPAR TIMESTAMP 8
61 MINDENOM CHARACTER VARYING(15) 15
62 MININCREMENT CHARACTER VARYING(15) 15
63 LINKSECID CHARACTER VARYING(20) 20
64 INTCCY CHARACTER VARYING(3) 3
65 INTEXCHRATE_8 NUMERIC(18,8) 19
66 INTEXCHTERMS CHARACTER VARYING(1) 1
67 SECMSIC CHARACTER VARYING(10) 10
68 REPOFLAG CHARACTER VARYING(1) 1
69 EXDIVDAYS CHARACTER VARYING(3) 3
70 DCPRICEIND CHARACTER VARYING(1) 1
71 FINCENT CHARACTER VARYING(15) 15
72 EXERCISEDAYS CHARACTER VARYING(3) 3
73 INTENDDATERULE CHARACTER VARYING(1) 1
74 SHORTCOUPIND CHARACTER VARYING(1) 1
75 EMTAIND CHARACTER VARYING(1) 1
76 PUBLISHDAYS CHARACTER VARYING(3) 3
77 ANNPERS CHARACTER VARYING(3) 3
78 FIXPERS CHARACTER VARYING(3) 3
79 FIXRATE_8 NUMERIC(18,8) 19
80 CASHDECS CHARACTER VARYING(2) 2
81 AIDECS CHARACTER VARYING(2) 2
82 PMTFREQ CHARACTER VARYING(4) 4
83 PRINPMTFREQ CHARACTER VARYING(4) 4
84 FIXFREQ CHARACTER VARYING(4) 4
85 MAXMFIX_8 NUMERIC(18,8) 19
86 MAXMLIFE_8 NUMERIC(18,8) 19
87 INTRNDRULE CHARACTER VARYING(1) 1
88 MININCRMT CHARACTER VARYING(8) 8
89 NOAMORTS CHARACTER VARYING(3) 3
90 LASTAMORT_8 NUMERIC(18,8) 19
91 PITYPE CHARACTER VARYING(1) 1
92 UPDATECOUNTER BIGINT 8
93 PHYSDELIND CHARACTER VARYING(1) 1
94 DVPIND CHARACTER VARYING(1) 1
95 RECORDDATEIND CHARACTER VARYING(1) 1
96 PERRATEFLOOR_12 NUMERIC(18,12) 19
97 LIFERATEFLOOR_12 NUMERIC(18,12) 19
98 DELAYDAYS CHARACTER VARYING(3) 3
99 PMTDAY CHARACTER VARYING(2) 2
100 SETTLECLASS CHARACTER VARYING(15) 15
101 PMTCAP_12 NUMERIC(18,12) 19
102 POOLNO CHARACTER VARYING(15) 15
103 CASHFLOWIND CHARACTER VARYING(1) 1
104 PREPMTMODEL CHARACTER VARYING(15) 15
105 WITHTAXRATE_12 NUMERIC(18,12) 19
106 FACTSECIND CHARACTER VARYING(1) 1
107 AMT1 NUMERIC(19,4) 19
108 AMT2 NUMERIC(19,4) 19
109 RATE1_12 NUMERIC(18,12) 19
110 RATE2_12 NUMERIC(18,12) 19
111 DATE1 TIMESTAMP 8
112 DATE2 TIMESTAMP 8
113 INDEXRATECODE CHARACTER VARYING(7) 7
114 ILIND CHARACTER VARYING(1) 1
115 DEFLATIONIND CHARACTER VARYING(1) 1
116 ILDECS CHARACTER VARYING(2) 2
117 NGPRICEIND CHARACTER VARYING(1) 1
118 CPIDAYCYCLE CHARACTER VARYING(2) 2
119 SCHEDID BIGINT 8
120 PRODID BIGINT 8
121 STRUCTID CHARACTER VARYING(1) 1
122 MKTVALSOURCE CHARACTER VARYING(15) 15
123 FORMULAID BIGINT 8
124 INTSETTCCY CHARACTER VARYING(3) 3
125 RATREVFIRSTLAST CHARACTER VARYING(1) 1
126 RATEFIXDAYS CHARACTER VARYING(3) 3
127 DTCIND CHARACTER VARYING(1) 1
128 FEDIND CHARACTER VARYING(1) 1
129 EUROCLEARIND CHARACTER VARYING(1) 1
130 CLEARSTREAMIND CHARACTER VARYING(1) 1
131 LOCALMARKET CHARACTER VARYING(15) 15
132 REPOTRACKINGIND CHARACTER VARYING(1) 1
133 TEMPLATEIND CHARACTER VARYING(1) 1
134 ENDOFMONTHIND CHARACTER VARYING(1) 1
135 REGENIND CHARACTER VARYING(1) 1
136 REGENDATE TIMESTAMP 8
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
141 ALLOWNEGATIVEINT CHARACTER VARYING(1) 1