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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19