PTRCJOBSEC_VW

 index back
Record View for list of PSJob accessible by user based on component security
SELECT A.OPRID , A.PNLGRPNAME , B.PRCSJOBNAME FROM PS_PTRCUSERPAGESEC A , PS_PRCSJOBPNL 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
PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20