FFS_MAINFTR_VW

(SQL View)
 Index Back

FFS Main Feature View

Main view for fetching valid FFS features.

SELECT DISTINCT C.PNLGRPNAME , FS.FEATURE_CD , M.FFS_PRIORITY , M.OPRID , M.ROLENAME , M.BUSINESS_UNIT , M.FFS_BU_TYPE , ' ' FROM PS_FFS_USERFIELDS FS , PS_FFS_USERMAIN M , PS_FFS_COMPFTR C WHERE FS.FEATURE_CD = C.FEATURE_CD AND FS.FFS_HASH = M.FFS_HASH

  • Related Language Record: FFS_MAINFTRVLNG

    • # 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_PRIORITY Character(2) VARCHAR2(2) NOT NULL Feature Priority
    10=Operator
    20=Role
    30=Business Unit
    40=Installation
    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    5 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    7 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
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description