PRCSLIST_VW

index back

Process Definition List

This view is used to list all valid process and jobs to be run from a given panel group.
SELECT DISTINCT D.DESCR , D.PRCSNAME , D.PRCSTYPE , T.GENPRCSTYPE , P.PNLGRPNAME FROM PS_PRCSDEFN D , PS_PRCSTYPEDEFN T , PS_PRCSDEFNPNL P WHERE D.PRCSTYPE = T.PRCSTYPE AND D.PRCSTYPE = P.PRCSTYPE AND D.PRCSNAME = P.PRCSNAME AND T.PRCSTYPE = P.PRCSTYPE

PeopleSoft Field NameField TypeColumn TypeDescription
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
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
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19