PROCESS_NAMEEODP_PRCS_INSTANCEEODP_QRYMSK_SDL(SQL View) |
Index Back |
|---|
| SELECT P.PRCSNAME , P.PRCSINSTANCE , ( SELECT XLATSHORTNAME FROM PSXLATITEM WHERE FIELDNAME ='RUNSTATUS' AND FIELDVALUE = P.RUNSTATUS ) , P.RUNDTTM , P.OPRID ,P.RQSTDTTM FROM PSPRCSRQST P WHERE PRCSNAME = 'EODP_QRYMSK' AND RUNCNTLID = 'SCHD_QRYMSK' AND RUNSTATUS IN ('5') AND BEGINDTTM IS NULL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_NAME |
Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 2 | EODP_PRCS_INSTANCE |
Character(15) | VARCHAR2(15) NOT NULL | Process Instance |
| 3 | EODP_PRCS_STATUS | Character(15) | VARCHAR2(15) NOT NULL | Process Status |
| 4 | EODP_NEXT_RUN_DTTM | DateTime(26) | TIMESTAMP | Next Run Date/Time |
| 5 | EODP_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
| 6 | EODP_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |