PT_IQREGUSER

index back

Users per CREF


SELECT DISTINCT C.PORTAL_NAME , C.PORTAL_OBJNAME , A.ROLEUSER , E.OPRDEFNDESC FROM PSROLEUSER A , PSROLECLASS B , PSPRSMPERM C , PSPRSMDEFN D , PSOPRDEFN E WHERE C.PORTAL_OBJNAME = D.PORTAL_OBJNAME AND A.ROLENAME = B.ROLENAME AND B.CLASSID = C.PORTAL_PERMNAME AND A.ROLEUSER = E.OPRID

PeopleSoft Field NameField TypeColumn TypeDescription
PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
ROLEUSERCharacter(30)VARCHAR2(30) NOT NULLRole User
OPRDEFNDESCCharacter(30)VARCHAR2(30) NOT NULLDescription field for a user
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19