PTESHISTORY_VW2

index back

SELECT A.PRCSINSTANCE ,B.PTSCHDL_NAME , A.PRCSNAME , A.PRCSTYPE ,A.RUNSTATUS ,A.DISTSTATUS FROM PSPRCSRQST A , PS_PTESHISTORY B WHERE A.PRCSINSTANCE = B.PRCSINSTANCE AND A.RUNSTATUS <> '9' UNION SELECT A.PRCSINSTANCE ,' ' , A.PRCSNAME , A.PRCSTYPE ,A.RUNSTATUS ,A.DISTSTATUS FROM PSPRCSRQST A WHERE A.RUNSTATUS <> '9' AND A.PRCSINSTANCE NOT IN ( SELECT PRCSINSTANCE FROM PS_PTESHISTORY )

PeopleSoft Field NameField TypeColumn TypeDescription
PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
PTSCHDL_NAMECharacter(30)VARCHAR2(30) NOT NULLPartition Schedule
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
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
DISTSTATUSCharacter(2)VARCHAR2(2) NOT NULLDistribution Status
0=None
1=Scheduled
2=Processing
3=Generated
4=Unable to Post
5=Posted to Web
6=Delete
7=Posting
9=Pending for Approval
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19