OPIC_SECL

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 SECID CHARACTER VARYING(20) 20
3 ASKPRICE_8 NUMERIC(18,8) 19
4 ASKPRICEYST_8 NUMERIC(18,8) 19
5 ASKRATE_8 NUMERIC(18,8) 19
6 ASKRATEYST_8 NUMERIC(18,8) 19
7 BIDPRICE_8 NUMERIC(18,8) 19
8 BIDPRICEYST_8 NUMERIC(18,8) 19
9 BIDRATE_8 NUMERIC(18,8) 19
10 BIDRATEYST_8 NUMERIC(18,8) 19
11 CLSGPRICE_8 NUMERIC(18,8) 19
12 CLSGPRICEYST_8 NUMERIC(18,8) 19
13 CLSGRATE_8 NUMERIC(18,8) 19
14 CLSGRATEYST_8 NUMERIC(18,8) 19
15 COUPREMAINAMT NUMERIC(19,4) 19
16 CURRFIXRATE_8 NUMERIC(18,8) 19
17 EFFLAGDAY CHARACTER VARYING(4) 4
18 FIXBASERATE_8 NUMERIC(18,8) 19
19 FIXBASETERMS CHARACTER VARYING(1) 1
20 FIXCYCLE CHARACTER VARYING(1) 1
21 FIXFREQ CHARACTER VARYING(3) 3
22 FIXDAY CHARACTER VARYING(2) 2
23 FIXLAGDAY CHARACTER VARYING(4) 4
24 FIXSPOTRATE_8 NUMERIC(18,8) 19
25 FIXSPOTDAYS CHARACTER VARYING(2) 2
26 FIXSPOTTERMS CHARACTER VARYING(1) 1
27 LSTPRCEMNTDATE TIMESTAMP 8
28 MARKMAKIND CHARACTER VARYING(1) 1
29 NEXTEFFDATE TIMESTAMP 8
30 NEXTFIXDATE TIMESTAMP 8
31 NEXTFIXRATE_8 NUMERIC(18,8) 19
32 NEXTIPAYDATE TIMESTAMP 8
33 OFFCLSGPRICE_8 NUMERIC(18,8) 19
34 OFFCLSGPRICEYST_8 NUMERIC(18,8) 19
35 OFFCLSGRATE_8 NUMERIC(18,8) 19
36 OFFCLSGRATEYST_8 NUMERIC(18,8) 19
37 PREVCOUPDATE TIMESTAMP 8
38 PREVCOUPRATE_8 NUMERIC(18,8) 19
39 PAYCNO CHARACTER VARYING(1) 1
40 SECSACCT CHARACTER VARYING(15) 15
41 SETTMEANS CHARACTER VARYING(7) 7
42 SETTACCT CHARACTER VARYING(15) 15
43 TAXIND CHARACTER VARYING(1) 1
44 LSTMNTDATE TIMESTAMP 8
45 EFFDATE TIMESTAMP 8
46 FIXDATE TIMESTAMP 8
47 EXCLDATE TIMESTAMP 8
48 TDYACCINT_8 NUMERIC(18,8) 19
49 YSTACCINT_8 NUMERIC(18,8) 19
50 PRICESOURCE_DDE CHARACTER VARYING(50) 50
51 YIELDSOURCE_DDE CHARACTER VARYING(50) 50
52 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
53 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
54 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
55 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8