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 Name Field Type Column Type Description
PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
PTSCHDL_NAME Character(30) VARCHAR2(30) NOT NULL Partition Schedule
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
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
DISTSTATUS Character(2) VARCHAR2(2) NOT NULL Distribution 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.uk PeopleTools 8.54
PTRef generated on 09-JUN-19