FSPC_ADM_QRYSEC(SQL Table) |
Index Back |
---|---|
Pagelet Config - Queries SecurAdministrator 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 |