PSCPQSELECT

index back

Composite Query

Composite Query CPQDM

  • Parent record: PSCPQDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    CPQNAME Character(30) VARCHAR2(30) NOT NULL Composite Query
    SELNUM Number(2,0) SMALLINT NOT NULL Select Number
    SELECTTYPE Number(1,0) SMALLINT NOT NULL Selection Type
    PARENTSELNUM Number(2,0) SMALLINT NOT NULL Parent Select Number
    QRYCOUNT Number(3,0) SMALLINT NOT NULL Query Count
    CRTCOUNT Number(3,0) SMALLINT NOT NULL Criteria Count
    HAVECRTCOUNT Number(3,0) SMALLINT NOT NULL Having Criteria Count
    QRYDISTINCT Character(1) VARCHAR2(1) NOT NULL Distinct
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 25-NOV-20