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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
GENPRCSTYPECharacter(2)VARCHAR2(2) NOT NULLGeneric 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
PRCSJOBNAMECharacter(8)VARCHAR2(8) NOT NULLProcess Job Name
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19