PSCPQMAP

 index back

Composite Query

Composite Query CPQDM table

  • Parent record: PSCPQSELECT

    • 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
    CPQQRYALIAS Character(30) VARCHAR2(30) NOT NULL Child Query Alias
    QRYNAMECHILD Character(30) VARCHAR2(30) NOT NULL Child Query Name
    CPQQRYALIASPAR Character(30) VARCHAR2(30) NOT NULL Parent Query Alias
    QRYNAMEPARENT Character(30) VARCHAR2(30) NOT NULL Connected Queries Parent Query Name
    JOINTYPE Number(1,0) SMALLINT NOT NULL Join Type
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20