PSCPQSELECT

index back

Composite Query

Composite Query CPQDM

  • Parent record: PSCPQDEFN
  • 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
    SELECTTYPENumber(1,0)SMALLINT NOT NULLSelection Type
    PARENTSELNUMNumber(2,0)SMALLINT NOT NULLParent Select Number
    QRYCOUNTNumber(3,0)SMALLINT NOT NULLQuery Count
    CRTCOUNTNumber(3,0)SMALLINT NOT NULLCriteria Count
    HAVECRTCOUNTNumber(3,0)SMALLINT NOT NULLHaving Criteria Count
    QRYDISTINCTCharacter(1)VARCHAR2(1) NOT NULLDistinct
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19