| # |
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_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Business Process Type
RTBL=Real Time Bottom Line
SYS=System
USER=User Defined
Prompt Table:
BPW_PRCTYPE_VW
|
| 3 |
BPW_PROC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Weaver ID
Prompt Table:
BPW_PROC_DEFN
|
| 4 |
BPW_PROC_RUN_CNTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Run Control ID
|
| 5 |
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
Prompt Table:
BPW_PROCSTAT_VW
|
| 6 |
BPW_CRITERIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Criteria
C=Custom Event
P=Process Status
Default Value: P
|
| 7 |
BPW_NOTIFY_ACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Active
Y/N Table Edit
|
| 8 |
BPW_CUSTOM_EVNT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Custom Event ID
|
| 9 |
BPW_EVNT_HDLR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Event Handler ID
|
| 10 |
BPW_CHANNEL_EMAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Email
Y/N Table Edit
Default Value: N
|
| 11 |
BPW_CHANNEL_WRKLST |
Character(1) |
VARCHAR2(1) NOT NULL |
Worklist
Y/N Table Edit
Default Value: N
|
| 12 |
BPW_CHANNEL_PUSH |
Character(1) |
VARCHAR2(1) NOT NULL |
Push Notification
Y/N Table Edit
Default Value: N
|
| 13 |
BPW_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template Name
Prompt Table:
WL_TEMPL_GEN_VW
|
| 14 |
BPW_NOTIFY_INHERIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Inherit Notifications
Y/N Table Edit
Default Value: N
|
| 15 |
BPW_CREATED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By User
|
| 16 |
BPW_CREATED_DTTM |
DateTime(26) |
TIMESTAMP |
Created Date/Time
Default Value: %Datetime
|
| 17 |
BPW_UPDATED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By User
|
| 18 |
BPW_UPDATED_DTTM |
DateTime(26) |
TIMESTAMP |
Updated Date/Time
Default Value: %Datetime
|
| 19 |
BPW_EONC_NOTIF_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Notification Name
Prompt Table:
BPW_EONC_NOT_VW
|