WM_PM_RUNLOG_VW(SQL View) |
Index Back |
|---|
| SELECT A.OPRID , A.RUN_CNTL_ID ,A.REQUEST_ID , A.PROCESS_INSTANCE ,A.DATE_TIME_HM ,A.MESSAGE_SET_NBR , A.MESSAGE_NBR , B.MESSAGE_TEXT , B.MSG_SEVERITY , B.DESCRLONG , A.COUNTER , A.COUNTER1 FROM PS_WM_PM_RUN_LOG A , PSMSGCATDEFN B WHERE A.MESSAGE_SET_NBR = B.MESSAGE_SET_NBR AND A.MESSAGE_NBR = B.MESSAGE_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: WM_PM_RUN_OPT.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: WM_PM_RUN_OPT.RUN_CNTL_ID |
| 3 | REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Request ID
Default Value: WM_PM_RUN_OPT.REQUEST_ID |
| 4 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Default Value: WM_PM_RUN_OPT.PROCESS_INSTANCE |
| 5 | DATE_TIME_HM |
DateTime(26) | TIMESTAMP | Date Timestamp |
| 6 | MESSAGE_SET_NBR |
Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 7 | MESSAGE_NBR |
Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 8 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
| 9 | MSG_SEVERITY | Character(1) | VARCHAR2(1) NOT NULL |
Message Severity
C=Cancel E=Error M=Message W=Warning |
| 10 | DESCRLONG | Long Character | CLOB | Long Description |
| 11 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 12 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |