OPC_HST_SECS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_OPC_HST_SECS

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