ROLE_TABLES_VW

index back

List ROLE Security tables

This SQL view will be used to select a list of record definition names for SQL tables containing 'ROLENAME' as a key field. It will be used by the Purge Role process, to identify tables that records must 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 = 'ROLENAME' AND B.RECTYPE = 0

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