PSCPQCRITERIA

index back

Composite Query

Composite Query - CPQDM managed object

  • Parent record: PSCPQSELECT
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    CPQNAMECharacter(30)VARCHAR2(30) NOT NULLComposite Query
    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
    RPARENLVLNumber(2,0)SMALLINT NOT NULLRight Paren Level
    CPQQRYALIASCharacter(30)VARCHAR2(30) NOT NULLChild Query Alias
    QRYFLDNAMECharacter(30)VARCHAR2(30) NOT NULLSource Field
    CONDTYPENumber(2,0)SMALLINT NOT NULLCondition Type
    EXPRTYPENumber(2,0)SMALLINT NOT NULLExpression Type
    CPQR1CRTQRYALIASCharacter(30)VARCHAR2(30) NOT NULLQuery Alias
    CPQR1CRTFLDNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Field
    CPQR1CRTEXPNUMNumber(3,0)SMALLINT NOT NULLRight1 Criteria Expression No.
    CPQR2CRTQRYALIASCharacter(30)VARCHAR2(30) NOT NULLQuery Alias
    CPQR2CRTFLDNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Field
    CPQR2CRTEXPNUMNumber(3,0)SMALLINT NOT NULLRight1 Criteria Expression No.
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19