OPRIDPrompt Table: RC_BP_OPRID_VW
M=Main Business Project
N=Sub-Business Project
1=Days
2=Hours
3=Minutes
C=Complete
L=Canceled
P=In Process
F=Failure
S=Success
Prompt Table: RC_BP_APPL_VW
RC_BP_MONITOR(SQL Table) |
Index Back |
|---|---|
Business Projects MonitorThis table is used for Business Projects Monitor. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: RC_BP_OPRID_VW |
| 2 | BUS_PROJ_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Business Project Type
M=Main Business Project N=Sub-Business Project |
| 3 | FILTERVALUE | Number(2,0) | SMALLINT NOT NULL | Filter Value |
| 4 | FILTERVALUE4 | Number(4,0) | SMALLINT NOT NULL | Filter Value |
| 5 | BP_FILTERUNIT | Character(1) | VARCHAR2(1) NOT NULL |
Filter Unit
1=Days 2=Hours 3=Minutes |
| 6 | REFRESH_BTN | Character(1) | VARCHAR2(1) NOT NULL | Refresh |
| 7 | BUS_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
This field is to store Business Process status.
C=Complete L=Canceled P=In Process |
| 8 | RC_OUTCOME | Character(1) | VARCHAR2(1) NOT NULL |
Outcome of a Task for Business Process tracking. See translates for possible values.
F=Failure S=Success |
| 9 | FROM_BP_INSTANCE | Number(18,0) | DECIMAL(18) NOT NULL | From BP Instance # |
| 10 | TO_BP_INSTANCE | Number(18,0) | DECIMAL(18) NOT NULL | To BP Instance # |
| 11 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 12 | RC_BUS_PROCESS_ID | Character(15) | VARCHAR2(15) NOT NULL | Business Process ID used in Business Process tracking. |
| 13 | BP_APPLNAME | Character(18) | VARCHAR2(18) NOT NULL |
Related Object
Prompt Table: RC_BP_APPL_VW |