BPW_PROC_INST(SQL Table) |
Index Back |
|---|
| # | 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 | SERVERNAME | Character(8) | VARCHAR2(8) NOT NULL |
Server Name
Prompt Table: BPW_SERVER_VW |
| 7 | BPW_PROC_ACT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Process Actions Only |
| 8 | BPW_ALERT_FLG | Character(3) | VARCHAR2(3) NOT NULL |
Update BUSINESS_PROCESS_WEAVER:ENUM:AlertType for new values
A10=Error A20=Warning A30=Information |
| 9 | BPW_RUNCNTL_OWNER | Character(30) | VARCHAR2(30) NOT NULL | Process Run Control Owner |
| 10 | BPW_LAST_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Operator |
| 11 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 12 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: I |
| 13 | BPW_EVNT_HDLR_ID | Character(30) | VARCHAR2(30) NOT NULL |
Event Handler ID
Prompt Table: BPW_AC_EVNT_VW |
| 14 | BPW_EVNT_HDLR_PARM | Character(254) | VARCHAR2(254) NOT NULL | Event Handler Parameter |
| 15 | BPW_CREATED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By User |
| 16 | BPW_CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date/Time |
| 17 | BPW_UPDATED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By User |
| 18 | BPW_UPDATED_DTTM | DateTime(26) | TIMESTAMP | Updated Date/Time |
| 19 | BPW_CURR_PROC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Current Process
N=No Y=Yes Default Value: Y |
| 20 | 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 |
| 21 | BPW_STATUS_DTTM | DateTime(26) | TIMESTAMP | Status Date/Time |
| 22 | BPW_STARTED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Started By User |
| 23 | BPW_STARTED_DTTM | DateTime(26) | TIMESTAMP | Started Date/Time |