RBC_PRCSLIST_VW (SQL View)	Index Back
CM process request view Used to get the cm request list

RBC_PRCSLIST_VW

(SQL View)

CM process request view

Used to get the cm request list

SELECT B.PRCSINSTANCE ,A.CMF_ID , B.MAINJOBNAME , B.SERVERNAMERUN , B.RUNSTATUS ,B.PRCSJOBNAME FROM PS_RBC_REQSTRUNCTL A , PSPRCSRQST B WHERE A.RUN_CNTL_ID = B.RUNCNTLID AND A.OPRID = B.OPRID AND B.PRCSTYPE = 'Application Engine'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 CMF_ID Character(36) VARCHAR2(36) NOT NULL Correspondence ID

3 MAINJOBNAME Character(30) VARCHAR2(30) NOT NULL Main Job Name

4 SERVERNAMERUN Character(8) VARCHAR2(8) NOT NULL Server Name - Runtime

5 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

6 PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CMF_ID	Character(36)	VARCHAR2(36) NOT NULL	Correspondence ID
3	MAINJOBNAME	Character(30)	VARCHAR2(30) NOT NULL	Main Job Name
4	SERVERNAMERUN	Character(8)	VARCHAR2(8) NOT NULL	Server Name - Runtime
5	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
6	PRCSJOBNAME	Character(8)	VARCHAR2(8) NOT NULL	Process Job Name