PSQRYCRITERIA

Return to Index

  • Parent record: PSQRYSELECT
  • PeopleSoft Field NameField TypeDescription
    OPRIDVARCHAR2(30) NOT NULLA user's ID
    QRYNAMEVARCHAR2(30) NOT NULLQuery Name
    SELNUMSMALLINT NOT NULLSelect Number
    CRTNUMSMALLINT NOT NULLCriteria Number
    COMBTYPESMALLINT NOT NULLCombination Type
    NEGATIONVARCHAR2(1) NOT NULLNegation
    LPARENLVLSMALLINT NOT NULLLeft Paren Level
    LCRTSELNUMSMALLINT NOT NULLLeft Criteria Selection No.
    LCRTFLDNUMSMALLINT NOT NULLLeft Criteria Field Number
    CONDTYPESMALLINT NOT NULLCondition Type
    EXPRTYPESMALLINT NOT NULLExpression Type
    R1CRTSELNUMSMALLINT NOT NULLRight1 Criteria Select Number
    R1CRTFLDNUMSMALLINT NOT NULLRight1 Criteria Field Number
    R1CRTEXPNUMSMALLINT NOT NULLRight1 Criteria Expression No.
    R2CRTSELNUMSMALLINT NOT NULLRight2 Criteria Select Number
    R2CRTFLDNUMSMALLINT NOT NULLRight2 Criteria Field Number
    R2CRTEXPNUMSMALLINT NOT NULLRight2 Criteria Expression No.
    RPARENLVLSMALLINT NOT NULLRight Paren Level
    QRYOJSELNUMSMALLINT NOT NULLOuter Join Select Number

    Author: PeopleTools 8.52

    Return to Index

    © David Kurtz  Last updated 01 August 2015