ACTIVITY_INSTANCESEQ_NUM1=Minutes
2=Hours
3=Days
4=Seconds
Y/N Table Edit
A=Activity
S=Sub Business Process
T=Task
RO_ACT_TASK_TMP(SQL Table) |
Index Back |
|---|---|
Table for loading dataTemporary Table for loading data on to the Screen. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACTIVITY_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Activity Instance |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | RC_BUS_PROCESS_ID | Character(15) | VARCHAR2(15) NOT NULL | Business Process ID used in Business Process tracking. |
| 4 | RC_TASK_ID | Character(15) | VARCHAR2(15) NOT NULL | Task ID used for Business Process tracking. |
| 5 | RC_ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID used in Business Process tracking. |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | AVG_TIME_ACT_SEC | Number(10,0) | DECIMAL(10) NOT NULL | Average Time for Performing the Activity in Minutes |
| 8 | AVG_TIME_TASK_SEC | Number(10,0) | DECIMAL(10) NOT NULL | Average Time for Performing the Task under a Business Project in Minutes |
| 9 | MANUAL_OVERRIDE | Number(12,2) | DECIMAL(11,2) NOT NULL | Manual Override Value for the Average Time at the Task Level. |
| 10 | OVERRIDE_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Override Unit for the Manual override value
1=Minutes 2=Hours 3=Days 4=Seconds |
| 11 | USE_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Override Selection Flag used for Order Capture Dashboard
Y/N Table Edit |
| 12 | MAN_OVERRIDE_SEC | Number(10,0) | DECIMAL(10) NOT NULL | Manual Override Time in Minutes used in Order Capture Dashboard |
| 13 | AVG_TIME_F_BP_SEC | Number(10,0) | DECIMAL(10) NOT NULL | Field to Capture the Average Time for Finishing the Business Project |
| 14 | BP_TYPE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Business Project Sub-level activities indicator
A=Activity S=Sub Business Process T=Task |