OPIC_SECS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SECID CHARACTER VARYING(20) 20
2 SEQ CHARACTER VARYING(4) 4
3 IPAYDATE TIMESTAMP 8
4 CALLPRICE_8 NUMERIC(18,8) 19
5 CASHFLOW_8 NUMERIC(18,8) 19
6 INTRATE_8 NUMERIC(18,8) 19
7 EXDIVDATE TIMESTAMP 8
8 INTPAYAMT_8 NUMERIC(18,8) 19
9 INTENDDTE TIMESTAMP 8
10 INTSTRTDTE TIMESTAMP 8
11 CAPRATE_8 NUMERIC(18,8) 19
12 RATECODE CHARACTER VARYING(7) 7
13 RATEFIXDATE TIMESTAMP 8
14 FLOORRATE_8 NUMERIC(18,8) 19
15 SPREADRATE_8 NUMERIC(18,8) 19
16 LSTMNTDATE TIMESTAMP 8
17 PRINAMT_8 NUMERIC(18,8) 19
18 PRINPAYAMT_8 NUMERIC(18,8) 19
19 PUTPRICE_8 NUMERIC(18,8) 19
20 STEPRATE_8 NUMERIC(18,8) 19
21 EXERDATE TIMESTAMP 8
22 PUBLISHDATE TIMESTAMP 8
23 BASIS CHARACTER VARYING(6) 6
24 NOTPRINAMT_8 NUMERIC(18,8) 19
25 NOTPRINPAYAMT_8 NUMERIC(18,8) 19
26 NOTINTPAYAMT_8 NUMERIC(18,8) 19
27 UPDATECOUNTER BIGINT 8
28 GROUPID BIGINT 8
29 FORMULAID BIGINT 8
30 FIXINGOVERRIDE BIGINT 8
31 RATESETDATE TIMESTAMP 8
32 INTSETTCCY CHARACTER VARYING(3) 3
33 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
35 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
36 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
37 CAPFLOORIND CHARACTER VARYING(1) 1
38 RATEREFIXIND CHARACTER VARYING(1) 1