PTRCPRCSLST

(SQL View)
 Index Back

Processes accessible by User

Reporting Console

SELECT DISTINCT U.OPRID , J.PRCSJOBNAME , J.PRCSTYPE , '9' ,J.PRCSJOBNAME , J.DESCR FROM PS_PRCSJOBDEFN J , PS_PRCSJOBPNL P , PS_PTRCUSERPAGESEC U WHERE J.PRCSJOBNAME = P.PRCSJOBNAME AND U.PNLGRPNAME = P.PNLGRPNAME UNION SELECT DISTINCT U1.OPRID , D.PRCSNAME , D.PRCSTYPE , T.GENPRCSTYPE , D.PRCSNAME , D.DESCR FROM PS_PRCSTYPEDEFN T , PS_PRCSDEFNPNL P , PS_PRCSDEFN D , PS_PTRCUSERPAGESEC U1 WHERE T.PRCSTYPE = D.PRCSTYPE AND D.PRCSTYPE = P.PRCSTYPE AND D.PRCSNAME = P.PRCSNAME AND T.PRCSTYPE = P.PRCSTYPE AND U1.PNLGRPNAME = P.PNLGRPNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
3 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
4 GENPRCSTYPE Character(2) VARCHAR2(2) NOT NULL Generic Process Type
0=Other
1=SQR
2=PeopleSoft COBOL
3=Crystal Report
4=Winword Macro
5=Application Engine
6=Cube Builder
7=nVision
8=Data Mover
9=PSJob
5 PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description