OPIC_IXRM

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 FIXCYCLE CHARACTER VARYING(1) 1
4 FIXFREQ CHARACTER VARYING(3) 3
5 FIXDAY CHARACTER VARYING(2) 2
6 FIXLAGDAY CHARACTER VARYING(4) 4
7 EFFLAGDAY CHARACTER VARYING(4) 4
8 NEXTFIXDATE TIMESTAMP 8
9 CURRFIXRATE_8 NUMERIC(18,8) 19
10 NEXTEFFDATE TIMESTAMP 8
11 NEXTFIXRATE_8 NUMERIC(18,8) 19
12 LSTMNTDATE TIMESTAMP 8
13 EFFDATE TIMESTAMP 8
14 FIXDATE TIMESTAMP 8
15 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
16 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
17 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
18 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8