FCT_OPC_EFS_SECM_EOM_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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