| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BPW_PROC_PROC_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance Number
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
BPW_PROC_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Business Process Type
RTBL=Real Time Bottom Line
SYS=System
USER=User Defined
|
| 4 |
BPW_PROC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Weaver ID
Prompt Table:
BPW_PROC_DEFN
|
| 5 |
BPW_PROC_RUN_CNTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Run Control ID
|
| 6 |
BPW_THRD_RUN_CNTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Thread Run Control ID
|
| 7 |
BPW_THRD_PROC_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Thread Instance Number
|
| 8 |
BPW_STEP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Step ID
|
| 9 |
BPW_STEP_PROC_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Step Instance Number
|
| 10 |
BPW_DYNAMIC_RC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dynamic Run Control
|
| 11 |
BPW_MULTI_RC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Threads
Y/N Table Edit
|
| 12 |
BPW_STEP_RUN_CNTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Step Run Control ID
Prompt Table:
%EDITTABLE
|
| 13 |
SERVERNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Server Name
Prompt Table:
BPW_SERVER_VW
|
| 14 |
BPW_START_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Start Action
|
| 15 |
BPW_PROC_STATUS_LP |
Character(2) |
VARCHAR2(2) NOT NULL |
Last Process/Run Status
Default Value: 40
|
| 16 |
BPW_PROC_STATUS_PR |
Character(2) |
VARCHAR2(2) NOT NULL |
Prior Process Status
|
| 17 |
BPW_DYNRC_DONE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dynamic Run Controls Created
|
| 18 |
BPW_ALERT_FLG |
Character(3) |
VARCHAR2(3) NOT NULL |
Update BUSINESS_PROCESS_WEAVER:ENUM:AlertType for new values
A10=Error
A20=Warning
A30=Information
|
| 19 |
BPW_NO_DATA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
No Data Processed
|
| 20 |
BPW_TASK_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Task ID
Prompt Table:
BPW_TASK_TBL
|
| 21 |
BPW_DESCR |
Character(80) |
VARCHAR2(80) NOT NULL |
Description
|
| 22 |
BPW_SKIP_STEP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Skip Step
Y/N Table Edit
Default Value: N
|
| 23 |
BPW_CONTONERR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Continue on Error
Y/N Table Edit
Default Value: N
|
| 24 |
BPW_PAUSE_WARN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pause on Warning
Y/N Table Edit
Default Value: N
|
| 25 |
BPW_PAUSE_BEF_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pause Before
Y/N Table Edit
Default Value: N
|
| 26 |
BPW_PAUSE_AFT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pause After
Y/N Table Edit
Default Value: N
|
| 27 |
BPW_SKIP_NODT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Skip on No Data
Y/N Table Edit
Default Value: N
|
| 28 |
BPW_DATA_CHECK_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
Data Check Record
Prompt Table:
BPW_DTCKREC_VW
|
| 29 |
BPW_EVNT_HDLR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Event Handler ID
Prompt Table:
BPW_AC_EVNT_VW
|
| 30 |
BPW_EVNT_HDLR_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Event Handler Parameter
|
| 31 |
BPW_CURR_PROC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Process
N=No
Y=Yes
Default Value: Y
|
| 32 |
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
Default Value: 40
|
| 33 |
BPW_STATUS_DTTM |
DateTime(26) |
TIMESTAMP |
Status Date/Time
|
| 34 |
BPW_STARTED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Started By User
|
| 35 |
BPW_STARTED_DTTM |
DateTime(26) |
TIMESTAMP |
Started Date/Time
|