PTRCPRCSLST

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 Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
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
PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19