| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
BPW_PROC_PROC_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance Number
|
| 3 |
BPW_OPERATOR_PI |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
BET=between
Default Value: =
|
| 4 |
BPW_PROC_PI_TO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance Number
|
| 5 |
BPW_PROC_RUN_CNTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Run Control ID
Prompt Table:
BPW_PI_RC_VW
|
| 6 |
BPW_OPERATOR_RC |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
BEG=begins with
BET=between
CON=contains
Default Value: BEG
|
| 7 |
BPW_PROC_RC_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Run Control ID
Prompt Table:
BPW_PI_RC_VW
|
| 8 |
BPW_PROC_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Process Status for Business Process Weaver.
- Any change should be reflected in BUSINESS_PROCESS_WEAVER:ENUM:ProcessStatus
- "Summarized" status is by xlate value so make so to choose the proper value for new status.
10=Skipped
15=Cancelled
20=Complete
22=Compl/Warning
25=Complete/Error
30=Paused After
40=Not Started
50=Paused Before
60=Started
70=On Hold
90=Error
|
| 9 |
BPW_OPERATOR_STAT |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
BET=between
Default Value: =
|
| 10 |
BPW_PROC_STATUS_TO |
Character(2) |
VARCHAR2(2) NOT NULL |
Process Status for Business Process Weaver.
- Any change should be reflected in BUSINESS_PROCESS_WEAVER:ENUM:ProcessStatus
- "Summarized" status is by xlate value so make so to choose the proper value for new status.
10=Skipped
15=Cancelled
20=Complete
22=Compl/Warning
25=Complete/Error
30=Paused After
40=Not Started
50=Paused Before
60=Started
70=On Hold
90=Error
|
| 11 |
BPW_PROC_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Business Process Type
RTBL=Real Time Bottom Line
SYS=System
USER=User Defined
|
| 12 |
BPW_OPERATOR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<>=not =
===
Default Value: =
|
| 13 |
BPW_PROC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Weaver ID
Prompt Table:
BPW_PI_BPID_VW
|
| 14 |
BPW_OPERATOR_BPID |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
BEG=begins with
BET=between
CON=contains
Default Value: BEG
|
| 15 |
BPW_PROC_ID_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Weaver ID
Prompt Table:
BPW_PI_BPID_VW
|
| 16 |
BPW_SRCH_DTTM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Started Date/Time
D=Date from
L=Last
Default Value: L
|
| 17 |
BPW_LAST_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Days/Hours/Minutes
A=All
D=Days
H=Hours
M=Minutes
N=Months
Y=Years
Default Value: D
|
| 18 |
BPW_LAST_UNIT_VAL |
Number(4,0) |
SMALLINT NOT NULL |
Last Unit Value
Default Value: 1
|
| 19 |
BPW_START_DATE |
Date(10) |
DATE |
Date
|
| 20 |
BPW_START_DATE_TO |
Date(10) |
DATE |
Started Date/Time
|
| 21 |
BPW_STARTED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Started By User
Prompt Table:
BPW_PI_OPRID_VW
|
| 22 |
BPW_OPERATOR_USER |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<>=not =
===
Default Value: =
|
| 23 |
BPW_SAVE_SRCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Save search criteria
Y/N Table Edit
|