PTNONUNPRCSVIEW

 index back

Non unqiue process view


SELECT DISTINCT A.GENPRCSTYPE , B.PTNONUNPRCSNAME FROM PS_PRCSTYPEDEFN A , PS_PRCSNONUNIQUE B WHERE A.PRCSTYPE=B.PRCSTYPE

PeopleSoft Field Name Field Type Column Type Description
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
PTNONUNPRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20