EX_SRCH_OPR_LVW

(SQL View)
 Index Back

SELECT A.FIELDTYPE , A.SRCH_OPERATOR , B.LANGUAGE_CD , B.XLATLONGNAME , B.XLATSHORTNAME FROM PS_EX_SRCH_OPRTS A , PSXLATITEMLANG B WHERE A.SRCH_OPERATOR = B.FIELDVALUE AND B.FIELDNAME = 'SRCH_OPERATOR'

  • Related Language Record for EX_SRCH_OPRS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    2 SRCH_OPERATOR Character(4) VARCHAR2(4) NOT NULL Allowed logic operator by field type
    !IN=not in
    0=All Values
    1=equal to
    2=less than
    21=before
    3=greater than
    31=after
    4=less than or equal to
    41=on or before
    5=greater than or equal to
    51=on or after
    6=between
    7=begins with
    8=contains
    9=in
    <=<
    <==<=
    <>=not =
    ===
    >=>
    >==>=
    A=not in
    B=not equal
    BEG=begins with
    BTWN=between
    IN=in
    LIKE=contains
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    5 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name