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 NameField TypeColumn TypeDescription
USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
PRCSJOBNAMECharacter(8)VARCHAR2(8) NOT NULLProcess Job Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19