Record View for list of PSJob accessible by user based on component security

PTRCJOBSEC_VW

(SQL View)
Index Back

SELECT A.OPRID , A.PNLGRPNAME , B.PRCSJOBNAME FROM PS_PTRCUSERPAGESEC A , PS_PRCSJOBPNL B WHERE A.PNLGRPNAME = B.PNLGRPNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name