RDT_PERMLIST_VW

(SQL View)
 Index Back

DT Permission List view

This views fetches the Permission list tied to the Content Reference. The Content Reference is fetched from Display Template Options Table.

SELECT A.DISP_TMPL_FAM_CD , A.DISP_TMPL_ID , B.PNLGRPNAME , B.MARKET , C.PORTAL_NAME , C.PORTAL_OBJNAME , C.PORTAL_PERMNAME , C.PORTAL_REFTYPE FROM PS_RDT_TMPL_DEFN A , PS_RDT_TMPL_OPT B , PSPRSMPERM C WHERE A.DISP_TMPL_ID = B.DISP_TMPL_ID AND B.PORTAL_OBJNAME = C.PORTAL_OBJNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
2 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.
3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
4 MARKET Character(3) VARCHAR2(3) NOT NULL Market
5 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
6 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
7 PORTAL_PERMNAME Character(30) VARCHAR2(30) NOT NULL Permission Name
8 PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder