HILP_EVENT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..QRMCGN_HILP_EVENT

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACTION_CODE CHARACTER VARYING(1) 1
3 KEY_COID INTEGER 4
4 KEY_PROD CHARACTER VARYING(3) 3
5 KEY_ACCT CHARACTER VARYING(9) 9
6 EVENT_EFF_DATE DATE 4
7 EVENT_CODE CHARACTER VARYING(5) 5
8 EVENT_SEQUENCE INTEGER 4
9 CREATE_USERID CHARACTER VARYING(8) 8
10 CREATE_DATE DATE 4
11 CREATE_TIME CHARACTER VARYING(8) 8
12 UPDATE_USERID CHARACTER VARYING(8) 8
13 UPDATE_DATE DATE 4
14 UPDATE_TIME CHARACTER VARYING(8) 8
15 EVENT_STATUS CHARACTER VARYING(3) 3
16 EVENT_DATE_1 DATE 4
17 EVENT_DATE_2 DATE 4
18 EVENT_DATE_3 DATE 4
19 EVENT_DATE_4 DATE 4
20 EVENT_BALANCE_1 NUMERIC(15,2) 19
21 EVENT_BALANCE_2 NUMERIC(15,2) 19
22 EVENT_BALANCE_3 NUMERIC(15,2) 19
23 EVENT_BALANCE_4 NUMERIC(15,2) 19
24 EVENT_RATE_1 DOUBLE PRECISION 8
25 EVENT_RATE_2 DOUBLE PRECISION 8
26 EVENT_RATE_3 DOUBLE PRECISION 8
27 EVENT_RATE_4 DOUBLE PRECISION 8
28 EVENT_NUMBER_1 INTEGER 4
29 EVENT_NUMBER_2 INTEGER 4
30 EVENT_NUMBER_3 INTEGER 4
31 EVENT_NUMBER_4 INTEGER 4
32 EVENT_FLAG_1 CHARACTER VARYING(1) 1
33 EVENT_FLAG_2 CHARACTER VARYING(1) 1
34 EVENT_FLAG_3 CHARACTER VARYING(1) 1
35 EVENT_FLAG_4 CHARACTER VARYING(1) 1
36 EVENT_TEXT_1 CHARACTER VARYING(40) 40
37 EVENT_TEXT_2 CHARACTER VARYING(40) 40
38 EVENT_TEXT_3 CHARACTER VARYING(40) 40
39 EVENT_TEXT_4 CHARACTER VARYING(40) 40
40 DELTA_TYPE CHARACTER VARYING(1) 1
41 EFFECTIVE_STRT_DT TIMESTAMP 8
42 EFFECTIVE_END_DT TIMESTAMP 8
43 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
44 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
45 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
46 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8