PSARCHUSEQRYVW

index back

Archive Template Queries


SELECT PSARCH_ID , QRYNAME , DESCR FROM PSQRYDEFN , PSARCHTEMPQRY WHERE PSARCH_SELECTQRY = QRYNAME

PeopleSoft Field NameField TypeColumn TypeDescription
PSARCH_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID (see PSARCHTEMPLATE).
QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19