PSARCHUSEQRYVW

index back

Archive Template Queries


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

PeopleSoft Field Name Field Type Column Type Description
PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19