ROLEUSR_TBLS_VW - OPRID DeleteTable Selection vw

ROLEUSR_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.RECNAME <> 'PRG_ROLEUSER' AND ((A.USEEDIT/1)-TRUNC(A.USEEDIT/2)*2<>0) AND A.FIELDNAME = 'ROLEUSER' AND B.RECTYPE = 0 AND A.RECNAME NOT IN ( SELECT C.RECNAME FROM PS_BYPASS_TABLE C)

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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

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