PSCONQRSMAP

index back

Connected Queries Relationship

Connected Queries Queries Relationship table

  • Parent record: PSCONQRSDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    CONQRSNAMECharacter(30)VARCHAR2(30) NOT NULLConnected Queries object name
    SEQNUMNumber(3,0)SMALLINT NOT NULLSequence Number
    QRYNAMEPARENTCharacter(30)VARCHAR2(30) NOT NULLConnected Queries Parent Query Name
    QRYNAMECHILDCharacter(30)VARCHAR2(30) NOT NULLChild Query Name
    EFFDTCONDTYPECharacter(4)VARCHAR2(4) NOT NULLEff Date Operator. Used in Connected Query
    EDGE=Eff Date >=
    EDGT=Eff Date >
    EDLE=Eff Date <=
    EDLT=Eff Date <
    EQU=Eff Date =

    Default: EQU

    CQ_SUPPORTSORDERBYNumber(1,0)SMALLINT NOT NULLSupports Order By
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19