PSCPQMAP

index back

Composite Query

Composite Query CPQDM table

  • 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
    CPQQRYALIASCharacter(30)VARCHAR2(30) NOT NULLChild Query Alias
    QRYNAMECHILDCharacter(30)VARCHAR2(30) NOT NULLChild Query Name
    CPQQRYALIASPARCharacter(30)VARCHAR2(30) NOT NULLParent Query Alias
    QRYNAMEPARENTCharacter(30)VARCHAR2(30) NOT NULLConnected Queries Parent Query Name
    JOINTYPENumber(1,0)SMALLINT NOT NULLJoin Type
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19