PROGRAM_NAMEMSG_LOG_PROG_VW(SQL View) |
Index Back |
|---|---|
Message Log Table |
| SELECT DISTINCT A.PROGRAM_NAME , A.JOBID , B.DTTM_STAMP_SEC , A.PROCESS_INSTANCE FROM PS_MESSAGE_LOG A , PS_MESSAGE_LOG B WHERE A.PROGRAM_NAME <> ' ' AND A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND A.MESSAGE_SEQ = B.MESSAGE_SEQ AND B.MESSAGE_SEQ = ( SELECT MAX(MESSAGE_SEQ) FROM PS_MESSAGE_LOG C WHERE B.PROCESS_INSTANCE = C.PROCESS_INSTANCE AND C.PROGRAM_NAME <> ' ') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROGRAM_NAME |
Character(8) | VARCHAR2(8) NOT NULL | Program Name |
| 2 | JOBID | Character(10) | VARCHAR2(10) NOT NULL | Job ID |
| 3 | DTTM_STAMP_SEC | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 4 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |