BPW_LOGINST_VW(SQL View) |
Index Back |
|---|
| SELECT I.BPW_PROC_PROC_INST , I.OPRID , I.BPW_PROC_TYPE , I.BPW_PROC_ID , I.BPW_PROC_RUN_CNTL , 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 , I.MESSAGE_SEQ , I.MESSAGE_SET_NBR , I.MESSAGE_NBR , I.MESSAGE_SEVERITY , I.BPW_LOG_TYPE , I.BPW_DEFAULT_TEXT , I.BPW_OBJECT_TYPE , I.BPW_UPDATED_DTTM , I.BPW_APPSVRDT_STR , I.BPW_MSGPARM_FLG , 0 , ' ' FROM PS_BPW_LOG_INST I |
| # | 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_STEP_ID |
Character(30) | VARCHAR2(30) NOT NULL | Step ID |
| 9 | BPW_STEP_PROC_INST |
Number(10,0) | DECIMAL(10) NOT NULL | Step Instance Number |
| 10 | BPW_STRC_RUN_CNTL |
Character(30) | VARCHAR2(30) NOT NULL | Step Thread Run Control ID |
| 11 | BPW_STRC_PROC_INST |
Number(10,0) | DECIMAL(10) NOT NULL | Step Thread Instance Number |
| 12 | MESSAGE_SEQ |
Number(9,0) | DECIMAL(9) NOT NULL | Message Sequence |
| 13 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 14 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 15 | MESSAGE_SEVERITY | Number(5,0) | INTEGER NOT NULL | Message Severity |
| 16 | BPW_LOG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Log Type
M=Message Log P=Process Log |
| 17 | BPW_DEFAULT_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Default Text |
| 18 | BPW_OBJECT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Object Type
0110=Process Instance 0120=Thread Instance 0130=Step Instance 0140=Step Thread Instance |
| 19 | BPW_UPDATED_DTTM | DateTime(26) | TIMESTAMP | Log Date/Time |
| 20 | BPW_APPSVRDT_STR | Character(15) | VARCHAR2(15) NOT NULL | App Server Date/Time |
| 21 | BPW_MSGPARM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Message Parm |
| 22 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 23 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |