PT_IQREGPERM

index back

Permission Lists per CREF


SELECT DISTINCT D.PORTAL_NAME , D.PORTAL_OBJNAME , C.PORTAL_PERMNAME , E.CLASSDEFNDESC FROM PSPRSMPERM C , PSPRSMDEFN D , PSCLASSDEFN E WHERE D.PORTAL_OBJNAME = C.PORTAL_OBJNAME AND D.PORTAL_NAME = C.PORTAL_NAME AND C.PORTAL_PERMNAME = E.CLASSID

PeopleSoft Field NameField TypeColumn TypeDescription
PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).

Prompt Table: PT_IQ_PRT_VW

PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
PORTAL_PERMNAMECharacter(30)VARCHAR2(30) NOT NULLPermission Name
CLASSDEFNDESCCharacter(30)VARCHAR2(30) NOT NULLPermission List Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19