OBP24_HST_FLX_WRF_TASK_METRIC_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TASK_ID CHARACTER VARYING(40) 40
2 TASK_NUMBER DOUBLE PRECISION 8
3 TASK_TYPE CHARACTER VARYING(100) 100
4 PRIORITY DOUBLE PRECISION 8
5 TASK_KEY CHARACTER VARYING(100) 100
6 IS_APPR_TASK CHARACTER VARYING(1) 1
7 APPR_WORK_ITEM_ID CHARACTER VARYING(100) 100
8 CREATED_BY CHARACTER VARYING(100) 100
9 CREATED_DATE TIMESTAMP 8
10 EXPIRATION_DURATION CHARACTER VARYING(100) 100
11 DUE_DURATION CHARACTER VARYING(100) 100
12 EXPIRATION_DATE TIMESTAMP 8
13 DUE_DATE TIMESTAMP 8
14 ASSIGNEE_USERS CHARACTER VARYING(500) 500
15 LAST_UPDATED_BY CHARACTER VARYING(100) 100
16 LAST_UPDATED_DATE TIMESTAMP 8
17 STATE CHARACTER VARYING(100) 100
18 SUB_STATE CHARACTER VARYING(100) 100
19 ACTION CHARACTER VARYING(100) 100
20 OUTCOME CHARACTER VARYING(100) 100
21 STAGE CHARACTER VARYING(100) 100
22 PARTICIPANT_NAME CHARACTER VARYING(100) 100
23 ACQUIRED_USER CHARACTER VARYING(100) 100
24 STAGE_CNT DOUBLE PRECISION 8
25 ESCALATION_CNT DOUBLE PRECISION 8
26 REASSIGN_CNT DOUBLE PRECISION 8
27 SUSPENSION_CNT DOUBLE PRECISION 8
28 WAIT_TIME DOUBLE PRECISION 8
29 IDLE_TIME DOUBLE PRECISION 8
30 ACTUAL_TIME DOUBLE PRECISION 8
31 SUSPENDED_TIME DOUBLE PRECISION 8
32 CYCLE_TIME DOUBLE PRECISION 8
33 ASSIGNEE_GROUP CHARACTER VARYING(100) 100
34 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
35 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
36 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
37 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8