FSPC_ADM_QRYSEC

(SQL Table)
Index Back

Pagelet Config - Queries Secur

Administrator level configuration - security table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAGELET_CONFIG_ID Character(18) VARCHAR2(18) NOT NULL FSWC-Workcenter ID
2 FSPC_GROUP_ID Character(36) VARCHAR2(36) NOT NULL Group ID
3 FSPC_LINK_ID Character(36) VARCHAR2(36) NOT NULL Link ID
4 FSPC_PERMISSIONTYP Character(1) VARCHAR2(1) NOT NULL FSWC - URL Permission Type (User, Role, Permission List)
1=User
2=Role
3=Permission List
5 FSPC_PERMISSION Character(30) VARCHAR2(30) NOT NULL FSWC - URL Permission Type (User, Role, Permission List)

Prompt Table: %EDITTABLE