PSQRYCRITERIA

index back

Query Criteria


  • Parent record: PSQRYSELECT
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
    SELNUMNumber(2,0)SMALLINT NOT NULLSelect Number
    CRTNUMNumber(3,0)SMALLINT NOT NULLCriteria Number
    COMBTYPENumber(1,0)SMALLINT NOT NULLCombination Type
    NEGATIONCharacter(1)VARCHAR2(1) NOT NULLNegation
    LPARENLVLNumber(2,0)SMALLINT NOT NULLLeft Paren Level
    LCRTSELNUMNumber(2,0)SMALLINT NOT NULLLeft Criteria Selection No.
    LCRTFLDNUMNumber(3,0)SMALLINT NOT NULLLeft Criteria Field Number
    CONDTYPENumber(2,0)SMALLINT NOT NULLCondition Type
    EXPRTYPENumber(2,0)SMALLINT NOT NULLExpression Type
    R1CRTSELNUMNumber(2,0)SMALLINT NOT NULLRight1 Criteria Select Number
    R1CRTFLDNUMNumber(3,0)SMALLINT NOT NULLRight1 Criteria Field Number
    R1CRTEXPNUMNumber(3,0)SMALLINT NOT NULLRight1 Criteria Expression No.
    R2CRTSELNUMNumber(2,0)SMALLINT NOT NULLRight2 Criteria Select Number
    R2CRTFLDNUMNumber(3,0)SMALLINT NOT NULLRight2 Criteria Field Number
    R2CRTEXPNUMNumber(3,0)SMALLINT NOT NULLRight2 Criteria Expression No.
    RPARENLVLNumber(2,0)SMALLINT NOT NULLRight Paren Level
    QRYOJSELNUMNumber(2,0)SMALLINT NOT NULLOuter Join Select Number
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19