Report Console - nVision Request

PTRC_NVS_INST

(SQL View)
Index Back

SELECT A.PRCSINSTANCE , A.ORIGPARMLIST FROM PSPRCSRQST B , PSPRCSPARMS A WHERE B.PRCSTYPE = 'nVision-Report' AND B.PRCSNAME = 'NVSRUN' AND A.PRCSINSTANCE = B.PRCSINSTANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ORIGPARMLIST Character(254) VARCHAR2(254) NOT NULL Original Parameter List