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

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