PSPTDEFSECGRPUV

index back

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

PeopleSoft Field NameField TypeColumn TypeDescription
OBJGROUPIDCharacter(18)VARCHAR2(18) NOT NULLObject Group ID
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
CLASSIDCharacter(30)VARCHAR2(30) NOT NULLThe name of the class (see PSCLASSDEFN).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19