PRCSRQST_CI_UPD

index back

SELECT P.PRCSINSTANCE , P.PRCSTYPE , P.PRCSNAME , P.RUNLOCATION , UPPER(%Substring(X.XLATLONGNAME , 1,10)) FROM PSPRCSRQST P , PSXLATITEM X WHERE X.FIELDNAME = 'RUNSTATUS' AND P.RUNSTATUS = X.FIELDVALUE

PeopleSoft Field Name Field Type Column Type Description
PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
RUNLOCATIONDESCR Character(10) VARCHAR2(10) NOT NULL Process Scheduler Process Run Location
RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19