PRCSRQST_CI_UPD

(SQL View)
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 PeopleSoft Field Type Database Column Type Description
1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
3 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
4 RUNLOCATIONDESCR Character(10) VARCHAR2(10) NOT NULL Process Scheduler Process Run Location
5 RUNSTATUSDESCR Character(10) VARCHAR2(10) NOT NULL Run Status