PAGELET_CONFIG_IDFSPC_GROUP_IDFSPC_LINK_IDFSPC_PERMISSIONTYP1=User
2=Role
3=Permission List
FSPC_PERMISSIONPrompt Table: %EDITTABLE
FSPC_MST_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 |