TBLSELECTION_VW

Return to Index

View: PS_TBLSELECTION_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.

PlatformView Text
DefaultSELECT A.RECNAME ,B.RECDESCR FROM PSRECFIELD A ,PSRECDEFN B WHERE B.RECNAME = A.RECNAME AND B.RECNAME <> 'PSOPRDEFN' AND ((A.USEEDIT/1)-(A.USEEDIT/2)*2<>0) AND A.FIELDNAME = 'OPRID' AND B.RECTYPE = 0 AND A.RECNAME NOT IN ( SELECT C.RECNAME FROM PS_BYPASS_TABLE C)
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 = 'OPRID' AND B.RECTYPE = 0 AND A.RECNAME NOT IN ( SELECT C.RECNAME FROM PS_BYPASS_TABLE C)
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 = 'OPRID' AND B.RECTYPE = 0 AND A.RECNAME NOT IN ( SELECT C.RECNAME FROM PS_BYPASS_TABLE C)

PeopleSoft Field NameDescription
RECNAMERecord (Table) Name
RECDESCRRecord Description

Author: PeopleTools

Return to Index

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