OPIC_RATE

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 RATECODE CHARACTER VARYING(7) 7
3 CCY CHARACTER VARYING(3) 3
4 RATETYPE CHARACTER VARYING(5) 5
5 VARFIX CHARACTER VARYING(1) 1
6 SOURCE CHARACTER VARYING(25) 25
7 DESMAT CHARACTER VARYING(3) 3
8 SPREAD_8 NUMERIC(18,8) 19
9 BASIS CHARACTER VARYING(6) 6
10 DESCR CHARACTER VARYING(25) 25
11 RATEFIXDAY CHARACTER VARYING(3) 3
12 LSTMNTDATE TIMESTAMP 8
13 FINCAL CHARACTER VARYING(15) 15
14 RATESOURCE_DDE CHARACTER VARYING(50) 50
15 RATESOURCE_ISDA CHARACTER VARYING(100) 100
16 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
17 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
18 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
19 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8