OPC_HST_EXTA

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 BR CHARACTER VARYING(2) 2
3 CODE CHARACTER VARYING(4) 4
4 QUAL CHARACTER VARYING(1) 1
5 DRCRIND1 CHARACTER VARYING(2) 2
6 SEQ1 CHARACTER VARYING(3) 3
7 INDAMT1 CHARACTER VARYING(3) 3
8 DRCRIND2 CHARACTER VARYING(2) 2
9 SEQ2 CHARACTER VARYING(3) 3
10 INDAMT2 CHARACTER VARYING(3) 3
11 DRCRIND3 CHARACTER VARYING(2) 2
12 SEQ3 CHARACTER VARYING(3) 3
13 INDAMT3 CHARACTER VARYING(3) 3
14 DRCRIND4 CHARACTER VARYING(2) 2
15 SEQ4 CHARACTER VARYING(3) 3
16 INDAMT4 CHARACTER VARYING(3) 3
17 DRCRIND5 CHARACTER VARYING(2) 2
18 SEQ5 CHARACTER VARYING(3) 3
19 INDAMT5 CHARACTER VARYING(3) 3
20 DRCRIND6 CHARACTER VARYING(2) 2
21 SEQ6 CHARACTER VARYING(3) 3
22 INDAMT6 CHARACTER VARYING(3) 3
23 DRCRIND7 CHARACTER VARYING(2) 2
24 SEQ7 CHARACTER VARYING(3) 3
25 INDAMT7 CHARACTER VARYING(3) 3
26 DRCRIND8 CHARACTER VARYING(2) 2
27 SEQ8 CHARACTER VARYING(3) 3
28 INDAMT8 CHARACTER VARYING(3) 3
29 DRCRIND9 CHARACTER VARYING(2) 2
30 SEQ9 CHARACTER VARYING(3) 3
31 INDAMT9 CHARACTER VARYING(3) 3
32 DRCRIND10 CHARACTER VARYING(2) 2
33 SEQ10 CHARACTER VARYING(3) 3
34 INDAMT10 CHARACTER VARYING(3) 3
35 DRCRIND11 CHARACTER VARYING(2) 2
36 SEQ11 CHARACTER VARYING(3) 3
37 INDAMT11 CHARACTER VARYING(3) 3
38 DRCRIND12 CHARACTER VARYING(2) 2
39 SEQ12 CHARACTER VARYING(3) 3
40 INDAMT12 CHARACTER VARYING(3) 3
41 DRCRIND13 CHARACTER VARYING(2) 2
42 SEQ13 CHARACTER VARYING(3) 3
43 INDAMT13 CHARACTER VARYING(3) 3
44 DRCRIND14 CHARACTER VARYING(2) 2
45 SEQ14 CHARACTER VARYING(3) 3
46 INDAMT14 CHARACTER VARYING(3) 3
47 DRCRIND15 CHARACTER VARYING(2) 2
48 SEQ15 CHARACTER VARYING(3) 3
49 INDAMT15 CHARACTER VARYING(3) 3
50 DRCRIND16 CHARACTER VARYING(2) 2
51 SEQ16 CHARACTER VARYING(3) 3
52 INDAMT16 CHARACTER VARYING(3) 3
53 DRCRIND17 CHARACTER VARYING(2) 2
54 SEQ17 CHARACTER VARYING(3) 3
55 INDAMT17 CHARACTER VARYING(3) 3
56 DRCRIND18 CHARACTER VARYING(2) 2
57 SEQ18 CHARACTER VARYING(3) 3
58 INDAMT18 CHARACTER VARYING(3) 3
59 DRCRIND19 CHARACTER VARYING(2) 2
60 SEQ19 CHARACTER VARYING(3) 3
61 INDAMT19 CHARACTER VARYING(3) 3
62 DRCRIND20 CHARACTER VARYING(2) 2
63 SEQ20 CHARACTER VARYING(3) 3
64 INDAMT20 CHARACTER VARYING(3) 3
65 LSTMNTDTE CHARACTER VARYING(10) 10
66 DELTA_TYPE CHARACTER VARYING(1) 1
67 EFFECTIVE_STRT_DT TIMESTAMP 8
68 EFFECTIVE_END_DT TIMESTAMP 8
69 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
70 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
71 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
72 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8