BPW_THRD_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 | 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_CURR_PROC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Current Process
N=No Y=Yes Default Value: Y |
| 9 | 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 |
| 10 | BPW_STATUS_DTTM | DateTime(26) | TIMESTAMP | Status Date/Time |
| 11 | BPW_STARTED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Started By User |
| 12 | BPW_STARTED_DTTM | DateTime(26) | TIMESTAMP | Started Date/Time |
| 13 | SERVERNAME | Character(8) | VARCHAR2(8) NOT NULL |
Server Name
Prompt Table: BPW_SERVER_VW |