OEB_XLA_EVENTS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EVENT_ID BIGINT 8
2 APPLICATION_ID BIGINT 8
3 EVENT_TYPE_CODE CHARACTER VARYING(30) 30
4 EVENT_DATE TIMESTAMP 8
5 ENTITY_ID BIGINT 8
6 EVENT_STATUS_CODE CHARACTER VARYING(1) 1
7 PROCESS_STATUS_CODE CHARACTER VARYING(1) 1
8 REFERENCE_NUM_1 DOUBLE PRECISION 8
9 REFERENCE_NUM_2 DOUBLE PRECISION 8
10 REFERENCE_NUM_3 DOUBLE PRECISION 8
11 REFERENCE_NUM_4 DOUBLE PRECISION 8
12 REFERENCE_CHAR_1 CHARACTER VARYING(240) 240
13 REFERENCE_CHAR_2 CHARACTER VARYING(240) 240
14 REFERENCE_CHAR_3 CHARACTER VARYING(240) 240
15 REFERENCE_CHAR_4 CHARACTER VARYING(240) 240
16 REFERENCE_DATE_1 TIMESTAMP 8
17 REFERENCE_DATE_2 TIMESTAMP 8
18 REFERENCE_DATE_3 TIMESTAMP 8
19 REFERENCE_DATE_4 TIMESTAMP 8
20 EVENT_NUMBER BIGINT 8
21 ON_HOLD_FLAG CHARACTER VARYING(1) 1
22 CREATION_DATE TIMESTAMP 8
23 CREATED_BY BIGINT 8
24 LAST_UPDATE_DATE TIMESTAMP 8
25 LAST_UPDATED_BY BIGINT 8
26 LAST_UPDATE_LOGIN BIGINT 8
27 PROGRAM_UPDATE_DATE TIMESTAMP 8
28 PROGRAM_APPLICATION_ID BIGINT 8
29 PROGRAM_ID BIGINT 8
30 REQUEST_ID BIGINT 8
31 UPG_BATCH_ID BIGINT 8
32 UPG_SOURCE_APPLICATION_ID BIGINT 8
33 UPG_VALID_FLAG CHARACTER VARYING(1) 1
34 TRANSACTION_DATE TIMESTAMP 8
35 BUDGETARY_CONTROL_FLAG CHARACTER VARYING(1) 1
36 MERGE_EVENT_SET_ID BIGINT 8
37 CDC_SOURCE_SYSTEM_CODE CHARACTER(4) 4
38 CDC_RECORD_TYPE CHARACTER(16) 16
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8