OPIC_HPRI

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 BIC CHARACTER VARYING(11) 11
7 C1 CHARACTER VARYING(70) 70
8 C2 CHARACTER VARYING(70) 70
9 C3 CHARACTER VARYING(70) 70
10 C4 CHARACTER VARYING(70) 70
11 CNARR CHARACTER VARYING(70) 70
12 SUPRECIND CHARACTER VARYING(1) 1
13 SUPCONFIND CHARACTER VARYING(1) 1
14 LSTMNTDTE TIMESTAMP 8
15 SACCT CHARACTER VARYING(15) 15
16 SMEANS CHARACTER VARYING(7) 7
17 SCHDSEQ CHARACTER VARYING(4) 4
18 AMENDOPER CHARACTER VARYING(4) 4
19 AMENDDATE TIMESTAMP 8
20 AMENDTIME CHARACTER VARYING(8) 8
21 AUTHDATE TIMESTAMP 8
22 AUTHOPER CHARACTER VARYING(4) 4
23 AUTHIND CHARACTER VARYING(1) 1
24 INPUTOPER CHARACTER VARYING(4) 4
25 INPUTDATE TIMESTAMP 8
26 EFFDATE TIMESTAMP 8
27 TEXT1 CHARACTER VARYING(15) 15
28 TEXT2 CHARACTER VARYING(15) 15
29 TEXT3 CHARACTER VARYING(15) 15
30 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
31 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
32 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
33 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8