PRCSLIST_VW

Return to Index

View: PS_PRCSLIST_VW

This view is used to list all valid process and jobs to be run from a given panel group.

PlatformView Text
DefaultSELECT 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 NameDescription
DESCRDescription
PRCSNAMEProcess Name
PRCSTYPEProcess Type
GENPRCSTYPEGeneric 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 (inactive)
PNLGRPNAMEComponent Name

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010