PSPRCSJOBSTATUS

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
JOBINSTANCENumber(10,0)DECIMAL(10) NOT NULLJob Instance
MAINJOBINSTANCENumber(10,0)DECIMAL(10) NOT NULLMain Job Instance
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
SRVRTYPECharacter(2)VARCHAR2(2) NOT NULLServer Type
1=Application Server
2=Distribution Agent
SERVERNAMERUNCharacter(8)VARCHAR2(8) NOT NULLServer Name - Runtime
RECEIVEDNumber(1,0)SMALLINT NOT NULLServer Received
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19