BPW_MSGLOG_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.MESSAGE_SET_NBR , M.MESSAGE_NBR , M.MESSAGE_SEVERITY , 'M' , ' ' , '0140' , M.DTTM_STAMP_SEC , %NumToChar(MESSAGE_SEQ) , 'Y' , R.PRCSNAME FROM PS_BPW_STRCINST_VW I , PS_MESSAGE_LOG 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 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 15 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 16 | MESSAGE_SEVERITY | Number(5,0) | INTEGER NOT NULL | Message Severity |
| 17 | BPW_LOG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Log Type
M=Message Log P=Process Log |
| 18 | BPW_DEFAULT_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Default Text |
| 19 | BPW_OBJECT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Object Type
0110=Process Instance 0120=Thread Instance 0130=Step Instance 0140=Step Thread Instance |
| 20 | BPW_UPDATED_DTTM | DateTime(26) | TIMESTAMP | Log Date/Time |
| 21 | BPW_APPSVRDT_STR | Character(15) | VARCHAR2(15) NOT NULL | App Server Date/Time |
| 22 | BPW_MSGPARM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Message Parm |
| 23 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |