PM_PERF_TRACEPSPMPERFTR_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT X.PM_PERF_TRACE , X.PM_MON_STRT_DTTM FROM PSPMTRANSHIST X WHERE X.PM_PERF_TRACE <> ' ' AND X.PM_MON_STRT_DTTM = ( SELECT MIN(Y.PM_MON_STRT_DTTM) FROM PSPMTRANSHIST Y WHERE X.PM_PERF_TRACE = Y.PM_PERF_TRACE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PM_PERF_TRACE |
Character(128) | VARCHAR2(128) NOT NULL | Performance Trace Name |
| 2 | PM_MON_STRT_DTTM | DateTime(26) | TIMESTAMP | Monitor Received Date/Time |