FFS_HASHOPRIDROLENAMEBUSINESS_UNITFFS_PRIORITY10=Operator
20=Role
30=Business Unit
40=Installation
FFS_BU_TYPEAL=Work Order
AR=Accounts Receivable
BI=Billing
IN=Inventory
OM=Order Management
PO=Purchasing
FFS_USERMAIN(SQL Table) |
Index Back |
|---|---|
Main User function |
| # | 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). |
| 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 |
| 6 | 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 |