PSCONQRSFLDRLVW

index back

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

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
SELCOUNTNumber(2,0)SMALLINT NOT NULLSelect Count
QRYFLDNAMEPARCharacter(30)VARCHAR2(30) NOT NULLSelect a Parent Query Field
QRYFLDNAMECHILDCharacter(30)VARCHAR2(30) NOT NULLChild Query Field 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 =
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19