PSQRYCRITERIA

index back

Query Criteria


  • Parent record: PSQRYSELECT
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    SELNUM Number(2,0) SMALLINT NOT NULL Select Number
    CRTNUM Number(3,0) SMALLINT NOT NULL Criteria Number
    COMBTYPE Number(1,0) SMALLINT NOT NULL Combination Type
    NEGATION Character(1) VARCHAR2(1) NOT NULL Negation
    LPARENLVL Number(2,0) SMALLINT NOT NULL Left Paren Level
    LCRTSELNUM Number(2,0) SMALLINT NOT NULL Left Criteria Selection No.
    LCRTFLDNUM Number(3,0) SMALLINT NOT NULL Left Criteria Field Number
    CONDTYPE Number(2,0) SMALLINT NOT NULL Condition Type
    EXPRTYPE Number(2,0) SMALLINT NOT NULL Expression Type
    R1CRTSELNUM Number(2,0) SMALLINT NOT NULL Right1 Criteria Select Number
    R1CRTFLDNUM Number(3,0) SMALLINT NOT NULL Right1 Criteria Field Number
    R1CRTEXPNUM Number(3,0) SMALLINT NOT NULL Right1 Criteria Expression No.
    R2CRTSELNUM Number(2,0) SMALLINT NOT NULL Right2 Criteria Select Number
    R2CRTFLDNUM Number(3,0) SMALLINT NOT NULL Right2 Criteria Field Number
    R2CRTEXPNUM Number(3,0) SMALLINT NOT NULL Right2 Criteria Expression No.
    RPARENLVL Number(2,0) SMALLINT NOT NULL Right Paren Level
    QRYOJSELNUM Number(2,0) SMALLINT NOT NULL Outer Join Select Number
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20