PTRCPRCSSEC_VW

index back
Record View for list of Process Type/Name accessible by user based on component security
SELECT A.OPRID , A.PNLGRPNAME , B.PRCSTYPE , B.PRCSNAME FROM PS_PTRCUSERPAGESEC A , PS_PRCSDEFNPNL B WHERE A.PNLGRPNAME = B.PNLGRPNAME

PeopleSoft Field Name Field Type Column Type Description
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19