EQRY_CRITERIA

(SQL Table)
 Index Back

eQuery Criteria selections

eQuery Criteria selections

  • Parent record: EQRY_DEF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQRY_NAME Character(20) VARCHAR2(20) NOT NULL Query Name
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 EQRY_CRIT_ID Character(10) VARCHAR2(10) NOT NULL Criteria ID
    4 EQRY_SEQNUM Number(3,0) SMALLINT NOT NULL Criteria row order
    5 HCMD_ATTRIBID Character(30) VARCHAR2(30) NOT NULL Created by Eric Solberg 2/18/02 Attribute name as defined by object descriptor
    6 HCMD_CLASSID Character(12) VARCHAR2(12) NOT NULL EI_CLASSID
    7 EQRY_LOGICAL Character(4) VARCHAR2(4) NOT NULL Logical operator (And/Or)
    1=And
    2=Or

    Default Value: 1

    8 EQRY_OPERATOR Character(4) VARCHAR2(4) NOT NULL SQL 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
    9 EQRY_VALUE Long Character CLOB SQL target value
    10 EQRY_GROUPSTARTER Character(1) VARCHAR2(1) NOT NULL Indentation group starter

    Default Value: N

    11 EQRY_INDENTLEVEL Number(3,0) SMALLINT NOT NULL Indent level

    Default Value: 0

    12 EQRY_ENDPARENS Number(1,0) SMALLINT NOT NULL Number of ending paraenthesis
    13 EQRY_ROW_LOCKED Character(1) VARCHAR2(1) NOT NULL Is row locked?

    Y/N Table Edit

    Default Value: N