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 NameField TypeColumn TypeDescription
PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
RUNLOCATIONDESCRCharacter(10)VARCHAR2(10) NOT NULLProcess Scheduler Process Run Location
RUNSTATUSDESCRCharacter(10)VARCHAR2(10) NOT NULLRun Status
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19