PSPTDEFSECGRPUV

index back

SELECT b.objgroupid , a.oprid , b.classid FROM PSOPRDEFN a , psoprobj b WHERE a.oprclass = b.classid

PeopleSoft Field Name Field Type Column Type Description
OBJGROUPID Character(18) VARCHAR2(18) NOT NULL Object Group ID
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20