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 Name Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

Prompt Table: PT_IQ_PRT_VW

PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
PORTAL_PERMNAME Character(30) VARCHAR2(30) NOT NULL Permission Name
CLASSDEFNDESC Character(30) VARCHAR2(30) NOT NULL Permission List Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19