BPW_MSGLOGP_VW(SQL View) |
Index Back |
|---|
| SELECT M.PROCESS_INSTANCE , %subrec(BPW_INSTKEY_SBR, I) , I.BPW_THRD_RUN_CNTL , I.BPW_THRD_PROC_INST , I.BPW_STEP_ID , I.BPW_STEP_PROC_INST , I.BPW_STRC_RUN_CNTL , I.BPW_STRC_PROC_INST , M.MESSAGE_SEQ , M.PARM_SEQ , M.MESSAGE_PARM FROM PS_BPW_STRCINST_VW I , PS_MESSAGE_LOGPARM M , PSPRCSRQST R WHERE I.BPW_STRC_PROC_INST > 0 AND (I.BPW_STRC_PROC_INST = R.MAINJOBINSTANCE AND M.PROCESS_INSTANCE = R.PRCSINSTANCE) OR (I.BPW_STRC_PROC_INST = M.PROCESS_INSTANCE AND M.PROCESS_INSTANCE = R.PRCSINSTANCE AND R.MAINJOBINSTANCE = 0) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BPW_PROC_PROC_INST |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance Number |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | BPW_PROC_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Business Process Type
RTBL=Real Time Bottom Line SYS=System USER=User Defined |
| 5 | BPW_PROC_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Process Weaver ID
Prompt Table: BPW_PROC_DEFN |
| 6 | BPW_PROC_RUN_CNTL |
Character(30) | VARCHAR2(30) NOT NULL | Process Run Control ID |
| 7 | BPW_THRD_RUN_CNTL |
Character(30) | VARCHAR2(30) NOT NULL | Thread Run Control ID |
| 8 | BPW_THRD_PROC_INST |
Number(10,0) | DECIMAL(10) NOT NULL | Thread Instance Number |
| 9 | BPW_STEP_ID |
Character(30) | VARCHAR2(30) NOT NULL | Step ID |
| 10 | BPW_STEP_PROC_INST |
Number(10,0) | DECIMAL(10) NOT NULL | Step Instance Number |
| 11 | BPW_STRC_RUN_CNTL |
Character(30) | VARCHAR2(30) NOT NULL | Step Thread Run Control ID |
| 12 | BPW_STRC_PROC_INST |
Number(10,0) | DECIMAL(10) NOT NULL | Step Thread Instance Number |
| 13 | MESSAGE_SEQ |
Number(9,0) | DECIMAL(9) NOT NULL | Message Sequence |
| 14 | PARM_SEQ |
Number(3,0) | SMALLINT NOT NULL | Message Parameter Sequence |
| 15 | MESSAGE_PARM | Character(254) | VARCHAR2(254) NOT NULL | Message Parameter Text |