PSPERM_TBLS_VW

index back

OPRID DeleteTable Selection vw

This SQL view will be used to select a list of record definition names for SQL tables containing 'OPRID' as a key field. It will be used as the prompt table behind BYPASS_TABLE.RECNAME. PSBYPASS_TABLE will be used by the Purge User Profile process, to identify tables that records must not be deleted from.
SELECT A.RECNAME ,B.RECDESCR FROM PSRECFIELD A ,PSRECDEFN B WHERE B.RECNAME = A.RECNAME AND ((A.USEEDIT/1)-TRUNC(A.USEEDIT/2)*2<>0) AND A.FIELDNAME = 'CLASSID' AND B.RECTYPE = 0 AND A.RECNAME <> 'PRG_PERMISSIONS'

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19