RC_BUS_PROCESS_IDACTIVITY_INSTANCERC_ACTIVITY_IDSEQ_NUMRC_TASK_IDLANGUAGE_CDRO_SBP_DESC_LVW(SQL View) |
Index Back |
|---|---|
Capture the Average TimeRecord 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.LANGUAGE_CD , B.DESCR FROM PS_RO_TASK_TIME A , PS_RO_BP_EFF_LVW B WHERE A.SEQ_NUM <> 0 AND A.RC_TASK_ID <> ' ' AND A.RC_TASK_ID = B.RC_BUS_PROCESS_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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |