OPIC_GRPM

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 GRIDPRICEID CHARACTER VARYING(10) 10
3 YIELDCURVE CHARACTER VARYING(8) 8
4 SPREAD_8 NUMERIC(18,8) 19
5 PRODUCT CHARACTER VARYING(6) 6
6 PRODTYPE CHARACTER VARYING(2) 2
7 CNO CHARACTER VARYING(10) 10
8 CNOEXCLUDE CHARACTER VARYING(1) 1
9 GUARANTOR CHARACTER VARYING(10) 10
10 GUAREXCLUDE CHARACTER VARYING(1) 1
11 ACCTNGTYPE CHARACTER VARYING(10) 10
12 ACCTYPEEXCLUDE CHARACTER VARYING(1) 1
13 RATCNO CHARACTER VARYING(10) 10
14 CRATING CHARACTER VARYING(10) 10
15 SIC CHARACTER VARYING(10) 10
16 SICEXCLUDE CHARACTER VARYING(1) 1
17 LSTMNTDATE TIMESTAMP 8
18 PROCESSID CHARACTER VARYING(8) 8
19 RATECODE CHARACTER VARYING(7) 7
20 SECID CHARACTER VARYING(20) 20
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8