FFS_HASHROLENAMEPrompt Table: PSROLEDEFN_SRCH
BUSINESS_UNITFFS_PRIORITY10=Operator
20=Role
30=Business Unit
40=Installation
Default Value: 20
FFS_RL_AN_SRCH(SQL View) |
Index Back |
|---|
| SELECT FFS_HASH , ROLENAME , ' ' , FFS_PRIORITY FROM PS_FFS_USERMAIN WHERE FFS_PRIORITY = '20' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FFS_HASH |
Character(28) | VARCHAR2(28) NOT NULL | Feature Security Hash |
| 2 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN_SRCH |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | FFS_PRIORITY |
Character(2) | VARCHAR2(2) NOT NULL |
Feature Priority
10=Operator 20=Role 30=Business Unit 40=Installation Default Value: 20 |