OBP24_FLX_WRF_TASK_EVENT_LOG_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TASK_ID CHARACTER VARYING(40) 40
2 TASK_VERSION DOUBLE PRECISION 8
3 TASK_NUMBER DOUBLE PRECISION 8
4 TASK_TYPE CHARACTER VARYING(100) 100
5 PRIORITY DOUBLE PRECISION 8
6 CREATED_BY CHARACTER VARYING(100) 100
7 CREATED_DATE TIMESTAMP 8
8 UPDATED_BY CHARACTER VARYING(100) 100
9 UPDATED_DATE TIMESTAMP 8
10 STATE CHARACTER VARYING(100) 100
11 SUB_STATE CHARACTER VARYING(100) 100
12 ACTION CHARACTER VARYING(100) 100
13 OUTCOME CHARACTER VARYING(100) 100
14 STAGE CHARACTER VARYING(100) 100
15 PARTICIPANT_NAME CHARACTER VARYING(100) 100
16 TASK_KEY CHARACTER VARYING(100) 100
17 IS_APPR_TASK CHARACTER VARYING(1) 1
18 APPR_WORK_ITEM_ID CHARACTER VARYING(100) 100
19 EXPIRATION_DURATION CHARACTER VARYING(100) 100
20 DUE_DURATION CHARACTER VARYING(100) 100
21 EXPIRATION_DATE TIMESTAMP 8
22 DUE_DATE TIMESTAMP 8
23 ASSIGNEE_USERS CHARACTER VARYING(500) 500
24 ASSIGNEE_GROUP CHARACTER VARYING(500) 500
25 UPDATED_BY_ASSIGNEE_GROUP CHARACTER VARYING(100) 100
26 ACQUIRED_USER CHARACTER VARYING(500) 500
27 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
28 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
29 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
30 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8