RO_TASK_TIME_VW

(SQL View)
 Index Back

Capture the Average Time

Record for Capturing the Average Time for the Business Project Activities and Tasks

SELECT A.RC_BUS_PROCESS_ID , A.ACTIVITY_INSTANCE , A.RC_ACTIVITY_ID , A.SEQ_NUM , A.RC_TASK_ID , B.DESCR , A.AVG_TIME_F_BP_SEC , A.AVG_TIME_ACT_SEC , A.AVG_TIME_TASK_SEC , A.MANUAL_OVERRIDE , A.OVERRIDE_UNIT , A.USE_OVERRIDE FROM PS_RO_TASK_TIME A , PS_RC_TASK B WHERE A.SEQ_NUM <> 0 AND A.RC_TASK_ID = B.RC_TASK_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.
2 ACTIVITY_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Activity Instance
3 RC_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID used in Business Process tracking.
4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 RC_TASK_ID Character(15) VARCHAR2(15) NOT NULL Task ID used for Business Process tracking.
6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
7 AVG_TIME_F_BP_SEC Number(10,0) DECIMAL(10) NOT NULL Field to Capture the Average Time for Finishing the Business Project
8 AVG_TIME_ACT_SEC Number(10,0) DECIMAL(10) NOT NULL Average Time for Performing the Activity in Minutes
9 AVG_TIME_TASK_SEC Number(10,0) DECIMAL(10) NOT NULL Average Time for Performing the Task under a Business Project in Minutes
10 MANUAL_OVERRIDE Number(12,2) DECIMAL(11,2) NOT NULL Manual Override Value for the Average Time at the Task Level.
11 OVERRIDE_UNIT Character(1) VARCHAR2(1) NOT NULL Override Unit for the Manual override value
1=Minutes
2=Hours
3=Days
4=Seconds
12 USE_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Selection Flag used for Order Capture Dashboard

Y/N Table Edit