PSCONQRSMAPVW

index back

Connected Queries Map View

Connected Queries
SELECT OPRID ,CONQRSNAME ,SEQNUM ,QRYNAMEPARENT ,QRYNAMECHILD ,EFFDTCONDTYPE ,CQ_SUPPORTSORDERBY FROM PSCONQRSMAP WHERE 0=1

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

Prompt Table: PSCONQRSSRCH_VW

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 =
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