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