FT_PRCSINST_VW (SQL View)	Index Back
Process Instance View FT_ETXRACT Process Instance View

FT_PRCSINST_VW

(SQL View)

Process Instance View

FT_ETXRACT Process Instance View

SELECT prcsinstance , prcsname , rundttm , runstatus FROM PSPRCSRQST WHERE prcsname = 'FT_EXTRACT' AND runstatus <> '2'

# 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