RC_BUS_PROCESS_IDACTIVITY_INSTANCERC_ACTIVITY_IDRO_ACT_TIME_VW(SQL View) |
Index Back |
|---|---|
Capture the Average TimeRecord for Capturing the Average Time for the Business Project Activities |
| 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 FROM PS_RO_TASK_TIME A , PS_RC_ACTIVITY B WHERE A.SEQ_NUM = 0 AND A.RC_TASK_ID = ' ' AND A.RC_ACTIVITY_ID = B.RC_ACTIVITY_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 |