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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
ACCTLOCKNumber(1,0)SMALLINT NOT NULLTo lock out PeopleSoft User Account
PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
JOBINSTANCENumber(10,0)DECIMAL(10) NOT NULLJob Instance
PRCSJOBNAMECharacter(8)VARCHAR2(8) NOT NULLProcess Job Name
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
RUNSTATUSCharacter(2)VARCHAR2(2) NOT NULLProcess 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
RUNDTTMDateTime(26)TIMESTAMPRun Date/Time
BEGINDTTMDateTime(26)TIMESTAMPBegin Date/Time
RECURNAMECharacter(30)VARCHAR2(30) NOT NULLRecurrence Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19