PSCONQRSMAP

 index back

Connected Queries Relationship

Connected Queries Queries Relationship table

  • Parent record: PSCONQRSDEFN

    • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    CONQRSNAME Character(30) VARCHAR2(30) NOT NULL Connected Queries object name
    SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    QRYNAMEPARENT Character(30) VARCHAR2(30) NOT NULL Connected Queries Parent Query Name
    QRYNAMECHILD Character(30) VARCHAR2(30) NOT NULL Child Query Name
    EFFDTCONDTYPE Character(4) VARCHAR2(4) NOT NULL Eff Date Operator. Used in Connected Query
    EDGE=Eff Date >=
    EDGT=Eff Date >
    EDLE=Eff Date <=
    EDLT=Eff Date <
    EQU=Eff Date =

    Default: EQU

    CQ_SUPPORTSORDERBY Number(1,0) SMALLINT NOT NULL Supports Order By
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20