FFS_MAINFLD_VW

(SQL View)
 Index Back

FFS Main Field View

View for fetching valid fields for FFS.

SELECT M.FFS_HASH , M.OPRID , M.ROLENAME , M.BUSINESS_UNIT , M.FFS_BU_TYPE , M.FFS_PRIORITY , F.PNLNAME , F.RECNAME , F.FIELDNAME , F.USER_DISPLAY , F.USER_UPDT , C.PNLGRPNAME , F.FEATURE_CD , F.FFS_FUNCTION_CD , F.FFS_FIELDTYPE 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 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_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
6 FFS_PRIORITY Character(2) VARCHAR2(2) NOT NULL Feature Priority
10=Operator
20=Role
30=Business Unit
40=Installation
7 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
10 USER_DISPLAY Character(1) VARCHAR2(1) NOT NULL Display

Y/N Table Edit

11 USER_UPDT Character(1) VARCHAR2(1) NOT NULL Enable for Update

Y/N Table Edit

12 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
13 FEATURE_CD Character(10) VARCHAR2(10) NOT NULL Feature Code
14 FFS_FUNCTION_CD Character(10) VARCHAR2(10) NOT NULL Function Code
15 FFS_FIELDTYPE Character(2) VARCHAR2(2) NOT NULL Feature Field Type
12=Push Button/Link
2=Group Box
4=Edit Box
5=Drop Down
7=Check Box