PSCONQRSFLDRLVW

index back

SELECT OPRID ,CONQRSNAME ,SEQNUM ,SELCOUNT ,QRYFLDNAMEPAR ,QRYFLDNAMECHILD ,' ' FROM PSCONQRSFLDREL WHERE 1=0

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
SELCOUNT Number(2,0) SMALLINT NOT NULL Select Count
QRYFLDNAMEPAR Character(30) VARCHAR2(30) NOT NULL Select a Parent Query Field
QRYFLDNAMECHILD Character(30) VARCHAR2(30) NOT NULL Child Query Field 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 =
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19