PSCONQRSMAPVW

index back

Connected Queries Map View

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

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

Prompt Table: PSCONQRSSRCH_VW

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