EQRY_PART_CRIT

(SQL Table)
 Index Back

Part Personalized Sch Criteria

All Criteria associated with a Participant's Personalized Search. Created from the Search Utility UIO Page.

  • Parent record: EQRY_DEF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQRY_COMBO_NAME Character(20) VARCHAR2(20) NOT NULL Output/criteria combination
    2 EQRY_PART_NAME Character(30) VARCHAR2(30) NOT NULL Query Name
    3 CONTEXT Number(15,0) DECIMAL(15) NOT NULL Plan Context. A single number that identifies the node, participant and plan combinations.
    4 EQRY_CRIT_ID Character(10) VARCHAR2(10) NOT NULL Criteria ID
    5 EQRY_SEQNUM Number(3,0) SMALLINT NOT NULL Criteria row order
    6 HCMD_ATTRIBID Character(30) VARCHAR2(30) NOT NULL Created by Eric Solberg 2/18/02 Attribute name as defined by object descriptor
    7 HCMD_CLASSID Character(12) VARCHAR2(12) NOT NULL EI_CLASSID
    8 EQRY_LOGICAL Character(4) VARCHAR2(4) NOT NULL Logical operator (And/Or)
    1=And
    2=Or

    Default Value: 1

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

    Default Value: N

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

    Default Value: 0

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

    Y/N Table Edit

    Default Value: N