PT_IQ_PRM_VW

(SQL View)
Index Back

Registry PermList Prompt View


SELECT DISTINCT C.PORTAL_PERMNAME , E.CLASSDEFNDESC FROM PSPRSMPERM C , PSCLASSDEFN E WHERE C.PORTAL_PERMNAME = E.CLASSID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PORTAL_PERMNAME Character(30) VARCHAR2(30) NOT NULL Permission Name
2 CLASSDEFNDESC Character(30) VARCHAR2(30) NOT NULL Permission List Description