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 Name Field Type Column Type Description
DESCR Character(30) VARCHAR2(30) NOT NULL Description
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
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19