OPIC_SRHR

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 CCY CHARACTER VARYING(3) 3
3 YRMONTH CHARACTER VARYING(7) 7
4 SPOTRATE1_8 NUMERIC(18,8) 19
5 TERMS1 CHARACTER VARYING(1) 1
6 SPOTRATE2_8 NUMERIC(18,8) 19
7 TERMS2 CHARACTER VARYING(1) 1
8 SPOTRATE3_8 NUMERIC(18,8) 19
9 TERMS3 CHARACTER VARYING(1) 1
10 SPOTRATE4_8 NUMERIC(18,8) 19
11 TERMS4 CHARACTER VARYING(1) 1
12 SPOTRATE5_8 NUMERIC(18,8) 19
13 TERMS5 CHARACTER VARYING(1) 1
14 SPOTRATE6_8 NUMERIC(18,8) 19
15 TERMS6 CHARACTER VARYING(1) 1
16 SPOTRATE7_8 NUMERIC(18,8) 19
17 TERMS7 CHARACTER VARYING(1) 1
18 SPOTRATE8_8 NUMERIC(18,8) 19
19 TERMS8 CHARACTER VARYING(1) 1
20 SPOTRATE9_8 NUMERIC(18,8) 19
21 TERMS9 CHARACTER VARYING(1) 1
22 SPOTRATE10_8 NUMERIC(18,8) 19
23 TERMS10 CHARACTER VARYING(1) 1
24 SPOTRATE11_8 NUMERIC(18,8) 19
25 TERMS11 CHARACTER VARYING(1) 1
26 SPOTRATE12_8 NUMERIC(18,8) 19
27 TERMS12 CHARACTER VARYING(1) 1
28 SPOTRATE13_8 NUMERIC(18,8) 19
29 TERMS13 CHARACTER VARYING(1) 1
30 SPOTRATE14_8 NUMERIC(18,8) 19
31 TERMS14 CHARACTER VARYING(1) 1
32 SPOTRATE15_8 NUMERIC(18,8) 19
33 TERMS15 CHARACTER VARYING(1) 1
34 SPOTRATE16_8 NUMERIC(18,8) 19
35 TERMS16 CHARACTER VARYING(1) 1
36 SPOTRATE17_8 NUMERIC(18,8) 19
37 TERMS17 CHARACTER VARYING(1) 1
38 SPOTRATE18_8 NUMERIC(18,8) 19
39 TERMS18 CHARACTER VARYING(1) 1
40 SPOTRATE19_8 NUMERIC(18,8) 19
41 TERMS19 CHARACTER VARYING(1) 1
42 SPOTRATE20_8 NUMERIC(18,8) 19
43 TERMS20 CHARACTER VARYING(1) 1
44 SPOTRATE21_8 NUMERIC(18,8) 19
45 TERMS21 CHARACTER VARYING(1) 1
46 SPOTRATE22_8 NUMERIC(18,8) 19
47 TERMS22 CHARACTER VARYING(1) 1
48 SPOTRATE23_8 NUMERIC(18,8) 19
49 TERMS23 CHARACTER VARYING(1) 1
50 SPOTRATE24_8 NUMERIC(18,8) 19
51 TERMS24 CHARACTER VARYING(1) 1
52 SPOTRATE25_8 NUMERIC(18,8) 19
53 TERMS25 CHARACTER VARYING(1) 1
54 SPOTRATE26_8 NUMERIC(18,8) 19
55 TERMS26 CHARACTER VARYING(1) 1
56 SPOTRATE27_8 NUMERIC(18,8) 19
57 TERMS27 CHARACTER VARYING(1) 1
58 SPOTRATE28_8 NUMERIC(18,8) 19
59 TERMS28 CHARACTER VARYING(1) 1
60 SPOTRATE29_8 NUMERIC(18,8) 19
61 TERMS29 CHARACTER VARYING(1) 1
62 SPOTRATE30_8 NUMERIC(18,8) 19
63 TERMS30 CHARACTER VARYING(1) 1
64 SPOTRATE31_8 NUMERIC(18,8) 19
65 TERMS31 CHARACTER VARYING(1) 1
66 LSTMNTDTE TIMESTAMP 8
67 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
68 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
69 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
70 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8