PTML_PRCLIST

(SQL View)
Index Back

SELECT R.PRCSINSTANCE , R.PRCSJOBSEQ , R.PRCSTYPE , R.PRCSNAME , R.OPRID , R.RUNDTTM , R.RUNSTATUS , R.DISTSTATUS FROM PSPRCSRQST R , PSOPRDEFN B , PSPRCSPRFL C , PSXLATITEM X WHERE B.OPRID = R.OPRID AND R.PRCSNAME='PTML_DSJOB' AND B.PRCSPRFLCLS = C.CLASSID AND R.RUNSTATUS = X.FIELDVALUE AND R.RUNSTATUS <> '2' AND X.FIELDNAME = 'RUNSTATUS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item
3 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

Prompt Table: PMN_PRCSTYPE_VW

4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
6 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
7 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
8 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