EOWC_FLDVALS_VW

(SQL View)
 Index Back

Filter values subrecord

Filter values subrecord

SELECT F.FILTER_ID , F.FIELDNAME , V.OPRID , V.PAGELET_CONFIG_ID , V.EOWC_VIEWBY , 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_EOWC_VIEWBY_VAL V ON %Join(COMMON_KEYS, FSFB_FLTRFLDS F, EOWC_VIEWBY_VAL 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 PAGELET_CONFIG_ID Character(18) VARCHAR2(18) NOT NULL FSWC-Workcenter ID
    5 EOWC_VIEWBY Character(36) VARCHAR2(36) NOT NULL Filter criteria identification
    6 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
    7 OPER_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Operation Fieldname
    8 OP_TIME_UNIT Character(2) VARCHAR2(2) NOT NULL Time Unit
    DY=Days
    HR=Hours
    MN=Minutes
    9 FSFB_VALUEFROM_01 Character(254) VARCHAR2(254) NOT NULL "From" value

    Prompt Table: %EDITTABLE

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

    Prompt Table: %EDITTABLE

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N