| # |
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
|
| 3 |
BPW_PROC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Weaver ID
|
| 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
Default Value: BPW_NOTIFY_RUN.BPW_PROC_STATUS
|
| 6 |
BPW_CRITERIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Criteria
C=Custom Event
P=Process Status
Default Value: BPW_NOTIFY_RUN.BPW_CRITERIA
|
| 7 |
BPW_SEQ_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequency Number
|
| 8 |
BPW_PARTY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Recipient Type
R=Role
S=SQL
U=User
Default Value: U
|
| 9 |
BPW_PARTICIPANTS |
Character(30) |
VARCHAR2(30) NOT NULL |
Recipients
Prompt Table:
%EDITTABLE
|
| 10 |
BPW_NOTIFY_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Level
P=Process
S=Steps
|
| 11 |
BPW_NOTIFY_ALLS |
Character(1) |
VARCHAR2(1) NOT NULL |
All Steps
Y/N Table Edit
Default Value: N
|
| 12 |
BPW_STEP_LIST |
Long Character |
CLOB |
Step Notify List
|
| 13 |
BPW_EMAIL_TEXT |
Character(250) |
VARCHAR2(250) NOT NULL |
EMAIL TEXT
|
| 14 |
BPW_CREATED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By User
|
| 15 |
BPW_CREATED_DTTM |
DateTime(26) |
TIMESTAMP |
Created Date/Time
Default Value: %Datetime
|
| 16 |
BPW_UPDATED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By User
|
| 17 |
BPW_UPDATED_DTTM |
DateTime(26) |
TIMESTAMP |
Updated Date/Time
Default Value: %Datetime
|