ROLE_TABLES_VW

Return to Index

View: PS_ROLE_TABLES_VW

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.

PlatformView Text
DefaultSELECT A.RECNAME ,B.RECDESCR FROM PSRECFIELD A ,PSRECDEFN B WHERE B.RECNAME = A.RECNAME AND ((A.USEEDIT/1)-(A.USEEDIT/2)*2<>0) AND A.FIELDNAME = 'ROLENAME' AND B.RECTYPE = 0
OracleSELECT 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
InformixSELECT 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 NameDescription
RECNAMERecord (Table) Name
RECDESCRRecord Description

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010