OPIC_SECM_FATCA

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

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