PT_IQREGPERM

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

Prompt Table: PT_IQ_PRT_VW

2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
3 PORTAL_PERMNAME Character(30) VARCHAR2(30) NOT NULL Permission Name
4 CLASSDEFNDESC Character(30) VARCHAR2(30) NOT NULL Permission List Description