RO_SBP_DESC_VW (SQL View)	Index Back
Capture the Average Time Record for Capturing the Average Time for the Business Project Activities and Tasks

RO_SBP_DESC_VW

(SQL View)

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 , A.MAN_OVERRIDE_SEC , 'S' FROM PS_RO_TASK_TIME A , PS_RO_BP_EFF_VW B WHERE A.SEQ_NUM <> 0 AND A.RC_TASK_ID <> ' ' AND A.RC_TASK_ID = B.RC_BUS_PROCESS_ID

Related Language Record: RO_SBP_DESC_LVW

# 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

13 MAN_OVERRIDE_SEC Number(10,0) DECIMAL(10) NOT NULL Manual Override Time in Minutes used in Order Capture Dashboard

14 BP_TYPE_IND Character(1) VARCHAR2(1) NOT NULL Business Project Sub-level activities indicator
A=Activity
S=Sub Business Process
T=Task

#	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
13	MAN_OVERRIDE_SEC	Number(10,0)	DECIMAL(10) NOT NULL	Manual Override Time in Minutes used in Order Capture Dashboard
14	BP_TYPE_IND	Character(1)	VARCHAR2(1) NOT NULL	Business Project Sub-level activities indicator A=Activity S=Sub Business Process T=Task