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