SCHDLRQSTLST_VW

Platform	View Text
Default	SELECT S.SCHEDULENAME ,S.JOBNAMESRC ,R.MAINJOBINSTANCE , R.RUNSTATUS , R.RQSTDTTM , R.RUNDTTM , R.BEGINDTTM , R.ENDDTTM FROM PSPRCSRQST R , PS_SCHDLDEFN S WHERE R.MAINJOBINSTANCE > 0 AND R.PRCSINSTANCE = R.MAINJOBINSTANCE AND R.SCHEDULENAME= S.SCHEDULENAME AND R.MAINJOBNAME=S.JOBNAMESRC

PeopleSoft Field Name	Description
SCHEDULENAME	Schedule Name
JOBNAMESRC	Job Name Source
MAINJOBINSTANCE	Main Job Instance
RUNSTATUS	Process Scheduler Process Run Status 1=Cancel 10=Not Successful 11=Posted (inactive) 12=Unable to post (inactive) 13=Resend (inactive) 14=Posting (inactive) 15=Content Generated (inactive) 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
RQSTDTTM	Request Date/Time
RUNDTTM	Run Date/Time
BEGINDTTM	Begin Date/Time
ENDDTTM	End Date/Time

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010