OPIC_HPSI

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BR CHARACTER VARYING(2) 2
2 PRODUCT CHARACTER VARYING(6) 6
3 TYPE CHARACTER VARYING(2) 2
4 DEALNO CHARACTER VARYING(8) 8
5 SEQ CHARACTER VARYING(4) 4
6 P1 CHARACTER VARYING(70) 70
7 P2 CHARACTER VARYING(70) 70
8 P3 CHARACTER VARYING(70) 70
9 P4 CHARACTER VARYING(70) 70
10 DET CHARACTER VARYING(6) 6
11 R1 CHARACTER VARYING(70) 70
12 R2 CHARACTER VARYING(70) 70
13 R3 CHARACTER VARYING(70) 70
14 R4 CHARACTER VARYING(70) 70
15 R5 CHARACTER VARYING(70) 70
16 R6 CHARACTER VARYING(70) 70
17 BIF CHARACTER VARYING(1) 1
18 SUPPAYIND CHARACTER VARYING(1) 1
19 SUPCONFIND CHARACTER VARYING(1) 1
20 LSTMNTDTE TIMESTAMP 8
21 SACCT CHARACTER VARYING(15) 15
22 SMEANS CHARACTER VARYING(7) 7
23 SCHDSEQ CHARACTER VARYING(4) 4
24 AMENDOPER CHARACTER VARYING(4) 4
25 AMENDDATE TIMESTAMP 8
26 AMENDTIME CHARACTER VARYING(8) 8
27 AUTHDATE TIMESTAMP 8
28 AUTHOPER CHARACTER VARYING(4) 4
29 AUTHIND CHARACTER VARYING(1) 1
30 INPUTOPER CHARACTER VARYING(4) 4
31 INPUTDATE TIMESTAMP 8
32 EFFDATE TIMESTAMP 8
33 TEXT1 CHARACTER VARYING(15) 15
34 TEXT2 CHARACTER VARYING(15) 15
35 TEXT3 CHARACTER VARYING(15) 15
36 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
37 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
38 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
39 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8