FSFB_FVALNOP_VW

(SQL View)
 Index Back

Filter values view

Filter values view

SELECT F.FILTER_ID , F.FIELDNAME , F.PROMPT_TABLE , F.REQUIRED_FLG , F.FSFB_RESTRICT_FLG , F.DISPLAY_ORDER , F.KEY_FIELD , F.DESCR_FLD , F.XLAT_FLDNAME , F.LABEL_ID , L.LONGNAME , D.FSPC_PUBLIC_FLG FROM PS_FSFB_FLTRFLDS F , PS_FSFB_FLTRDEFN D , PSDBFLDLABL L WHERE D.FILTER_ID = F.FILTER_ID AND L.LABEL_ID = F.LABEL_ID AND L.FIELDNAME = F.FIELDNAME AND F.EFF_STATUS = 'A'

  • Related Language Record: FSFB_FVALNOPLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FILTER_ID Character(10) VARCHAR2(10) NOT NULL Filter criteria identification
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: FSFB_RECFLD_VW

    3 PROMPT_TABLE Character(15) VARCHAR2(15) NOT NULL Record Name
    4 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

    Y/N Table Edit

    5 FSFB_RESTRICT_FLG Character(1) VARCHAR2(1) NOT NULL Restrict Operands if Required

    Y/N Table Edit

    6 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style
    7 KEY_FIELD Character(18) VARCHAR2(18) NOT NULL Defines the primary "value" field to use when searching a table for "IN" list values.
    8 DESCR_FLD Character(18) VARCHAR2(18) NOT NULL Defines the primary "description" field to use when searching a table for "IN" list values.
    9 XLAT_FLDNAME Character(18) VARCHAR2(18) NOT NULL Xlat Fieldname
    10 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    11 LABEL30 Character(30) VARCHAR2(30) NOT NULL Label Description 30 char
    12 FSPC_PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor