PNLGRPNAMEFEATURE_CDFFS_FUNCTION_CD10=Operator
20=Role
30=Business Unit
40=Installation
AL=Work Order
AR=Accounts Receivable
BI=Billing
IN=Inventory
OM=Order Management
PO=Purchasing
FFS_MAINFUNC_VW(SQL View) |
Index Back |
|---|---|
FFS Main Function ViewMain view for fetching valid FFD functions. |
| SELECT DISTINCT C.PNLGRPNAME , F.FEATURE_CD , F.FFS_FUNCTION_CD , FFS_PRIORITY , M.OPRID , M.ROLENAME , M.BUSINESS_UNIT , M.FFS_BU_TYPE , ' ' FROM PS_FFS_USERFIELDS F , PS_FFS_USERMAIN M , PS_FFS_COMPFTR C WHERE F.FEATURE_CD = C.FEATURE_CD AND M.FFS_HASH = F.FFS_HASH |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | FEATURE_CD |
Character(10) | VARCHAR2(10) NOT NULL | Feature Code |
| 3 | FFS_FUNCTION_CD |
Character(10) | VARCHAR2(10) NOT NULL | Function Code |
| 4 | FFS_PRIORITY | Character(2) | VARCHAR2(2) NOT NULL |
Feature Priority
10=Operator 20=Role 30=Business Unit 40=Installation |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | 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 |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |