EOEW_SRCFILTER

(SQL Table)
Index Back

EOEW SDO Filter metadata

  • Related Language Record: EOEW_SRCFLTRLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEW_SRCDONAME Character(30) VARCHAR2(30) NOT NULL Source Data Object
    2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 EOEW_SRCTABLE Character(80) VARCHAR2(80) NOT NULL Source Record Name
    5 EOEW_SRCCOL Character(80) VARCHAR2(80) NOT NULL Source Field Name
    6 EOEW_SRC_OPERATOR Character(4) VARCHAR2(4) NOT NULL Comparison Operator
    10=Between
    11=Not Between
    12=Exists
    13=Not Exists
    14=Like
    15=Not Like
    2=Equals
    3=Not Equal To
    4=Greater Than
    5=Less Than Or Equal To
    6=Less Than
    7=Greater Than Or Equal To
    8=In
    9=Not In
    7 EOEW_SRC_OPLOGICAL Character(4) VARCHAR2(4) NOT NULL Logical Operator
    1=And
    2=Or
    8 NEGATION Character(1) VARCHAR2(1) NOT NULL Negation
    9 EO_VALUE Character(254) VARCHAR2(254) NOT NULL Value
    10 EOEW_SRCTABLEQUAL Character(80) VARCHAR2(80) NOT NULL Source Record Name
    11 EOEW_SRCCOLQUAL Character(80) VARCHAR2(80) NOT NULL Source Field Name
    12 EOEW_SRC_GRPSTART Character(1) VARCHAR2(1) NOT NULL Group Starter
    13 EOEW_SRC_INDENTLVL Number(3,0) SMALLINT NOT NULL Indent Level
    14 EOEW_SRC_ENDPARENS Number(1,0) SMALLINT NOT NULL End Parens
    15 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained

    Y/N Table Edit

    Default Value: N

    16 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    18 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.