PSPRSMPERM

(SQL Table)
Index Back

Portal Structure Permission

Portal Registry Structure Permission Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
2 PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder
3 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
4 PORTAL_PERMNAME Character(30) VARCHAR2(30) NOT NULL Permission Name
5 PORTAL_PERMTYPE Character(30) VARCHAR2(30) NOT NULL Permission Type

Default Value: P

6 PORTAL_ISCASCADE Number(1,0) SMALLINT NOT NULL Is Cascade