FFS_BU_AN_SRCH(SQL View) |
Index Back |
|---|
| SELECT FFS_HASH , ' ' , BUSINESS_UNIT , FFS_PRIORITY , FFS_BU_TYPE FROM PS_FFS_USERMAIN WHERE FFS_PRIORITY = '30' |
| # | 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). |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 4 | FFS_PRIORITY |
Character(2) | VARCHAR2(2) NOT NULL |
Feature Priority
10=Operator 20=Role 30=Business Unit 40=Installation Default Value: 30 |
| 5 | FFS_BU_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Business Unit Type
AL=Work Order AR=Accounts Receivable BI=Billing IN=Inventory OM=Order Management PO=Purchasing |