DFW_SCHED

index back

SELECT C.OPRID , C.ACCTLOCK , A.PRCSINSTANCE , A.JOBINSTANCE , A.PRCSJOBNAME , A.PRCSNAME , a.RUNSTATUS , B.BEGINDTTM , A.RUNDTTM , A.RECURNAME FROM PSPRCSQUE A , PSPRCSRQST B , PSOPRDEFN C WHERE A.PRCSINSTANCE = B.PRCSINSTANCE AND A.OPRID = C.OPRID

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
ACCTLOCK Number(1,0) SMALLINT NOT NULL To lock out PeopleSoft User Account
PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success
RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time
RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19