FPY_PRCSINST_VW (SQL View)	Index Back
Process Instance View Process instance View

FPY_PRCSINST_VW

(SQL View)

Process Instance View

Process instance View

SELECT P.prcsinstance , P.prcsname , P.rundttm , P.runstatus FROM PSPRCSRQST P WHERE P.prcsname = 'FPY_IMPORT' AND P.runstatus NOT IN('1', '2','8') AND P.prcsinstance=( SELECT MAX(P1.prcsinstance) FROM PSPRCSRQST P1 WHERE P1.prcsname = 'FPY_IMPORT' AND P1.runstatus NOT IN('1', '2','8') )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

3 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time

4 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
3	RUNDTTM	DateTime(26)	TIMESTAMP	Run Date/Time
4	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