FSFB_FLDVAL_LVW

(SQL View)
 Index Back

Filter values view

Filter values view

SELECT F.FILTER_ID , F.FIELDNAME , V.OPRID , L.LANGUAGE_CD , F.LABEL_ID , L.LONGNAME FROM PS_FSFB_FLTRFLDS F JOIN PS_FSFB_FLTRDEFN D ON D.FILTER_ID = F.FILTER_ID JOIN PSDBFLDLABLLANG L ON %Join(COMMON_KEYS, FSFB_FLTRFLDS F, PSDBFLDLABLLANG L) 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 for EOWC_FLDVALS_VW FSFB_FLDVALS_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    6 LABEL30 Character(30) VARCHAR2(30) NOT NULL Label Description 30 char