FSFB_FLDVALS_VW

(SQL View)
 Index Back

Filter values subrecord

Filter values subrecord

SELECT F.FILTER_ID , F.FIELDNAME , V.OPRID , V.OPERATION , V.OPER_FIELDNAME , V.OP_TIME_UNIT , V.FSFB_VALUEFROM_01 , V.FSFB_VALUETO_01 , V.FSFB_VALDTFROM_01 , V.FSFB_VALDTTO_01 , V.FSFB_VALUEIN_01 , V.FSFB_SQL_LONG , 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 , F.FSFB_EXCLUDEIN_FLG FROM PS_FSFB_FLTRFLDS F JOIN PS_FSFB_FLTRDEFN D ON D.FILTER_ID = F.FILTER_ID JOIN PSDBFLDLABL L ON L.LABEL_ID = F.LABEL_ID AND L.FIELDNAME = F.FIELDNAME LEFT OUTER JOIN PS_FSFB_FLTRVALS V ON %Join(COMMON_KEYS, FSFB_FLTRFLDS F, FSFB_FLTRVALS V) WHERE F.EFF_STATUS = 'A'

  • Related Language Record: FSFB_FLDVAL_LVW

    • # 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 OPERATION Character(3) VARCHAR2(3) NOT NULL Arithmetic Operation
    <=Less Than
    <==Less Than or Equal To
    <>=Not Equal To
    ==Equal To
    >=Greater Than
    >==Greater Than or Equal To
    5 OPER_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Operation Fieldname
    6 OP_TIME_UNIT Character(2) VARCHAR2(2) NOT NULL Time Unit
    DY=Days
    HR=Hours
    MN=Minutes
    7 FSFB_VALUEFROM_01 Character(254) VARCHAR2(254) NOT NULL "From" value

    Prompt Table: %EDITTABLE

    8 FSFB_VALUETO_01 Character(254) VARCHAR2(254) NOT NULL "To" value

    Prompt Table: %EDITTABLE

    9 FSFB_VALDTFROM_01 Date(10) DATE "From" value
    10 FSFB_VALDTTO_01 Date(10) DATE "To" value
    11 FSFB_VALUEIN_01 Long Character(1999) VARCHAR2(1999) "IN" list values
    12 FSFB_SQL_LONG Long Character CLOB SQL Statement
    13 PROMPT_TABLE Character(15) VARCHAR2(15) NOT NULL Record Name
    14 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

    Y/N Table Edit

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

    Y/N Table Edit

    16 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style
    17 KEY_FIELD Character(18) VARCHAR2(18) NOT NULL Defines the primary "value" field to use when searching a table for "IN" list values.
    18 DESCR_FLD Character(18) VARCHAR2(18) NOT NULL Defines the primary "description" field to use when searching a table for "IN" list values.
    19 XLAT_FLDNAME Character(18) VARCHAR2(18) NOT NULL Xlat Fieldname
    20 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    21 LABEL30 Character(30) VARCHAR2(30) NOT NULL Label Description 30 char
    22 FSPC_PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor
    23 FSFB_EXCLUDEIN_FLG Character(1) VARCHAR2(1) NOT NULL Exclude "IN" operator flag for WorkCenter

    Y/N Table Edit

    Default Value: N